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
File format
Use a file in Google Sheets format. Opening an
.xlsxfile in Google Sheets keeps it in Excel format. Convert the file before connecting it.
Get credentials
- Go to the Google Cloud Console and select or create a project.
- Navigate to APIs & Services > Library and enable the Google Sheets API.
- Go to APIs & Services > Credentials and create an OAuth 2.0 Client ID.
- 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
- Open Live Data > Connectors.
- Search for Google Sheets in the catalogue.
- Click the Google Sheets card.
- 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. |
Convert an Excel file
If the connection test reports an unsupported file format, convert your Excel workbook to Google Sheets.
- Open the Excel file in Google Sheets.
- From File, choose Save as Google Sheets. Google creates a new file.
- Check that the Google account you connected can open the new file.
- In Live Data, open your source, then Configuration. Replace the spreadsheet URL with the new file’s URL and run the connection test again.
You can keep the existing OAuth authorization for the same Google account.
Resume a paused sync
In Live Data > Sources, click Resume. Your Google authorization and schedule stay in place. To import data right away, click Sync now.
Check the result in Runs and open the imported data from Data.
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.

