Skip to main content
Glama

google-sheets-mcp

get_table_metadata_tool

Extract detailed metadata for tables in Google Sheets, including structure, columns, data types, formatting, and statistics. Specify specific columns, include sample data, or exclude metadata types for tailored insights.

Instructions

Get comprehensive metadata for tables in Google Sheets. This tool provides detailed information about table structure, columns, data types, formatting, statistics, and other properties. If no table name is provided, returns metadata for all tables. Args: spreadsheet_name: Name of the spreadsheet sheet_name: Name of the sheet containing the table table_name: Name of the table to get metadata for (optional) include_sample_data: Whether to include sample data rows include_formulas: Whether to include formula information include_formatting: Whether to include cell formatting details include_statistics: Whether to include data statistics max_sample_rows: Maximum number of sample rows to return specific_columns: List of column names to get metadata for (optional) exclude_metadata_types: List of metadata types to exclude Returns: JSON string containing table metadata or list of all tables

Input Schema

NameRequiredDescriptionDefault
exclude_metadata_typesNoList of metadata types to exclude (e.g., ['sample_data', 'formatting', 'statistics', 'merges', 'conditional_formatting', 'filters'])
include_formattingNoWhether to include cell formatting details
include_formulasNoWhether to include formula information
include_sample_dataNoWhether to include sample data rows
include_statisticsNoWhether to include data statistics
max_sample_rowsNoMaximum number of sample rows to return
sheet_nameYesThe name of the sheet containing the table
specific_columnsNoList of column names to get metadata for (optional)
spreadsheet_nameYesThe name of the Google Spreadsheet
table_nameNoName of the table to get metadata for. If not provided, returns metadata for all tables in the sheet.

Input Schema (JSON Schema)

{ "properties": { "exclude_metadata_types": { "default": null, "description": "List of metadata types to exclude (e.g., ['sample_data', 'formatting', 'statistics', 'merges', 'conditional_formatting', 'filters'])", "items": { "type": "string" }, "title": "Exclude Metadata Types", "type": "array" }, "include_formatting": { "default": false, "description": "Whether to include cell formatting details", "title": "Include Formatting", "type": "boolean" }, "include_formulas": { "default": false, "description": "Whether to include formula information", "title": "Include Formulas", "type": "boolean" }, "include_sample_data": { "default": false, "description": "Whether to include sample data rows", "title": "Include Sample Data", "type": "boolean" }, "include_statistics": { "default": false, "description": "Whether to include data statistics", "title": "Include Statistics", "type": "boolean" }, "max_sample_rows": { "default": 5, "description": "Maximum number of sample rows to return", "title": "Max Sample Rows", "type": "integer" }, "sheet_name": { "description": "The name of the sheet containing the table", "title": "Sheet Name", "type": "string" }, "specific_columns": { "default": null, "description": "List of column names to get metadata for (optional)", "items": { "type": "string" }, "title": "Specific Columns", "type": "array" }, "spreadsheet_name": { "description": "The name of the Google Spreadsheet", "title": "Spreadsheet Name", "type": "string" }, "table_name": { "default": null, "description": "Name of the table to get metadata for. If not provided, returns metadata for all tables in the sheet.", "title": "Table Name", "type": "string" } }, "required": [ "spreadsheet_name", "sheet_name" ], "title": "get_table_metadata_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