Google Sheets
A Model Context Protocol server that integrates with Google Drive and Google Sheets, enabling users to create, read, update, and manage spreadsheets through natural language commands.
What is Google Sheets?
Google Sheets is a Model Context Protocol (MCP) server that allows AI assistants like Claude, Cursor, and VS Code to model context protocol server that integrates with google drive and google sheets, enabling users to create, read, update, and manage spreadsheets through natural language commands.
A Model Context Protocol server that integrates with Google Drive and Google Sheets, enabling users to create, read, update, and manage spreadsheets through natural language commands.
This server falls under the Business Applications category on MCPgee, the world's largest MCP server directory with 33,000+ servers.
Features
- A Model Context Protocol server that integrates with Google
Use Cases
Maintainer
Works with
Installation
NPM
npx -y mcp-google-sheetsManual Installation
npx -y mcp-google-sheetsConfiguration
Configuration Details
claude_desktop_config.json
Performance
Response Metrics
Resource Usage
How to Set Up and Use Google Sheets
The mcp-google-sheets MCP server connects AI assistants to Google Drive and Google Sheets, enabling natural language commands to create, read, update, and manage spreadsheets without writing any code. It is built on the Activepieces open-source automation platform and exposes spreadsheet operations — including reading rows, appending data, and creating new sheets — as MCP tools that Claude and other LLMs can call directly. Teams that manage structured data in Google Sheets can use this server to automate reporting, data entry, and analysis workflows through conversation.
Prerequisites
- Node.js 18 or higher with npx available
- A Google account with access to the target Google Sheets files
- Google Cloud project with the Sheets API and Drive API enabled
- OAuth 2.0 credentials (client ID and client secret) from Google Cloud Console
- An MCP-compatible client such as Claude Desktop or Claude Code
Enable the Google Sheets and Drive APIs
Go to the Google Cloud Console (console.cloud.google.com), create or select a project, and enable both the Google Sheets API and Google Drive API for that project.
Create OAuth 2.0 credentials
In Google Cloud Console, navigate to APIs & Services → Credentials → Create Credentials → OAuth 2.0 Client ID. Choose 'Desktop application' as the application type. Download the resulting client_secret JSON file.
Install the MCP server package
Use npx to run the mcp-google-sheets package directly without a global install, or install it globally for repeated use.
npx -y mcp-google-sheetsConfigure your MCP client
Add the server to your claude_desktop_config.json or equivalent MCP client configuration file, passing your Google OAuth credentials as environment variables.
Authenticate with Google on first run
The first time the server starts, it will open a browser window for Google OAuth consent. Complete the flow to grant access to your Drive and Sheets. Credentials are cached locally for subsequent runs.
Verify the connection
Ask your AI assistant to list available spreadsheets or read from a known sheet to confirm the server is connected and authenticated correctly.
Google Sheets Examples
Client configuration
Add this block to your claude_desktop_config.json, replacing the credential values with your actual Google OAuth client details.
{
"mcpServers": {
"mcp-google-sheets": {
"command": "npx",
"args": ["-y", "mcp-google-sheets"],
"env": {
"GOOGLE_CLIENT_ID": "your-client-id.apps.googleusercontent.com",
"GOOGLE_CLIENT_SECRET": "your-client-secret"
}
}
}
}Prompts to try
Use these natural language prompts with Claude after configuring the mcp-google-sheets server.
- "List all spreadsheets in my Google Drive"
- "Read the first 20 rows from the 'Q1 Sales' sheet in my Budget spreadsheet"
- "Append a new row with values [2024-06-01, 450.00, 'Subscription'] to my Revenue sheet"
- "Create a new spreadsheet called 'Project Tracker' with headers: Task, Owner, Due Date, Status"Troubleshooting Google Sheets
OAuth authentication fails or browser window does not open
Ensure GOOGLE_CLIENT_ID and GOOGLE_CLIENT_SECRET are set correctly. Verify that the OAuth client type is 'Desktop application' in Google Cloud Console and that the redirect URI includes http://localhost.
Permission denied when accessing a spreadsheet
The authenticated Google account must have at least Viewer access to the target spreadsheet. Share the spreadsheet with your account, or use a service account with domain-wide delegation for organization-wide access.
npx fails to find or run mcp-google-sheets
Run `npm cache clean --force` and retry. Ensure Node.js is 18 or higher with `node --version`. If the package is not found on npm, install from source using the activepieces monorepo.
Frequently Asked Questions about Google Sheets
What is Google Sheets?
Google Sheets is a Model Context Protocol (MCP) server that model context protocol server that integrates with google drive and google sheets, enabling users to create, read, update, and manage spreadsheets through natural language commands. It connects AI assistants to external tools and data sources through a standardized interface.
How do I install Google Sheets?
Install via npm with the command: npx -y mcp-google-sheets. Then add the server configuration to your AI client's JSON config file (e.g., claude_desktop_config.json or .cursor/mcp.json).
Which AI clients work with Google Sheets?
Google Sheets works with all major MCP-compatible AI clients including Claude Desktop, Claude Code, Cursor, VS Code (GitHub Copilot), Windsurf, and Cline.
Is Google Sheets free to use?
Yes, Google Sheets is open source and available under the NOASSERTION license. You can use it freely in both personal and commercial projects.
Google Sheets Alternatives — Similar Business Applications Servers
Looking for alternatives to Google Sheets? Here are other popular business applications servers you can use with Claude, Cursor, and VS Code.
n8n
★ 189.1kA comprehensive MCP server that provides full control over n8n automation workflows through natural language. It offers 43 tools for managing workflows, executions, credentials, and data tables, with safety features like write-mode protection and dou
LobeHub
★ 77.5k🤯 LobeHub is your Chief Agent Operator, organizing your agents into 7×24 operations by hiring, scheduling, and reporting on your entire AI team.
Jeecgboot
★ 46.4kAI 低代码平台，「低代码 + 零代码」双模式驱动：低代码一键生成前后端代码，零代码 5 分钟搭建系统，AI Skills 一句话画流程、设计表单、生成整套系统。内置 AI聊天、知识库、流程编排、MCP插件等，兼容主流大模型。引领「AI 生成 → 在线配置 → 代码生成 → 手工合并->AI修改」开发模式，消除 Java 项目 80% 的重复工作，提效而不失灵活。
CowAgent
★ 44.7kCowAgent (chatgpt-on-wechat) 是基于大模型的超级AI助理，能主动思考和任务规划、访问操作系统和外部资源、创造和执行Skills、通过长期记忆和知识库不断成长，比OpenClaw更轻量和便捷。同时支持微信、飞书、钉钉、企微、QQ、公众号、网页等接入，可选择DeepSeek/OpenAI/Claude/Gemini/ MiniMax/Qwen/GLM/LinkAI，能处理文本、语音、图片和文件，可快速搭建个人AI助理和企业数字员工。
Minds Platform
★ 39.2kPlatform dedicated to building an open foundation for applied Artificial Intelligence, designed for people seeking production-ready AI systems they can truly control, extend and deploy anywhere.
Astrbot
★ 32.8kAI Agent Assistant & development framework that integrates lots of IM platforms, LLMs, plugins and AI feature, and can be your openclaw alternative. ✨
Browse More Business Applications MCP Servers
Explore all business applications servers available in the MCPgee directory. Each server includes setup guides for Claude, Cursor, and VS Code.
Set Up Google Sheets in Your Editor
Choose your AI client for step-by-step setup instructions.
Quick Config Preview
Add this to your claude_desktop_config.json or .cursor/mcp.json
Ready to use Google Sheets?
Browse our complete directory of 33,000+ MCP servers, read setup guides for your editor, and start building with the Model Context Protocol.