mcp-google-docs

MIT License
1
  • Linux
  • Apple

Integrations

  • Provides tools for Google Drive manipulation including listing files, copying files, renaming files, and creating various types of documents including empty spreadsheets and template-based spreadsheets.

  • Offers comprehensive Google Sheets functionality for managing sheets, manipulating data (rows/columns/cells), creating and modifying charts, and updating cell formats. Includes capabilities for sheet listing, copying, renaming, and data retrieval.

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

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

-
security - not tested
A
license - permissive license
-
quality - not tested

remote-capable server

The server can be hosted and run remotely because it primarily relies on remote services or has no dependency on the local environment.

A tool for manipulating Google Spreadsheet and Google Drive using MCP (Metoro Control Protocol).

  1. Features
    1. Google Drive Features
    2. Google Sheets Features
    3. Google Docs Features
    4. Google Slides Features
  2. Installation
    1. 1. Virtual Environment Setup
    2. 2. Install Required Packages
    3. 3. Google Cloud Console Setup
    4. 4. Environment Variables Setup
  3. Usage
    1. 1. Run the Program
    2. 2. Use Tools via MCP
  4. Environment Variables
    1. License

      Related MCP Servers

      • -
        security
        A
        license
        -
        quality
        This MCP server integrates with Google Drive to allow listing, reading, and searching over files.
        Last updated -
        1,495
        43,961
        JavaScript
        MIT License
      • -
        security
        A
        license
        -
        quality
        This MCP server integrates with Google Drive to allow listing, reading, and searching files, as well as the ability to read and write to Google Sheets.
        Last updated -
        203
        JavaScript
        MIT License
      • -
        security
        A
        license
        -
        quality
        A Model Context Protocol server that integrates with Google Drive and Google Sheets, enabling users to create, read, update, and manage spreadsheets through natural language commands.
        Last updated -
        44
        Python
        MIT License
        • Linux
        • Apple
      • A
        security
        F
        license
        A
        quality
        Provides a Model Context Protocol (MCP) server that enables LLMs to directly access and interact with Google Spreadsheet data.
        Last updated -
        2
        1
        TypeScript
        • Apple

      View all related MCP servers

      ID: 1oos2ptkkj