-
securityA
license-
qualityThis 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 -
130
2
MIT License
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
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 fileMCPGD_FOLDER_ID: Google Drive folder IDMCPGD_TOKEN_PATH: Path to token storage file (Optional, Default: ~/.mcp_google_spreadsheet.json)
License
MIT License
This server cannot be installed
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
- AsecurityFlicenseAqualityProvides a Model Context Protocol (MCP) server that enables LLMs to directly access and interact with Google Spreadsheet data.Last updated -21
- -securityAlicense-qualityA server that provides a Machine Control Protocol (MCP) interface to search, access, and interact with Google Drive files and folders, enabling AI assistants to work with Google Drive content.Last updated -5MIT License
- -securityFlicense-qualityAn MCP server that enables interaction with Google Sheets through natural language, allowing users to create, read, update, and manage spreadsheet data via the Google Sheets API v4.Last updated -