mcp-google-sheets
129
The `mcp-google-sheets` project serves as a gateway to seamlessly integrate AI with Google Sheets using a Python-based MCP server. It allows users to automate and manage their spreadsheet data effectively, facilitating integration with MCP-compatible clients for enhanced data workflows.
mcp-google-sheets
Your AI Assistant's Gateway to Google Sheets!
What is this?
mcp-google-sheets
is a Python-based MCP server that acts as a bridge between any MCP-compatible client and the Google Sheets API. It enables interaction with Google Spreadsheets for automation and data manipulation workflows powered by AI.
Quick Start
- Prerequisite: Configure Google Cloud credentials and enable APIs.
- Install
uv
for running the server. - Set essential environment variables for authentication.
- Run the server using
uvx mcp-google-sheets
. - Connect your MCP client to the server.
Key Features
- Integration: Directly connects to Google Drive & Google Sheets APIs.
- Tools: CRUD operations, listing, batching, sharing, etc.
- Authentication: Supports Service Accounts, OAuth 2.0, and credentials via environment variables.
- Deployment: Easy to run instantly or clone for development.
- AI-Ready: Interact with spreadsheets through natural language.
Available Tools & Resources
- Operations like listing spreadsheets, updating cells, batch processing, sharing, etc.