Modify Sheet Values
modify_sheet_valuesDestructive
Modify values in a specific range of a Google Sheet: write new data, update existing cells, or clear the range. Supports raw or user-entered input.
Instructions
Modify values in a specific range of a Google Sheet - can write, update, or clear values
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| values | No | 2D array of values to write/update. Can be Python list [["cell1", "cell2"], ["cell3", "cell4"]] or JSON string '[["cell1", "cell2"], ["cell3", "cell4"]]'. Required unless clear_values=True. | |
| range_name | Yes | The range to modify (e.g., "Sheet1!A1:D10", "A1:D10"). Required. | |
| clear_values | No | If True, clears the range instead of writing values. When True, 'values' parameter is ignored. | |
| spreadsheet_id | Yes | The ID of the spreadsheet. Required. | |
| user_google_email | No | The user's Google email address for Sheets access. If None, uses the current authenticated user from FastMCP context (auto-injected by middleware). | |
| value_input_option | No | How to interpret input values: 'RAW' (values not parsed) or 'USER_ENTERED' (values parsed as if typed by user) | USER_ENTERED |
Output Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| error | No | Error message if operation failed | |
| range | Yes | Range that was modified | |
| message | Yes | Success or error message | |
| success | Yes | Whether the operation succeeded | |
| operation | Yes | Type of operation performed ('update', 'clear') | |
| updatedRows | No | Number of rows updated | |
| clearedRange | No | Range that was cleared | |
| updatedCells | No | Number of cells updated | |
| spreadsheetId | Yes | Unique identifier for the spreadsheet | |
| updatedColumns | No | Number of columns updated |