S Sheets MCP
GitHub →

Open-source MCP server

Connect Claude to your Google Sheets in 60 seconds.

One-click OAuth, no local install. Lets any MCP-compatible host read, write, and format your spreadsheets — autofit columns, freeze headers, color rows, share with teammates, all from a conversation.

Connect with Google How it works

We never store your sheet data. Only an OAuth refresh token, encrypted at rest, so the connector can act on your behalf.

How it works

  1. 1

    Click "Connect with Google"

    Standard Google consent screen. You grant access to Sheets + Drive. We capture an offline refresh token, encrypt it with AES-256-GCM, and mint a personal MCP bearer token for you.

  2. 2

    Paste the install command

    One claude mcp add command, pre-filled with your token, ready to copy. Works in Claude Code, Claude Desktop, Cursor, Continue.dev — anything that speaks MCP.

  3. 3

    Talk to your Sheets

    Just ask. Examples:

    • "Find my expense tracker and add a row for today: groceries, 42.50."
    • "Beautify the Q3 roadmap tab — autofit columns, freeze the header, wrap text."
    • "Share the team OKRs sheet with [email protected] as a commenter."

13 tools, ready to call

list_sheets

Search Drive by name.

get_sheet_metadata

Tabs + grid sizes.

read_range

Read an A1 range.

write_range

Overwrite cells.

append_rows

Insert at bottom.

beautify

Header + freeze + autofit in one call.

format_header_row

Bold + gray + freeze row 1.

autofit_columns

Fit columns to content.

freeze_rows

Freeze top N.

wrap_text

Wrap on a range.

set_background_color

RGB tint a range.

add_sheet_tab

New tab.

create_spreadsheet

New empty spreadsheet.

share_with_email

Reader / commenter / writer.

Security model