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