# Google Workspace MCP Server

A comprehensive Model Context Protocol (MCP) server for Google Workspace integration with Claude Desktop. Provides 109 tools for Gmail, Calendar, Sheets, Docs, Drive, plus local storage and personal memory system.

## Features

- **Gmail**: Read, send, reply, forward emails, manage drafts and labels
- **Google Calendar**: List, create, update, delete events
- **Google Sheets**: Create, read, write spreadsheets with formatting
- **Google Docs**: Create and edit documents with formatting
- **Google Drive**: Upload, download, share files and folders
- **Local Storage**: Profile, job applications, contacts, skills, tasks
- **Memory System**: Personal preferences, behaviors, goals, patterns

---

## Setup Guide

### Prerequisites

- Python 3.10 or higher
- Claude Desktop installed
- Google Cloud project with APIs enabled

### Step 1: Clone or Download

```bash
git clone <repository-url>
cd google-mcp-server
```

### Step 2: Install Dependencies

```bash
pip install -r requirements.txt
```

Required packages:
- `mcp>=0.9.0`
- `google-api-python-client>=2.100.0`
- `google-auth-httplib2>=0.2.0`
- `google-auth-oauthlib>=1.2.0`
- `python-dotenv>=1.0.0`
- `requests>=2.31.0`

### Step 3: Set Up Google Cloud Project

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 Sheets API
   - Google Docs API
   - Google Drive API
4. Go to **APIs & Services > Credentials**
5. Click **Create Credentials > OAuth client ID**
6. Select **Desktop app** as application type
7. Download the JSON file
8. Rename it to `credentials.json` and place in the `google-mcp-server` folder

### Step 4: Authenticate with Google

Run the authentication script:

```bash
cd google-mcp-server
python src/google_auth.py
```

This will:
1. Open a browser window for Google sign-in
2. Ask you to authorize the app
3. Create a `tokens.json` file with your access tokens

### Step 5: Set Up Database Folder (Optional)

Create a centralized database folder for all your data:

```bash
mkdir -p ~/Documents/pbdb/mcp
mkdir -p ~/Documents/pbdb/analytics
mkdir -p ~/Documents/pbdb/exports
mkdir -p ~/Documents/pbdb/backups
```

The MCP server stores data in:
- `~/Documents/pbdb/mcp/local_data.db` - Job tracking, contacts, skills
- `~/Documents/pbdb/mcp/personal_memory.db` - Personal memory system

### Step 6: Configure Claude Desktop

1. Find your Claude Desktop config file:
   - **Windows**: `%APPDATA%\Claude\claude_desktop_config.json`
   - **macOS**: `~/Library/Application Support/Claude/claude_desktop_config.json`
   - **Linux**: `~/.config/Claude/claude_desktop_config.json`

2. Add the MCP server configuration:

```json
{
  "mcpServers": {
    "google-workspace": {
      "command": "python",
      "args": [
        "C:/path/to/google-mcp-server/src/mcp_server.py"
      ],
      "env": {},
      "cwd": "C:/path/to/google-mcp-server"
    }
  }
}
```

**Windows Example:**
```json
{
  "mcpServers": {
    "google-workspace": {
      "command": "C:\\Users\\YourName\\miniconda3\\python.exe",
      "args": [
        "C:\\Users\\YourName\\google-mcp-server\\src\\mcp_server.py"
      ],
      "env": {},
      "cwd": "C:\\Users\\YourName\\google-mcp-server"
    }
  }
}
```

**macOS/Linux Example:**
```json
{
  "mcpServers": {
    "google-workspace": {
      "command": "/usr/bin/python3",
      "args": [
        "/home/username/google-mcp-server/src/mcp_server.py"
      ],
      "env": {},
      "cwd": "/home/username/google-mcp-server"
    }
  }
}
```

### Step 7: Restart Claude Desktop

Close and reopen Claude Desktop. The MCP server will initialize automatically.

### Step 8: Verify Installation

In Claude Desktop, try these commands:
- "Show my recent emails"
- "What events do I have on my calendar?"
- "List my Google Drive files"
- "What do you know about me?"

---

## Available Tools (109 Total)

### Gmail (21 tools)
| Tool | Description |
|------|-------------|
| `list_emails` | List emails from inbox |
| `get_email_detail` | Get full email content |
| `send_email` | Send a new email |
| `search_emails` | Search emails with query |
| `create_draft` | Create a draft email |
| `list_drafts` | List all drafts |
| `update_draft` | Update a draft |
| `send_draft` | Send a draft |
| `delete_draft` | Delete a draft |
| `reply_to_email` | Reply to an email |
| `forward_email` | Forward an email |
| `add_label` | Add label to email |
| `remove_label` | Remove label from email |
| `list_labels` | List all labels |
| `mark_as_read` | Mark email as read |
| `mark_as_unread` | Mark email as unread |
| `trash_email` | Move to trash |
| `archive_email` | Archive email |
| `create_followup_draft` | Create job follow-up draft |
| `create_thank_you_draft` | Create thank you draft |

