Skip to content

How-to guide

Configure Google Sheets

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

3 min

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 Google Sheets logo

Use a file in Google Sheets format. Opening an .xlsx file in Google Sheets keeps it in Excel format. Convert the file before connecting it.

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:

Available streams

StreamDescription
SpreadsheetsList of all spreadsheets accessible by the authenticated account
Sheets (rows)Row-level data from individual sheets within a spreadsheet
MetadataSpreadsheet properties, sheet names, and structure information

Limits

LimitValue
API quota300 requests per minute per project (Google default)
Cells per syncUp to 10 million cells per spreadsheet
Concurrent spreadsheetsNo hard limit; subject to API quota

Troubleshooting

ErrorSolution
403 Insufficient permissionsEnsure the Sheets API is enabled and the OAuth scope includes spreadsheet access.
Empty rows returnedCheck that the spreadsheet contains data in the expected range and the header row is correctly defined.
Rate limit exceededReduce 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.

  1. Open the Excel file in Google Sheets.
  2. From File, choose Save as Google Sheets. Google creates a new file.
  3. Check that the Google account you connected can open the new file.
  4. 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.

Did this page help you achieve your goal?