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.