Google Workspace MCP Server - Control Gmail, Calendar, Docs, Sheets, Slides, Chat, Forms & Drive

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[List[List[str]]]): 2D array of values to write/update. 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.

{ "properties": { "clear_values": { "default": false, "title": "Clear Values", "type": "boolean" }, "range_name": { "title": "Range Name", "type": "string" }, "service": { "title": "service", "type": "string" }, "spreadsheet_id": { "title": "Spreadsheet Id", "type": "string" }, "user_google_email": { "title": "User Google Email", "type": "string" }, "value_input_option": { "default": "USER_ENTERED", "title": "Value Input Option", "type": "string" }, "values": { "anyOf": [ { "items": { "items": { "type": "string" }, "type": "array" }, "type": "array" }, { "type": "null" } ], "default": null, "title": "Values" } }, "required": [ "service", "user_google_email", "spreadsheet_id", "range_name" ], "title": "modify_sheet_valuesArguments", "type": "object" }