gogcli-mcp-sheets

gogcli-mcp-sheets

[!WARNING] AI-developed project. This codebase was built and is actively maintained by Claude Code. Review all code and tool permissions before use.

Extended Google Sheets MCP server via gogcli. Includes auth tools plus 22 additional dedicated Sheets tools for tab management, formatting, named ranges, and more.

Requirements

• gogcli installed and authenticated
• Node.js 18+

brew install gogcli
gog auth add [e-mail] --services sheets

Installation

npm install -g gogcli-mcp-sheets

Claude Desktop

Add to ~/Library/Application Support/Claude/claude_desktop_config.json:

{
  "mcpServers": {
    "gogcli-sheets": {
      "command": "gogcli-mcp-sheets",
      "env": {
        "GOG_ACCOUNT": "[e-mail]"
      }
    }
  }
}

Claude Code

claude mcp add gogcli-sheets -- gogcli-mcp-sheets

Extra Sheets Tools (22)

Plus 5 auth tools and 8 base Sheets tools (get, update, append, clear, metadata, create, find-replace, run).

Tool	Description
gog_sheets_add_tab	Add a new sheet tab
gog_sheets_delete_tab	Delete a sheet tab
gog_sheets_rename_tab	Rename a sheet tab
gog_sheets_copy	Copy a sheet to another spreadsheet
gog_sheets_export	Export as CSV, TSV, XLSX, PDF, ODS, or HTML
gog_sheets_freeze	Freeze rows and/or columns
gog_sheets_insert	Insert rows or columns
gog_sheets_merge	Merge cells
gog_sheets_unmerge	Unmerge cells
gog_sheets_format	Apply cell formatting (bold, color, etc.)
gog_sheets_number_format	Set number format (currency, percent, date, etc.)
gog_sheets_read_format	Read cell formatting
gog_sheets_resize_columns	Resize column widths or auto-fit
gog_sheets_resize_rows	Resize row heights or auto-fit
gog_sheets_named_ranges_list	List named ranges
gog_sheets_named_ranges_get	Get a named range by name or ID
gog_sheets_named_ranges_add	Create a named range
gog_sheets_named_ranges_update	Update a named range
gog_sheets_named_ranges_delete	Delete a named range
gog_sheets_notes	Read cell notes
gog_sheets_update_note	Add or update cell notes
gog_sheets_links	List hyperlinks in a range
gog_sheets_set_links	Set =HYPERLINK() cells in one call (batch)
gog_sheets_snapshot	Back up a whole spreadsheet before a risky edit

License

MIT