google-drive-mcp-server
The Google Drive MCP Server is designed for seamless integration with Google Drive and Google Sheets, facilitating operations such as reading spreadsheet data. It requires setting up OAuth credentials from Google Cloud and offers an initial tool for reading data, with more features anticipated.
Google Drive MCP Server
MCP server for integrating with Google Drive and Google Sheets.
Setup Instructions
-
Go to Google Cloud Console
-
Create a new project or select an existing one
-
Enable the Google Drive API and Google Sheets API for your project
-
Configure the OAuth consent screen:
- Go to "OAuth consent screen"
- Select "External" user type
- Fill in the application name and required information
- Add the required scopes for Drive and Sheets
- Add your email as a test user
-
Create OAuth 2.0 credentials:
- Go to "Credentials"
- Click "Create Credentials" > "OAuth client ID"
- Select "Desktop app" as the application type
- Name your client
- Download the client configuration file
- Rename it to
credentials.json
and place it in the root directory of this project
Installation
npm install
Running the Server
npm start
The first time you run the server, it will prompt you to authorize access to your Google account. Follow the instructions in your browser to complete the authorization process.
Configuration
The server requires the following files:
credentials.json
: OAuth 2.0 client configuration from Google Cloud Consoletoken.json
: Generated after first authorization (do not edit manually)
Available Tools
read-spreadsheet
: Read data from Google Sheets- More tools coming soon...