Prototype · Preview: every server in the official registry, synced every 30 minutes. Reviews and accounts come in a later step.
PopNx MCPMCP servers for people who use AI · explained in plain words

Gogcli MCP Sheets

by chrischallversion 4.10.0i★ –iRuns on your computer
Registry nameio.github.chrischall/gogcli-mcp-sheets

Install

Overview

Description from the maker (original English)

Extended Google Sheets for Claude via gogcli — auth + full Sheets support

PopNx MCP’s three pillars

These three are never merged into one score: opinions, measurements and popularity are different things.

What you can do with it

We have not written a plain-language summary for this one yet. Below are the facts we read from the registry.

  • Connection: Runs on your computer
  • Transport: stdio
  • Category: Docs, sheets & office work

Install

Pick the AI app you use, then copy the settings.

Before you install

  • Basic checks: 1 of 1 passed
  • Runs on your computer with your user’s permissions (files, network, apps).
  • You fill in yourself: GOG_ACCOUNT, GOG_PATH, DISPLAY_TZ, GOG_READONLY, GOG_TIMEZONE

You need

  • npmNode.js installed (for the npx command)

Which app do you use?

Pick your app above. We remember it, so next time the button says “Install in …”.

Open Claude Desktop → Settings → Developer → Edit Config, and paste this into claude_desktop_config.json

{
  "mcpServers": {
    "gogcli-sheets": {
      "command": "npx",
      "args": [
        "-y",
        "gogcli-mcp-sheets"
      ],
      "env": {
        "GOG_ACCOUNT": "your-value",
        "GOG_PATH": "your-value",
        "DISPLAY_TZ": "your-value",
        "GOG_READONLY": "your-value",
        "GOG_TIMEZONE": "your-value"
      }
    }
  }
}

Run this in your terminal

claude mcp add gogcli-sheets --env GOG_ACCOUNT=your-value --env GOG_PATH=your-value --env DISPLAY_TZ=your-value --env GOG_READONLY=your-value --env GOG_TIMEZONE=your-value -- npx -y gogcli-mcp-sheets

Fill in the empty values before running it.

Open in Cursor

Or copy the settings yourself

Paste into .cursor/mcp.json in your project, or ~/.cursor/mcp.json

{
  "mcpServers": {
    "gogcli-sheets": {
      "command": "npx",
      "args": [
        "-y",
        "gogcli-mcp-sheets"
      ],
      "env": {
        "GOG_ACCOUNT": "your-value",
        "GOG_PATH": "your-value",
        "DISPLAY_TZ": "your-value",
        "GOG_READONLY": "your-value",
        "GOG_TIMEZONE": "your-value"
      }
    }
  }
}

Your browser asks to open the app, then the app shows the settings and asks you to confirm. Key values are left empty for you to fill in.

Open in VS Code

Or copy the settings yourself

Paste into .vscode/mcp.json in your project

{
  "servers": {
    "gogcli-sheets": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "gogcli-mcp-sheets"
      ],
      "env": {
        "GOG_ACCOUNT": "your-value",
        "GOG_PATH": "your-value",
        "DISPLAY_TZ": "your-value",
        "GOG_READONLY": "your-value",
        "GOG_TIMEZONE": "your-value"
      }
    }
  }
}

Your browser asks to open the app, then the app shows the settings and asks you to confirm. Key values are left empty for you to fill in.

This one runs on your computer, and ChatGPT can only connect to servers on the internet. Pick another app.

Your choice stays on this device in a cookie; no account needed.

