create_table_tool
Create structured tables in Google Sheets with specified columns and data types. Organize data effectively with validation and formatting options for dropdowns and more.
Instructions
Input 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') |