Google Sheets Connector
Connector implementation
Build the Google Sheets integration
Spreadsheet rows as contacts, lists, consent updates, suppression lists, or campaign planning data for Brevo.
Implementation Overview
Implement a Google Sheets connector that authenticates to the vendor surface, normalizes source records in Tajo, and activates eligible data in Brevo.
Treat this as an implementation guide. Build and validate the auth, mapping, sync, and operations paths before production use.
developers.google.com/workspace/sheets/api/guides/concepts
| Property | Value |
|---|---|
| Integration surface | Docs |
| Implementation status | Implementation required |
| Category | Data Sources |
| Setup complexity | advanced |
| Vendor documentation | developers.google.com/workspace/sheets/api/guides/concepts |
| Allowed host | Not recorded |
| Base URL | Not recorded |
| OpenAPI schema | Not recorded |
| MCP server | Not recorded |
| Last researched | 2026-08-19 |
High-value Brevo source for CSV-style contact/list syncs. Google discovery docs, not OpenAPI — normalized from official-api to docs-only to match google-calendar. Docs moved under developers.google.com/workspace/.
Authentication
-
Keep developers.google.com/workspace/sheets/api/guides/concepts linked from the connector runbook so operators can confirm vendor behavior during incidents.
-
Store credentials per Tajo workspace and keep tenant-specific secrets out of connector configuration files.
-
Add a credential smoke test that verifies read access to a harmless resource before running backfills or enabling webhooks.
Data To Sync
Start with these inferred data domains, then confirm exact vendor resources and permissions from the source documentation:
- Contact and identity records
- Campaign, messaging, or audience state
- Custom objects and operational metadata
The connector should make source records idempotent by keeping a stable key such as a vendor object ID, email address, event ID, ticket ID, order ID, or campaign ID. If the vendor only exposes list APIs, Tajo should store the cursor strategy and replay policy explicitly.
Sync Shape
No typed contract exists for Google Sheets, so the direction of each resource and its conflict handling are not recorded. Direction is declared per resource on a connector contract; see the connector catalog for how contracts are promoted.
Mapping To Tajo/Brevo
No Brevo projection is recorded for Google Sheets. A projection is declared on a typed connector contract, and Google Sheets does not have one yet, so this page will not state a mapping it cannot source.
The conventions that apply to every connector — stable external IDs, normalization, backfill and sync strategy, error handling, and the builder checklist — are documented once under “Applies to every connector” on the connector catalog.