Read a sheet
readRows of a sheet as a text table: row numbers, values as shown, and the version (v N) to apply changes at. A range, or a sheet's rows under its header row, filtered and sorted; with "group" or "totals", totals instead of rows. 200 rows unless "limit" says, at most 1,000; the answer says how to page on with "from". With "chart", a chart's points instead.
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": {
"doc": "<doc>"
},
"name": "read"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| csv | No | As CSV instead of a table. | |
| doc | Yes | The doc's link or its code. | |
| from | No | The first of the matching rows to give, from 1. | |
| chart | No | A chart's number (chart #2 in the outline): its points as a table, label column then each series, as drawn (a long range thinned, saying how many rows of how many). Alone, with doc. | |
| group | No | Group the rows by these columns. | |
| limit | No | How many rows. Default 200, at most 1,000. | |
| range | No | "Tasks!A1:G40", "Tasks!B:B", "Tasks!3:5", a defined name, or "E17" when there's one sheet. | |
| sheet | No | A sheet or table by name: its rows under its header row. Default: the only sheet. | |
| where | No | A filter on headers: "Area = Kitchen and Status <> Done or Hours > 4". With = <> < > <= >= contains, "is empty" and "is not empty"; dates as yyyy-mm-dd. | |
| select | No | Columns to show, by header or letter, in this order. | |
| styles | No | Formatting in words: bold, fills, number formats, merges, sizes, frozen panes; a cell a conditional format colours shows it with the rule, as fill #f6d3d0 (format #3). | |
| totals | No | Per group, or for all the rows: "count", "sum Hours", "avg Hours", "min Due", "max Due". | |
| orderBy | No | "Due desc, ID". Empty cells go last. | |
| formulas | No | Formulas with their results: =F2*50 → 50. |