Read values
read_valuesRead multiple Google Sheets ranges in one call, returning values as 2-D arrays with options for formatted values, raw values, or formulas.
Instructions
Reads one or more A1 ranges in a single call (one request against the quota, however many ranges) and returns valueRanges[] — each with its resolved range and a 2-D values array (outer = rows unless major_dimension=COLUMNS). Trailing empty rows/columns are omitted; a fully empty range has no values key at all. value_render_option: FORMATTED_VALUE (default, strings as displayed, honoring the cell's number format and locale), UNFORMATTED_VALUE (raw numbers/booleans), FORMULA (the formula text, e.g. "=SUM(A1:A10)" — the way to read formulas). With UNFORMATTED_VALUE, dates arrive as serial numbers unless date_time_render_option=FORMATTED_STRING.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| ranges | Yes | One or more A1 ranges to read in a single call. | |
| spreadsheet_id | Yes | The spreadsheet id — the long id from the URL (docs.google.com/spreadsheets/d/<spreadsheetId>/edit) or from create_spreadsheet / search_spreadsheets output. | |
| major_dimension | No | Whether the outer array is rows (default) or columns. | |
| value_render_option | No | How values are rendered (default FORMATTED_VALUE); FORMULA returns formula text. | |
| date_time_render_option | No | How dates/times render with UNFORMATTED_VALUE (default SERIAL_NUMBER). |