modify_sheet_values
Write, update, or clear values in specific ranges of Google Sheets to manage spreadsheet data directly through automated workflows.
Instructions
Modifies values in a specific range of a Google Sheet - can write, update, or clear values.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| user_google_email | Yes | The user's Google email address. Required. | |
| spreadsheet_id | Yes | The ID of the spreadsheet. Required. | |
| range_name | Yes | The range to modify (e.g., "Sheet1!A1:D10", "A1:D10"). Required. | |
| values | No | 2D array of values to write/update. Can be a JSON string or Python list. Required unless clear_values=True. | |
| value_input_option | No | How to interpret input values ("RAW" or "USER_ENTERED"). Defaults to "USER_ENTERED". | USER_ENTERED |
| clear_values | No | If True, clears the range instead of writing values. Defaults to False. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |