google-sheets-mcp

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

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