On this page
Google Sheets: How to setup an integration via Google Sheets
Sync your costs (and min, max, MAP and more) into Flashpricer from a Google Sheet: publish the sheet as a CSV, then connect it as a Hosted CSV integration. Flashpricer re-reads it automatically every 30 minutes.
Keep a Google Sheet of your SKUs and costs, publish it as a CSV, and connect it to Flashpricer as a Hosted CSV integration. Flashpricer re-reads the sheet automatically — so your costs (and min, max, MAP and more) stay in sync without manual uploads.
There are two halves to this: publish your Google Sheet as a CSV, then point Flashpricer at its URL. Once connected, Flashpricer polls the sheet on a schedule and updates your items — no more manual cost uploads.
Part 1 — Publish your Google Sheet as a CSV
In Google Sheets, add a header row with SKU and the columns you want to sync (at least one of cost, min, max, MAP…). One SKU per row.
Go to File → Share → Publish to web. In the dialog, change Web Page to Comma-separated values (.csv), then click Publish.
Google gives you a public link ending in output=csv. Copy it — that's the URL Flashpricer needs (not the normal share link).
In Google Sheets, open File → Share → Publish to web:
In the Publish to web dialog, switch the format from Web page to Comma-separated values (.csv), then click Publish:
Publish this document to the web. Published content will be visible to anyone who has the link.
Google gives you a link ending in output=csv — copy that. Your sheet just needs a header row and a SKU column, for example:
| A | B | C | D | |
|---|---|---|---|---|
| 1 | SKU | COST | MIN | MAX |
| 2 | SKU-1 | 12.50 | 15.99 | 24.99 |
| 3 | SKU-2 | 8.00 | 10.99 | 18.50 |
Use the CSV-published URL — not the share link. A normal "Share" link points to a web page, not a CSV, so Flashpricer can't read it. Make sure you copied the link from Publish to web → Comma-separated values (.csv).
What columns can you include?
The only required column is SKU. Add at least one of the optional columns below — you're not limited to cost. Headers are matched by name (case-insensitive, any order):
| Column header | Updates… |
|---|---|
| SKU Required | Identifies the item to update. |
| COST | The item cost. |
| MIN | The manual minimum price. |
| MAX | The manual maximum price. |
| MAP | The Minimum Advertised Price. |
| SALES CHANNEL ID | Targets a specific sales channel for that row. |
| STRATEGY ID | Assigns a repricing strategy. |
| FBM SHIPPING COST | The merchant shipping cost. |
Part 2 — Connect it in Flashpricer
Go to Settings → Integrations.
Click Connect Integration and choose Hosted CSV from the menu.
Give the integration a Name, paste your CSV Url, and click Create CSV integration.
Then fill in the form:
The CSV file must be hosted on a public URL and contain the following column headers: SKU + one or all of the following COST, MIN, MAX, MAP, SALES CHANNEL ID, STRATEGY ID, CURRENCY, FBM SHIPPING COST.
Flashpricer checks the URL as you enter it and previews the headers it recognized, so you'll know right away if the sheet is set up correctly. It also runs a first sync as soon as you create the integration.
How the sync works
- ·Automatic every 30 minutes. Flashpricer re-reads the sheet on a schedule — edit the sheet and your data updates on the next cycle. It also syncs once right after you connect it.
- ·Costs you set by hand are safe. A cost you set manually (or via a bulk upload) takes precedence — the sheet only updates a cost that itself came from an integration. (Min, max and other fields are last-writer-wins: the most recent change from any source wins.)
- ·Empty or 0 cost clears it. A blank or
0cost is treated as "no cost" and also clears that item's calculated min/max — leave real values in every row you want kept. - ·Big swings trigger a heads-up. A cost change over both 50% and $20 still applies, but you'll get a warning email so you can double-check the sheet.
Troubleshooting
If the URL won't validate or a sync fails, it's usually one of these:
- ·URL unreachable or errored — the link isn't public, or the host returned an error. Re-copy the Publish to web → CSV link and make sure the sheet is still published.
- ·Missing headers — the file must have a header row with SKU plus at least one recognized column (cost, min, max…). A share link (which returns a web page) fails this check.
- ·Too few rows — the CSV needs a header row and at least one data row.
- ·Stuck in error > 5 days — an integration left in an error state for over 5 days is disabled automatically; fix the sheet and reconnect.
Frequently asked
Do I have to include a cost column?
How often does it update?
Will it overwrite costs I set by hand?
Why won't my URL validate?
Publish your sheet, then connect it on Settings → Integrations. Questions? Email success@flashpricer.com.