update_sheet_values_tool
Modify data in Google Sheets by writing values to specified ranges, enabling automated spreadsheet updates and data management.
Instructions
Update values in 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") values: 2D array of values to write. Example: [["Header1", "Header2"], ["Value1", "Value2"]] value_input: How input values should be interpreted - "USER_ENTERED" or "RAW"
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| user_google_email | Yes | ||
| spreadsheet_id | Yes | ||
| range | Yes | ||
| values | Yes | ||
| value_input | No | USER_ENTERED |