Skip to main content
Glama

google-sheets-mcp

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

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

NameRequiredDescriptionDefault
column_namesYesList of column names (e.g., ['Employee Name', 'Age', 'Department', 'Salary'])
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
sheet_nameYesThe name of the sheet to create table in
spreadsheet_nameYesThe name of the Google Spreadsheet
start_cellYesStarting cell for the table (e.g., 'A1')
table_nameYesA 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" }

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