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
| Name | Required | Description | Default | 
|---|---|---|---|
| cell_updates | Yes | List 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_name | Yes | The name of the sheet containing the table | |
| spreadsheet_name | Yes | The name of the Google Spreadsheet | |
| table_name | Yes | Name 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"
}