mcp-google-sheets

129
cloud_platformsdatabasesdeveloper_tools

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.