Spreadsheet Tools

The Google Sheets tools enable AI Agents to interact with Google Sheets spreadsheets, allowing them to create, read, update, and manage spreadsheet data and properties.

Google Sheets integration required. Learn how to set up.

Available Tools

Tool Name	Description
Add Rows	Append new rows to a Google Sheets spreadsheet
Create New Spreadsheet	Create a new spreadsheet file in Google Sheets
List All Spreadsheets	Retrieve a list of all spreadsheet files in a Google Sheets account
List All Rows	Get all rows from a specific tab in a spreadsheet
List All Tabs	View all tabs in a Google Sheets spreadsheet
Search Files	Search for specific spreadsheet files
Update Row Properties	Update structural or formatting properties of rows
Update Row Values	Modify the content/values of specific rows

Google Sheets

Add Rows

Description: Adds new rows to the end of a specified Google Sheets spreadsheet tab. System Tool ID: google_sheets_append_rows Arguments:

Name	Required	Type	Description
spreadsheet_id	Required	string	The ID of the target spreadsheet
tab_id	Required	string	The ID of the specific tab
values	Required	array	Array of arrays containing row values as strings

Create New Spreadsheet

Description: Creates a new Google Sheets spreadsheet with specified name. System Tool ID: google_sheets_create_file Arguments:

Name	Required	Type	Description
name	Required	string	Name for the new spreadsheet

List All Spreadsheets

Description: Retrieves a list of all spreadsheet files in the connected Google Sheets account. System Tool ID: google_sheets_find_all_files Arguments:

Name	Required	Type	Description
cursor	Optional	string	Pagination cursor for large lists

List All Rows

Description: Retrieves all rows from a specified tab in a Google Sheets spreadsheet. System Tool ID: google_sheets_find_all_rows Arguments:

Name	Required	Type	Description
spreadsheet_id	Required	string	ID of the target spreadsheet
tab_id	Required	string	ID of the specific tab
cursor	Optional	string	Pagination cursor for large datasets

List All Tabs

Description: Retrieves all tabs present in a specified Google Sheets spreadsheet. System Tool ID: google_sheets_find_all_tabs Arguments:

Name	Required	Type	Description
spreadsheet_id	Required	string	ID of the target spreadsheet
cursor	Optional	string	Pagination cursor for large lists

Search Files

Description: Searches for Google Sheets files based on a query string. System Tool ID: google_sheets_search_files Arguments:

Name	Required	Type	Description
query	Required	string	Search query to find specific files
cursor	Optional	string	Pagination cursor for search results

Update Row Properties

Description: Updates structural or formatting properties of rows in a Google Sheets spreadsheet. System Tool ID: google_sheets_update_rows Arguments:

Name	Required	Type	Description
spreadsheet_id	Required	string	ID of the target spreadsheet
body	Required	object	Request body containing update operations

This tool uses the batchUpdate endpoint and is specifically for structural or formatting changes to the spreadsheet.

Update Row Values

Description: Updates the content/values of specific rows in a Google Sheets spreadsheet. System Tool ID: google_sheets_update_rows_values Arguments:

Name	Required	Type	Description
spreadsheet_id	Required	string	ID of the target spreadsheet
body	Required	object	Request body containing the values to update

This tool uses the values:batchUpdate endpoint and is specifically for updating cell values/content.

Basics

AI Agents

Platform Capabilities

Tool Docs

Trigger Docs

How to Guides

API Documentation

Help

Available Tools

Google Sheets

Add Rows

Create New Spreadsheet

List All Spreadsheets

List All Rows

List All Tabs

Search Files

Update Row Properties

Update Row Values

​Available Tools

​Google Sheets

​Add Rows

​Create New Spreadsheet

​List All Spreadsheets

​List All Rows

​List All Tabs

​Search Files

​Update Row Properties

​Update Row Values

Available Tools

Google Sheets

Add Rows

Create New Spreadsheet

List All Spreadsheets

List All Rows

List All Tabs

Search Files

Update Row Properties

Update Row Values