Use a Google Sheets link as a source
Run a feed off a Google Sheet by publishing it as a CSV link. Edit the sheet, and your feed refreshes from it on schedule, with no upload and no extra logins.
Why Google Sheets makes a great source
A Google Sheet is one of the easiest ways to manage a product catalog by hand and still get automatic feeds. You keep your products in the sheet, MartechFlow reads them on a schedule, and your output feeds stay in sync with whatever you typed. It is the stupid-simple path for small or fast-changing catalogs that do not live in a store platform.
MartechFlow treats a published Google Sheet as a CSV source. That means no Google sign-in, no app permissions, and no special access to grant. You publish the sheet to the web as CSV, and MartechFlow fetches that link like any other CSV feed URL.
Publish your sheet as CSV
The key step is to publish the sheet (or a specific tab) as a CSV link so MartechFlow can read it. Publishing is different from sharing: a shared link still needs Google authentication, while a published CSV link serves plain data.
- 1Open your sheet in Google Sheets. Make sure the first row is your column headers and each row below is one product.
- 2Go to File, then Share, then Publish to web.
- 3Choose the specific tab that holds your products (not Entire Document), and set the format to Comma-separated values (.csv).
- 4Click Publish and copy the link Google gives you. This is your published CSV URL.
- 5In MartechFlow, add a new feed, choose Google Sheet (published CSV) as the source, and paste that link.
Connect it in MartechFlow
In the New feed form, pick Google Sheet (published CSV) for the source type and paste your published link into the URL field. MartechFlow reads it as a CSV: the first row becomes your column names and each row becomes a product. Open the feed, load a preview to confirm the columns look right, then map your fields and set a refresh schedule on the Source tab.
Keeping it current
Once published, your sheet updates the feed automatically. When you edit a price or add a row, the next scheduled refresh picks up the change, with no re-publish needed. Set the refresh frequency to match how often you edit the sheet.
A couple of things to watch. Google can take a short while to update the published copy after you edit, so a change may appear on the next refresh rather than instantly. And if you ever stop publishing the sheet or remove access, the feed can no longer read it, so leave the published link in place while the feed is live.