Google Sheets MCP Server

A Model Context Protocol (MCP) server for Google Sheets that enables Claude Desktop to interact with Google Sheets directly. This server provides tools for creating, reading, writing, and managing Google Sheets through Claude Desktop.

Features

• Create new Google Sheets
• Read and write data to existing sheets
• Format cells and ranges
• Add and delete sheets
• Write formulas
• Search for sheets
• List available sheets

Prerequisites

• Python 3.10 or higher
• Google Cloud Project with Google Sheets API enabled
• OAuth 2.0 credentials from Google Cloud Console
• Claude Desktop application
• uv package manager (recommended)

Installation

1. Clone the repository:

git clone https://github.com/yourusername/google-sheets-mcp-server.git
cd google-sheets-mcp-server

2. Create and activate a virtual environment:

python -m venv .venv
source .venv/bin/activate  # On Windows: .venv\Scripts\activate

3. Install dependencies using uv:

uv pip install -e .

4. Set up Google Cloud credentials:
   • Go to Google Cloud Console
   • Create a new project or select an existing one
   • Enable the Google Sheets API and Google Drive API
   • Create OAuth 2.0 credentials (Desktop app)
   • Download the credentials and save as ~/.config/google_sheets_mcp/google-sheets-mcp.json

Configuration

1. Configure Claude Desktop:
   • Open Claude Desktop settings
   • Add the following to your claude_desktop_config.json:

{
  "mcpServers": {
    "google_sheets": {
      "command": "/path/to/your/.venv/bin/python",
      "args": [
        "/path/to/your/google_sheets.py",
        "--credentials-path",
        "/Users/yourusername/.config/google_sheets_mcp/google-sheets-mcp.json",
        "--log-level",
        "DEBUG"
      ]
    }
  }
}

2. First-time setup:
   • Run the server manually to complete OAuth authentication:

python google_sheets.py --credentials-path ~/.config/google_sheets_mcp/google-sheets-mcp.json

• Follow the browser prompts to authorize the application
• The token will be saved automatically for future use

Usage

After setup, you can use the following commands in Claude Desktop:

• Create a new sheet: create_sheet(title: str)
• Format cells: format_range(file_id: str, range: str, format: dict)
• Write formulas: write_formula(file_id: str, range: str, formula: str)
• Add sheets: add_sheet(file_id: str, title: str)
• Delete sheets: delete_sheet(file_id: str, sheet_id: int)
• Get sheet properties: get_sheet_properties(file_id: str)

Development

Project Structure

google-sheets-mcp-server/
├── .venv/                  # Virtual environment
├── google_sheets.py        # Main server implementation
├── pyproject.toml         # Project configuration and dependencies
├── tests/                 # Test files
└── README.md             # This file

Adding New Features