sheets_read_range
Read cell values from a specified A1 range in a Google Sheets spreadsheet to retrieve formatted, raw, or formula data for analysis.
Instructions
Reads cell values from a specified range in a spreadsheet
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| range | Yes | The A1 notation range to read (e.g. Sheet1!A1:D10) | |
| value_render | No | How values should be rendered: formatted (default), unformatted (raw numbers), or formula | |
| spreadsheet_id | Yes | The ID of the spreadsheet |