Google Sheets Integration

Zephyr documentation

How Google Sheets Integration Works

Zephyr can append rows to Google Sheets spreadsheets as a workflow action using OAuth 2.0. When a workflow triggers, the sheets_append action adds a new row containing the email subject, sender, timestamp, and a body excerpt. This is useful for building logs, trackers, or databases from incoming emails without any manual copy-paste.

Setting Up Google Sheets

1) Go to console.cloud.google.com and create or select a project.

2
Enable the Google Sheets API and the Google People API (for userinfo).
3
Create OAuth 2.0 credentials (Web application type).
4
Set the redirect URI to your Zephyr API URL + /connectors/google-sheets/callback.
5
Copy the Client ID and Client Secret.
6
Add them as SSM parameters: /zephyr/prod/google-sheets-client-id and /zephyr/prod/google-sheets-client-secret.
7
Deploy Zephyr.
8
In Settings > Connected Services, click Connect on the Google Sheets card and sign in with your Google account.

Creating Google Sheets Workflows

Example: 'When I receive an invoice email, append a row to my Invoice Log spreadsheet'. The AI generates a workflow with sheets_append specifying your Spreadsheet ID and sheet name (defaults to Sheet1 if not set). Each appended row contains the email subject, sender address, timestamp, and a short excerpt of the email body.

Finding Your Spreadsheet ID

Open your Google Sheet in the browser. The Spreadsheet ID is the long string in the URL between /d/ and /edit. For example, in the URL docs.google.com/spreadsheets/d/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgVE2upms/edit, the ID is 1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgVE2upms. Copy it and paste it into the Spreadsheet ID field in the WorkflowBuilder.