read_sheet_values
Extract data from Google Sheets by specifying spreadsheet ID, range, and value format to retrieve formatted, unformatted, or formula-based cell contents.
Instructions
Reads values from a specific range in a Google Sheet.
Args: user_google_email (str): The user's Google email address. Required. spreadsheet_id (str): The ID of the spreadsheet. Required. range_name (str): The range to read (e.g., "Sheet1!A1:D10", "A1:D10"). Defaults to "A1:Z1000". value_render_option (str): How values should be rendered in the output. "FORMATTED_VALUE" (default) - display values (e.g., "1,450", "$2.50"). "UNFORMATTED_VALUE" - raw numbers without formatting (e.g., 1450, 2.5). "FORMULA" - the underlying formulas (e.g., "=C7C9 - C8C9").
Returns: str: The formatted values from the specified range.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| user_google_email | Yes | ||
| spreadsheet_id | Yes | ||
| range_name | No | A1:Z1000 | |
| value_render_option | No | FORMATTED_VALUE |