get_spreadsheet_info
Retrieve spreadsheet metadata including title, locale, tab names, and sheet IDs. Discover tab names and IDs to prepare for reading values or managing sheets.
Instructions
Inspect a spreadsheet's metadata (title, locale, tabs, sizes).
Use this to discover sheet (tab) names and sheetIds before calling read_sheet_values, manage_sheet_tabs, or protect_sheet_range. Also surfaces conditional format counts per tab. Does not read cell values — use read_sheet_values for that. Requires the spreadsheets.readonly OAuth scope.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| user_google_email | Yes | The user's Google email address (authenticated account). | |
| spreadsheet_id | Yes | Spreadsheet ID from list_spreadsheets or a URL like docs.google.com/spreadsheets/d/<id>/edit. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |