read_sheet_values
Fetch cell values from a given range in a Google Sheet, optionally including hyperlinks and notes, to access spreadsheet data.
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". include_hyperlinks (bool): If True, also fetch hyperlink metadata for the range. Defaults to False to avoid expensive includeGridData requests. include_notes (bool): If True, also fetch cell notes for the range. Defaults to False to avoid expensive includeGridData requests.
Returns: str: The formatted values from the specified range.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| range_name | No | A1:Z1000 | |
| include_notes | No | ||
| spreadsheet_id | Yes | ||
| user_google_email | Yes | ||
| include_hyperlinks | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |