bd01010/chatgpt-mcp-connector

ChatGPT Google Workspace MCP Connector

A full OAuth-enabled MCP (Model Context Protocol) server for ChatGPT that provides access to Google Workspace (Drive, Docs, Sheets, Slides).

Features

✅ Full OAuth 2.0 authentication flow ✅ Real Google Workspace access (not mock data) ✅ Multiple Google services:

• Google Drive (list, create, read, update, delete files)
• Google Docs (create documents)
• Google Sheets (create spreadsheets)
• Google Slides (create presentations)

Setup Instructions

1. Google Cloud Console Setup

CRITICAL: You must add the authorized redirect URI to Google Cloud Console:

1. Go to Google Cloud Console
2. Select your project or create a new one
3. Go to APIs & Services → Credentials
4. Find your OAuth 2.0 Client ID (the one with ID ending in ...mm7s.apps.googleusercontent.com)
5. Click on it to edit
6. Under Authorized redirect URIs, add:

   https://chatgpt-mcp-connector.vercel.app/oauth/callback
   

7. Click Save

2. Deployment Status

This project is deployed at:

• URL: https://chatgpt-mcp-connector.vercel.app
• OAuth Callback: https://chatgpt-mcp-connector.vercel.app/oauth/callback

3. Add to ChatGPT

1. Go to ChatGPT → Settings → Connectors → Add Connector
2. Fill in:
   • Name: Google Workspace
   • Server URL: https://chatgpt-mcp-connector.vercel.app/sse
   • Description: Access Google Drive, Docs, Sheets, and Slides
   • Authentication: OAuth
3. Click Create
4. You'll be redirected to Google to authorize access

OAuth Flow

The connector implements the full OAuth 2.0 flow:

1. Authorization endpoint: /oauth/authorize
2. Token endpoint: /oauth/token
3. Callback endpoint: /oauth/callback
4. Discovery endpoint: /.well-known/oauth-authorization-server

Available Tools

• drive_list - List files in Google Drive
• drive_create_folder - Create a new folder
• drive_create_file - Create a new file with content
• drive_read_file - Read file content
• drive_update_file - Update file content
• drive_delete_file - Delete a file
• docs_create - Create a new Google Doc
• sheets_create - Create a new Google Sheet
• slides_create - Create a new Google Slides presentation

Security Notes

• OAuth tokens are stored in secure session storage
• All API calls require valid authentication
• Implements proper CORS headers for ChatGPT integration
• Uses Google's official OAuth 2.0 flow

Troubleshooting

If you get "Error fetching OAuth configuration":

1. Verify the redirect URI is added in Google Cloud Console
2. Make sure you saved the changes in Google Cloud Console
3. Try removing and re-adding the connector in ChatGPT

If authentication fails:

1. Make sure you're using the correct Google account
2. Verify all required scopes are authorized
3. Check that the OAuth client is not in test mode (should be in production)