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
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 |