sheets_get_data
Retrieve data from Google Sheets by specifying spreadsheet ID and range, with optional formatting and date rendering controls.
Instructions
Get data from Google Sheets with optional formatting
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| range | Yes | The range to retrieve (e.g., A1:C10) | |
| spreadsheetId | Yes | The ID of the spreadsheet | |
| valueRenderOption | No | How values should be rendered | FORMATTED_VALUE |
| dateTimeRenderOption | No | How dates should be rendered | FORMATTED_STRING |