Skip to main content
Back to list of enterprise systems Use the Google Sheets integration to create spreadsheets and worksheets, add and update rows, find and export data, format rows, and manage worksheets through Action Tools. It also provides triggers for new or updated rows, new rows, spreadsheets, and worksheets.

Supported actions

Triggers

Prerequisites

  • A Google account with access to the spreadsheets, worksheets, and Shared Drives used by your tools.
  • A Google Cloud project with the Google Sheets API and Google Drive API enabled, and an OAuth client for Studio.

Set up the integration

1

Prepare Google OAuth credentials

Create an OAuth client in Google Cloud and add the callback URL displayed in the Studio auth profile as an authorized redirect URI. Enable the Google Sheets API and Google Drive API for the Google Cloud project.
2

Create the auth profile

In Integrations, select Google Sheets > Connect. On Project Auth Profiles, select New Profile > Integration Profile > Google Sheets > Continue. Use OAuth 2.0 and the Preconfigured usage mode. Studio prepopulates the authorization URL (https://accounts.google.com/o/oauth2/v2/auth), token and refresh URLs (https://oauth2.googleapis.com/token), and authorization parameters (response_type=code, access_type=offline, and prompt=consent). The requested scopes are https://www.googleapis.com/auth/spreadsheets, https://www.googleapis.com/auth/drive.readonly, and https://www.googleapis.com/auth/drive; PKCE is off by default. Enter the OAuth client ID and secret, copy the callback URL into the OAuth client configuration, and select Create Profile.
3

Create the action tool

In Tools, select New Tool > Action > Google Sheets > Continue. Select the Action and Auth Profile, configure the inputs, and choose whether to return the complete connector response or define custom output parameters. Select Create Tool, then assign the tool to an agent.

Action reference

These fields match the Google Sheets action forms in Studio. Spreadsheet, worksheet, folder, and column dropdowns are populated from the selected auth profile and prior selections. The optional includeTeamDrives boolean appears on every action except Custom API Call. It defaults to false; enable it to include spreadsheets and folders in Shared Drives in the dropdowns.

Trigger reference

The optional includeTeamDrives trigger setting defaults to false. Turn it on to include Shared Drive spreadsheets in the Spreadsheet dropdowns. The spreadsheet and worksheet dropdowns update from the selected profile and prior selections.

Troubleshoot common issues