google-sheets-mcp

Update table cells by range. This tool updates cell data in a specific range within a table. You can specify the exact cell range using A1 notation. Args: spreadsheet_name: Name of the spreadsheet sheet_name: Name of the sheet containing the table table_name: Name of the table to update start_cell: Starting cell reference (e.g., 'A1', 'B2') end_cell: Ending cell reference (e.g., 'C5', 'D10') cell_values: 2D array of values to update (rows x columns) Returns: JSON string with update details

{ "properties": { "cell_values": { "description": "2D array of values to update (rows x columns)\n \n Must match the range dimensions based on start_cell and end_cell.\n \n EXAMPLE: For range 'A1:C2', you need 2 rows x 3 columns:\n [\n ['Value1', 'Value2', 'Value3'],\n ['Value4', 'Value5', 'Value6']\n ]\n ", "items": { "items": { "anyOf": [ { "type": "string" }, { "type": "integer" }, { "type": "number" }, { "type": "boolean" }, { "type": "null" } ] }, "type": "array" }, "title": "Cell Values", "type": "array" }, "end_cell": { "description": "Ending cell reference (e.g., 'C5', 'D10')", "title": "End Cell", "type": "string" }, "sheet_name": { "description": "The name of the sheet containing the table", "title": "Sheet Name", "type": "string" }, "spreadsheet_name": { "description": "The name of the Google Spreadsheet", "title": "Spreadsheet Name", "type": "string" }, "start_cell": { "description": "Starting cell reference (e.g., 'A1', 'B2')", "title": "Start Cell", "type": "string" }, "table_name": { "description": "Name of the table to update", "title": "Table Name", "type": "string" } }, "required": [ "spreadsheet_name", "sheet_name", "table_name", "start_cell", "end_cell", "cell_values" ], "title": "update_table_cells_by_range_toolArguments", "type": "object" }