# Google Sheets

> Google Sheets is an MCP server. Google Sheets integration with OAuth, spreadsheet management, batch operations, and formatting. It can run locally on your machine or as a hosted remote server.

- **Kind:** MCP server
- **Repository:** https://github.com/mcp-z/mcp-sheets
- **MCP Registry name:** io.github.mcp-z/mcp-sheets
- **Listing updated:** 2026-11-13

## About

Google Sheets integration with OAuth, spreadsheet management, batch operations, and formatting

## Install

### Claude Code (Terminal)

```sh
claude mcp add mcp-sheets --env GOOGLE_CLIENT_ID='<GOOGLE_CLIENT_ID>' --env GOOGLE_CLIENT_SECRET='<GOOGLE_CLIENT_SECRET>' -- npx -y @mcp-z/mcp-sheets
```

### Claude Desktop (claude_desktop_config.json)

```json
{
  "mcpServers": {
    "mcp-sheets": {
      "command": "npx",
      "args": [
        "-y",
        "@mcp-z/mcp-sheets"
      ],
      "env": {
        "GOOGLE_CLIENT_ID": "<GOOGLE_CLIENT_ID>",
        "GOOGLE_CLIENT_SECRET": "<GOOGLE_CLIENT_SECRET>"
      }
    }
  }
}
```

### Cursor (~/.cursor/mcp.json)

```json
{
  "mcpServers": {
    "mcp-sheets": {
      "command": "npx",
      "args": [
        "-y",
        "@mcp-z/mcp-sheets"
      ],
      "env": {
        "GOOGLE_CLIENT_ID": "<GOOGLE_CLIENT_ID>",
        "GOOGLE_CLIENT_SECRET": "<GOOGLE_CLIENT_SECRET>"
      }
    }
  }
}
```

### VS Code (.vscode/mcp.json)

```json
{
  "servers": {
    "mcp-sheets": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@mcp-z/mcp-sheets"
      ],
      "env": {
        "GOOGLE_CLIENT_ID": "<GOOGLE_CLIENT_ID>",
        "GOOGLE_CLIENT_SECRET": "<GOOGLE_CLIENT_SECRET>"
      }
    }
  }
}
```

### Windsurf (~/.codeium/windsurf/mcp_config.json)

```json
{
  "mcpServers": {
    "mcp-sheets": {
      "command": "npx",
      "args": [
        "-y",
        "@mcp-z/mcp-sheets"
      ],
      "env": {
        "GOOGLE_CLIENT_ID": "<GOOGLE_CLIENT_ID>",
        "GOOGLE_CLIENT_SECRET": "<GOOGLE_CLIENT_SECRET>"
      }
    }
  }
}
```

### Other clients (your client's MCP settings (most use this shape))

```json
{
  "mcpServers": {
    "mcp-sheets": {
      "command": "npx",
      "args": [
        "-y",
        "@mcp-z/mcp-sheets"
      ],
      "env": {
        "GOOGLE_CLIENT_ID": "<GOOGLE_CLIENT_ID>",
        "GOOGLE_CLIENT_SECRET": "<GOOGLE_CLIENT_SECRET>"
      }
    }
  }
}
```

## FAQ

### How do I add Google Sheets to Claude Code?

Run this command in your terminal: claude mcp add mcp-sheets --env GOOGLE_CLIENT_ID='<GOOGLE_CLIENT_ID>' --env GOOGLE_CLIENT_SECRET='<GOOGLE_CLIENT_SECRET>' -- npx -y @mcp-z/mcp-sheets

## Where this comes from

- Description: from the official MCP Registry entry.
- Install steps: from the official MCP Registry entry.

---
Source: https://ai-powered.com/mcp/google-sheets-2
