Tools for writing data to Google Sheets.
Validate and normalize a range name.
Permissive A1 validator. Supports:
'A1', 'Z99''A1:B2''A:A', 'B:D''1:1', '5:10''Sheet1!A1', "'My Sheet'!A1:B2"'MyData', 'Sales_2024'Validate and normalize a Google Spreadsheet ID.
Base class for Google Sheets tools.
Authentication:
api_resource: OAuth2 credentials for full access (read/write private sheets)api_key: API key for read-only access (public sheets only)Write operations require OAuth2 credentials.
Google Sheets insert data options for append operations.
Determines how data should be inserted when appending to a table.
Google Sheets value input options for write operations.
Determines how input values should be interpreted when writing to cells.
Base schema for write operations with common fields.
Input schema for SheetsUpdateValuesTool.
Tool for updating values in a single range of Google Sheets.
Inherits from
SheetsBaseTool.
Updates cell values in a specified range, overwriting existing data.
Requires OAuth2 authentication. Use api_resource parameter with
authenticated Google Sheets service.
Input schema for SheetsAppendValuesTool.
Tool for appending values to a Google Spreadsheet table.
Inherits from
SheetsBaseTool.
Appends data to the end of a table, automatically finding the last row with data.
Requires OAuth2 authentication. Use api_resource parameter with
authenticated Google Sheets service.
Input schema for SheetsClearValuesTool.
Tool for clearing values from a Google Spreadsheet range.
Inherits from
SheetsBaseTool.
Clears cell values from a specified range while preserving formatting and structure.
Requires OAuth2 authentication. Use api_resource parameter with
authenticated Google Sheets service.
Only values are cleared. Formatting, borders, colors, fonts, and data validation rules remain intact.
Schema for a single range update in batch operation.
Input schema for SheetsBatchUpdateValuesTool.
Tool for batch updating multiple ranges in Google Sheets efficiently.
Inherits from
SheetsBaseTool.
Updates multiple ranges in a single API call, dramatically improving efficiency.