Tools for reading data from 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 date/time render options.
Determines how dates, times, and durations should be rendered in the response.
Google Sheets major dimension options.
Determines how the values should be oriented in the response.
Google Sheets value render options.
Determines how values should be rendered in the response.
Base schema for read operations with common fields.
Base class for Google Sheets read operations.
Provides shared functionality for data processing, value extraction, and record conversion that is common across all read tools.
Input schema for SheetsReadDataTool.
Tool for reading data from a single range in Google Sheets.
Inherits from
BaseReadTool.
Reads data from a single range with support for various rendering options and data transformations.
Input schema for SheetsBatchReadDataTool.
Tool for reading data from multiple ranges in Google Sheets efficiently.
Inherits from
BaseReadTool.
Reads multiple ranges in a single API call, reducing network overhead and improving performance.
Schema for DataFilter used with getByDataFilter API.
Input schema for SheetsFilteredReadDataTool.
Tool for reading data from Google Sheets using DataFilters.
Uses getByDataFilter API to read ranges specified by A1 notation, grid
coordinates, or developer metadata. Optionally includes detailed cell formatting.
Requires OAuth2 authentication (not API key).
This tool is for RANGE SELECTION, not conditional filtering like
'score > 50'. For conditional filtering, create a Filter View using
Sheets UI or batchUpdate API.