google-mcp

MCP server for Google Drive, Docs, and Sheets — built for Claude Code.

Gives Claude Code direct read/write access to Google Sheets (cell-level edits, formatting, structure), Google Docs (insert, replace, append), and Drive (search).

Setup

Prerequisites

• Node.js 18+ (brew install node on macOS)
• A Google Cloud project with the Drive, Docs, and Sheets APIs enabled
• An OAuth 2.0 Client ID (Desktop app type) — download as credentials.json

Install

git clone git@github.com:ztgluis/google-mcp.git ~/dev/google-mcp
cd ~/dev/google-mcp
npm install

Authenticate

Place your credentials.json in the project root, then:

npm run auth

This opens your browser for Google sign-in and saves token.json locally (never committed).

Register with Claude Code

From your Claude Code project directory:

claude mcp add google -s project -- node "$HOME/dev/google-mcp/index.js"

Restart Claude Code to load the server.

Tools (29)

Drive

• search_drive — search files by name or content

Docs

• read_doc — read a Google Doc as plain text
• edit_doc — insert, delete, replace, or append text in a Google Doc

Sheets — Data

• read_sheet — read a range
• batch_read_sheet — read multiple ranges in one call
• append_sheet_row — append a row after the last data row (supports dataRange for complex layouts)
• update_sheet_cell — update a single cell or range
• batch_update_sheet — write to multiple ranges in one call
• clear_sheet — clear values in a range
• insert_rows — insert rows at a position, optionally with data
• delete_rows — delete rows
• delete_columns — delete columns
• find_replace — find and replace text
• sort_range — sort a range by one or more columns
• export_sheet — export to CSV, TSV, XLSX, PDF, or HTML

Sheets — Formatting

• format_cells — colors, fonts, alignment, number formats, wrap strategy
• merge_cells — merge a range
• unmerge_cells — unmerge a range
• add_conditional_formatting — boolean or gradient rules
• freeze — freeze rows/columns (with merged-cell conflict detection)
• auto_resize — auto-fit columns or rows to content

Sheets — Structure

• get_sheet_metadata — title, URL, sheet names, IDs, dimensions, frozen rows/cols
• create_spreadsheet — create a new spreadsheet
• insert_sheet — add a tab
• delete_sheet — remove a tab
• rename_sheet — rename a tab
• duplicate_sheet — duplicate a tab within the same spreadsheet
• copy_sheet_to — copy a tab to a different spreadsheet
• update_sheet_properties — change tab title, color, grid size, frozen rows/cols

Security

credentials.json and token.json are gitignored and must never be committed. Each machine generates its own token.json via npm run auth.