MCP server for interacting with Google Drive and Sheets
MCP server for interacting with Google Drive and Sheets. The mcp gdrive mcp server wraps that behind the Model Context Protocol, so an assistant can use it through 9 defined tools rather than through you.
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.
Setup follows the usual MCP pattern — install or clone the server, register it in your client's configuration file, restart the client. The configuration blocks on this page cover the common clients.
Everything the assistant can do here goes through one of these:
gdrive_search — Description: Search for files in Google DriveInput — - query (string): Search queryOutput — Returns file names and MIME types of matching filesgdrive_read_file — Description: Read contents of a file from Google Drivegsheets_read — Description: Read data from a Google Spreadsheet with flexible options for ranges and formattinggsheets_update_cell — Description: Update a cell value in a Google SpreadsheetTools — The Tools tool exposed by this serverResources — The Resources tool exposed by this serverAuthentication — Next you will need to run node ./dist/index.js to trigger the authentication stepYou will need 3 environment variables: CLIENT_ID, CLIENT_SECRET, GDRIVE_CREDS_DIR. The server will not start without them, which is usually why the tools fail to appear on a first run. Keep credentials in your client's env block or a secrets manager rather than in a file you might commit.
Among the file and storage access options, the useful question is rarely "what can it do" but "what does it cost you to run" — permissions, credentials, and how much of your context its toolset consumes. MCP Gdrive's toolset — gdrive_search, Input, Output and 6 more — is a fair guide to whether it matches your workflow. It is maintained by isaacphi; worth a glance at recent repository activity before you build anything load-bearing on it.
This entry was verified against MCP Gdrive's own documentation before publication; SyncDev keeps the directory reviewed rather than auto-generated.
| Tool | What it does |
|---|---|
| gdrive_search | **Description**: Search for files in Google Drive. |
| Input | - query (string): Search query. |
| Output | Returns file names and MIME types of matching files. |
| gdrive_read_file | **Description**: Read contents of a file from Google Drive. |
| gsheets_read | **Description**: Read data from a Google Spreadsheet with flexible options for ranges and formatting. |
| gsheets_update_cell | **Description**: Update a cell value in a Google Spreadsheet. |
| Tools | The Tools tool exposed by this server. |
| Resources | The Resources tool exposed by this server. |
| Authentication | Next you will need to run node ./dist/index.js to trigger the authentication step |
{
"mcpServers": {
"gdrive": {
"command": "npx",
"args": ["-y", "@isaacphi/mcp-gdrive"],
"env": {
"CLIENT_ID": "<CLIENT_ID>",
"CLIENT_SECRET": "<CLIENT_SECRET>",
"GDRIVE_CREDS_DIR": "/path/to/config/directory"
}
}
}
}Configuration as documented by the project. Restart the client after saving.
| Variable | Description | Required |
|---|---|---|
| CLIENT_ID | Configuration value read at startup. | Optional |
| CLIENT_SECRET | Credential the server authenticates with. | Yes |
| GDRIVE_CREDS_DIR | Filesystem location the server is allowed to use. | Optional |
Scoped local file access — read, write, search and reorganise files in directories you explicitly allow.
Search and read your Drive — Docs, Sheets and files become context your assistant can actually use.
Query, modify and analyse local SQLite databases in conversation — the fastest way to chat with a data file.
Chat with your second brain — search, read and write vault notes through the Local REST API.
Model Context Protocol (MCP) tool to interact with Claude Desktop on macOS
Upload, search, transform and organise your Cloudinary media library from a chat window