Google Drive And Sheets MCP Server

A Rust - based MCP server that provides functions to interact with Google Drive and Google Sheets, supporting operations such as file listing and spreadsheet reading/writing, and can be integrated into distributed proxy workflows.

Developer tools Cloud storage #Google Drive #Spreadsheet operations #MCP protocol #Rust tool .Rust

rating : 2.5 points

downloads : 17

update time : 2025-04-23

What is Google Drive & Sheets MCP Server?

This is a tool built on Rust that interacts with Google Drive and Sheets services through the standardized Model Context Protocol (MCP). It allows developers or users to integrate Google Workspace features into automated workflows.

How to use this service?

You can use it by installing the Rust binary and configuring Google API credentials. The service can run as an independent server or be integrated into proxy frameworks such as Distri.

Use cases

Suitable for scenarios that require automated processing of Google cloud files or spreadsheet data, such as data collection, report generation, content management, and other automated workflows.

Main features

Google Drive file listSupports filtering files by MIME type and custom query conditions, and allows configuration of pagination size and sorting method.

Read spreadsheet dataRead data from a specified range in a Google spreadsheet, supporting retrieval by row or column dimensions.

Write spreadsheet dataWrite data to a Google spreadsheet, supporting specification of the write range.

Create a new spreadsheetCreate a new spreadsheet document with a custom title and multiple worksheets.

Advantages and limitations

Advantages

Standardized MCP protocol, easy to integrate with other services

Supports core functions of Google Drive and Sheets

Flexible filtering and query options

Can be used as an independent service or integrated into a proxy framework

Limitations

Requires Google API credential configuration

Functions focus on basic operations, lacking advanced features

Requires maintenance of OAuth tokens

How to use

Install the tool

Install the binary using Rust's cargo tool.

Configure Google API

Create a project in Google Cloud Platform, enable the Drive and Sheets APIs, and obtain OAuth credentials.

Set environment variables

Configure necessary environment variables such as ACCESS_TOKEN and CLIENT_ID.

Start the service

Start the corresponding service using the drive or sheets sub - commands as needed.

Usage examples

Automatically back up report dataAutomatically export business report data from the database to a Google spreadsheet every week.

Team file managementAutomatically organize files in the team's shared folder and classify them by type.

Frequently Asked Questions

How to obtain Google API credentials?

What to do when the token expires?

Can I access multiple Google accounts simultaneously?

Related resources

GitHub repository

Project source code and latest version

Google API documentation

Official documentation for the Google Drive API

MCP protocol description

Model Context Protocol specification

🚀 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:

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

Featured MCP Services

Markdownify MCP

Markdownify is a multi-functional file conversion service that supports converting multiple formats such as PDFs, images, audio, and web page content into Markdown format.

TypeScript

1.7K

5 points

Duckduckgo MCP Server

Certified

The DuckDuckGo Search MCP Server provides web search and content scraping services for LLMs such as Claude.

The GitLab MCP server is a project based on the Model Context Protocol that provides a comprehensive toolset for interacting with GitLab accounts, including code review, merge request management, CI/CD configuration, and other functions.

A Python-based MCP Server that provides advanced to-do list management and content organization functions through the Notion API, enabling seamless integration between AI models and Notion.

UnityMCP is a Unity editor plugin that implements the Model Context Protocol (MCP), providing seamless integration between Unity and AI assistants, including real - time state monitoring, remote command execution, and log functions.

554

5 points

Figma Context MCP

Framelink Figma MCP Server is a server that provides access to Figma design data for AI programming tools (such as Cursor). By simplifying the Figma API response, it helps AI more accurately achieve one - click conversion from design to code.

Context7 MCP is a service that provides real-time, version-specific documentation and code examples for AI programming assistants. It is directly integrated into prompts through the Model Context Protocol to solve the problem of LLMs using outdated information.

The MiniMax Model Context Protocol (MCP) is an official server that supports interaction with powerful text-to-speech, video/image generation APIs, and is suitable for various client tools such as Claude Desktop and Cursor.

Python

745

4.8 points

Zhiqi Future, Your AI Solution Think Tank

English 简体中文繁體中文にほんご