Connecting a Google Sheet as a Feed

Use a Google Sheet as a product feed or an auxiliary feed. Publish the sheet to the web as CSV and paste the published link into your catalog.

Updated November 6, 2026

You can use a Google Sheet as your product feed, or as an auxiliary feed you look up values from. Publish the sheet to the web first, because Renable can't sign in to your Google account to read the link in your address bar.

Step 1: publish your sheet to the web as CSV#

In Google Sheets:

  1. Open File → Share → Publish to web.
  2. Choose the tab you want to use as the feed.
  3. Pick Comma-separated values (.csv) as the format.
  4. Click Publish and confirm.
  5. Copy the published link Google gives you.

Anyone with the published link can read the sheet for as long as it's published. If the sheet holds sensitive data, copy what Renable needs into a separate sheet and publish that one.

Step 2: add the sheet in Renable#

  1. Open the catalog and go to the Data sources tab.
  2. To use the sheet as your product feed, click Add product feed, or open the card of the feed you have, and choose Google Sheet as the source. To use it as an auxiliary feed, click + Add auxiliary feed and choose Google Sheet….
  3. Paste the link into the Google Sheet link field. The preview shows your sheet's columns and rows once Renable can read it. If you pasted an editing link, it tells you to publish first.
  4. Click Save (it reads Save & generate mapping if the product feed has no mapping yet), then Publish the catalog. If you want the sheet read straight away, click Import now after publishing.

A sheet shared with "anyone with the link" often works without publishing, but publishing is the reliable route.

Good to know#

  • Only the published tab is read. Keep your feed rows on that tab, and notes or other data on tabs you don't publish.
  • Several images for one product: put them in one cell, separated by commas. Renable splits additional_image_link and lifestyle_image_link automatically. Any other comma-separated cell stays one value until you add a Split step. See Mapping your feed to catalog fields.
  • Edits can take a while to arrive. Google refreshes a published sheet on its own schedule, so a change won't always reach Renable the moment you save it. Each import reads the latest published copy.

Or ask Aimée#

Paste your published link to Aimée and tell her what it's for ("use this sheet as my product feed" or "look up supplier prices from this sheet"). She checks the link, adds it to your draft, and can set up the lookup. Publish the catalog and the next import reads the sheet. If the link isn't published yet, she'll walk you through it.

Where to go next#