Tool Docs
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.