Skip to main content
Glama

google-sheets-mcp

analyze_sheet_structure_tool

Generate a detailed breakdown of a Google Sheet’s structure, including tables, charts, slicers, drawings, and metadata, by specifying the spreadsheet and sheet name.

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

NameRequiredDescriptionDefault
sheet_nameYesName of the specific sheet to analyze
spreadsheet_nameYesThe 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" }

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/henilcalagiya/google-sheets-mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server