update_table_cells_by_range_tool
Update specific cells within a table by defining a range in A1 notation and providing a 2D array of values.
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 detailsInput Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| spreadsheet_name | Yes | The name of the Google Spreadsheet | |
| sheet_name | Yes | The name of the sheet containing the table | |
| table_name | Yes | Name of the table to update | |
| start_cell | Yes | Starting cell reference (e.g., 'A1', 'B2') | |
| end_cell | Yes | Ending cell reference (e.g., 'C5', 'D10') | |
| 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'] ] |
Output Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |