Skip to main content
Glama

google-sheets-mcp

add_table_column_tool

Extend tables in Google Sheets by adding new columns with specified names, data types, and positions. Supports dropdown validation and multiple column additions at once.

Instructions

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

Input Schema

NameRequiredDescriptionDefault
column_namesYesList of column names (e.g., ['Status', 'Priority', 'Notes'])
column_typesYesList of column types: DOUBLE, CURRENCY, PERCENT, DATE, TIME, DATE_TIME, TEXT, BOOLEAN, DROPDOWN
dropdown_columnsNoList of column names that should have dropdown validation
dropdown_valuesNoComma-separated dropdown options for each dropdown column
positionsNoList of positions to insert columns (0-based index, empty list for end)
sheet_nameYesThe name of the sheet containing the table
spreadsheet_nameYesThe name of the Google Spreadsheet
table_nameYesName of the table to add columns to

Input Schema (JSON Schema)

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

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/henilcalagiya/google-sheets-mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server