mcp-google-docs

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

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

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).

Related MCP Servers

Google Drive server
modelcontextprotocol
-
security
A
license
-
quality
This MCP server integrates with Google Drive to allow listing, reading, and searching over files.
Last updated -
1,369
49,637
JavaScript
MIT License
Google Drive MCP Server
rishipradeep-think41
-
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 -
91
JavaScript
MIT License
mcp-google-sheets
xing5
-
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 -
134
Python
MIT License
Spreadsheet MCP Server
HosakaKeigo
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

View all related MCP servers