Skip to main content
Glama
Sejin-Koo

google-workspace-mcp

by Sejin-Koo

google-workspace-mcp

An MCP server that handles Google Workspace (Sheets / Docs / Slides / Forms) and Google Drive.

The official "Google Drive" connector that is connected to Cowork by default only supports search, read, file creation, and moving to trash — it cannot modify the contents of existing files. So even to add a single row to a sheet, the only option was to recreate the entire data as a new file and discard the existing one. This server fills that gap — it appends rows to sheets while keeping the file ID, edits document bodies, and adds slides.

Provided Tools

Tool

What it does

sheets_values

Read cell values / append (add rows) / update / clear

sheets_manage

Create spreadsheets, add/delete/rename tabs, fetch metadata, batchUpdate

docs_read

Read documents as text (including tables) or as the original structure

docs_write

Create documents, append to the end, insert at a position, find and replace, batchUpdate

slides_read

Fetch text and speaker notes per slide

slides_write

Create presentations, add slides (fill in title/body), delete, find and replace

forms_tool

Create/fetch forms, fetch response lists/individual responses, batchUpdate

drive_search

Search by file name, full-text content search, MIME, and folder conditions

drive_file

Metadata, create, create folders, replace content (keeping ID), rename, move, copy, trash, permanently delete, download, export

drive_comments

View/write comments, reply, resolve, delete

drive_revisions

View version history, retrieve past version content, pin for retention

drive_permissions

Check/add/change/remove sharing permissions

drive_shared_drives

List shared drives and view details

drive_changes

Issue a start token, then fetch only the changes after that point

All tools can have their response length capped via max_chars; 0 means no truncation.

Related MCP server: Google Docs, Drive & Sheets MCP Server

Environment Variables

Name

Description

GOOGLE_CLIENT_ID

OAuth client ID

GOOGLE_CLIENT_SECRET

OAuth client secret

GOOGLE_REFRESH_TOKEN

Refresh token that includes the https://www.googleapis.com/auth/drive scope

MCP_GATE_KEYS

Comma-separated list of allowed access gate keys. If empty, the gate is disabled

MCP_GATE_MODE

If enforce, calls without a key are blocked with 401

A single drive scope covers the Sheets, Docs, Slides, and Forms APIs along with the entire Drive API (the official auth scope list for each API includes auth/drive).

Google Cloud Project Setup

Separate from scopes, the APIs you plan to use must be enabled in the project. If they are not enabled, you will get a 403 has not been used in project ... or it is disabled.

  • Google Sheets API / Google Docs API / Google Slides API / Google Forms API

  • Google Drive API

Invocation

https://<배포도메인>/api/mcp?k=<게이트키>

Local Smoke Test

Put the three Google credentials above into scripts/.env.local.json (gitignored) and:

npm install
npm test

It creates test files in a real Google account and cleans them up by moving them to the trash at the end.

Maintenance

ActivityMaintained
ResponsivenessNo issues

Related MCP Connectors

Related MCP Servers