Google Sheets

Connecting Google Sheets lets agents read spreadsheet data and append rows — a common way to log leads, capture form submissions, or hand results to a team that lives in spreadsheets.

Setup

Follow the same Google Cloud steps as Gmail, with two differences: enable the Google Sheets API and the Google Drive API instead of the Gmail API, and use the Sheets redirect variable.

GOOGLE_CLIENT_ID=your-client-id
GOOGLE_CLIENT_SECRET=your-client-secret
GOOGLE_SHEET_REDIRECT_URI=https://api.yourdomain.com/connect/state

The Drive API must be enabled even though this is the Sheets integration — listing available spreadsheets is a Drive operation, so it fails without it.

Scopes requested

Scope	Grants
`https://www.googleapis.com/auth/spreadsheets`	Read and write all spreadsheets
`https://www.googleapis.com/auth/drive.readonly`	List spreadsheets to choose from
`https://www.googleapis.com/auth/userinfo.profile`	Basic profile
`https://www.googleapis.com/auth/userinfo.email`	The account’s address

spreadsheets grants write access to every spreadsheet the authorizing account can reach, not just the one you intend to use. Consider connecting from a dedicated service account with access only to the sheets you want exposed.

Connect

In your workspace, go to Settings → Integrations, find Google Sheets, and click Connect. Choose the Google account that owns — or can reach — the spreadsheets you want to use.

Working with sheets

Add a Google Sheets step to a workflow. The step lets you pick a spreadsheet, then a tab within it, and shows that tab’s columns so you can map values to the right cells. Appending a row is the most common use: capture a lead from a conversation and write it to a sheet your team already watches.

Values are written positionally, so the column order shown in the step is the order they land in. If someone reorders columns in the spreadsheet, revisit the step — the mapping does not follow the change.

Troubleshooting

Symptom	Fix
Spreadsheet list is empty	Drive API not enabled, or the account genuinely has no spreadsheets.
A spreadsheet is missing from the picker	The connected account cannot access that file. Share it with that account.
Rows land in the wrong columns	Columns were reordered in the spreadsheet after the step was configured. Re-map the step.
The tab cannot be found	The tab was renamed or deleted. Tab names are matched exactly, including case and spaces.
Writes fail intermittently under load	Google enforces per-minute quotas on Sheets. Spread the work out rather than writing a row at a time in a tight loop.

Getting started

Integrations

Open source

Setup

Scopes requested

Connect

Working with sheets

Troubleshooting

​Setup

​Scopes requested

​Connect

​Working with sheets

​Troubleshooting

Setup

Scopes requested

Connect

Working with sheets

Troubleshooting