Tmp.MII9JI7trn

Use when the user asks to read, write, format, or manage Google Sheets. Triggers for requests involving spreadsheet data, cell formatting, tab management, named ranges, merging cells, freezing rows/columns, exporting spreadsheets, or any Sheets operation. Includes auth and Sheets tools only.

gogcli-mcp-sheets

Extended Google Sheets MCP server via gogcli — 35 tools: auth + 8 base Sheets + 22 extra dedicated Sheets tools.

• Source: github.com/chrischall/gogcli-mcp

Requirements

• gogcli installed and authenticated
• Node.js 18 or later

Setup

json

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

Extra Sheets Tools

Tool	What it does
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
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
gog_sheets_number_format	Set number format
gog_sheets_read_format	Read cell formatting
gog_sheets_resize_columns	Resize column widths
gog_sheets_resize_rows	Resize row heights
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
gog_sheets_named_ranges_list	List named ranges
gog_sheets_named_ranges_get	Get a named range
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

Plus 5 auth tools and 8 base Sheets tools.