mcp-gsheetsTools Reference
sheets_batch_get_values
Read data from multiple ranges in one request
sheets_batch_get_values
Read data from multiple ranges in a single API call for better performance.
Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
spreadsheetId | string | Yes | The spreadsheet ID |
ranges | string[] | Yes | Array of A1 notation ranges |
Example
{
"tool": "sheets_batch_get_values",
"arguments": {
"spreadsheetId": "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms",
"ranges": ["Sheet1!A1:B10", "Sheet2!C1:D5", "Summary!A1:Z1"]
}
}Response
Returns an array of value ranges, one for each requested range.