Google Drive Server

This MCP server integrates with Google Drive, enabling file listing, reading, searching, and Google Sheets interaction. It incorporates code from Anthropic, PBC (MIT License).

Components

Tools

• gdrive_search: Searches Google Drive using a query, optional page token, and page size (max 100). Returns file names and MIME types.
• gdrive_read_file: Reads a file from Google Drive using its file ID, returning the file's contents.
• gsheets_read: Reads data from a Google Spreadsheet, with optional A1 notation ranges or a specific sheet ID. Returns the specified data.
• gsheets_update_cell: Updates a cell value in a Google Spreadsheet using file ID, cell range, and new value. Confirms the updated value.

Resources

The server provides access to Google Drive files (gdrive:///<file_id>), supporting all file types. Google Workspace files are automatically exported (Docs to Markdown, Sheets to CSV, Presentations to plain text, Drawings to PNG).

Getting Started

The guide details Google Cloud project setup, API enabling, OAuth configuration, credential creation, and environment variable setup. Authentication is required via a browser prompt.

Usage with Desktop App

Configuration details are provided for integrating the server with a desktop application.

License

Licensed under the MIT License.