update_table_column_name_tool
Modify column headers in Google Sheets tables by specifying indices and new names. Ensure updated columns and names match for accurate table organization and consistency.
Instructions
Update column names in a table.
This tool updates existing column names in a table by their index.
The number of column indices must match the number of new column names.
Args:
spreadsheet_name: Name of the spreadsheet
sheet_name: Name of the sheet containing the table
table_name: Name of the table to update column names in
column_indices: List of column indices to update (0-based)
new_column_names: List of new column names
Returns:
JSON string with success status and update details
Input Schema
Name | Required | Description | Default |
---|---|---|---|
column_indices | Yes | List of column indices to update (0-based) | |
new_column_names | Yes | List of new column names (must match column_indices count) | |
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 column names in |
Input Schema (JSON Schema)
{
"properties": {
"column_indices": {
"description": "List of column indices to update (0-based)",
"items": {
"type": "integer"
},
"title": "Column Indices",
"type": "array"
},
"new_column_names": {
"description": "List of new column names (must match column_indices count)",
"items": {
"type": "string"
},
"title": "New Column Names",
"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 column names in",
"title": "Table Name",
"type": "string"
}
},
"required": [
"spreadsheet_name",
"sheet_name",
"table_name",
"column_indices",
"new_column_names"
],
"title": "update_table_column_name_toolArguments",
"type": "object"
}