Google Sheets
Connect an online Google Sheet for federated analysis. The sheet is read as a table and can be joined with datasets from other connectors.
When to use
- Reference data, mappings, or manually maintained tables kept in a Google Sheet.
- Enriching data from other sources with a small, human-edited lookup table.
Before you begin
Choose how Datyo authenticates to the sheet:
- Service account — create a Google Cloud service account, generate its JSON key, and share the target spreadsheet with the service account's email address (read access is sufficient). This is the recommended method for a stable, unattended connection.
- Authorization token — an OAuth token with read access to the sheet.
Connection settings
| Field | Required | Description |
|---|---|---|
| Spreadsheet ID | Yes | The spreadsheet identifier from its URL (the portion between /d/ and the next /). |
| Service account JSON | One of | The service account key. Stored encrypted. Remember to share the sheet with the service account. |
| Authorization token | One of | An OAuth token with read access. Stored encrypted. |
Test and save
Enter the fields and use Test connection. On success, the sheet is available for analysis.
Capabilities
- Execution model: Federated. The sheet can be joined with datasets from other connectors.
- Access: Read-only.
- Column types: Inferred from the sheet's contents; a consistent header row and column types improve accuracy.
Troubleshooting
- Permission denied — for a service account, confirm the spreadsheet has been shared with the service account's email; the key alone does not grant access to a private sheet.
- Wrong or empty data — check the Spreadsheet ID and that the intended sheet/tab contains a header row.