mcp-google-sheets

The 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 allows users to interact with their Google Spreadsheets using a defined set of tools, enabling powerful automation and data manipulation workflows driven by AI. By leveraging this server, users can streamline their spreadsheet tasks and enhance productivity through automation. To get started, users need to set up Google Cloud Platform credentials and enable the necessary APIs, preferably using a Service Account. The server can be run easily with a single command, ensuring that users always have the latest version with the newest features and bug fixes.

{
  "mcpServers": {
    "mcp-google-sheets": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-mcp-google-sheets"
      ]
    }
  }
}