MCP Google Workspace Integration

A comprehensive MCP (Metoro Control Protocol) tool for interacting with Google Workspace services including Google Docs, Sheets, Slides, and Drive.

Features

Google Drive Features

• List files

• Copy files

• Rename files

• Create empty spreadsheets

• Create spreadsheets from templates

• Copy existing spreadsheets

Google Sheets Features

• List sheets

• Copy sheets

• Rename sheets

• Get sheet data

• Add/Delete rows

• Add/Delete columns

• Update cells

• Create/Update/Delete charts

• Update cell formats

Google Docs Features

• Create documents

• Insert text with formatting

• Add headings

• Insert images

• Create and manage tables

• Insert page breaks

• Add horizontal rules

• Update document styles

• Manage table styles and content

Google Slides Features

• Create presentations

• Add slides

• Insert images

• Add shapes and lines

• Update text styles

• Modify slide backgrounds

• Update slide layouts

• Add slide transitions

• Add speaker notes

Related MCP server: google-sheets-mcp

Installation

1. Virtual Environment Setup

macOS/Linux

# Create virtual environment
python -m venv venv

# Activate virtual environment
source venv/bin/activate

Windows

# Create virtual environment
python -m venv venv

# Activate virtual environment
venv\Scripts\activate

2. Install Required Packages

pip install -r requirements.txt

3. Google Cloud Console Setup

1. Create a project in Google Cloud Console

2. Create OAuth 2.0 client ID

3. Enable required APIs:

   • Google Sheets API

   • Google Drive API

   • Google Docs API

   • Google Slides API

4. Environment Variables Setup

export MCPGD_CLIENT_SECRET_PATH="/path/to/client_secret.json"
export MCPGD_FOLDER_ID="your_folder_id"
export MCPGD_TOKEN_PATH="/path/to/token.json"  # Optional

Usage

1. Run the Program

python main.py

2. Use Tools via MCP

Google Drive Examples

# List files
mcp list_files

# Copy a file
mcp copy_file --file-id "file_id" --new_name "new_name"

Google Sheets Examples

# Get sheet data
mcp get_sheet_data --spreadsheet_id "your_spreadsheet_id" --range "Sheet1!A1:D10"

# Create chart
mcp create_chart --chart_type "LINE" --range "A1:B10" --sheet_name "Sheet1" --title "Sales Trend"

Google Docs Examples

# Create document
mcp create_document --title "My Document"

# Insert formatted text
mcp insert_text_to_document --document_id "doc_id" --text "Hello World" --font_family "Arial" --font_size 12

Google Slides Examples

# Create presentation
mcp create_presentation --title "My Presentation"

# Add slide with content
mcp add_slide_to_presentation --presentation_id "presentation_id" --title "Slide Title" --content "Slide Content"

Environment Variables

• MCPGD_CLIENT_SECRET_PATH: Path to Google OAuth 2.0 client secret file

• MCPGD_FOLDER_ID: Google Drive folder ID

• MCPGD_TOKEN_PATH: Path to token storage file (Optional, Default: ~/.mcp_google_spreadsheet.json)

License

MIT License