Get Spreadsheet Information
get_spreadsheet_infoRetrieve details of a Google spreadsheet, including sheet names and IDs, to understand its structure.
Instructions
Get information about a specific spreadsheet including its sheets
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| spreadsheet_id | Yes | The ID of the spreadsheet to get info for. Required. | |
| user_google_email | No | The user's Google email address for Sheets access. If None, uses the current authenticated user from FastMCP context (auto-injected by middleware). |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| error | No | Error message if operation failed | |
| title | Yes | Title of the spreadsheet | |
| sheets | Yes | List of sheets in the spreadsheet | |
| sheetCount | Yes | Total number of sheets | |
| spreadsheetId | Yes | Unique identifier for the spreadsheet | |
| spreadsheetUrl | No | Web URL for the spreadsheet |