delete_table_column_tool
Remove specified columns from a table in Google Sheets to update the table structure. The remaining columns shift left to fill the gaps. Requires spreadsheet, sheet, table names, and column list.
Instructions
Delete specific columns from a table in Google Sheets.
This tool removes the specified columns from the table and updates the table structure
accordingly. The remaining columns will be shifted left to fill the gaps.
Args:
spreadsheet_name: Name of the spreadsheet
sheet_name: Name of the sheet containing the table
table_name: Name of the table to delete columns from
column_names: List of column names to delete
Returns:
JSON string with operation results
Input Schema
Name | Required | Description | Default |
---|---|---|---|
column_names | Yes | List of column names to delete from the table | |
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 delete columns from |
Input Schema (JSON Schema)
{
"properties": {
"column_names": {
"description": "List of column names to delete from the table",
"items": {
"type": "string"
},
"title": "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 delete columns from",
"title": "Table Name",
"type": "string"
}
},
"required": [
"spreadsheet_name",
"sheet_name",
"table_name",
"column_names"
],
"title": "delete_table_column_toolArguments",
"type": "object"
}