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.

Connector	Supported 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.

Required setting

• SpreadsheetId: the Google Spreadsheet ID.

Example URL:

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

Spreadsheet ID:

1czi_fUjwpcxnFxw5639tM0HLZDMfqOlDRhia7oJEC0k

Authorization modes

The Google Sheets connector supports two modes:

1. Public sheet mode (no OAuth)
2. OAuth mode (authorized in App settings)

1. Public sheet mode (no OAuth)

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

After that, only SpreadsheetId is needed.

2. OAuth mode (authorized in App settings)

You can also authorize the connector from the App, the same way as Exact Online:

• Go to: Settings -> Connectors -> GoogleSheet
• Click Authorize GoogleSheet
• Complete the Google OAuth flow
• Return to the connector settings page

After authorization:

• The connector reads data through the Google Sheets API using OAuth access tokens.
• This allows reading sheets that are not publicly shared.
• You can revoke access from the same connector settings page using Revoke Authorization.

What This Changes In Practice

For customers, the key difference is how sheet access is granted:

Mode	How access works	Does sheet need to be public?	Recommended
Public sheet mode	Access through public export URL	Yes (Anyone with the link)	No, only for quick tests
OAuth mode	Access through Google API with authorized token	No	Yes

Practical impact for customers

• With public mode, anyone with the link can potentially access the sheet data.
• With OAuth mode, the sheet can stay private and access is based on explicit authorization.
• OAuth mode is better for production, security, and compliance requirements.

Recommendation

Use OAuth mode for customer environments.
Use public mode only for temporary demos or rapid prototyping.