sheets_read_range
Read data from a Google Sheet range, returning rows as objects with header keys. Supports formatted, unformatted, or formula values.
Instructions
Read data from a Google Sheet range. Range format: 'SheetName!A1:Z100' or just 'SheetName' for the whole sheet. First row is treated as headers and data is returned as an array of objects.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| range | Yes | Range in A1 notation. Examples: 'Users!A1:Z500', 'Orders'. | |
| skip_header | No | If true, returns raw 2D array instead of objects with header keys. | |
| spreadsheet | No | Optional spreadsheet ID. | |
| value_render | No | How to render values. FORMATTED_VALUE = as seen in UI, UNFORMATTED_VALUE = raw numbers, FORMULA = show formulas. | FORMATTED_VALUE |