Configure Google Sheets

At a glance

Google Sheets is a collaborative spreadsheet application. With Ontologie, you can sync your spreadsheets, individual sheet rows, and metadata into your workspace.

Before you start

• A Google account with access to the spreadsheets you want to sync
• A Google Cloud project with the Sheets API enabled

Get credentials

1. Go to the Google Cloud Console and select or create a project.
2. Navigate to APIs & Services > Library and enable the Google Sheets API.
3. Go to APIs & Services > Credentials and create an OAuth 2.0 Client ID.
4. Add the Ontologie callback URL to the authorized redirect URIs.

Screenshots of the Google Cloud Console will be added in a future update.

Configure in Ontologie

1. Open Live Data > Connectors.
2. Search for Google Sheets in the catalogue.
3. Click the Google Sheets card.
4. Follow the configuration wizard:
   • Method: OAuth
   • See the full guide: OAuth Connector

Available streams

Stream	Description
Spreadsheets	List of all spreadsheets accessible by the authenticated account
Sheets (rows)	Row-level data from individual sheets within a spreadsheet
Metadata	Spreadsheet properties, sheet names, and structure information

Limits

Limit	Value
API quota	300 requests per minute per project (Google default)
Cells per sync	Up to 10 million cells per spreadsheet
Concurrent spreadsheets	No hard limit; subject to API quota

Troubleshooting

Error	Solution
403 Insufficient permissions	Ensure the Sheets API is enabled and the OAuth scope includes spreadsheet access.
Empty rows returned	Check that the spreadsheet contains data in the expected range and the header row is correctly defined.
Rate limit exceeded	Reduce the sync frequency or split large spreadsheets into smaller ones.

Expected result

Your data appears in Live Data > Streams with the Synced status. Synchronization runs at the configured frequency.

Need help?

See the Troubleshooting page for connection errors or write to us: Support and contact.