batch_read
Read values from multiple spreadsheet ranges in one call. Specify spreadsheet ID and comma-separated ranges to get a JSON mapping of each range to its values.
Instructions
Read values from multiple ranges at once.
Args: spreadsheet_id: The ID of the spreadsheet. ranges: Comma-separated A1 notation ranges (e.g., "Sheet1!A1:B5,Sheet1!D1:E5").
Returns: JSON object mapping each range to its values.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"spreadsheet_id": "<spreadsheet_id>",
"ranges": "<ranges>"
},
"name": "batch_read"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| ranges | Yes | ||
| spreadsheet_id | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |