Read cells
read_rangeRead cell values, formulas, raw numbers, or formatting from a Google Sheets range. Large ranges truncate, and next_range continues reading.
Instructions
Read cell contents from a range, or its formatting with mode "formats". Large ranges are truncated; use next_range to continue.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| mode | No | values = as displayed; formulas = show formulas instead of results; raw = unformatted numbers; formats = cell formatting (fill, font, alignment, number format, borders) as a style table plus a per-row map of style ids, with merges, banding, conditional formats, column widths, frozen panes and gridlines | values |
| range | Yes | A1 range, e.g. "Sheet1!A1:D20", "'My Tab'!B:B", or a tab name | |
| 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 | ||
| spreadsheet | Yes | Google Sheets link or spreadsheet ID. The name of a spreadsheet used with Sheets MCP before also works |