Spreadsheet overview
get_spreadsheet_infoRetrieve a spreadsheet's title, tabs, charts, named ranges, and preview rows to map its layout before making changes.
Instructions
Get a spreadsheet's title, tabs (sizes, frozen rows/cols), charts (ids, types, data ranges), named ranges, and the first few rows of each tab. Call this first to understand a sheet's layout.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| account | No | Google account to use: an email or unique part of one (e.g. "acme.com"). Default: the account that can open the spreadsheet, else the default account. | |
| spreadsheet | Yes | Google Sheets link or spreadsheet ID. The name of a spreadsheet used with Sheets MCP before also works | |
| preview_rows | No |