Back to feed
Dev.to
Dev.to
7/23/2026
I built a Google Sheets MCP server so Claude reads my sheets

I built a Google Sheets MCP server so Claude reads my sheets

Short summary

PasteSheet is a tool that turns a Google Sheet URL into a cached, read-only MCP server endpoint that AI clients like Claude and Cursor can query directly. It avoids full Google account OAuth by publishing a single sheet as its own endpoint with three tools: list_tabs, get_schema, and query_rows. The schema-reading tool is highlighted as the key reliability feature, letting the AI discover column names before constructing queries. Setup requires one config line or a single CLI command.

  • •PasteSheet exposes a single Google Sheet as a read-only MCP server for Claude/Cursor
  • •Three tools — list_tabs, get_schema, query_rows — let the AI discover and query sheet data
  • •No Google Cloud project or OAuth needed; just paste a share URL and connect

Generated with AI, which can make mistakes.

#ai-tools#ai-agents#open-source
Read full article at Dev.to

Is this a good recommendation for you?

Comments

Failed to load comments. Please try again.

Explore more

Claude Code, Beyond the Prompt — Part 4: Your First MCP Server (Give Claude Safe Hands on Your Own Tools)
Dev.to
Scrapling MCP: Giving Claude Code a Real Web Scraper
Dev.to
The original title is: "I built an open-source MCP server so AI agents can read the web - even sites that block bots"
Dev.to
The original title is: "MCP Servers Explained: How Claude Code Connects to Everything"
Dev.to