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
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) |
Input Schema (JSON Schema)
{
"properties": {
"majorDimension": {
"description": "The major dimension of the values (default: ROWS)",
"enum": [
"ROWS",
"COLUMNS"
],
"type": "string"
},
"ranges": {
"description": "Array of A1 notation ranges to retrieve (e.g., [\"Sheet1!A1:B10\", \"Sheet2!C1:D5\"])",
"items": {
"type": "string"
},
"type": "array"
},
"spreadsheetId": {
"description": "The ID of the spreadsheet (found in the URL after /d/)",
"type": "string"
},
"valueRenderOption": {
"description": "How values should be represented (default: FORMATTED_VALUE)",
"enum": [
"FORMATTED_VALUE",
"UNFORMATTED_VALUE",
"FORMULA"
],
"type": "string"
}
},
"required": [
"spreadsheetId",
"ranges"
],
"type": "object"
}