Google Workspace Connector
Reference Connector v1
AD
Google reference implementation

Organization · Google Workspace

Google Sheets can act as a client-owned ADV record store while Gmail handles optional notifications. OAuth refresh credentials stay server-side.

Active adapter: —

Primary DataGoogle SheetsOne tab per ADV model
NotificationsGmail APIOptional send connector
AuthorizationOAuth 2.0Refresh token server-side
ResidencyClient-OwnedDefault Google deployment

Environment Readiness

Only configuration presence is shown.

Checking...

Adapter Mode

Switch only after the connector is healthy.

Spreadsheet Bootstrap

Creates missing ADV tabs and header rows in an existing authorized spreadsheet.

Waiting for configuration.

Required Netlify Environment Variables

Never store these credential values in GitHub.

ADV_GOOGLE_CLIENT_ID

OAuth client ID.

ADV_GOOGLE_CLIENT_SECRET

OAuth client secret, server-side only.

ADV_GOOGLE_REFRESH_TOKEN

Long-lived OAuth refresh token, server-side only.

ADV_GOOGLE_SPREADSHEET_ID

Authorized ADV operational spreadsheet.

ADV_GOOGLE_GMAIL_USER

Optional mailbox identity used for Gmail send. Defaults to me.

Prepared Google Components

Same ADV contract, different connector.

Sheets Manifest — 13 common ADV tabs.
Setup Guide — OAuth and deployment choices.
Sheets CRUD: create/read/update/delete common ADV records by stable ADV ID.
Gmail Send: optional server-side notification endpoint.