Skip to content

Google Sheets

Google Sheets can be used as a simple data source to manage and synchronize product information directly from spreadsheets. This is ideal for smaller datasets or quick prototyping.

ConnectorSupported Features
Items✅ Attributes   ✅ Name   ❌ Family code   ✅ Unit of Measures   ❌ Images   ❌ Attachments
Prices❌ Not supported
Stock❌ Not supported
Orders❌ Not supported
Customers❌ Not supported

Settings

In the app you need to configure your GoogleSheet connector. We need the ID of the sheet we need to look at.

To share a Google sheet with our connector, you need to configure the following in your google sheet:

  • File -> Share -> Share with others -> General access -> set to Anyone with the link -> Done

Afterwards you can copy the ID from the url, see the bold part in the example down below:

https://docs.google.com/spreadsheets/d/**1czi_fUjwpcxnFxw5639tM0HLZDMfqOlDRhia7oJEC0k**/edit?gid=0#gid=0