read_sheet_values
Read cell values from a Google Sheets A1 range, optionally including formulas, notes, or hyperlinks. Output limited to 50 rows; widen range or paginate for more.
Instructions
Read cell values from an A1 range (optionally with formulas/notes).
Output is capped at 50 rows for readability — widen the range or paginate manually for more. For writing use modify_sheet_values. For appending to a table use append_table_rows. Requires the spreadsheets.readonly OAuth scope.
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": {
"user_google_email": "<user_google_email>",
"spreadsheet_id": "<spreadsheet_id>"
},
"name": "read_sheet_values"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| user_google_email | Yes | The user's Google email address (authenticated account). | |
| spreadsheet_id | Yes | Spreadsheet ID from list_spreadsheets. | |
| range_name | No | A1 notation, e.g. "Sheet1!A1:D10", "A:D", or unqualified "A1:D10" (first sheet). Default "A1:Z1000". | A1:Z1000 |
| include_hyperlinks | No | True adds a hyperlink-metadata section for cells containing URLs. Triggers an includeGridData request — more expensive. | |
| include_notes | No | True adds a cell-notes section. Same cost caveat as include_hyperlinks. | |
| include_formulas | No | True fetches raw formula strings (=SUM(...), etc.) alongside displayed values — useful before writing back to avoid clobbering cross-sheet references. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |