What is Google Sheets Mcp Server

google-sheets-mcp-server is a Model Context Protocol (MCP) server implementation that allows Claude Desktop to interact directly with Google Sheets, enabling users to create, read, write, and manage Google Sheets seamlessly.

Use cases

Use cases include automating data entry into Google Sheets, generating reports, managing project timelines, and facilitating collaborative work by allowing multiple users to interact with sheets through Claude Desktop.

How to use

To use google-sheets-mcp-server, first install the necessary dependencies and set up your Google Cloud credentials. After configuration, you can use commands in Claude Desktop to create sheets, format cells, write formulas, and manage your Google Sheets.

Key features

Key features include the ability to create new Google Sheets, read and write data, format cells and ranges, add or delete sheets, write formulas, search for sheets, and list available sheets.

Where to use

google-sheets-mcp-server can be used in various fields such as data analysis, project management, and any application that requires interaction with Google Sheets for data manipulation and reporting.

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

1. Add new tool methods to the GoogleSheetsMCP class
2. Decorate them with @mcp.tool()
3. Update the README with new feature documentation

Running Tests

pytest

Troubleshooting

1. Server Connection Issues

   • Check if the server is running
   • Verify credentials path in config
   • Check logs in Claude Desktop

2. Authentication Issues

   • Ensure OAuth credentials are valid
   • Check if your email is added as a test user
   • Try deleting token.json and re-authenticating

3. API Errors

   • Verify Google Sheets API is enabled
   • Check API quotas and limits
   • Review error logs for specific issues

Contributing

1. Fork the repository
2. Create a feature branch
3. Commit your changes
4. Push to the branch
5. Create a Pull Request

License

This project is licensed under the MIT License - see the LICENSE file for details.