Let your formulas run your store
FlexSync is the only Shopify app that syncs Google Sheets formula results straight to your store.
Made for Formula Automators
Whether you
- Get supplier price lists as Google Sheets
- Price products from cost plus a markup
- Want product status to follow stock automatically
- Clean up product data with formulas, not by hand
FlexSync lets you
- Sync formula results to Shopify, not just typed values
- Pull supplier prices with IMPORTRANGE
- Look up costs with VLOOKUP and apply your markup
- Set status rules with IF, like draft at zero stock
Your need, our solution
The jobs Formula Automators do every week, and how FlexSync handles each one from Google Sheets.
=IMPORTRANGE(url, "Prices!B2") pulls a supplier's price list, and their updates flow into Shopify.
Learn how →=VLOOKUP(sku, cost_sheet, 3, 0) looks up cost per SKU, then apply your markup.
Learn how →=IF(stock<10,"sale","active") changes product status automatically.
Learn how →=IF(inventory=0,"draft","active") drafts empty products and republishes on restock.
Learn how →=compare_at*0.85 sets a sale price as a percentage of the original.
Learn how →=PROPER(title_column) applies the same casing rules across your whole catalog.
Learn how →Formulas that change your store
Every example below is a native Google Sheets formula. FlexSync syncs the result to Shopify.
=IF(stock<10,"sale","active")
Auto-set product status
Stock drops below 10 and the Shopify status changes automatically.
=compare_at * 0.85
Formula-driven sale pricing
Update one formula to run a sitewide promotion.
=IMPORTRANGE(url, "Prices!B2")
Pull prices from a supplier sheet
Their updates flow into your Shopify prices automatically.
=PROPER(title_column)
Standardize product titles
Change it once and every product title follows.
=IF(inventory=0,"draft","active")
Auto-draft out-of-stock products
When it's back in stock, it republishes on its own.
=VLOOKUP(sku, cost_sheet, 3, 0)
Cost-based pricing
Prices always reflect your actual costs.
When your supplier updates their Sheet, your store updates too
Point an IMPORTRANGE at your supplier's price list. When they change a price, the formula result changes, and FlexSync syncs the new price to Shopify without any downloading or copy-pasting.
- Works with any Sheet you can access
- Combine with markup math in the same cell
- Every result change syncs to Shopify
Base every price on what the product actually costs you
Keep your costs in their own tab or file. VLOOKUP finds each SKU's cost, your markup does the rest, and Shopify prices follow your real costs instead of last quarter's guess.
- Costs live in one place
- Change a markup, reprice a category
- Pair with cost per item for margin reports
Up and running in three steps
Enable formulas
Turn on the formula feature in FlexSync settings.
Write your formula
Use any native Google Sheets formula in an editable column.
Let it run
When the result changes, FlexSync syncs it to Shopify.
I pull supplier prices with IMPORTRANGE and they just appear in Shopify. No extra steps.
What merchants are saying
Rated 4.9 out of 5 on the Shopify App Store.
"Thanks for the support, they took a lot of time to help me resolve my issues. If needed don't mind asking help of them! Real good experience to sync my prices in real time!"
"This is an excellent app doing exactly as expected. The support is very helpful and new feature requests were added with just a few weeks. I absolutely recommend this app to any stores who want to work in parallel in a Google Sheet like I do."
"Great app to have a vision of all my inventory at once. Great support, I use it everyday and highly recommend."
Built for every kind of Shopify operation
Not quite you? See how other merchants use FlexSync.
Frequently asked questions
Still have questions? Our support team is available 24/7 at support@flexsync.app.
Native Google Sheets formulas, including IF, VLOOKUP, IMPORTRANGE, PROPER and arithmetic. FlexSync syncs the formula's result to Shopify.
A cell in a synced, editable column whose value comes from a formula. Each plan includes a set number: 20 on Free, 1,000 on Starter, 5,000 on Growth and 10,000 on Ultimate.
Yes. Enable it in FlexSync first; the formula feature guide walks through the setup step by step.
Yes. Use IMPORTRANGE to pull from another spreadsheet, or VLOOKUP to reference a cost or supplier tab in the same file.
No, FlexSync handles the sync and you only write the formula.