read_sheet_values
Extract data from a specified range in a Google Sheet using the user's email, spreadsheet ID, and range name. Streamlines access to spreadsheet values for analysis or integration.
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".
Returns: str: The formatted values from the specified range.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| range_name | No | A1:Z1000 | |
| spreadsheet_id | Yes | ||
| user_google_email | Yes |
Input Schema (JSON Schema)
{
"properties": {
"range_name": {
"default": "A1:Z1000",
"title": "Range Name",
"type": "string"
},
"spreadsheet_id": {
"title": "Spreadsheet Id",
"type": "string"
},
"user_google_email": {
"title": "User Google Email",
"type": "string"
}
},
"required": [
"user_google_email",
"spreadsheet_id"
],
"type": "object"
}