Google Drive & Sheets MCP Server
by distrihub
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.
Last updated: N/A
What is Google Drive & Sheets MCP Server?
This is an MCP (Model Context Protocol) server that allows agents and other systems to interact with Google Drive and Google Sheets programmatically. It provides a standardized interface for performing common operations on Google Workspace services.
How to use Google Drive & Sheets MCP Server?
To use this server, you need to install the mcp-google binary, configure a Google Cloud Project with the necessary APIs enabled and OAuth 2.0 credentials, and set up environment variables for authentication. You can then start the Drive or Sheets MCP server independently and interact with them using the MCP protocol, or integrate them into a Distri agent configuration.
Key features of Google Drive & Sheets MCP Server
List files in Google Drive with filtering options
Read data from Google Sheets with options to specify range and dimension
Write data to Google Sheets
Create new spreadsheets with custom titles and multiple sheets
Clear values from ranges in spreadsheets
MCP Integration with agent frameworks like Distri
Use cases of Google Drive & Sheets MCP Server
Automating file management in Google Drive
Extracting and analyzing data from Google Sheets
Generating reports and dashboards based on Google Sheets data
Integrating Google Workspace services into AI agent workflows
Programmatically creating and updating spreadsheets
FAQ from Google Drive & Sheets MCP Server
What is MCP?
What is MCP?
MCP stands for Model Context Protocol. It's a protocol for communication between agents and tools.
What Google APIs are required?
What Google APIs are required?
You need the Google Drive API and the Google Sheets API enabled in your Google Cloud Project.
How do I authenticate?
How do I authenticate?
You need to configure OAuth 2.0 credentials and set the ACCESS_TOKEN, GOOGLE_CLIENT_ID, GOOGLE_CLIENT_SECRET, and GOOGLE_REFRESH_TOKEN environment variables.
How do I install the server?
How do I install the server?
Use cargo install --git https://github.com/distrihub/mcp-google-workspace.git to install the mcp-google binary.
How do I use this with Distri?
How do I use this with Distri?
Configure your Distri agent with the mcp type and specify the command to start the Drive or Sheets server with the appropriate access token.