analyze_sheet_structure_tool
Generate a structured overview of a Google Sheet, including sheet info, tables, charts, slicers, drawings, and metadata, to quickly understand its layout and contents.
Instructions
Analyze a specific sheet's structure - quick overview.
This tool provides a simple overview of what's in the sheet:
- Sheet basic info (name, size, hidden status)
- Tables (count, names, ranges, sizes)
- Charts (count, IDs, positions)
- Slicers (count, IDs, positions)
- Drawings (count, IDs, positions)
- Developer metadata (count, keys, values)
- Summary (total elements, sheet type, frozen panes)
Args:
spreadsheet_name: The name of the Google Spreadsheet
sheet_name: Name of the specific sheet to analyze
Returns:
JSON string with simplified structure overview
Input Schema
Name | Required | Description | Default |
---|---|---|---|
sheet_name | Yes | Name of the specific sheet to analyze | |
spreadsheet_name | Yes | The name of the Google Spreadsheet |
Input Schema (JSON Schema)
{
"properties": {
"sheet_name": {
"description": "Name of the specific sheet to analyze",
"title": "Sheet Name",
"type": "string"
},
"spreadsheet_name": {
"description": "The name of the Google Spreadsheet",
"title": "Spreadsheet Name",
"type": "string"
}
},
"required": [
"spreadsheet_name",
"sheet_name"
],
"title": "analyze_sheet_structure_toolArguments",
"type": "object"
}