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 optionalincludeTeamDrives 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.
Add Row
Add Row
Add Multiple Rows
Add Multiple Rows
Update Row
Update Row
Update Multiple Rows
Update Multiple Rows
Delete Row
Delete Row
Find Rows
Find Rows
Create Spreadsheet
Create Spreadsheet
Create Worksheet
Create Worksheet
Clear Sheet
Clear Sheet
Delete Worksheet
Delete Worksheet
Rename Worksheet
Rename Worksheet
Format Row(s)
Format Row(s)
Get Single Row by ID
Get Single Row by ID
Get next row(s)
Get next row(s)
Get All Rows
Get All Rows
Find Spreadsheet(s)
Find Spreadsheet(s)
Find Worksheet(s)
Find Worksheet(s)
Copy Worksheet
Copy Worksheet
Create Spreadsheet Column
Create Spreadsheet Column
Export Worksheet
Export Worksheet
Custom API Call
Custom API Call
Trigger reference
The optionalincludeTeamDrives 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.
New or Updated Row
New or Updated Row
New Row Added
New Row Added
New Spreadsheet
New Spreadsheet
New Worksheet
New Worksheet