Values you fill in

  • GOG_ACCOUNT env
    Email address of the Google account to use (matches gogcli auth)
  • GOG_PATH env
    Override path to the gogcli binary (auto-discovered otherwise)
  • DISPLAY_TZ env
    zone for *Display fields and for interpreting naive gog values; defaults to America/New_York
  • GOG_READONLY env
    block all mutating gog API requests (injects gog's --readonly); set to 0/false/no/off (or unset) to allow writes
  • GOG_TIMEZONE env
    zone gog formats naive dates in; unset, runner.ts hands gog DISPLAY_TZ so the two cannot diverge

These settings are generated from the maker’s registry entry. If the README says otherwise, follow the README.

What it can do

Runs on your computer; the tool list appears in your AI app after you install it.

Basic checksi

We check information anyone can see; we have not read the code. Checks that do not apply are left out of the count. · Checked Nov 7, 2026

  • ✓ Pass

    Maker matches the repo

    The registry name was verified with the GitHub account chrischall, which owns the repo

  • … Not checked yet

    Still maintained

    We have not read this repo from GitHub yet

  • … Not checked yet

    Has a licence

    We have not read this repo from GitHub yet

  • – Not applicable

    Endpoint responds

    This one runs on your computer; there is no internet endpoint

  • – Not applicable

    Sign-in with OAuth

    Runs on your computer and uses local settings instead

  • … Not checked yet

    No hidden instructions in tool descriptions

    Runs on your computer; we can only read tool lists from internet endpoints

Compared with others in Docs, sheets & office worki

  • More stars than 0% of the other 2194 servers in this category
  • Published to the registry more recently than 96% of the other 2194 servers in this category
  • Basic checks equal to or better than 100% of the other 2194 servers in this category

Compared with every active server in this category in the registry. Stars count only when the publisher owns the repo.

Common questions

Is Gogcli MCP Sheets safe?

It passed 1 of 1 applicable basic checks. We have not read the code. Before adding a key or token, see what access the server asks for and use a key with only the permissions you need.

What keys or codes does it need?

The registry does not list a required key, though some servers ask you to sign in on first use.

Does it run on my computer or in the cloud?

It runs on your computer. Your AI app starts it when needed, and data does not pass through the maker’s servers (unless it calls an online service itself).

Is it still maintained?

The GitHub repo last changed –, and the latest version (4.10.0) reached the registry today.

Which apps can use it?

Apps that support MCP, such as Claude Desktop, Claude Code, Cursor and VS Code. You also need Node.js on your computer.

What can I use instead?

In the same category: Agent-Native Calendar, Excel MCP Server, MCP Server for Excel

Alternatives

Servers in the same category from other makers, sorted by stars.

Reading a card:★ GitHub starsiThree pillars: reviews · checks · usageiUpdated = latest version published to the registryi

Agent-Native Google Calendar - manage events, sync, and public booking

Runs in the cloud★ 7,620MITUpdated 2 months ago
Install

Excel MCP Server

by haris-musa

Lets AI create and edit Excel files itself, including formulas, charts and PivotTables, without Excel installed.

Runs on your computer★ 4,276MITUpdated 6 days ago
Install

Excel automation for AI - Sheets, Power Query, DAX, VBA, Tables, Ranges and more. Windows only.

Runs on your computer★ 847MITUpdated 4 days ago
Install

README from the maker

Open the README

Copied from the maker’s repo as written. PopNx MCP has not reviewed or endorsed it. HTML, images and scripts are removed. Links lead off this site.

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 55 additional dedicated Sheets tools for tab management, formatting, named ranges, Connected Sheets, and more.

Requirements

  • gogcli installed and authenticated
  • Node.js 22+
brew install gogcli

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

Claude Code
claude mcp add gogcli-sheets -- gogcli-mcp-sheets

Extra Sheets Tools (59)

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

ToolDescription
gog_sheets_add_tabAdd a new sheet tab
gog_sheets_delete_tabDelete a sheet tab
gog_sheets_rename_tabRename a sheet tab
gog_sheets_copyCopy a sheet to another spreadsheet
gog_sheets_exportExport as CSV, TSV, XLSX, PDF, ODS, or HTML
gog_sheets_freezeFreeze rows and/or columns
gog_sheets_insertInsert rows or columns
gog_sheets_mergeMerge cells
gog_sheets_unmergeUnmerge cells
gog_sheets_formatApply cell formatting (bold, color, etc.)
gog_sheets_number_formatSet number format (currency, percent, date, etc.)
gog_sheets_read_formatRead cell formatting
gog_sheets_resize_columnsResize column widths or auto-fit
gog_sheets_resize_rowsResize row heights or auto-fit
gog_sheets_named_ranges_listList named ranges
gog_sheets_named_ranges_getGet a named range by name or ID
gog_sheets_named_ranges_addCreate a named range
gog_sheets_named_ranges_updateUpdate a named range
gog_sheets_named_ranges_deleteDelete a named range
gog_sheets_notesRead cell notes
gog_sheets_update_noteAdd or update cell notes
gog_sheets_linksList hyperlinks in a range
gog_sheets_links_setSet =HYPERLINK() cells in one call (batch)
gog_sheets_snapshotBack up a whole spreadsheet before a risky edit
gog_sheets_datasource_listList Connected Sheets data sources (BigQuery / Looker) with sheet + execution status
gog_sheets_datasource_describeFull data-source spec, including its query, status and refresh schedules
gog_sheets_datasource_table_listList anchored data-source tables (extracts) and their A1 anchors
gog_sheets_datasource_table_describeDescribe the extract anchored at an A1 cell
gog_sheets_datasource_table_readRead a bounded number of rows out of an extract
gog_sheets_datasource_addAdd a BigQuery Connected Sheets data source (custom SQL or a native table)
gog_sheets_datasource_updateRepoint a data source's SQL, table or billing project
gog_sheets_datasource_refreshRe-run a data source so its sheet and extracts pick up current data
gog_sheets_datasource_deleteDelete a data source, its linked sheet, and unlink dependent objects
gog_sheets_list_tabsList tabs in a spreadsheet (sheetId, title, index, gridProperties)
gog_sheets_copy_pasteCopy a range's values/formulas/format to another range (tiles to fill down/across).
gog_sheets_validation_getRead data-validation rules (dropdowns, checkboxes, conditions) on a range.
gog_sheets_validation_setSet a data-validation rule on a range: dropdowns, checkboxes, number/date conditions, or custom formulas.
gog_sheets_validation_clearRemove all data-validation rules from a range.
gog_sheets_delete_dimensionDelete a row or column span, table-aware: intersecting tables are shrunk and their remaining data preserved.
gog_sheets_batch_updateUpdate values in multiple ranges atomically with one Sheets API request.
gog_sheets_reorder_tabMove a tab to a specific 0-based position.
gog_sheets_chart_listList embedded charts in a spreadsheet.
gog_sheets_chart_getGet a chart's full definition (spec + position) by chart ID.
gog_sheets_chart_createCreate an embedded chart from a JSON ChartSpec.
gog_sheets_chart_updateReplace a chart's spec by chart ID.
gog_sheets_chart_deleteDelete a chart by chart ID.
gog_sheets_table_listList Google Sheets tables in a spreadsheet.
gog_sheets_table_getGet a Google Sheets table by table ID.
gog_sheets_table_createCreate a Google Sheets table over a range with typed columns.
gog_sheets_table_appendAppend data rows to a table.
gog_sheets_table_clearClear all data rows from a table.
gog_sheets_table_deleteDelete a Google Sheets table. By default preserves the table's cell values and formulas (emulates "Convert to range"); set keep_data=false to also wipe the data.
gog_sheets_banding_listList alternating-color banded ranges.
gog_sheets_banding_setApply alternating colors to a range.
gog_sheets_banding_clearRemove alternating-color banding by ID or for a whole sheet.
gog_sheets_filter_setSet a basic filter on a range; replacing an existing filter requires replace=true.
gog_sheets_conditional_format_listList conditional formatting rules.
gog_sheets_conditional_format_addAdd a conditional formatting rule to a range (boolean or gradient).
gog_sheets_conditional_format_clearRemove conditional formatting rules from a sheet.

License

MIT

Ask PopNx