Google Drive & Sheets MCP Server

What is Google Drive & Sheets MCP Server?

A Rust-based server that implements the Model Context Protocol (MCP) for interacting with Google Drive and Google Sheets. It exposes file and spreadsheet operations as MCP tools, designed for use in agent workflows and compositions like Distri.

How to use Google Drive & Sheets MCP Server?

Install via cargo install --git https://github.com/distrihub/mcp-google-workspace.git, then configure OAuth credentials via environment variables. Start the Drive or Sheets servers with mcp-google drive --access-token <token> or mcp-google sheets --access-token <token>. Optionally, define them in a Distri agent YAML configuration.

Key features of Google Drive & Sheets MCP Server

• List Google Drive files with MIME type, query, and ordering filters
• Read spreadsheet data with range and dimension control
• Write data to Google Sheets
• Create new spreadsheets with custom titles and multiple sheets
• Clear values from ranges in spreadsheets
• Built-in token refresh command for OAuth authentication

Use cases of Google Drive & Sheets MCP Server

• Automate file search and retrieval in Google Drive via an MCP agent
• Read and write spreadsheet data as part of a multi‑step agent workflow
• Programmatically create new spreadsheets with predefined sheets
• Integrate Google Workspace operations into custom MCP‑compatible tools

FAQ from Google Drive & Sheets MCP Server

What prerequisites are required?

You need Rust (latest stable), a Google Cloud Project with Drive and Sheets APIs enabled, and OAuth 2.0 credentials configured.

How do I install the server?

Run cargo install --git https://github.com/distrihub/mcp-google-workspace.git to install the mcp-google binary.

How do I start the Drive or Sheets server?

Run mcp-google drive --access-token <your-access-token> or mcp-google sheets --access-token <your-access-token> from the command line.

What MCP tools are available?

Drive: list_files. Sheets: read_values, write_values, create_spreadsheet, clear_values. Capabilities are also exposed via the resources/list endpoint.

How do I refresh my OAuth token?

Use the mcp-google refresh command with --client-id, --client-secret, and --refresh-token flags.