update_sheet_values_tool
Modify Google Sheets data programmatically by writing values to specific ranges using A1 notation and 2D arrays.
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 |