Google Sheets (OAuth) MCP Connector for Claude
A+Power up spreadsheets via Google Sheets — create, read, write, and append data, handle batch operations, and audit sheet info directly from any AI agent.
7 tools Official Updated Oct 1, 2026 Official Vinkius Partner
Connect your Google Sheets via OAuth2 to any AI agent and take full control of your spreadsheet creation, data manipulation, and batch processing through natural conversation.
What you can do
- Live Spreadsheet Creation — Create brand-new Google Spreadsheets by commanding specific titles and optionally including initial sheet names natively within your workspace
- Advanced Data Retrieval — Extracts structured cell arrays by evaluating physical spreadsheet coordinates utilizing A1 notation to retrieve read-only content flawlessly
- High-Throughput Batch Reading — Retrieve data from multiple ranges simultaneously, allowing your agent to analyze complex cross-sheet dependencies synchronously
- Cell & Range Orchestration — Injects discrete structural nodes executing precise write operations to overwrite existing values or append new rows while maintaining native formats
- Range Invalidation & Clearing — Irreversibly vaporizes cell target values within specific A1 boundaries to manage your workspace volume and data integrity securely
- Spreadsheet Metadata Auditing — Fetch detailed info about your spreadsheet including titles, locale, timezone, and individual sheet attributes flawlessly
- Automation & Logging Discovery — Identify bounded spreadsheet IDs from URLs and analyze specific cell ranges to extract precise textual strings for RAG or reporting
How it works
- Subscribe to this server
- Enter your Google OAuth2 Access Token (can be obtained via Google OAuth Playground or
gcloud auth print-access-token) - Start managing your spreadsheets from Claude, Cursor, or any MCP-compatible client
Who is this for?
- Data Analysts & Scientists — create and populate spreadsheets for analysis using natural language without opening the Google Sheets UI
- Operations & Finance Teams — automate reporting and log data across multiple sheet ranges in real-time
- Product Managers — audit project trackers and verify spreadsheet metadata through natural conversation
- Developers — test and debug complex spreadsheet batch operations and verify A1 notation logic through the chat interface
spreadsheetoauth2batch-processingdata-manipulationreal-time-syncapi-integration
Related Connectors
NEW 



Google Slides MCP
6 tools Official
Read, create, and edit Google Slides decks — a full presentation workflow for any AI agent through the official Slides API.
A+ View details →
Smartsheet MCP
12 tools Official
Manage sheets, reports, and rows on Smartsheet with AI agents.
A+ View details →
Google Calendar MCP
15 tools Official
Sync and orchestrate your agenda securely — scan, schedule, and manipulate Google Calendar events natively in chat.
A+ View details →
Google Cloud Storage MCP
12 tools Official
Manage your GCS buckets and objects — list files, upload data, and audit permissions via AI.
A+ View details →