Google Drive MCP Server

What is Google Drive MCP Server?

A Model Context Protocol server that integrates with Google Drive and Google Sheets, allowing AI assistants to access spreadsheet data via the read-spreadsheet tool.

How to use Google Drive MCP Server?

Create a Google Cloud project, enable the Drive and Sheets APIs, configure OAuth consent, download OAuth client credentials as credentials.json, run npm install then npm start from the project root. On first launch, follow the browser prompt to authorize access.

Key features of Google Drive MCP Server

• Reads data from Google Sheets via read-spreadsheet tool
• Uses OAuth 2.0 for secure Google account access
• Stores credentials locally (credentials.json and token.json)
• First-run browser authorization flow

Use cases of Google Drive MCP Server

—

FAQ from Google Drive MCP Server

What prerequisites are required?

A Google Cloud project with the Drive and Sheets APIs enabled, and OAuth 2.0 credentials downloaded as credentials.json.

How do I authorize the server?

Run npm start and follow the browser prompt to sign in and grant access. The authorization token is stored locally in token.json.

What tools are currently available?

The server provides the read-spreadsheet tool for reading data from Google Sheets. More tools are promised in future updates.

Where are credentials stored?

In the project root directory: credentials.json (your OAuth client configuration) and token.json (generated after first authorization). Do not edit token.json manually.

How is authentication handled?

The server uses OAuth 2.0 with a desktop application client type. The first run initiates a browser-based authorization flow; subsequent runs reuse the saved token.