create_table_tool
Create structured tables in Google Sheets with defined columns, data types, and dropdown validation to enhance data organization and formatting.
Instructions
Create a new table in Google Sheets.
This tool creates a structured table with specified columns and data types.
Tables provide better data organization, validation, and formatting capabilities.
Args:
spreadsheet_name: Name of the spreadsheet
sheet_name: Name of the sheet to create table in
table_name: Name for the table
start_cell: Starting cell for the table (e.g., "A1")
column_names: List of column names
column_types: List of column types corresponding to column_names
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 table details
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| column_names | Yes | List of column names (e.g., ['Employee Name', 'Age', 'Department', 'Salary']) | |
| 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 | |
| sheet_name | Yes | The name of the sheet to create table in | |
| spreadsheet_name | Yes | The name of the Google Spreadsheet | |
| start_cell | Yes | Starting cell for the table (e.g., 'A1') | |
| table_name | Yes | A descriptive name for the table (e.g., 'Project Tracker', 'Customer Data') |