Google Workspace MCP Server

MCP server for Google Slides, Sheets, Docs, and Drive. Enables AI assistants to create, read, and modify Google Workspace documents programmatically.

Quick Start

npm install
npm run build
npm run get-token  # One-time OAuth setup
npm start

Configuration

Required Environment Variables

GOOGLE_CLIENT_ID=your_client_id
GOOGLE_CLIENT_SECRET=your_client_secret
GOOGLE_REFRESH_TOKEN=your_refresh_token

Optional Module Toggles

All modules enabled by default. Set to false to disable:

ENABLE_SHEETS=false
ENABLE_SLIDES=false
ENABLE_DOCS=false
ENABLE_REVISIONS=false

Drive tools are always enabled (core functionality).

Claude Code Configuration

Add to your MCP settings:

{
  "mcpServers": {
    "google-workspace-mcp": {
      "command": "node",
      "args": ["/path/to/google-workspace-mcp/build/index.js"],
      "env": {
        "GOOGLE_CLIENT_ID": "your_client_id",
        "GOOGLE_CLIENT_SECRET": "your_client_secret",
        "GOOGLE_REFRESH_TOKEN": "your_refresh_token"
      }
    }
  }
}

Available Tools

Drive (always enabled)

Tool	Description
`create_folder`	Create a folder in Google Drive
`list_files`	List files/folders with filtering, pagination, and sorting. Supports Shared Drives.
`get_file`	Get detailed metadata for a specific file (permissions, capabilities, owners)
`search_files`	Search Drive using query syntax (e.g., `name contains 'report'`)
`export_file`	Export Google Docs/Sheets/Slides to PDF, text, CSV, docx, etc.

Sheets

Tool	Description
`create_spreadsheet`	Create a new spreadsheet
`get_spreadsheet`	Get spreadsheet metadata
`get_sheet_values`	Read cell values
`update_sheet_values`	Write cell values
`batch_update_spreadsheet`	Apply formatting/structural changes
`append_sheet_values`	Append rows
`summarize_spreadsheet`	Extract all data
`copy_sheet`	Copy sheet between spreadsheets

Slides

Tool	Description
`create_presentation`	Create a new presentation
`get_presentation`	Get presentation metadata
`batch_update_presentation`	Apply updates to slides
`get_page`	Get specific slide details
`summarize_presentation`	Extract text from all slides

Docs

Tool	Description
`create_document`	Create a new document
`get_document`	Get document content
`batch_update_document`	Insert/delete/format text
`summarize_document`	Extract text content

Version History

Tool	Description
`list_revisions`	List document version history
`get_revision`	Get revision details with restore instructions

Security

OAuth Scopes

This server requests the minimum scopes needed:

Scope	Purpose
`presentations`	Create/edit Google Slides
`spreadsheets`	Create/edit Google Sheets
`documents`	Create/edit Google Docs
`drive.readonly`	Browse, search, and read file metadata (including Shared Drives)
`drive.file`	Export and manage files created by this app

What This Server CAN Access

All Slides presentations in your account
All Sheets spreadsheets in your account
All Docs documents in your account
Drive file metadata, browsing, and search (including Shared Drives)
Export Google Workspace files to other formats (PDF, text, CSV, etc.)

What This Server CANNOT Access

Gmail, Calendar, or other Google services
Delete or permanently modify files you don't own
Your Google account password or 2FA settings

Security Best Practices

Never commit .env files to version control
Use a dedicated Google Cloud project for this server
Review access at Google Account Permissions
Regenerate tokens with npm run get-token if compromised

OAuth Setup

1. Enable APIs

In Google Cloud Console:

Create or select a project
Enable: Slides API, Sheets API, Docs API, Drive API

2. Create Credentials

Go to APIs & Services > Credentials
Create OAuth client ID (Desktop app type)
Download client ID and secret

3. Configure Consent Screen

Add these scopes:

https://www.googleapis.com/auth/presentations
https://www.googleapis.com/auth/spreadsheets
https://www.googleapis.com/auth/documents
https://www.googleapis.com/auth/drive.readonly
https://www.googleapis.com/auth/drive.file

4. Generate Refresh Token

# Add client ID and secret to .env first
npm run get-token

The refresh token is generated once and stored. Regenerate only if:

You change OAuth scopes
You revoke access from your Google account
You need to use a different account

Troubleshooting

"Request had insufficient authentication scopes"

Verify all 5 scopes are in your OAuth consent screen
Regenerate token: npm run get-token
Restart the MCP server

"API has not been used in project"

Enable the missing API in Google Cloud Console. The error message includes a direct link.

One service works but another doesn't

The token was generated without all scopes. Add missing scopes to consent screen and regenerate with npm run get-token.

Development

npm install          # Install dependencies
npm run build        # Compile TypeScript
npm run lint         # Run ESLint
npm test             # Run tests
npm run get-token    # Generate OAuth token

Testing with MCP Inspector

export $(cat .env | xargs) && npx @modelcontextprotocol/inspector node build/index.js

License

ISC

Google Workspace