You can use a Google Sheet as a source in Renable — either as your main product feed or as an auxiliary feed you look up values from. Renable reads the sheet the same way it reads any feed: by fetching it over the web. That only works if the sheet is published to the web first, because a normal sharing link needs a Google sign-in that Renable doesn't have.
Why you have to publish the sheet first#
The link in your browser's address bar — the one that ends in /edit — is a private editing link. Renable can't open it, because it isn't signed in to your Google account. Publishing to the web creates a separate, public link to a read-only copy of the sheet that anyone (including Renable) can read without signing in. There's no way to turn an edit link into a feed link by hand; you have to do the publish step in Google, and then paste the published link.
Step 1: Publish your sheet to the web as CSV#
In Google Sheets:
- Open File → Share → Publish to web.
- Choose the tab you want to use as the feed.
- Pick Comma-separated values (.csv) as the format.
- Click Publish and confirm.
- Copy the published link Google gives you.
Step 2: Add the Google Sheet in Renable#
- Open the catalog and go to the Data sources tab.
- To use the sheet as your main product feed, open the product feed source and choose Google Sheet as the source. To use it as an auxiliary feed, click + Add auxiliary feed and choose Google Sheet.
- Paste your sheet's link into the Google Sheet link field.
Renable tells you what it sees as you paste, and shows a live preview beside the guidance rather than blocking you. If you paste an editing link that can't be read without signing in, the preview says so and the steps above explain how to publish. Once a link actually fetches — a published link always works, and a sheet shared with "anyone with the link" often does too — the preview shows your sheet's columns and rows, and that preview is the real confirmation that the connection works. Publishing to the web is still the reliable route, so prefer it when you can.
A published sheet is readable by anyone with the link#
Publishing to the web removes the sign-in requirement, which is exactly what lets Renable read it — but it also means anyone who has the published link can read that sheet. Don't publish a sheet that contains anything you wouldn't be comfortable sharing publicly. If a sheet holds sensitive data, move the data Renable needs into a separate sheet and publish only that one. Renable shows this reminder wherever a Google Sheet source is set up, because the sheet stays readable for as long as it's published.
Only the tab you published is read#
When you publish, you choose a single tab. Renable reads that one tab — not the whole workbook. Put the rows you want in the feed on the tab you publish, and keep working notes or other data on tabs you don't publish.
Your edits don't appear instantly#
Google serves a cached copy of a published sheet and refreshes it on its own schedule, so a change you make in the sheet won't necessarily show up in Renable the moment you save it — give your edits a little while to appear rather than expecting them immediately. Renable re-fetches the sheet on each import, so the latest published copy is what gets used.
Publish the catalog to start using the sheet#
Like every catalog change, adding a Google Sheet source lives in your draft and doesn't take effect until you Publish the catalog. "Import now" uses your last published configuration, so publish first, then import. The draft-and-publish model is covered in Transforming your feed.
Or ask Aimée#
You don't have to set this up in the dialog yourself. Paste your published sheet link to Aimée and ask her to use it as your product feed — she'll check that it fetches, set it on your catalog draft, and remind you that a published sheet is readable by anyone with the link. If the link isn't published yet, she'll walk you through the publish-to-web steps.
You can also ask her to add a published sheet as an auxiliary feed — "use this sheet for stock levels" or "look up supplier prices from this sheet". She adds it to your catalog draft as a Google Sheet source and can wire the lookup for you; publish the catalog and the next import reads the sheet. She'll give you the same publish-to-web steps if the link isn't published yet, and the same reminder that a published sheet is public.
Where to go next#
- Joining another feed — look up values from an auxiliary feed, including a Google Sheet.
- Mapping tables — build a small lookup table by hand instead of hosting one in a sheet.
- Transforming your feed — the draft-and-publish model these edits live in.