gdocs-mcp

gdocs-mcp

MCP server for Google Docs and Sheets that enables AI assistants to read, create, edit, style, export, and collaborate on documents using local OAuth authentication.

Category
访问服务器

README

gdocs-mcp

Open-source MCP server for Google Docs and Sheets. Give Claude (or any MCP-compatible AI) the ability to read, create, edit, style, export, and collaborate on your Google Docs — with OAuth tokens that never leave your machine.

Open-source. Self-hosted. Your tokens never leave your machine.

Quick Start

1. Set up Google Cloud credentials (one-time)

  1. Go to Google Cloud Console
  2. Create a project (or use an existing one)
  3. Enable the Google Docs API, Google Sheets API, and Google Drive API
  4. Go to Google Auth Platform > Audience, set to External, add yourself as a test user
  5. Go to Credentials > Create Credentials > OAuth client ID > Desktop app
  6. Download the JSON file

2. Authenticate

npx gdocs-mcp auth ~/Downloads/client_secret_*.json

This opens your browser for Google sign-in, saves the token to ~/.gdocs-mcp/, and prints the MCP config.

3. Add to Claude Desktop

Edit ~/Library/Application Support/Claude/claude_desktop_config.json (macOS) or %APPDATA%\Claude\claude_desktop_config.json (Windows):

{
  "mcpServers": {
    "gdocs": {
      "command": "npx",
      "args": ["gdocs-mcp"]
    }
  }
}

Restart Claude Desktop. Ask Claude: "List my recent Google Docs" to verify.

Add to Claude Code

claude mcp add gdocs -- npx gdocs-mcp

Tools (28)

Google Docs — Read & Write

Tool Description
read_document Read the full content of a Google Doc
search_documents Search Google Drive for documents by name, content, or date
create_document Create a new Google Doc with optional Markdown content
replace_all_text Find and replace all occurrences of text in a document
replace_image Replace an existing image with a new image from a URI
update_document_markdown Replace the entire document body with Markdown
update_document_section_markdown Insert or replace a section by index with Markdown
update_document_style Update page size, margins, text direction
update_document Raw batchUpdate with 35+ request types
unmerge_table_cells Unmerge previously merged table cells

Content Insertion

Tool Description
insert_image Insert an image from a URL with optional width/height sizing
insert_table Create a table with specified rows (1-20) and columns (1-20)
insert_page_break Insert a page break at a specific position
insert_link Add a hyperlink to an existing text range

Document Management

Tool Description
export_document Export as PDF, DOCX, TXT, or HTML. Save to file or return base64
copy_document Duplicate a doc with a new title. Great for templates
delete_document Move to trash. Requires exact title confirmation to prevent accidents

Comments

Tool Description
get_comments List comments with author, content, resolved status, and replies
add_comment Add a comment anchored to specific text in the document

Style Presets

Define how your documents look once, apply everywhere.

Tool Description
extract_document_styles Extract styles from a reference Google Doc and save as a reusable preset
apply_style_preset Apply a style preset to any document — fonts, colors, spacing, tables
list_style_presets List all available presets (4 built-in + your custom presets)
set_active_preset Set the default preset for new documents
delete_style_preset Delete a custom preset

Formatting

Tool Description
update_header_footer Create or update header/footer content and styling
format_list Apply bullet, numbered, or remove list formatting (6 glyph presets)

Google Sheets

Tool Description
get_charts List all charts in a spreadsheet with IDs and specs

Automation

Tool Description
execute_script Run a function in a deployed Google Apps Script project

Style Presets

Built-in Presets

Preset Font Headings Body
clean Inter Dark charcoal, 22/16/13pt 11pt, 1.5x spacing
corporate Arial Dark grey, conservative 11pt, 1.4x spacing
classic Georgia + Garamond Dark blue, serif 11pt, 1.4x spacing
minimal Roboto Black, light weight 10.5pt, 1.5x spacing

Extract + Apply Workflow

Point to a Google Doc that already looks the way you want:

You: "Extract styles from my brand doc and save as 'brand'"
  → extract_document_styles(documentId, saveAs: "brand")

You: "Apply brand styles to this report"
  → apply_style_preset(documentId, presetName: "brand")

One-step capture, one-step apply. No JSON editing needed.

Style Properties

Presets support every text and paragraph property the Google Docs API exposes:

Text: font family, font size, bold, italic, underline, strikethrough, small caps, text color, background color, baseline offset

Paragraph: alignment (left/center/right/justified), line spacing, space above/below, first line indent, start/end indent, keep lines together, keep with next, direction (LTR/RTL), paragraph borders

Document: page margins, page size

Tables: header row background and text color, bold headers, border color and width, cell padding, alternating row backgrounds

Only properties you specify are applied. Omitted properties are left unchanged. Config stored at ~/.gdocs-mcp/styles.json.

