get_table_metadata_tool
Retrieve comprehensive metadata for Google Sheets tables, including structure, columns, data types, formatting, and statistics. Optionally include sample data or formulas.
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 tablesInput Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| spreadsheet_name | Yes | The name of the Google Spreadsheet | |
| sheet_name | Yes | The name of the sheet containing the table | |
| table_name | No | Name of the table to get metadata for. If not provided, returns metadata for all tables in the sheet. | |
| include_sample_data | No | Whether to include sample data rows | |
| include_formulas | No | Whether to include formula information | |
| include_formatting | No | Whether to include cell formatting details | |
| include_statistics | No | Whether to include data statistics | |
| max_sample_rows | No | Maximum number of sample rows to return | |
| specific_columns | No | List of column names to get metadata for (optional) | |
| exclude_metadata_types | No | List of metadata types to exclude (e.g., ['sample_data', 'formatting', 'statistics', 'merges', 'conditional_formatting', 'filters']) |
Output Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |