add_table_column_tool
Extend tables in Google Sheets by adding new columns with specified names, data types, and positions. Supports dropdown validation and multiple column additions at once.
Instructions
Input Schema
Name | Required | Description | Default |
---|---|---|---|
column_names | Yes | List of column names (e.g., ['Status', 'Priority', 'Notes']) | |
column_types | Yes | List of column types: DOUBLE, CURRENCY, PERCENT, DATE, TIME, DATE_TIME, TEXT, BOOLEAN, DROPDOWN | |
dropdown_columns | No | List of column names that should have dropdown validation | |
dropdown_values | No | Comma-separated dropdown options for each dropdown column | |
positions | No | List of positions to insert columns (0-based index, empty list for end) | |
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 add columns to |