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
Windows
2. Install Required Packages
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
Usage
1. Run the Program
2. Use Tools via MCP
Google Drive Examples
Google Sheets Examples
Google Docs Examples
Google Slides Examples
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
- -securityAlicense-qualityThis MCP server integrates with Google Drive to allow listing, reading, and searching over files.Last updated -1,49543,961JavaScriptMIT License
- -securityAlicense-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 -203JavaScriptMIT License
- -securityAlicense-qualityA 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 -44PythonMIT License
- AsecurityFlicenseAqualityProvides a Model Context Protocol (MCP) server that enables LLMs to directly access and interact with Google Spreadsheet data.Last updated -21TypeScript