Get Spreadsheet Values
sheets_get_valuesRead-onlyIdempotent
Read cell values from a specified range in a Google Spreadsheet. Returns data as rows or columns in markdown or JSON format.
Instructions
Read cell values from a specific range in a Google Spreadsheet.
Args:
spreadsheet_id (string): The ID of the Google Spreadsheet
range (string): The A1 notation range to read (e.g., 'Sheet1!A1:D10' or 'A1:D10')
major_dimension ('ROWS' | 'COLUMNS'): Return data by rows or columns (default: 'ROWS')
response_format ('markdown' | 'json'): Output format (default: 'markdown')
Returns: For JSON format: { "range": string, "majorDimension": string, "values": [[cell values...], ...] }
Examples:
Read range: spreadsheet_id="...", range="Sheet1!A1:D10"
Read specific column: spreadsheet_id="...", range="Sheet1!A:A"
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| spreadsheet_id | Yes | The ID of the Google Spreadsheet | |
| range | Yes | The A1 notation range to read (e.g., 'Sheet1!A1:D10' or 'A1:D10') | |
| major_dimension | No | Whether to return data by rows or columns | ROWS |
| response_format | No | Output format: 'markdown' for human-readable or 'json' for structured data | markdown |