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