Googleworkspace MCP Server

🚀 Google Workspace MCP Server

A Model Context Protocol (MCP) server for interacting with Google Workspace APIs, including Gmail, Drive, Calendar, Docs, Sheets, and Slides.

🚀 Quick Start

This is a Model Context Protocol (MCP) server designed to interact with Google Workspace APIs. It supports multiple Google Workspace services and provides a series of tools for easy operation.

✨ Features

• Gmail API: Send emails, list messages, manage labels, etc.
• Drive API: List files, create folders, upload files.
• Docs API: Create and edit Google Docs.
• Sheets API: Read and write spreadsheet data.
• Slides API: Create presentations and slides.
• Calendar API: List and create calendar events.
• Authentication: OAuth2 authentication process helper.

📦 Installation

Prerequisites

• Node.js 16+
• A Google Cloud project with the necessary APIs enabled
• OAuth 2.0 client credentials

Steps

npm install

📚 Documentation

Configuration

1. Copy the .env.example file to .env:

   cp .env.example .env
   

2. Edit the .env file with your Google API credentials:

   CLIENT_ID=your_client_id
   CLIENT_SECRET=your_client_secret
   REDIRECT_URI=http://localhost:3000/oauth2callback
   REFRESH_TOKEN=your_refresh_token
   

3. If you don't have a refresh token yet, you can obtain it using the authentication tools provided by the server.

Usage

Start the Server

npm run dev

Use with MCP Inspector

To test the server with MCP Inspector:

npm run inspect

This will open the MCP Inspector in your browser, allowing you to test all tools and resources.

Authentication

If you don't have a refresh token, you can use these tools:

1. Use the generate_auth_url tool to get the authorization URL.
2. Open the URL in your browser and authorize the application.
3. Copy the authorization code from the redirect URL.
4. Use the exchange_code_for_tokens tool and the code to exchange for a refresh token.
5. Add the refresh token to the .env file.

Available Tools

Gmail

• gmail_list_messages: List Gmail messages that meet the criteria.
• gmail_get_message: Get a specific Gmail message by ID.
• gmail_send_message: Send a new email.
• gmail_list_labels: List all Gmail labels.
• gmail_modify_message: Modify message labels.
• gmail_trash_message: Move a message to the trash.
• gmail_untrash_message: Remove a message from the trash.
• gmail_create_draft: Create a draft.

Drive

• drive_list_files: List files in Google Drive.
• drive_get_file: Get the metadata of a specific file.
• drive_create_folder: Create a new folder in Google Drive.
• drive_upload_file: Upload a file to Google Drive.

Docs

• docs_get_document: Get the content of a Google Doc.
• docs_create_document: Create a new Google Doc.
• docs_append_text: Add text to the end of a document.

Sheets

• sheets_get_values: Read values from a Google Sheet.
• sheets_update_values: Update values in a spreadsheet.
• sheets_create_spreadsheet: Create a new Google Sheet.

Slides

• slides_create_presentation: Create a new Google Slides presentation.
• slides_get_presentation: Get information about a presentation.
• slides_create_slide: Add a new slide to a presentation.

Calendar

• calendar_list_events: List calendar events.
• calendar_create_event: Create a new calendar event.

Resources

scheme://authority/path?query#fragment

For example:

workspace://auth/guide