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

google-sheets-mcp

analyze_sheet_structure_tool

Instructions

Input Schema

Input Schema (JSON Schema)

Other Tools from google-sheets-mcp

Related Tools

MCP directory API