--- title: "Formula Automators" id: "1028" type: "page" slug: "shopify-google-sheets-formulas" published_at: "2026-11-01T15:48:43+00:00" modified_at: "2026-11-01T15:48:43+00:00" url: "https://flexsync.app/use-cases/shopify-google-sheets-formulas/" markdown_url: "https://flexsync.app/use-cases/shopify-google-sheets-formulas.md" --- # Let your formulas run your store IF, VLOOKUP and IMPORTRANGE that change Shopify FlexSync is the only Shopify app that syncs Google Sheets formula results straight to your store. [Start for Free](https://apps.shopify.com/flex-stock-sync/install?utm_source=flexsync.app&utm_medium=use-case-page&utm_campaign=shopify-google-sheets-formulas) [Unlock Pro](/pricing) [#](#) 4.9/5 on Shopify App Store Built for Shopify Free plan up to 500 SKUs GDPR compliant Skill**Comfortable with Sheets formulas** Goal**Rules instead of manual edits** Data**Supplier & cost sheets** Is this you?## 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 Why they choose FlexSync## Your need, our solution The jobs Formula Automators do every week, and how FlexSync handles each one from Google Sheets. Your needOur solution **Supplier price changes**=IMPORTRANGE(url, "Prices!B2") pulls a supplier's price list, and their updates flow into Shopify. [Learn how →](/docs/how-to-enable-and-use-flexsync-shopify-formula-feature/) **Cost-based pricing**=VLOOKUP(sku, cost_sheet, 3, 0) looks up cost per SKU, then apply your markup. [Learn how →](/docs/how-to-enable-and-use-flexsync-shopify-formula-feature/) **Status by stock level**=IF(stock<10,"sale","active") changes product status automatically. [Learn how →](/docs/how-to-enable-and-use-flexsync-shopify-formula-feature/) **Out-of-stock handling**=IF(inventory=0,"draft","active") drafts empty products and republishes on restock. [Learn how →](/docs/how-to-enable-and-use-flexsync-shopify-formula-feature/) **Sale pricing**=compare_at*0.85 sets a sale price as a percentage of the original. [Learn how →](/docs/how-to-enable-and-use-flexsync-shopify-formula-feature/) **Consistent titles**=PROPER(title_column) applies the same casing rules across your whole catalog. [Learn how →](/docs/bulk-inventory-variant-product-updates-from-google-sheets/) Everything in one place## 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. Supplier feeds## 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 Supplier feed · FlexSync**Synced** fx`=IMPORTRANGE(supplier_url,"Prices!B2")*1.4` | 1 | Product | SKU | Supplier cost | Markup | Price | | --- | --- | --- | --- | --- | --- | | 2 | Ceramic Mug | CM-12-WHT | 6.20 | ×1.4 | 8.68 | | 3 | Pour-over Set | PO-SET-01 | 18.50 | ×1.4 | 25.90 | | 4 | Grinder Pro | GR-PRO-02 | 54.00 | ×1.4 | 75.60 | | 5 | Filter Papers | FP-100 | 2.10 | ×1.4 | 2.94 | | 6 | Glass Carafe | GC-600 | 11.40 | ×1.4 | 15.96 | Margin rules## 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 Pricing rules · FlexSync**Synced** fx`=ROUND(VLOOKUP(B2,Costs!A:C,3,0)*1.6,2)` | 1 | Product | SKU | Cost | Margin | Price | | --- | --- | --- | --- | --- | --- | | 2 | Ceramic Mug | CM-12-WHT | 6.20 | 37% | 9.92 | | 3 | Pour-over Set | PO-SET-01 | 18.50 | 37% | 29.60 | | 4 | Grinder Pro | GR-PRO-02 | 54.00 | 37% | 86.40 | | 5 | Filter Papers | FP-100 | 2.10 | 37% | 3.36 | | 6 | Glass Carafe | GC-600 | 11.40 | 37% | 18.24 | How it works## Up and running in three steps 1### Enable formulas Turn on the formula feature in FlexSync settings. 2### Write your formula Use any native Google Sheets formula in an editable column. 3### Let it run When the result changes, FlexSync syncs it to Shopify. [Read the getting started guide](/docs/getting-started-with-flexsync-shopify-stock-sync/) > I pull supplier prices with IMPORTRANGE and they just appear in Shopify. No extra steps. Formula automator Real merchants · Real results## 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!" N Nashor France · Shopify App Store "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." P PureTime Denmark · Shopify App Store "Great app to have a vision of all my inventory at once. Great support, I use it everyday and highly recommend." T TOKAY Ultimate France · Shopify App Store [Read all reviews on Shopify →](https://apps.shopify.com/flex-stock-sync#adp-reviews) Who uses FlexSync## Built for every kind of Shopify operation Not quite you? See how other merchants use FlexSync. [Growing DTC Brands Weekly price changes, small team Explore →](/use-cases/shopify-dtc-brands/) [Multi-Location Retailers Stock across stores & warehouses Explore →](/use-cases/shopify-multi-location-inventory/) [Agencies and Ops Teams Many client stores, one Drive Explore →](/use-cases/shopify-agencies/) [Solo Merchants Small catalog, no developer Explore →](/use-cases/shopify-solo-merchants/) [High-Volume Merchants 25,000+ SKUs, daily changes Explore →](/use-cases/shopify-high-volume-inventory/) Questions## Frequently asked questions Still have questions? Our support team is available 24/7 at [support@flexsync.app](mailto:support@flexsync.app) . ### Which Google Sheets formulas work with FlexSync? Native Google Sheets formulas, including IF, VLOOKUP, IMPORTRANGE, PROPER and arithmetic. FlexSync syncs the formula's result to Shopify. ### What is a formula-driven cell? 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. ### Do I need to turn the formula feature on? Yes. Enable it in FlexSync first; the formula feature guide walks through the setup step by step. ### Can formulas reference other Sheets or tabs? Yes. Use IMPORTRANGE to pull from another spreadsheet, or VLOOKUP to reference a cost or supplier tab in the same file. ### Do I need Zapier or scripts? No, FlexSync handles the sync and you only write the formula. ## Bring your Shopify store into one live spreadsheet [Install FlexSync Free](https://apps.shopify.com/flex-stock-sync/install?utm_source=flexsync.app&utm_medium=use-case-page&utm_campaign=shopify-google-sheets-formulas) [Unlock Pro](/pricing) ×