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.

​

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

​

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