google-sheets-mcp

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

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