sheets_read_values
Read multiple Google Sheets ranges across tabs in one request and return valueRanges in order, with options to inspect formulas or calculated numbers.
Instructions
Read one or more ranges across spreadsheet tabs in one request. Returns valueRanges in requested order, with trailing empty rows/columns omitted. Choose FORMULA to inspect formulas or UNFORMATTED_VALUE for calculated numbers.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| No | Google account email. May be omitted when exactly one account is configured; required when multiple accounts are configured. | ||
| ranges | Yes | ||
| major_dimension | No | Default ROWS | |
| value_render_option | No | Default FORMATTED_VALUE | |
| spreadsheet_id_or_url | Yes | Google Sheets spreadsheet ID or full docs.google.com/spreadsheets URL. The URL's gid does not select a tab; use a sheet-qualified range. | |
| date_time_render_option | No | Default SERIAL_NUMBER; ignored when value_render_option is FORMATTED_VALUE |