Google Drive & Sheets MCP Server

A Model Context Protocol (MCP) server built in Rust for interacting with Google Drive and Google Sheets. This tool provides MCP-compatible interfaces for Google Workspace services, allowing it to be used as part of larger agent workflows and compositions.

Features

Google Drive Operations

List files in Google Drive with filtering options:
- Filter by MIME type
- Custom search queries
- Configurable page size
- Custom ordering

Google Sheets Operations

Read data from Google Sheets with options:
- Specify range
- Choose major dimension (ROWS or COLUMNS)
Write data to Google Sheets
Create new spreadsheets with:
- Custom title
- Multiple sheets
Clear values from ranges in spreadsheets

MCP Integration

This server implements the Model Context Protocol (MCP), making it compatible with agent frameworks like Distri. Each service exposes its capabilities as MCP tools:

Drive Tools

list_files: List and filter Drive files with customizable parameters
Available capabilities exposed via resources/list endpoint

Sheets Tools

read_values: Read spreadsheet data with dimension control
write_values: Write data to spreadsheets
create_spreadsheet: Create new spreadsheets
clear_values: Clear ranges in spreadsheets
Available capabilities exposed via resources/list endpoint

Prerequisites

Rust (latest stable version)
Google Cloud Project with Drive and Sheets APIs enabled
OAuth 2.0 credentials configured for your Google Cloud Project

Installation

Install the mcp-google binary directly from GitHub using Cargo:

cargo install --git https://github.com/distrihub/mcp-google-workspace.git

This will install the mcp-google command to your system.

Configuration

Before using the server, you need to:

Set up a Google Cloud Project
Enable Google Drive and Google Sheets APIss
Create OAuth 2.0 credentials
Set up your environment variables:
- ACCESS_TOKEN: Your Google OAuth access token
- GOOGLE_CLIENT_ID: Your OAuth client ID
- GOOGLE_CLIENT_SECRET: Your OAuth client secret
- GOOGLE_REFRESH_TOKEN: Your OAuth refresh token

Usage

As MCP Server

The servers can be started independently and will communicate using the MCP protocol over stdio:

Start the Drive MCP server:

mcp-google drive --access-token <your-access-token>

Start the Sheets MCP server:

mcp-google sheets --access-token <your-access-token>

Using with Distri

This server can be used as part of a Distri agent configuration:

agents:
  google_workspace:
    drive:
      type: mcp
      command: ["mcp-google", "drive", "--access-token", "${ACCESS_TOKEN}"]
    sheets:
      type: mcp
      command: ["mcp-google", "sheets", "--access-token", "${ACCESS_TOKEN}"]

Token Management

Refresh your OAuth token:

mcp-google refresh \
  --client-id <your-client-id> \
  --client-secret <your-client-secret> \
  --refresh-token <your-refresh-token>

License

This project is licensed under the MIT License - see the LICENSE file for details.

Contributing

Contributions are welcome! Please feel free to submit a Pull Request.

Note

This is an MCP-compatible server that interacts with Google services. Make sure you have appropriate permissions and credentials before using the tool.

Google Drive & Sheets MCP Server