Google Sheets
Sync data to a Google Sheets spreadsheet. Use Zeotap to populate spreadsheets with model results, audience lists, or enriched data for teams that work in Google Sheets.
Prerequisites
- A Google account with access to Google Sheets
- A Google Sheets spreadsheet to write to
- The spreadsheet must be accessible by the authenticated Google account
Authentication
Google Sheets uses Google OAuth 2.0 with PKCE authentication.
- Click Connect with OAuth in Zeotap
- Sign in with the Google account that can edit the spreadsheet
- Under Spreadsheet, paste the spreadsheet URL or ID and click Select in Google Drive. The Google Drive picker opens on that spreadsheet; click Select to confirm it. You can also browse to the spreadsheet in the picker.
- Click Test to confirm Zeotap can open it
Required OAuth Scopes
https://www.googleapis.com/auth/drive.file— access only to the spreadsheets you select in the Google Drive picker
Zeotap can open only the spreadsheets you select. Reads and writes go through the Google Sheets API. To sync to a different spreadsheet, select it the same way, in the destination or in the sync’s destination settings.
Configuration
Google Sheets does not require additional configuration fields beyond authentication.
Target Settings
| Field | Type | Required | Description |
|---|---|---|---|
| Spreadsheet | Google Drive file | Yes | The spreadsheet to write to, selected with Select in Google Drive. You can paste its URL (https://docs.google.com/spreadsheets/d/{SPREADSHEET_ID}/edit) or ID first; the picker then opens on it. |
| Worksheet Name | Text | No | The name of the worksheet tab to sync data to. Default: Sheet1 |
Supported Operations
Sync Modes: Insert, Upsert, Mirror
Audience Sync Modes: Add, Remove, Mirror, Upsert
Features
- Field Mapping: Yes
- Schema Introspection: Yes — Zeotap reads the first row of the worksheet as column headers
How It Works
Zeotap writes data to the specified worksheet in the Google Sheets spreadsheet:
- The first row of the worksheet is treated as the header row (column names)
- For Insert mode, new rows are appended below existing data
- For Upsert and Mirror modes, the worksheet is cleared and rewritten with the complete dataset including headers
- If the target worksheet does not exist, Zeotap creates it automatically
Schema Introspection
Zeotap reads the first row of the target worksheet to discover available columns. This enables field mapping — you can map source fields to specific spreadsheet columns.
If the worksheet is empty, Zeotap creates the header row from the mapped fields on the first sync.
Troubleshooting
Spreadsheet not found
Verify the spreadsheet ID is correct. The ID is the long string in the spreadsheet URL between /d/ and /edit. Ensure the authenticated Google account has access to the spreadsheet.
Authentication expired
Google OAuth tokens expire periodically. If you see authentication errors, reconnect the Google Sheets integration in Zeotap by re-authorizing with OAuth.
Worksheet not found
If the specified worksheet name does not exist, Zeotap automatically creates it in the spreadsheet. The default worksheet is Sheet1.
Rate limited
Google Sheets API has quotas of 60 requests per minute per user. For large datasets, Zeotap batches writes to stay within limits. Very large syncs may take longer due to rate limiting.
Spreadsheet too large
Google Sheets has a limit of 10 million cells per spreadsheet. If your data exceeds this limit, consider using a warehouse destination (BigQuery, Snowflake) instead.
Permission denied
The authenticated Google account must have Editor access to the spreadsheet. View-only access is not sufficient. Share the spreadsheet with the Google account used for OAuth.