read_range
Read cell values from a specified A1 range in Google Sheets, with options for formatted, unformatted, or formula output.
Instructions
Read cell values from an A1 range (e.g. Sheet1!A1:C10).
value_render_option: FORMATTED_VALUE (as shown, default),
UNFORMATTED_VALUE (typed values), or FORMULA (underlying formulas).
Returns {"range", "values"} where values is a list of rows.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| range | Yes | ||
| spreadsheet_id | Yes | ||
| value_render_option | No | FORMATTED_VALUE |