get_sheet_data
Obtain data from a Google Sheet by providing the spreadsheet ID and sheet name, with an optional cell range. By default, returns only cell values; include grid data for formatting details.
Instructions
Get data from a specific sheet in a Google Spreadsheet.
Args: spreadsheet_id: The ID of the spreadsheet (found in the URL) sheet: The name of the sheet range: Optional cell range in A1 notation (e.g., 'A1:C10'). If not provided, gets all data. include_grid_data: If True, includes cell formatting and other metadata in the response. Note: Setting this to True will significantly increase the response size and token usage when parsing the response, as it includes detailed cell formatting information. Default is False (returns values only, more efficient).
Returns: Grid data structure with either full metadata or just values from Google Sheets API, depending on include_grid_data parameter
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| spreadsheet_id | Yes | ||
| sheet | Yes | ||
| range | No | ||
| include_grid_data | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |