Query Google Sheets as structured JSON for schemas, tabs, and filtered rows.
Copy the install command and let the AI configure it · recommended for beginners
Please install the "PasteSheet — Google Sheets" MCP server from askskill: Run: claude mcp add --transport http 'com-pastesheet-google-sheets' 'https://pastesheet.com/mcp'
List all sheets and tabs in this Google Sheets file, and return each tab's column names, inferred field types, and sample rows as structured JSON.
A JSON response with sheet lists, tab names, field schemas, and sample data.
Read the 'Sales Data' tab, filter records from 2024 where the region is 'East China', and return only customer name, order amount, and closing date as a JSON array.
A structured JSON array of matching rows containing only the requested fields.
Analyze the header definitions in the 'User Feedback' tab, identify empty columns, duplicate column names, and fields with many missing values, then provide a JSON summary of the findings.
A JSON summary of schema issues and data quality findings for follow-up cleaning.
Read, write, and manage Google Sheets through natural language conversations.
Read live Google Sheets data for AI queries, reminders, and automation.
Let AI read, write, and manage data in Google Sheets.
Enable AI to read, write, and manage Google Sheets data and structure.
Read public Google Sheets with column filtering and structured JSON output.
Let AI fully manage Google Sheets for analysis, charts, pivots, and formatting.