mcp-google-sheets
This MCP server integrates with your Google Drive and Google Sheets, to enable creating and modifying spreadsheets.
This MCP server bridges AI assistants with Google Sheets and Google Drive, enabling spreadsheet creation, data manipulation, and automation through natural language. Built in Python, it exposes 19 tools for operations including reading/writing cells, managing sheets, batch updates, sharing, formatting, and chart creation. Developers can integrate it with MCP-compatible clients like Claude Desktop to let AI assistants interact with spreadsheets programmatically. It supports multiple authentication methods including service accounts, OAuth 2.0, and Application Default Credentials.
Key Features
Use Cases
- 01Automate quarterly report generation and data population through conversational commands
- 02Create data visualizations and charts in spreadsheets using natural language descriptions
- 03Batch update multiple spreadsheet ranges across different files from AI-processed data
- 04Share spreadsheets with team members and set permissions without leaving the AI assistant
- 05Extract and summarize data from multiple spreadsheets for cross-project analysis
- 06Automate repetitive data entry tasks by instructing the AI to update cells and append rows
Related MCP Servers
View moremarkitdown
Python tool for converting files and office documents to Markdown.
firecrawl
The context API to search, scrape, and interact with the web at scale. 🔥
prompts.chat
f.k.a. Awesome ChatGPT Prompts. Share, discover, and collect prompts from the community. Free and open source — self-host for your organization with complete privacy.
langflow
Langflow is a powerful tool for building and deploying AI-powered agents and workflows.
mcp-google-sheets — FAQ
What is mcp-google-sheets?+
It's a Python-based MCP server that connects AI assistants like Claude Desktop to the Google Sheets and Google Drive APIs, allowing you to create, read, update, and manage spreadsheets through natural language commands.
How do I install and configure this MCP server?+
Install uv/uvx, set up Google Cloud Platform credentials (service account recommended), share a Drive folder with the service account, set SERVICE_ACCOUNT_PATH and DRIVE_FOLDER_ID environment variables, then add the server configuration to your MCP client's config file (e.g., claude_desktop_config.json) with command 'uvx' and args 'mcp-google-sheets@latest'.
Which AI clients work with this MCP server?+
It works with any MCP-compatible client, with Claude Desktop being the primary documented example. The server uses the standard MCP protocol, so it should work with other MCP clients as well.
Do I need a Google Cloud account and API keys?+
Yes, you must create a Google Cloud Platform project, enable the Google Sheets API and Google Drive API, and set up either a Service Account (recommended) or OAuth 2.0 credentials. Service accounts require sharing a Drive folder with the service account email.
Is this MCP server free to use?+
The MCP server itself is open-source and free (MIT License), but you'll need a Google Cloud Platform account. Google provides free tier usage for their APIs, though high-volume usage may incur costs.
How can I reduce the context window usage?+
Use tool filtering by specifying only the tools you need via the --include-tools command-line argument or ENABLED_TOOLS environment variable. This can reduce context usage from ~13K tokens (all 19 tools) to just the subset you require.
How do I install mcp-google-sheets?+
Open the source repository on GitHub and follow its README. mcp-google-sheets is a mcp server — MCP Agents Market links you directly to the official repo.
Is mcp-google-sheets free?+
mcp-google-sheets is an open-source project hosted on GitHub. Check the repository for its license and any usage requirements.