sheets_batch_get_values
Retrieve values from multiple specified ranges in a Google Sheets spreadsheet using A1 notation, with options for major dimension and value representation.
Instructions
Get values from multiple ranges in a Google Sheets spreadsheet
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| majorDimension | No | The major dimension of the values (default: ROWS) | |
| ranges | Yes | Array of A1 notation ranges to retrieve (e.g., ["Sheet1!A1:B10", "Sheet2!C1:D5"]) | |
| spreadsheetId | Yes | The ID of the spreadsheet (found in the URL after /d/) | |
| valueRenderOption | No | How values should be represented (default: FORMATTED_VALUE) |