Google Drive server
@isaacphi
Model Context Protocol (MCP) Server for reading from Google Drive and editing Google Sheets
概要
What is Google Drive server?
This MCP server integrates with Google Drive to allow listing, reading, and searching files, as well as the ability to read and write to Google Sheets. It is built for developers using the Model Context Protocol to enable AI agents to interact with Google Drive content.
How to use Google Drive server?
Set up a Google Cloud project, enable the Drive and Sheets APIs, create OAuth credentials, and configure environment variables (GDRIVE_CREDS_DIR, CLIENT_ID, CLIENT_SECRET). Run node ./dist/index.js to authenticate via browser, then configure the server in your MCP client’s configuration file. The server exposes tools and resources for file operations.
Key features of Google Drive server
- Search files in Google Drive by query and pagination.
- Read the contents of any Google Drive file.
- Read and update Google Sheets cells with flexible ranges.
- Export Google Workspace files (Docs, Sheets, Presentations, Drawings) to standard formats.
- Access all file types via
gdrive:///<file_id>resource URIs.
Use cases of Google Drive server
- Allow an AI assistant to search and retrieve documents from a user’s Drive.
- Automate data entry into Google Sheets via cell updates.
- Enable reading of exported content (Markdown, CSV, plain text, PNG) for downstream processing.
FAQ from Google Drive server
What Google APIs are required?
You must enable the Google Drive API and Google Sheets API; for document reading, also enable the Google Docs API.
How do I configure OAuth credentials?
Download the OAuth client JSON (type “Desktop App”) from Google Cloud Console, rename it to gcp-oauth.keys.json, and place it in the directory set by GDRIVE_CREDS_DIR.
Where is the OAuth token stored?
The token is saved in the directory specified by the GDRIVE_CREDS_DIR environment variable.
What transport does the server use?
The server uses the standard MCP transport over stdio, invoked via npx -y @isaacphi/mcp-gdrive. Authentication is OAuth 2.0.
Does the server support all file types?
Yes, but Google Workspace files (Docs, Sheets, Presentations, Drawings) are automatically exported to Markdown, CSV, plain text, or PNG. Other files are provided in their native format via gdrive:///<file_id>.