modify_sheet_values
Update, write, or clear values in a specific range of a Google Sheet. Specify the range, input values, and user email to modify spreadsheet data efficiently.
Instructions
Modifies values in a specific range of a Google Sheet - can write, update, or clear values.
Args: user_google_email (str): The user's Google email address. Required. spreadsheet_id (str): The ID of the spreadsheet. Required. range_name (str): The range to modify (e.g., "Sheet1!A1:D10", "A1:D10"). Required. values (Optional[Union[str, List[List[str]]]]): 2D array of values to write/update. Can be a JSON string or Python list. Required unless clear_values=True. value_input_option (str): How to interpret input values ("RAW" or "USER_ENTERED"). Defaults to "USER_ENTERED". clear_values (bool): If True, clears the range instead of writing values. Defaults to False.
Returns: str: Confirmation message of the successful modification operation.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| clear_values | No | ||
| range_name | Yes | ||
| spreadsheet_id | Yes | ||
| user_google_email | Yes | ||
| value_input_option | No | USER_ENTERED | |
| values | No |