read_sheet_values
Extract formatted data from a specific range in a Google Sheet using the user's email, spreadsheet ID, and range name for precise data retrieval.
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 | |
| service | Yes | ||
| spreadsheet_id | Yes | ||
| user_google_email | Yes |
Input Schema (JSON Schema)
{
"properties": {
"range_name": {
"default": "A1:Z1000",
"title": "Range Name",
"type": "string"
},
"service": {
"title": "service",
"type": "string"
},
"spreadsheet_id": {
"title": "Spreadsheet Id",
"type": "string"
},
"user_google_email": {
"title": "User Google Email",
"type": "string"
}
},
"required": [
"service",
"user_google_email",
"spreadsheet_id"
],
"title": "read_sheet_valuesArguments",
"type": "object"
}