Get Google Spreadsheet
sheets_get_spreadsheetRetrieve Google Spreadsheet metadata, including sheet titles, row/column counts, and optional cell data, using the spreadsheet ID. Output as markdown or JSON.
Instructions
Retrieve metadata and optionally cell data from a Google Spreadsheet.
Args:
spreadsheet_id (string): The ID of the Google Spreadsheet (found in the URL after /d/)
include_grid_data (boolean): Whether to include cell data (default: false)
response_format ('markdown' | 'json'): Output format (default: 'markdown')
Returns: Spreadsheet title, sheets info, and metadata. For JSON format: { "spreadsheetId": string, "title": string, "locale": string, "sheets": [{ "sheetId": number, "title": string, "rowCount": number, "columnCount": number }], "spreadsheetUrl": string }
Examples:
Get spreadsheet info: spreadsheet_id="1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms"
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| spreadsheet_id | Yes | The ID of the Google Spreadsheet (found in the URL) | |
| response_format | No | Output format: 'markdown' for human-readable or 'json' for structured data | markdown |
| include_grid_data | No | Whether to include cell data (can be large) |