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.
Input Schema
TableJSON 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
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |