sheets_get_spreadsheet
Retrieve spreadsheet metadata, tab titles, IDs, dimensions, and named ranges; exclude cell data by default or include grid data for formatting with range limits.
Instructions
Get spreadsheet metadata, tab titles/IDs, dimensions, named ranges, and other properties. Cell grid data is excluded by default; enable it for formatting and restrict ranges for large spreadsheets. Discover spreadsheet IDs with drive_search_files using mimeType = 'application/vnd.google-apps.spreadsheet'.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| No | Google account email. May be omitted when exactly one account is configured; required when multiple accounts are configured. | ||
| ranges | No | ||
| include_grid_data | No | Default false; true includes cell data and formatting | |
| spreadsheet_id_or_url | Yes | Google Sheets spreadsheet ID or full docs.google.com/spreadsheets URL. The URL's gid does not select a tab; use a sheet-qualified range. |