update_table_cells_by_range_tool
Modify cell data within a specified range in Google Sheets using A1 notation. Specify spreadsheet, sheet, table, start/end cells, and a 2D array of values to update the table accurately.
Instructions
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
Input Schema
| Name | Required | Description | Default | 
|---|---|---|---|
| cell_values | Yes | 2D array of values to update (rows x columns) Must match the range dimensions based on start_cell and end_cell. EXAMPLE: For range 'A1:C2', you need 2 rows x 3 columns: [ ['Value1', 'Value2', 'Value3'], ['Value4', 'Value5', 'Value6'] ] | |
| end_cell | Yes | Ending cell reference (e.g., 'C5', 'D10') | |
| sheet_name | Yes | The name of the sheet containing the table | |
| spreadsheet_name | Yes | The name of the Google Spreadsheet | |
| start_cell | Yes | Starting cell reference (e.g., 'A1', 'B2') | |
| table_name | Yes | Name of the table to update | 
Input Schema (JSON Schema)
{
  "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"
}