MCP Google Docs

🚀 MCP Google Workspace Integration

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

🚀 Quick Start

This MCP Google Workspace Integration tool allows seamless interaction with various Google Workspace services. Follow the steps below to get started.

✨ Features

Google Drive Features

• List files
• Copy files
• Rename files
• Create blank spreadsheets
• Create spreadsheets using templates
• Copy existing spreadsheets

Google Sheets Features

• List worksheets
• Copy worksheets
• Rename worksheets
• Get worksheet data
• Add/remove rows
• Add/remove columns
• Update cells
• Create/update/delete charts
• Update cell formatting

Google Docs Features

• Create documents
• Insert formatted text
• Add headings
• Insert images
• Create and manage tables
• Insert headers
• Add horizontal dividers
• 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

📦 Installation

1. Virtual Environment Setup

macOS/Linux

# Create a virtual environment
python -m venv venv

# Activate the virtual environment
source venv/bin/activate

Windows

# Create a virtual environment
python -m venv venv

# Activate the virtual environment
venv\Scripts\activate

2. Install Required Packages

pip install -r requirements.txt

3. Google Cloud Console Setup

1. Create a project in the Google Cloud Console.
2. Create an OAuth 2.0 client ID.
3. Enable the required APIs:
   • Google Sheets API
   • Google Drive API
   • Google Docs API
   • Google Slides API

4. Environment Variable 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 Examples

Basic Usage

1. Run the Program

python main.py

2. Use the Tool 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 worksheet data
mcp get_sheet_data --spreadsheet_id "your_spreadsheet_id" --range "Sheet1!A1:D10"

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

Google Docs Examples

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

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

Google Slides Examples

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

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

📚 Documentation

Environment Variables

📄 License

MIT License