add_table_column_tool
Extend tables in Google Sheets by adding new columns with specific data types, validation rules, and positions. Supports batch column addition, dropdown validation, and customizable placement.
Instructions
Add new columns to an existing table in Google Sheets.
This tool extends an existing table with additional columns.
New columns can have different data types and validation rules.
Supports adding multiple columns at once with proper positioning.
Args:
spreadsheet_name: Name of the spreadsheet
sheet_name: Name of the sheet containing the table
table_name: Name of the table to add columns to
column_names: List of column names to add
column_types: List of column types corresponding to column_names
positions: List of positions to insert columns (0-based index, empty list for end)
dropdown_columns: List of column names that should have dropdown validation
dropdown_values: List of comma-separated dropdown options for each dropdown column
Returns:
JSON string with success status and column addition details
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 |
Input Schema (JSON Schema)
{
"properties": {
"column_names": {
"description": "List of column names (e.g., ['Status', 'Priority', 'Notes'])",
"items": {
"type": "string"
},
"title": "Column Names",
"type": "array"
},
"column_types": {
"description": "List of column types: DOUBLE, CURRENCY, PERCENT, DATE, TIME, DATE_TIME, TEXT, BOOLEAN, DROPDOWN",
"items": {
"type": "string"
},
"title": "Column Types",
"type": "array"
},
"dropdown_columns": {
"default": [],
"description": "List of column names that should have dropdown validation",
"items": {
"type": "string"
},
"title": "Dropdown Columns",
"type": "array"
},
"dropdown_values": {
"default": [],
"description": "Comma-separated dropdown options for each dropdown column",
"items": {
"type": "string"
},
"title": "Dropdown Values",
"type": "array"
},
"positions": {
"default": [],
"description": "List of positions to insert columns (0-based index, empty list for end)",
"items": {
"type": "integer"
},
"title": "Positions",
"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 add columns to",
"title": "Table Name",
"type": "string"
}
},
"required": [
"spreadsheet_name",
"sheet_name",
"table_name",
"column_names",
"column_types"
],
"title": "add_table_column_toolArguments",
"type": "object"
}