gsheets-mcp

MCP server for Google Sheets operations.

Tools

| Tool | Description | |------|-------------| | gsheet_list_tabs | List tabs in a spreadsheet by name or ID | | gsheet_read_range | Read values from a range | | gsheet_update_range | Update a range with user-entered values | | gsheet_append_rows | Append rows to a range | | gsheet_create | Create a new spreadsheet | | gsheet_copy_spreadsheet | Copy all or selected tabs into a new spreadsheet | | gsheet_search | Search Drive for spreadsheets by name | | gsheet_clear_range | Clear all values in a range | | gsheet_touch_range | Rewrite formulas in a range to trigger recalculation |

Setup

Prerequisites

• Python 3.10+
• Google account with Sheets and Drive API access
• OAuth desktop client credentials from Google Cloud Console

Installation

git clone https://github.com/<your-user>/gsheets-mcp.git
cd gsheets-mcp
python3 -m venv venv
source venv/bin/activate
pip install -e .

Authentication

1. Save your OAuth desktop credentials file as drive_credentials.json in the repository root.
2. Run an auth bootstrap once:

source venv/bin/activate
python -c "from src import sheets_client; sheets_client.authenticate()"

1. Complete browser consent. A local token.pickle cache will be created.

Claude Code Configuration

Add to ~/.claude.json:

{
  "mcpServers": {
    "gsheets-mcp": {
      "type": "stdio",
      "command": "/path/to/gsheets-mcp/venv/bin/python",
      "args": ["/path/to/gsheets-mcp/run_server.py"]
    }
  }
}

Development

source venv/bin/activate
pytest
python run_server.py

License

MIT