MCP Google Workspace Integration
About
A lightweight MCP Server for integrating Google Docs, Sheets, and Slides with custom applications. Enables seamless document management, real-time collaboration, and API-based automation.
Explore
- List files
- Copy files
- Rename files
- Create empty spreadsheets
- Create spreadsheets from templates
- Copy existing spreadsheets
- List sheets
- Copy sheets
- Rename sheets
- Get sheet data
- Add/Delete rows
- Add/Delete columns
- Update cells
- Create/Update/Delete charts
- Update cell formats
- 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
- 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
Setting up with Highlight
This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:
- Download and install Highlight from highlightai.com/download
- Navigate to the plugins tab and select "Add Custom Plugin"
-
Configure the plugin with the settings below
Plugin Name
MCP Google Workspace IntegrationCommand (node, npx, python, etc.)Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.
- Enable "Start Automatically" if you want the plugin to start when Highlight launches
From the repository
python -m venv venv
source venv/bin/activate
pip install -r requirements.txt
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
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
``
-
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)Claude Desktop / Cursor
Paste into your MCP client config file to install this server.
{
"mcpServers": {
"mcp google workspace integration": {
"mcp-google-docs": {
"command": "python",
"args": [
"-m",
"venv",
"venv"
]
}
}
}
}McpServers
{
"mcp-google-docs": {
"command": "python",
"args": [
"-m",
"venv",
"venv"
]
}
}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 spreadsheetsGoogle 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 formatsGoogle 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 contentGoogle 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 notesInstallation
1. Virtual Environment Setup
macOS/Linux
```bashSign in to leave a review
Use Google, GitHub, or an email account so ratings stay tied to real people.
No reviews posted yet.
