{"type":"mcp_server","name":"mcp-gdrive","description":"This repository provides an MCP server integrating with Google Drive, enabling file listing, reading, searching, and Google Sheets manipulation through tools for reading and updating spreadsheet data. This repository provides","category":"Productivity","language":"TypeScript","stars":283,"forks":12,"owner":"isaacphi","github_url":"https://github.com/isaacphi/mcp-gdrive","homepage":null,"setup":"## Setup\n\n1. [Create a new Google Cloud project](https://console.cloud.google.com/projectcreate).\n2. [Enable the Google Drive API](https://console.cloud.google.com/workspace-api/products).\n3. [Configure an OAuth consent screen](https://console.cloud.google.com/apis/credentials/consent) (\"internal\" is fine for testing).\n4. Add OAuth scopes `https://www.googleapis.com/auth/drive.readonly`, `https://www.googleapis.com/auth/spreadsheets`.\n5. Enable the [Google Sheets API](https://console.cloud.google.com/apis/api/sheets.googleapis.com/) and [Google Docs API](https://console.cloud.google.com/marketplace/product/google/docs.googleapis.com) in your workspaces Enabled API and Services section.\n6. [Create an OAuth Client ID](https://console.cloud.google.com/apis/credentials/oauthclient) for application type \"Desktop App\".\n7. Download the JSON file of your client's OAuth keys.\n8. Rename the key file to `gcp-oauth.keys.json` and place into the path you specify with `GDRIVE_CREDS_DIR` (i.e. `/Users/username/.config/mcp-gdrive`).\n9. Note your OAuth Client ID and Client Secret, and provide them as environment variables along with your configuration directory.\n10. Setup a .env file within the project with `GDRIVE_CREDS_DIR`, `CLIENT_ID`, and `CLIENT_SECRET`.\n11. Build the server with either `npm run build` or `npm run watch`.\n12. Run `node ./dist/index.js` to trigger the authentication step.\n13. Authenticate with your browser using an account in the same organization as your Google Cloud project.\n14. Your OAuth token is saved in the directory specified by the `GDRIVE_CREDS_DIR` environment variable.","tools":"## Available Tools\n\n1.  **gdrive_search** (Search for files in Google Drive.)\n2.  **gdrive_read_file** (Read contents of a file from Google Drive.)\n3.  **gsheets_read** (Read data from a Google Spreadsheet with flexible options for ranges and formatting.)\n4.  **gsheets_update_cell** (Update a cell value in a Google Spreadsheet.)","faq":null,"created_at":"2024-12-13T23:49:36+00:00","updated_at":"2025-03-28T10:21:33+00:00","source_url":"https://model-context-protocol.com/servers/mcp-server-google-drive-sheets","related_articles":[]}