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: Spreadsheet MCP Server

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

Create a project in Google Cloud Console
Create OAuth 2.0 client ID
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

This server cannot be installed

-

security - not tested

A

license - permissive license

-

quality - not tested

How are these scores calculated?

Resources

GitHub Repository

Need Help?

Report Issue

Related Servers

mcp-google-docs