modify_sheet_values
Write, overwrite, or clear values in a specified A1 range in Google Sheets. Supports USER_ENTERED or RAW input options.
Instructions
Write, overwrite, or clear values in an A1 range.
Side effects: overwrites existing cells in the exact range. To append new rows to a table use append_table_rows instead. For formatting use format_sheet_range. Requires the spreadsheets OAuth scope.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| user_google_email | Yes | The user's Google email address (authenticated account). | |
| spreadsheet_id | Yes | Spreadsheet ID. | |
| range_name | Yes | A1 range, e.g. "Sheet1!A1:D10". Range extent determines how many cells are overwritten regardless of values length — for example a 10x4 range clears leftover cells not covered by values. | |
| values | No | 2D array of row arrays (e.g. [["a", "b"], ["c", "d"]]), or a JSON string. Required unless clear_values=True. | |
| value_input_option | No | "USER_ENTERED" (default — strings parsed as dates/numbers/formulas, matches typing into the UI) or "RAW" (strings stored verbatim; formulas stored as literal text). | USER_ENTERED |
| clear_values | No | True clears the range instead of writing. Ignores `values`. |
Output Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |