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
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') |
Input Schema (JSON Schema)
{
"properties": {
"column_names": {
"description": "List of column names (e.g., ['Employee Name', 'Age', 'Department', 'Salary'])",
"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"
},
"sheet_name": {
"description": "The name of the sheet to create table in",
"title": "Sheet Name",
"type": "string"
},
"spreadsheet_name": {
"description": "The name of the Google Spreadsheet",
"title": "Spreadsheet Name",
"type": "string"
},
"start_cell": {
"description": "Starting cell for the table (e.g., 'A1')",
"title": "Start Cell",
"type": "string"
},
"table_name": {
"description": "A descriptive name for the table (e.g., 'Project Tracker', 'Customer Data')",
"title": "Table Name",
"type": "string"
}
},
"required": [
"spreadsheet_name",
"sheet_name",
"table_name",
"start_cell",
"column_names",
"column_types"
],
"title": "create_table_toolArguments",
"type": "object"
}