Skip to main content
Glama

google-sheets-mcp

update_table_cells_by_notation_tool

Update specific table cells in Google Sheets using A1 notation. Define spreadsheet, sheet, and table names, then provide cell references and new values for precise modifications.

Instructions

Update specific cells in a table. This tool updates multiple cells in a table with new values 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 cell_updates: List of cell updates with cell_notation and value Returns: JSON string with success status and update details

Input Schema

NameRequiredDescriptionDefault
cell_updatesYesList of cell updates, each containing: - cell_notation: Cell reference in A1 notation (e.g., 'A1', 'B5') - value: New value for the cell (string, number, boolean, or None) EXAMPLE: [ {"cell_notation": "A1", "value": "New Value"}, {"cell_notation": "B5", "value": 50000}, {"cell_notation": "C10", "value": True} ]
sheet_nameYesThe name of the sheet containing the table
spreadsheet_nameYesThe name of the Google Spreadsheet
table_nameYesName of the table to update

Input Schema (JSON Schema)

{ "properties": { "cell_updates": { "description": "List of cell updates, each containing:\n - cell_notation: Cell reference in A1 notation (e.g., 'A1', 'B5')\n - value: New value for the cell (string, number, boolean, or None)\n \n EXAMPLE: [\n {\"cell_notation\": \"A1\", \"value\": \"New Value\"},\n {\"cell_notation\": \"B5\", \"value\": 50000},\n {\"cell_notation\": \"C10\", \"value\": True}\n ]\n ", "items": { "additionalProperties": { "anyOf": [ { "type": "string" }, { "type": "integer" }, { "type": "number" }, { "type": "boolean" }, { "type": "null" } ] }, "type": "object" }, "title": "Cell Updates", "type": "array" }, "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" }, "table_name": { "description": "Name of the table to update", "title": "Table Name", "type": "string" } }, "required": [ "spreadsheet_name", "sheet_name", "table_name", "cell_updates" ], "title": "update_table_cells_by_notation_toolArguments", "type": "object" }

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/henilcalagiya/google-sheets-mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server