### Calendar (5 tools)
| Tool | Description |
|------|-------------|
| `list_calendar_events` | List upcoming events |
| `create_calendar_event` | Create a new event |
| `update_calendar_event` | Update an event |
| `delete_calendar_event` | Delete an event |
| `get_calendar_event` | Get event details |

### Sheets (11 tools)
| Tool | Description |
|------|-------------|
| `create_spreadsheet` | Create new spreadsheet |
| `read_sheet` | Read data from sheet |
| `write_sheet` | Write data to sheet |
| `append_sheet` | Append rows to sheet |
| `get_sheet_info` | Get spreadsheet info |
| `create_sheet_tab` | Create new tab |
| `list_spreadsheets` | List all spreadsheets |
| `format_cells` | Format cells |
| `add_formula` | Add formula to cell |
| `share_spreadsheet` | Share spreadsheet |
| `create_job_tracker` | Create job tracker template |

### Docs (12 tools)
| Tool | Description |
|------|-------------|
| `create_document` | Create new document |
| `read_document` | Read document content |
| `append_to_document` | Append text |
| `format_document_text` | Format text |
| `apply_paragraph_style` | Apply styles |
| `insert_table` | Insert table |
| `insert_bullet_list` | Insert bullet list |
| `insert_numbered_list` | Insert numbered list |
| `list_documents` | List all documents |
| `share_document` | Share document |
| `create_daily_report` | Create report template |

### Drive (17 tools)
| Tool | Description |
|------|-------------|
| `list_files` | List files |
| `list_folders` | List folders |
| `create_folder` | Create folder |
| `upload_file` | Upload file |
| `download_file` | Download file |
| `move_file` | Move file |
| `copy_file` | Copy file |
| `delete_file` | Delete file |
| `search_files` | Search files |
| `share_file` | Share with user |
| `share_file_with_anyone` | Share with link |
| `get_file_metadata` | Get file info |
| `rename_file` | Rename file |
| `get_storage_quota` | Get storage info |
| `export_to_drive` | Export content |

### Local Storage (21 tools)
| Tool | Description |
|------|-------------|
| `set_profile` | Set profile field |
| `get_profile` | Get profile |
| `get_full_profile` | Get complete profile |
| `add_job_application` | Add job application |
| `get_job_applications` | Get applications |
| `update_job_application` | Update application |
| `add_interview` | Add interview |
| `get_interviews` | Get interviews |
| `add_contact` | Add contact |
| `get_contacts` | Get contacts |
| `add_skill` | Add skill |
| `get_skills` | Get skills |
| `add_work_experience` | Add experience |
| `get_work_experience` | Get experience |
| `add_education` | Add education |
| `get_education` | Get education |
| `add_task` | Add task |
| `get_tasks` | Get tasks |
| `complete_task` | Complete task |
| `add_note` | Add note |
| `get_notes` | Get notes |
| `get_job_search_summary` | Get job stats |

### Memory System (22 tools)
| Tool | Description |
|------|-------------|
| `save_about_me` | Save user info |
| `get_about_me` | Get user info |
| `remember` | Remember anything |
| `recall` | Recall memories |
| `add_behavior` | Store behavior pattern |
| `get_behaviors` | Get behaviors |
| `add_preference` | Store preference |
| `get_preferences` | Get preferences |
| `add_goal` | Store goal |
| `get_goals` | Get goals |
| `add_work_style` | Store work style |
| `get_work_style` | Get work style |
| `add_fact` | Store fact |
| `get_facts` | Get facts |
| `add_decision` | Log decision |
| `get_decisions` | Get decisions |
| `add_interaction` | Log interaction |
| `get_interactions` | Get interactions |
| `add_learning` | Store learning |
| `get_learnings` | Get learnings |
| `get_everything_about_user` | Get all user data |
| `search_memory` | Search memories |

---

## Project Structure

```
google-mcp-server/
├── src/
│   ├── mcp_server.py       # Main MCP server (109 tools)
│   ├── google_auth.py      # OAuth authentication
│   ├── google_gmail.py     # Gmail integration
│   ├── google_calendar.py  # Calendar integration
│   ├── google_sheets.py    # Sheets integration
│   ├── google_docs.py      # Docs integration
│   ├── google_drive.py     # Drive integration
│   ├── local_storage.py    # SQLite local storage
│   └── memory_system.py    # Personal memory system
├── credentials.json        # OAuth credentials (create this)
├── tokens.json            # Auth tokens (auto-generated)
├── config.json            # Configuration
├── requirements.txt       # Dependencies
└── README.md
```

---

## Troubleshooting

### Server not loading in Claude Desktop
1. Check the path in `claude_desktop_config.json`
2. Verify Python path is correct
3. Check logs at `%APPDATA%\Claude\logs\mcp-server-google-workspace.log`

### Authentication errors
1. Delete `tokens.json` and re-authenticate
2. Verify `credentials.json` is valid
3. Check that APIs are enabled in Google Cloud Console

### Database errors
1. Verify database folder exists at `~/Documents/pbdb/mcp/`
2. Check file permissions
3. Delete `.db` files to reset (data will be lost)

---

## License

MIT License