# MCP Server for Google Services
A Model Context Protocol (MCP) server that integrates Google services with Claude Desktop. Provides 80+ tools for Gmail, Calendar, Drive, Sheets, and Docs operations.
## Features
- **Gmail**: Search, read, send, reply, label, and organize emails
- **Google Calendar**: Create, update, delete events; find free slots
- **Google Drive**: Search, list, read files and folders
- **Google Sheets**: Read, write, append data; manage spreadsheets
- **Google Docs**: Create and read documents
- **Memory System**: Persistent storage for context and preferences
- **Database Support**: Optional PostgreSQL and MongoDB integration
## Project Structure
```
mcpwithgoogle/
├── src/
│ ├── mcp_server.py # Main MCP server (80+ tools)
│ ├── google_auth.py # OAuth authentication
│ ├── google_gmail.py # Gmail operations
│ ├── google_calendar.py # Calendar operations
│ ├── google_drive.py # Drive operations
│ ├── google_sheets.py # Sheets operations
│ ├── google_docs.py # Docs operations
│ ├── memory_system.py # Persistent memory
│ ├── local_storage.py # Local data storage
│ └── setup.py # OAuth setup script
├── config/
│ └── claude_desktop_config.json # Example Claude config
├── scripts/
│ └── setup_my_profile.py
├── config.example.json # Google OAuth config template
├── authenticate.py # Authentication script
├── requirements.txt
├── .env.example
└── README.md
```
## Prerequisites
- Python 3.8+
- Claude Desktop
- Google Cloud Project with APIs enabled:
- Gmail API
- Google Calendar API
- Google Drive API
- Google Sheets API
## Installation
### Step 1: Clone the Repository
```bash
git clone https://github.com/pbulbule13/mcpwithgoogle.git
cd mcpwithgoogle
```
### Step 2: Install Dependencies
```bash
pip install -r requirements.txt
```
### Step 3: Google Cloud Setup
1. Go to [Google Cloud Console](https://console.cloud.google.com/)
2. Create a new project or select existing
3. Enable the following APIs:
- Gmail API
- Google Calendar API
- Google Drive API
- Google Sheets API
4. Go to **Credentials** > **Create Credentials** > **OAuth 2.0 Client ID**
5. Select **Desktop app** as application type
6. Download the credentials and save as `credentials.json` in the project root
### Step 4: Configure
```bash
# Copy example config
cp config.example.json config.json
# Edit with your Google OAuth credentials
```
**config.json:**
```json
{
"google": {
"clientId": "YOUR_CLIENT_ID.apps.googleusercontent.com",
"clientSecret": "YOUR_CLIENT_SECRET",
"redirectUri": "http://localhost",
"calendarId": "primary"
}
}
```
### Step 5: Authenticate with Google
```bash
python authenticate.py
```
This opens a browser for Google OAuth. After authorization, tokens are saved locally.
### Step 6: Configure Claude Desktop
Edit your Claude Desktop configuration file:
| OS | Path |
|----|------|
| Windows | `%APPDATA%\Claude\claude_desktop_config.json` |
| macOS | `~/Library/Application Support/Claude/claude_desktop_config.json` |
| Linux | `~/.config/Claude/claude_desktop_config.json` |
Add:
```json
{
"mcpServers": {
"google-workspace": {
"command": "python",
"args": [
"C:\\path\\to\\mcpwithgoogle\\src\\mcp_server.py"
],
"env": {},
"cwd": "C:\\path\\to\\mcpwithgoogle"
}
}
}
```
**Important:** Replace `C:\\path\\to\\` with your actual absolute path.
### Step 7: Restart Claude Desktop
1. Completely quit Claude Desktop (check system tray)
2. Restart Claude Desktop
3. The tools will be automatically available
## Verify Installation
In Claude Desktop, type:
```
Show me available tools
```
You should see 80+ tools listed.
## Available Tools
### Email Tools
- `search_emails` - Search Gmail with queries
- `get_email` - Get email by ID
- `send_email` - Send new email
- `reply_to_email` - Reply to email
- `list_labels` - List Gmail labels
- `create_label` - Create new label
- `move_to_label` - Move email to label
### Calendar Tools
- `get_calendar_events` - List events
- `create_calendar_event` - Create event
- `update_calendar_event` - Update event
- `delete_calendar_event` - Delete event
- `find_free_slots` - Find available times
### Drive Tools
- `search_drive` - Search files
- `list_drive_files` - List files in folder
- `get_file_content` - Read file content
- `create_folder` - Create folder
### Sheets Tools
- `read_sheet` - Read spreadsheet data
- `write_sheet` - Write to spreadsheet
- `append_sheet` - Append rows
- `create_sheet` - Create new spreadsheet
### Docs Tools
- `create_doc` - Create document
- `read_doc` - Read document content
### Memory Tools
- `remember` - Store information
- `recall` - Retrieve information
- `forget` - Remove information
- `list_memories` - List all stored items
## Example Usage
In Claude Desktop:
```
"Show my unread emails from today"
"Schedule a meeting tomorrow at 2 PM with john@example.com"
"Find documents about 'project proposal' in my Drive"
"What meetings do I have this week?"
"Remember that my favorite color is blue"
```
## Troubleshooting
### MCP Server Not Appearing
1. Verify the path in `claude_desktop_config.json` is absolute and correct
2. Ensure Python is in your system PATH
3. Restart Claude Desktop completely
4. Check Claude Desktop logs for errors
### Authentication Errors
1. Delete `tokens.json` and re-run `python authenticate.py`
2. Verify `credentials.json` exists in project root
3. Check Google Cloud Console for API quota issues
### Import Errors
```bash
pip install --upgrade -r requirements.txt
```
## Security Notes
- Never commit `credentials.json`, `tokens.json`, or `config.json` to git
- The `.gitignore` file excludes sensitive files by default
- Store API keys in environment variables when possible
## License
MIT License
