Google Drive And Sheets MCP Server

🚀 Google Drive & Sheets MCP Server

A Model Context Protocol (MCP) server written in Rust for interacting with Google Drive and Google Sheets. This tool provides an MCP-compatible interface for Google Workspace services, enabling them 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 sorting.

Google Sheets Operations

• Read data from Google Sheets with the following options:
  • Specify a range.
  • Choose the major dimension (rows or columns).
• Write data to Google Sheets.
• Create a new spreadsheet with:
  • A custom title.
  • Multiple worksheets.
• Clear values within a spreadsheet range.

📚 MCP Integration

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

Drive Tools

• list_files: List and filter Drive files by custom parameters.
• Available capabilities are exposed via the resources/list endpoint.

Sheets Tools

• read_values: Read spreadsheet data while controlling the dimension.
• write_values: Write data to a spreadsheet.
• create_spreadsheet: Create a new spreadsheet.
• clear_values: Clear values within a range.
• Available capabilities are exposed via the resources/list endpoint.

📦 Prerequisites

• Rust (the latest stable version).
• A Google Cloud project with the Drive and Sheets APIs enabled.
• Google OAuth 2.0 credentials configured.

📦 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 on your system.

🛠️ Configuration

Before using the server, you need to do the following:

1. Set up a Google Cloud project.
2. Enable the Google Drive and Google Sheets APIs.
3. Create OAuth 2.0 credentials.
4. Set 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 Examples

As an MCP Server

You can start each server independently and communicate via the MCP protocol using standard input and output:

Start the Drive MCP server:

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

Start the Sheets MCP server:

mcp

(It seems the original command for starting the Sheets MCP server is incomplete. Please provide the full command if needed.)