Skip to main content
Glama

google-sheets-mcp

update_table_cells_by_notation_tool

Modify specific cells in a Google Sheets table using A1 notation. Provide spreadsheet name, sheet name, table name, and a list of cell updates to apply new values efficiently.

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