Connect Claude Desktop, Cursor, or any MCP client to your Google Docs, Google Sheets, and Google Drive.
- Go to the Google Cloud Console
- Create or select a project
- Enable the Google Docs API, Google Sheets API, and Google Drive API
- Configure the OAuth consent screen (External, add your email as a test user)
- Create an OAuth client ID (Desktop app type)
- Copy the Client ID and Client Secret from the confirmation screen
Need more detail? See step-by-step instructions at the bottom of this page.
GOOGLE_CLIENT_ID="your-client-id" \
GOOGLE_CLIENT_SECRET="your-client-secret" \
npx -y @a-bonus/google-docs-mcp authThis opens your browser for Google authorization. After you approve, the refresh token is saved to ~/.config/google-docs-mcp/token.json.
Claude Desktop / Cursor / Windsurf:
{
"mcpServers": {
"google-docs": {
"command": "npx",
"args": ["-y", "@a-bonus/google-docs-mcp"],
"env": {
"GOOGLE_CLIENT_ID": "your-client-id",
"GOOGLE_CLIENT_SECRET": "your-client-secret"
}
}
}
}The server starts automatically when your MCP client needs it.
Deploy once for your team -- no local installs required. The server uses MCP OAuth 2.1 so your MCP client handles authentication automatically.
gcloud run deploy google-docs-mcp \
--source . \
--region europe-west3 \
--port 8080 \
--allow-unauthenticated \
--set-env-vars "^|^MCP_TRANSPORT=httpStream|BASE_URL=https://your-service.run.app|GOOGLE_CLIENT_ID=...|GOOGLE_CLIENT_SECRET=...|TOKEN_STORE=firestore|JWT_SIGNING_KEY=your-secret-key"Then each user just adds the URL to their MCP client -- no npx, no tokens, no local setup:
{
"mcpServers": {
"google-docs": {
"type": "streamableHttp",
"url": "https://your-service.run.app/mcp"
}
}
}Your MCP client will prompt for Google sign-in on first connection. See Remote Deployment for details.
Tools across Google Docs, Sheets, and Drive:
| Tool | Description |
|---|---|
readDocument |
Read content as plain text, JSON, or markdown |
appendText |
Append text to a document |
insertText |
Insert text at a specific position |
deleteRange |
Remove content by index range |
modifyText |
Replace, prepend, or transform text in a document |
findAndReplace |
Find and replace text across a document |
listTabs |
List all tabs in a multi-tab document |
addTab |
Add a new tab to a document |
renameTab |
Rename a document tab |
replaceDocumentWithMarkdown |
Replace entire document content from markdown |
replaceRangeWithMarkdown |
Replace a specific range with markdown content |
appendMarkdown |
Append markdown-formatted content |
applyTextStyle |
Bold, italic, colors, font size, links |
applyParagraphStyle |
Alignment, spacing, indentation |
insertTable |
Create an empty table |
insertTableWithData |
Create a table pre-filled with data |
insertPageBreak |
Insert page breaks |
insertImage |
Insert images from URLs or local files |
| Tool | Description |
|---|---|
listComments |
View all comments with author and date |
getComment |
Get a specific comment with replies |
addComment |
Create a comment anchored to text |
replyToComment |
Reply to an existing comment |
resolveComment |
Mark a comment as resolved |
deleteComment |
Remove a comment |
| Tool | Description |
|---|---|
readSpreadsheet |
Read data from a range (A1 notation) |
writeSpreadsheet |
Write data to a range |
batchWrite |
Write to multiple ranges in one call |
appendRows |
Add rows to a sheet |
clearRange |
Clear cell values |
createSpreadsheet |
Create a new spreadsheet |
addSheet |
Add a sheet/tab |
deleteSheet |
Remove a sheet/tab |
duplicateSheet |
Copy a sheet within or across spreadsheets |
renameSheet |
Rename a sheet/tab |
getSpreadsheetInfo |
Get metadata and sheet list |
listSpreadsheets |
Find spreadsheets |
formatCells |
Bold, colors, alignment on cell ranges |
copyFormatting |
Copy formatting from one range to another |
readCellFormat |
Read formatting details of a cell range |
freezeRowsAndColumns |
Pin header rows/columns |
setDropdownValidation |
Add/remove dropdown lists on cells |
setColumnWidths |
Set column widths in pixels |
autoResizeColumns |
Auto-fit column widths to content |
addConditionalFormatting |
Add conditional formatting rules |
groupRows |
Group rows for collapsible sections |
ungroupAllRows |
Remove all row groupings |
insertChart |
Create a chart from data |
deleteChart |
Remove a chart |
| Tool | Description |
|---|---|
createTable |
Create a new named table with column types |
listTables |
List all tables in a spreadsheet or sheet |
getTable |
Get detailed table metadata by name or ID |
deleteTable |
Delete a table (optionally clear data) |
updateTableRange |
Modify table dimensions (add/remove rows/cols) |
appendTableRows |
Append rows to a table (table-aware insertion) |
| Tool | Description |
|---|---|
listDocuments |
List documents, optionally filtered by date |
searchDocuments |
Search by name or content |
getDocumentInfo |
Get document metadata |
createDocument |
Create a new document |
createDocumentFromTemplate |
Create from an existing template |
createFolder |
Create a folder |
listFolderContents |
List folder contents |
getFolderInfo |
Get folder metadata |
moveFile |
Move a file to another folder |
copyFile |
Duplicate a file |
renameFile |
Rename a file |
deleteFile |
Move to trash or permanently delete |
listDriveFiles |
List any file type in Drive with filters |
searchDriveFiles |
Search all Drive files by name or content |
downloadFile |
Download a file's content |
"Read document ABC123 as markdown"
"Append 'Meeting notes for today' to document ABC123"
"Make the text 'Important' bold and red in document ABC123"
"Replace the entire document with this markdown: # Title\n\nNew content here"
"Insert a 3x4 table at index 50 in document ABC123"
"Read range A1:D10 from spreadsheet XYZ789"
"Write [[Name, Score], [Alice, 95], [Bob, 87]] to range A1 in spreadsheet XYZ789"
"Create a new spreadsheet titled 'Q1 Report'"
"Format row 1 as bold with a light blue background in spreadsheet XYZ789"
"Freeze the first row in spreadsheet XYZ789"
"Add a dropdown with options [Open, In Progress, Done] to range C2:C100"
"Create a table named 'Tasks' in range A1:D10 with columns: Task (TEXT), Status (DROPDOWN: 'Not Started','In Progress','Done'), Priority (NUMBER)"
"List my 10 most recent Google Docs"
"Search for documents containing 'project proposal'"
"Create a folder called 'Meeting Notes' and move document ABC123 into it"
The server supports a full round-trip markdown workflow:
- Read a document as markdown:
readDocumentwithformat='markdown' - Edit the markdown locally
- Push changes back:
replaceDocumentWithMarkdown
Supported: headings, bold, italic, strikethrough, links, bullet/numbered lists, horizontal rules.
Deploy the server centrally on Google Cloud Run (or any container host) so your team can use it without local installs. The server uses MCP OAuth 2.1 with FastMCP's built-in GoogleProvider -- MCP clients handle the auth flow automatically.
Visit the server root URL (/) for setup instructions and a ready-to-copy client config.
| Variable | Description |
|---|---|
MCP_TRANSPORT |
Set to httpStream to enable remote mode (default: stdio) |
BASE_URL |
Public URL of the deployed server (required for OAuth redirects) |
GOOGLE_CLIENT_ID |
OAuth client ID (Web application type) |
GOOGLE_CLIENT_SECRET |
OAuth client secret |
ALLOWED_DOMAINS |
Comma-separated list of allowed Google Workspace domains (optional) |
PORT |
HTTP port (default: 8080) |
TOKEN_STORE |
Set to firestore for persistent token storage (default: in-memory) |
JWT_SIGNING_KEY |
Fixed signing key so tokens survive restarts (auto-generated if not set) |
REFRESH_TOKEN_TTL |
Refresh token lifetime in seconds (default: 2592000 / 30 days) |
GCLOUD_PROJECT |
GCP project ID for Firestore (required when TOKEN_STORE=firestore) |
- Create a GCP project and enable Docs, Sheets, and Drive APIs
- Create an OAuth client (Web application type, not Desktop)
- Set the authorized redirect URI to
{BASE_URL}/oauth/callback - Deploy to Cloud Run:
gcloud run deploy google-docs-mcp \
--source . \
--region europe-west3 \
--port 8080 \
--allow-unauthenticated \
--set-env-vars "^|^MCP_TRANSPORT=httpStream|BASE_URL=https://your-service.run.app|ALLOWED_DOMAINS=yourdomain.com|GOOGLE_CLIENT_ID=...|GOOGLE_CLIENT_SECRET=...|TOKEN_STORE=firestore|JWT_SIGNING_KEY=your-secret-key"Note: The
^|^prefix changes the env var delimiter from,to|becauseALLOWED_DOMAINScontains commas.
- By default, OAuth sessions are stored in memory and lost on restart
- For production, set
TOKEN_STORE=firestoreandJWT_SIGNING_KEYfor persistent auth across deploys and cold starts ALLOWED_DOMAINSrestricts access to specific Google Workspace domains- Access tokens refresh automatically; inactive sessions expire after 30 days
- Users can revoke access at any time via Google Account permissions
Merging changes to main does not automatically update your Cloud Run service. Each deployment is independent — you need to redeploy manually when you want new features or fixes.
To update:
-
Pull the latest code:
git pull origin main
-
Redeploy to Cloud Run:
gcloud run deploy your-service-name --source . --region your-regionYour existing environment variables are preserved — no need to pass
--set-env-varsagain.
When to redeploy:
- Bug fixes and security patches — redeploy as soon as possible
- New features — redeploy at your convenience
- Breaking changes — check the release notes before redeploying
You can check your current version against the latest release on the releases page.
Pass your Google Cloud OAuth client credentials as environment variables:
| Variable | Description |
|---|---|
GOOGLE_CLIENT_ID |
OAuth client ID from Google Cloud Console |
GOOGLE_CLIENT_SECRET |
OAuth client secret from Google Cloud Console |
For Google Workspace with domain-wide delegation:
| Variable | Description |
|---|---|
SERVICE_ACCOUNT_PATH |
Path to the service account JSON key file |
GOOGLE_IMPERSONATE_USER |
Email of the user to impersonate (optional) |
{
"mcpServers": {
"google-docs": {
"command": "npx",
"args": ["-y", "@a-bonus/google-docs-mcp"],
"env": {
"SERVICE_ACCOUNT_PATH": "/path/to/service-account-key.json",
"GOOGLE_IMPERSONATE_USER": "user@yourdomain.com"
}
}
}
}OAuth refresh tokens are stored in ~/.config/google-docs-mcp/token.json (respects XDG_CONFIG_HOME). To re-authorize, run the auth command again or delete the token file.
Set GOOGLE_MCP_PROFILE to store tokens in a profile-specific subdirectory. This allows using different Google accounts for different projects:
| Variable | Description |
|---|---|
GOOGLE_MCP_PROFILE |
Profile name for isolated token storage (optional) |
{
"mcpServers": {
"google-docs": {
"command": "npx",
"args": ["-y", "@a-bonus/google-docs-mcp"],
"env": {
"GOOGLE_CLIENT_ID": "...",
"GOOGLE_CLIENT_SECRET": "...",
"GOOGLE_MCP_PROFILE": "work"
}
}
}
}Tokens are stored per profile:
~/.config/google-docs-mcp/
├── token.json # default (no profile)
├── work/token.json # GOOGLE_MCP_PROFILE=work
├── personal/token.json # GOOGLE_MCP_PROFILE=personal
Without GOOGLE_MCP_PROFILE, behavior is unchanged.
- Comment anchoring: Programmatically created comments appear in the comment list but aren't visibly anchored to text in the Google Docs UI. This is a Google Drive API limitation.
- Comment resolution: Resolved status may not persist in the Google Docs UI.
- Converted documents: Docs converted from Word may not support all API operations.
- Markdown tables/images: Not yet supported in the markdown-to-Docs conversion.
- Deeply nested lists: Lists with 3+ nesting levels may have formatting quirks.
- Server won't start:
- Verify
GOOGLE_CLIENT_IDandGOOGLE_CLIENT_SECRETare set in theenvblock of your MCP config. - Try running manually:
npx @a-bonus/google-docs-mcpand check stderr for errors.
- Verify
- Authorization errors:
- Ensure Docs, Sheets, and Drive APIs are enabled in Google Cloud Console.
- Confirm your email is listed as a Test User on the OAuth consent screen.
- Re-authorize:
npx @a-bonus/google-docs-mcp auth - Delete
~/.config/google-docs-mcp/token.jsonand re-authorize if upgrading.
- Tab errors:
- Use
listTabsto see available tab IDs. - Omit
tabIdfor single-tab documents.
- Use
- High CPU with multiple MCP sessions: Some clients call
tools/listvery often. FastMCP otherwise recomputes JSON Schema for every tool on every request, which can pin a CPU core per process. This server precomputes the payload once before stdio starts and replaces thetools/listhandler with a cached snapshot. If you still see sustained load, capture a few seconds withsample <pid> 1 10(macOS) ornode --cpu-profand report it.
Step-by-step Google Cloud Console instructions
For remote deployment, create an OAuth client of type Web application (not Desktop app). Use Desktop app only for local stdio usage.
- Go to Google Cloud Console: Open console.cloud.google.com
- Create or Select a Project: Click the project dropdown > "NEW PROJECT". Name it (e.g., "MCP Docs Server") and click "CREATE".
- Enable APIs:
- Navigate to "APIs & Services" > "Library"
- Search for and enable: Google Docs API, Google Sheets API, Google Drive API
- Configure OAuth Consent Screen:
- Go to "APIs & Services" > "OAuth consent screen"
- Choose "External" and click "CREATE"
- Fill in: App name, User support email, Developer contact email
- Click "SAVE AND CONTINUE"
- Add scopes:
documents,spreadsheets,drive - Click "SAVE AND CONTINUE"
- Add your Google email as a Test User
- Click "SAVE AND CONTINUE"
- Create Credentials:
- Go to "APIs & Services" > "Credentials"
- Click "+ CREATE CREDENTIALS" > "OAuth client ID"
- Application type: "Desktop app"
- Click "CREATE"
- Copy the Client ID and Client Secret
Contributions are welcome! See CONTRIBUTING.md for development setup, architecture overview, and guidelines.
MIT -- see LICENSE for details.
