get_sheet_values_tool
Retrieve data from Google Sheets using A1 notation ranges with options for formatted, unformatted, or formula-based value rendering.
Instructions
Get values from a Google Sheet.
Args: user_google_email: The user's Google email address spreadsheet_id: The spreadsheet ID range: A1 notation range (e.g., "Sheet1!A1:D10" or just "Sheet1") value_render: How values should be rendered - "FORMATTED_VALUE", "UNFORMATTED_VALUE", or "FORMULA"
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| user_google_email | Yes | ||
| spreadsheet_id | Yes | ||
| range | No | Sheet1 | |
| value_render | No | FORMATTED_VALUE |