google-sheets-mcp

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

{ "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" }