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": "you@gmail.com"
      }
    }
  }
}

Extra Sheets Tools#

ToolWhat it doesgog_sheets_add_tabAdd a new sheet tabgog_sheets_delete_tabDelete a sheet tabgog_sheets_rename_tabRename a sheet tabgog_sheets_copyCopy a sheet to another spreadsheetgog_sheets_exportExport as CSV, TSV, XLSX, PDFgog_sheets_freezeFreeze rows and/or columnsgog_sheets_insertInsert rows or columnsgog_sheets_mergeMerge cellsgog_sheets_unmergeUnmerge cellsgog_sheets_formatApply cell formattinggog_sheets_number_formatSet number formatgog_sheets_read_formatRead cell formattinggog_sheets_resize_columnsResize column widthsgog_sheets_resize_rowsResize row heightsgog_sheets_notesRead cell notesgog_sheets_update_noteAdd or update cell notesgog_sheets_linksList hyperlinks in a rangegog_sheets_set_linksSet =HYPERLINK() cells in one call (batch)gog_sheets_snapshotBack up a whole spreadsheet before a risky editgog_sheets_named_ranges_listList named rangesgog_sheets_named_ranges_getGet a named rangegog_sheets_named_ranges_addCreate a named rangegog_sheets_named_ranges_updateUpdate a named rangegog_sheets_named_ranges_deleteDelete a named range

Plus 5 auth tools and 8 base Sheets tools.