Read several ranges
read_rangesRead multiple ranges across any tabs in one call; each range is truncated to its share of max_cells, so you can continue with the returned next_range.
Instructions
Read several ranges in one call, across any tabs. Faster than calling read_range repeatedly. Each range is truncated to its share of max_cells; use its next_range with read_range to continue.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| mode | No | values = as displayed; formulas = show formulas instead of results; raw = unformatted numbers | values |
| ranges | Yes | ||
| account | No | Google account to use: an email or unique part of one (e.g. "acme.com"). Default: the account that can open the spreadsheet, else the default account. | |
| max_cells | No | Total across all ranges | |
| spreadsheet | Yes | Google Sheets link or spreadsheet ID. The name of a spreadsheet used with Sheets MCP before also works |