google-workspace-mcp
Provides tools to read document content and structure, create documents, append text, insert text at specific positions, and perform find-and-replace operations.
Provides tools to search files by name and content, manage file metadata, create and replace file content, move and copy files, manage comments, revisions, permissions, and shared drives.
Provides tools to create forms, manage form settings, and read and retrieve form responses.
Provides tools to read, append, update, and clear cell values, manage spreadsheet tabs, and retrieve spreadsheet metadata.
Provides tools to read slide content and speaker notes, create presentations, add slides with titles and body text, delete slides, and perform find-and-replace.
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@google-workspace-mcpadd a row with today's expenses to my sheet named 'Trip Planning'"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
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 |
| Read cell values / append (add rows) / update / clear |
| Create spreadsheets, add/delete/rename tabs, fetch metadata, batchUpdate |
| Read documents as text (including tables) or as the original structure |
| Create documents, append to the end, insert at a position, find and replace, batchUpdate |
| Fetch text and speaker notes per slide |
| Create presentations, add slides (fill in title/body), delete, find and replace |
| Create/fetch forms, fetch response lists/individual responses, batchUpdate |
| Search by file name, full-text content search, MIME, and folder conditions |
| Metadata, create, create folders, replace content (keeping ID), rename, move, copy, trash, permanently delete, download, export |
| View/write comments, reply, resolve, delete |
| View version history, retrieve past version content, pin for retention |
| Check/add/change/remove sharing permissions |
| List shared drives and view details |
| 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 |
| OAuth client ID |
| OAuth client secret |
| Refresh token that includes the |
| Comma-separated list of allowed access gate keys. If empty, the gate is disabled |
| If |
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 testIt creates test files in a real Google account and cleans them up by moving them to the trash at the end.
This server cannot be deployed
Maintenance
Related MCP Connectors
Permissioned access to Gmail, Drive and Calendar via the user's own Google account
Multiple Gmail accounts, editable Google Sheets & Docs for AI agents. Deny-by-default access rules.
Your workspace as agent tools — docs, canvases, slides, sheets, projects, tickets, and a shell.
SEO & marketing toolkit for AI agents: GA4, Search Console, AdSense, GTM, PageSpeed, Trends.
Related MCP Servers
- AlicenseNot gradedqualityDmaintenanceEnables comprehensive interaction with Google Docs and Google Drive through AI assistants, supporting document reading/writing, rich formatting, table/image insertion, comment management, and complete file/folder operations with secure OAuth authentication.9MIT
- AlicenseNot gradedqualityDmaintenanceEnables deep integration with Google Workspace for AI assistants, allowing for document creation, spreadsheet manipulation, and file management. It supports advanced features like template processing, comment thread management, and cell formatting.47MIT
- FlicenseNot gradedqualityDmaintenanceProvides AI assistants with access to Google Workspace APIs including Sheets, Calendar, Gmail, Tasks, Drive, and Docs. Enables full CRUD operations and management of Google services through natural language.1-
- AlicenseNot gradedqualityDmaintenanceEnables AI assistants to create, read, and modify Google Slides, Sheets, Docs, and Drive documents programmatically. Supports file management, content editing, and version history retrieval.1,1201MIT