Upgrading to v0.4

v0.4 expands the Drive scope from drive.readonly to drive (needed for export, copy, delete, and comments). You must re-authenticate:

npx gdocs-mcp auth

If you don't need the new tools and want to keep the old scope:

GDOCS_MCP_READONLY=1 npx gdocs-mcp

Scope Justification

Scope Tools
documents read, create, replace, update, insert image/table/link/page break, style presets, header/footer, format list
spreadsheets.readonly get_charts
drive search, export, copy, delete, get/add comments

Limitations

These are Google Docs API limitations, not gdocs-mcp limitations:

  • Table of Contents styling is not controllable — TOC entries mirror heading styles
  • Custom named styles cannot be created — only the 9 built-in types (Title, Subtitle, Heading 1-6, Normal Text)
  • Conditional formatting does not exist in Google Docs
  • Multi-column layout is not exposed via the API
  • Table header detection assumes row 0 is the header — multi-row headers are not detected
  • Suggested edits (propose mode) are not yet supported
  • Comment replies are not yet supported — only top-level comments
  • Image URLs are passed directly to Google's API — the MCP server does not fetch them

Performance Logging

Every tool call logs latency to stderr:

[gdocs-mcp] read_document: 342ms (api: 298ms)
[gdocs-mcp] apply_style_preset: 1247ms (api: 1102ms, 1593 requests)
[gdocs-mcp] list_style_presets: 2ms (local)

Disable with GDOCS_MCP_QUIET=1.

Security

  • OAuth tokens stored locally at ~/.gdocs-mcp/token.json with 600 permissions
  • Credentials stored at ~/.gdocs-mcp/credentials.json with 600 permissions
  • Style presets stored at ~/.gdocs-mcp/styles.json
  • No telemetry, no data collection, no third-party token storage
  • Tokens refresh automatically; if refresh fails, run npx gdocs-mcp auth again
  • delete_document requires exact title match — not a boolean flag

Configuration

Credentials and tokens stored in ~/.gdocs-mcp/ by default. Override with:

GDOCS_CREDENTIALS=/path/to/credentials.json npx gdocs-mcp

Environment variables:

Variable Effect
GDOCS_CREDENTIALS Override credentials.json path
GDOCS_MCP_READONLY Set to 1 to disable write tools (export, copy, delete, comments)
GDOCS_MCP_QUIET Set to 1 to disable performance logging

For faster startup, install globally:

npm install -g gdocs-mcp

Requirements

  • Node.js 18+
  • A Google Cloud project with Docs, Sheets, and Drive APIs enabled

License

MIT

推荐服务器

Baidu Map

Baidu Map

百度地图核心API现已全面兼容MCP协议,是国内首家兼容MCP协议的地图服务商。

官方
精选
JavaScript
Playwright MCP Server

Playwright MCP Server

一个模型上下文协议服务器,它使大型语言模型能够通过结构化的可访问性快照与网页进行交互,而无需视觉模型或屏幕截图。

官方
精选
TypeScript
Magic Component Platform (MCP)

Magic Component Platform (MCP)

一个由人工智能驱动的工具,可以从自然语言描述生成现代化的用户界面组件,并与流行的集成开发环境(IDE)集成,从而简化用户界面开发流程。

官方
精选
本地
TypeScript
Audiense Insights MCP Server

Audiense Insights MCP Server

通过模型上下文协议启用与 Audiense Insights 账户的交互,从而促进营销洞察和受众数据的提取和分析,包括人口统计信息、行为和影响者互动。

官方
精选
本地
TypeScript
VeyraX

VeyraX

一个单一的 MCP 工具,连接你所有喜爱的工具:Gmail、日历以及其他 40 多个工具。

官方
精选
本地
graphlit-mcp-server

graphlit-mcp-server

模型上下文协议 (MCP) 服务器实现了 MCP 客户端与 Graphlit 服务之间的集成。 除了网络爬取之外,还可以将任何内容(从 Slack 到 Gmail 再到播客订阅源)导入到 Graphlit 项目中,然后从 MCP 客户端检索相关内容。

官方
精选
TypeScript
Kagi MCP Server

Kagi MCP Server

一个 MCP 服务器,集成了 Kagi 搜索功能和 Claude AI,使 Claude 能够在回答需要最新信息的问题时执行实时网络搜索。

官方
精选
Python
e2b-mcp-server

e2b-mcp-server

使用 MCP 通过 e2b 运行代码。

官方
精选
Neon MCP Server

Neon MCP Server

用于与 Neon 管理 API 和数据库交互的 MCP 服务器

官方
精选
Exa MCP Server

Exa MCP Server

模型上下文协议(MCP)服务器允许像 Claude 这样的 AI 助手使用 Exa AI 搜索 API 进行网络搜索。这种设置允许 AI 模型以安全和受控的方式获取实时的网络信息。

官方
精选