Prototyp · Vorschau: alle Server aus der offiziellen Registry, alle 30 Minuten synchronisiert. Bewertungen und Benutzerkonten folgen in einem späteren Schritt.
PopNx MCPMCP-Server für alle, die KI nutzen · in einfachen Worten erklärt

Google Sheets MCP

von mmedumVersion 4.2.1i★ –iLäuft auf deinem Computer
Name in der Registryio.github.mmedum/google-sheets-mcp

Installieren

Überblick

Beschreibung vom Entwickler (englisches Original)

Google Sheets as MCP tools: read ranges, write without destroying formulas, format and validate.

Die drei Säulen von PopNx MCP

Diese drei werden nie zu einer Punktzahl zusammengefasst: Meinungen, Messungen und Beliebtheit sind verschiedene Dinge.

Was du damit machen kannst

Für diesen Server haben wir noch keine Zusammenfassung in einfacher Sprache geschrieben. Unten stehen die Fakten, die wir aus der Registry gelesen haben.

  • Verbindung: Läuft auf deinem Computer
  • Transport: stdio
  • Kategorie: Dokumente, Tabellen & Büroarbeit

Installation

Wähle die KI-App, die du nutzt, und kopiere die Einstellungen.

Bevor du installierst

  • Basischecks: 1 von 1 bestanden
  • Läuft auf deinem Computer mit den Rechten deines Benutzerkontos (Dateien, Netzwerk, Apps).
  • Die Registry nennt keinen Schlüssel zum Eintragen.

Welche App nutzt du?

Wähle oben deine App. Wir merken sie uns, damit der Button beim nächsten Mal „In … installieren“ anzeigt.

Die .mcpb-Datei des Entwicklers herunterladen

Der Link führt zur Datei des Entwicklers selbst; wir hosten sie nicht und verpacken sie nicht neu. Öffne die Datei, dann installiert Claude Desktop sie.

Führe das in deinem Terminal aus

Dein Browser fragt, ob er die App öffnen darf, dann zeigt die App die Einstellungen und bittet dich um Bestätigung. Schlüsselwerte bleiben leer, damit du sie selbst einträgst.

Dein Browser fragt, ob er die App öffnen darf, dann zeigt die App die Einstellungen und bittet dich um Bestätigung. Schlüsselwerte bleiben leer, damit du sie selbst einträgst.

Dieser Server läuft auf deinem Computer, und ChatGPT kann sich nur mit Servern im Internet verbinden. Wähle eine andere App.

Deine Auswahl bleibt in einem Cookie auf diesem Gerät; kein Konto nötig.

Diese Einstellungen werden aus dem Registry-Eintrag des Entwicklers erzeugt. Wenn in der README etwas anderes steht, folge der README.

Was er kann

Läuft auf deinem Computer; die Tool-Liste erscheint nach der Installation in deiner KI-App.

Basischecksi

Wir prüfen Informationen, die jeder sehen kann; den Code haben wir nicht gelesen. Checks, die nicht zutreffen, werden nicht mitgezählt. · Geprüft am 7. Nov. 2026

  • ✓ Bestanden

    Entwickler passt zum Repo

    Der Registry-Name wurde mit dem GitHub-Konto mmedum bestätigt, dem das Repo gehört

  • … Noch nicht geprüft

    Wird noch gepflegt

    Dieses Repo haben wir noch nicht von GitHub gelesen

  • … Noch nicht geprüft

    Hat eine Lizenz

    Dieses Repo haben wir noch nicht von GitHub gelesen

  • – Nicht zutreffend

    Endpunkt antwortet

    Dieser Server läuft auf deinem Computer; es gibt keinen Endpunkt im Internet

  • – Nicht zutreffend

    Anmeldung mit OAuth

    Läuft auf deinem Computer und nutzt stattdessen lokale Einstellungen

  • … Noch nicht geprüft

    Keine versteckten Anweisungen in Tool-Beschreibungen

    Läuft auf deinem Computer; Tool-Listen können wir nur von Endpunkten im Internet lesen

Im Vergleich mit anderen in Dokumente, Tabellen & Büroarbeiti

  • Mehr Sterne als 0 % der anderen 2193 Server in dieser Kategorie
  • Neuer in der Registry veröffentlicht als 90 % der anderen 2193 Server in dieser Kategorie
  • Basischecks gleich gut wie oder besser als bei 100 % der anderen 2193 Server in dieser Kategorie

Verglichen mit allen aktiven Servern dieser Kategorie in der Registry. Sterne zählen nur, wenn dem Herausgeber das Repo gehört.

Häufige Fragen

Ist Google Sheets MCP sicher?

Er hat 1 von 1 zutreffenden Basischecks bestanden. Den Code haben wir nicht gelesen. Bevor du einen Schlüssel oder Token hinzufügst, sieh nach, welche Zugriffe der Server verlangt, und nutze einen Schlüssel, der nur die Berechtigungen hat, die du brauchst.

Welche Schlüssel oder Codes braucht er?

Die Registry nennt keinen erforderlichen Schlüssel, manche Server bitten dich aber bei der ersten Nutzung, dich anzumelden.

Läuft er auf meinem Computer oder in der Cloud?

Er läuft auf deinem Computer. Deine KI-App startet ihn bei Bedarf, und die Daten laufen nicht über die Server des Entwicklers (außer der Server ruft selbst einen Onlinedienst auf).

Wird er noch gepflegt?

Das GitHub-Repo wurde zuletzt – geändert, und die neueste Version (4.2.1) kam vorgestern in die Registry.

Welche Apps können ihn nutzen?

Apps, die MCP unterstützen, etwa Claude Desktop, Claude Code, Cursor und VS Code. Außerdem brauchst du MCPB auf deinem Computer.

Was kann ich stattdessen nutzen?

In derselben Kategorie: Agent-Native Calendar, Excel MCP Server, MCP Server for Excel

Alternativen

Server derselben Kategorie von anderen Entwicklern, sortiert nach Sternen.

So liest du eine Karte:★ GitHub-SterneiDrei Säulen: Bewertungen · Checks · NutzungiAktualisiert = neueste Version in der Registry veröffentlichti

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

Läuft in der Cloud★ 7.620MITAktualisiert vor 2 Monaten
Installieren

Excel MCP Server

von haris-musa

Create and edit Excel files with AI: charts, PivotTables, formulas. No Excel needed.

Läuft auf deinem Computer★ 4.276MITAktualisiert vor 6 Tagen
Installieren

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

Läuft auf deinem Computer★ 847MITAktualisiert vor 4 Tagen
Installieren

README vom Entwickler

README öffnen

Unverändert aus dem Repo des Entwicklers übernommen. PopNx MCP hat den Inhalt weder geprüft noch empfiehlt es ihn. HTML, Bilder und Skripte wurden entfernt. Links führen von dieser Website weg.

google-sheets-mcp

Google Sheets as MCP tools. Read and write ranges without destroying the formulas underneath. One Go binary over stdio, signed in as you, with your own OAuth client and the refresh token in your OS keyring.

It is for a person with a Google account who wants an assistant to read, write and reshape the spreadsheets they can already open, as them. It works inside a spreadsheet: values, formulas, formatting, sheets, charts, pivot tables, Connected Sheets, cell comments and notes. Finding, sharing, moving and trashing files, and their revisions, belong to a server built on the Drive API.

Goals and non-goals

Goals:

  • A write never destroys what it did not see. The target is read first. Overwriting anything non-empty, a formula above all, is refused until the call says so, naming the cells, and carries the checkpoint of what it replaces.
  • What Google changes is said. Every write reports each value Google stored differently from how it was sent, and every delete names what it takes, including what Google removes without saying so.
  • The model never guesses an address. Ranges are A1 throughout, sheet titles are read and quoted, and every read is a grid with its column letters and row numbers.
  • Nothing irreversible or outward-reaching runs unless you turn it on. Deletes are not registered by default and need confirm, and a formula that makes Google fetch a URL needs a setting no argument can lift.
  • Reads are bounded. Every read has a budget in cells and characters, resolved before the call, and says where to continue.
  • Act as you, and log nothing about your spreadsheets. Every call runs as the signed-in account, and the logs never carry cell values, formulas, titles, ranges or search terms.

Non-goals:

  • Files, folders, sharing and revisions. Drive is read only to find a spreadsheet by title, show its owner and modified time, and name the signed-in account.
  • Spreadsheet settings. No tool changes a spreadsheet's title, locale or recalculation setting.
  • Changes pushed to it. The Sheets API has no push channel or change feed.
  • Apps Script, add-ons or a calculation engine. Formulas are written and read as text, and Google computes them.
  • A hosted service. It speaks stdio only, so Claude on the web and on mobile cannot reach it.
  • Asking you before a call. Your client approves each call; the server asks nothing.

What makes this one different

  • Guarded writes. A spreadsheet has no undo behind an API call, and the value you can see is rarely the whole cell: underneath it there may be a formula, a different stored type, or a note. write_values reads the target first and refuses to overwrite anything non-empty without overwrite, or a formula without overwrite_formulas as well.
  • It does the index arithmetic. Google names the first sheet in the account's language, so it is often not an English word. Titles are read from the spreadsheet and quoted for you, and the model never sees a GridRange.
  • Coercion is reported. input: typed parses as a person typing, so 007 becomes 7; every value Google changed comes back named.
  • A curated surface, gated by registration. A tool that is switched off is not registered, so it cannot be called at all.
  • Verifiable releases. Signed checksums, build provenance, SBOMs and reproducible builds.

Tools

The Scope column names what each tool needs. A spreadsheet named by its title is found through Drive, under drive.readonly. In read-only mode, spreadsheets.readonly takes the place of spreadsheets.

ToolWhat it doesScope
get_spreadsheetThe spreadsheet card: title, link, locale, and every sheet's exact title, id, size, frozen rows, hidden state and what it holds, plus named ranges, tables, protected ranges and filter views. No cell data, so it costs the same on a spreadsheet of ten cells and one of ten million. Call it firstspreadsheets
read_rangeAn addressed grid of a range: column letters across the top, row numbers down the side. show=both prints each formula under the value it produced. Budgeted in cells and characters, with a continuation, and every read returns a checkpointspreadsheets
read_formattingWhat a range looks like — number formats, fonts, colors, borders, alignment — per block of identically formatted cells rather than per cell, with the merges, conditional rules, banding, validation and notes that decide how a cell looks without being on the cellspreadsheets
search_spreadsheetsFind a spreadsheet by part of its title, by text inside it, by owner or by when it changeddrive.readonly
find_in_spreadsheetSearch one spreadsheet for text or an RE2 pattern and get back A1 addresses, saying whether each match was in a value, in the formula under it, or in a note beside itspreadsheets
create_spreadsheetA new spreadsheet, optionally with extra sheets and seed values. Returns its card, including the id every later call needsspreadsheets
write_valuesWrite a rectangle, refusing first anything the write would destroy that you cannot see, then reporting every value Google stored differently from how it was sent. An overwrite carries the checkpoint of what it replacesspreadsheets
append_rowsAdd rows after a block of data and report where they actually landed — Google decides the destination, and the same sheet given different ranges appends in different places. It inserts, so it never writes over a rowspreadsheets
format_cellsNumber format, font, colors, borders, alignment, wrapping, merges and notes, applied in one atomic batch. A merge, a clear and a note are the three that take something away, and each is refused until acknowledgedspreadsheets
manage_rangeAdd, update or delete what is attached to a range: a named range, a protected range, a validation rule, a table and the types of its columns, banding, or a conditional format rule or color scale. Existing ones are named by the range they cover, not by an idspreadsheets
transform_rangeSort, replace, trim, de-duplicate, split, shuffle, fill, copy or move a range — the operations that move data without you naming its new address, so each reads what it would land on firstspreadsheets
manage_anchorLabel a row, column or sheet so it can be found again after the spreadsheet has been edited around it. An anchor follows its row through inserts, deletes, moves and sorts, where an A1 address goes stale the moment somebody inserts a row. Pass anchor: anywhere a range or band is taken, except in delete_dimensions and clear_values, which take the rows or range itself so the call shows what goesspreadsheets
manage_chartAdd, update, move, delete or list charts and slicers. A chart floats above the grid, so adding one overwrites nothing, and its data is named in A1, one range per series. A listing reports which charts have lost their series — what deleting a charted column does, and what nothing in Sheets tells youspreadsheets
manage_pivot_tableAdd, update, delete or list pivot tables, with groups by date or number ranges, filters and calculated values. Columns are named in A1 or by their heading, never by counting, and every result reports the rectangle the table covers right now: the size is computed from the data rather than chosen. A listing reads every rule back in the spelling the tool takesspreadsheets
connect_data_sourceOff by default: connect a BigQuery query or table through Connected Sheets. Google makes a sheet for it and runs the query, charged to the Cloud project you name, now and on every refreshspreadsheets, bigquery.readonly
manage_data_sourceOff by default: refresh one Connected Sheets data source, cancel a refresh, or list what is connected. get_spreadsheet already says whether a spreadsheet has one, with no extra scopespreadsheets, bigquery.readonly
read_cell_commentsThe comment threads on a spreadsheet's cells: the cell each is on now, open or resolved, who it is assigned to, and every post. A thread follows its cell as rows move, and one whose row was deleted is still listed, without a cellspreadsheets
manage_cell_commentComment on a cell, reply, edit a post, resolve or reopen. Google emails an assignee, and may notify an address the text names, which is how this server reaches someone outside the spreadsheetspreadsheets
manage_sheetAdd, rename, duplicate, copy to another spreadsheet, hide, unhide, reorder, resize, freeze or color a sheetspreadsheets
edit_dimensionsInsert, move, resize, auto-size, group, ungroup, hide or unhide rows and columnsspreadsheets
delete_dimensionsDestructive, off by default: remove rows or columns and the data on them, having counted what that isspreadsheets
clear_valuesDestructive, off by default: clear a range's values and keep its formatting, notes and validation rulesspreadsheets
delete_sheetDestructive, off by default: delete a sheet and everything on it, having counted what that isspreadsheets
delete_cell_commentDestructive, off by default: delete a comment thread with its replies, or one reply. Resolving keeps it, and is usually what is wantedspreadsheets
delete_data_sourceDestructive, off by default: delete a Connected Sheets data source, the sheet Google made for it, and everything on that sheet; Google unlinks what was built on the source. The call names that sheet's title. Needs no BigQuery scope, so it reaches a source somebody else connectedspreadsheets

The destructive tools are not registered at all unless GSHEETS_ENABLE_DESTRUCTIVE=true, and each still needs confirm: true on the call. connect_data_source and manage_data_source are not registered unless GSHEETS_ENABLE_DATA_SOURCES=true, which is also what makes login ask for the BigQuery scope. Connected Sheets needs a Cloud project with BigQuery and billing before it does anything, so asking everyone for that scope would be the wrong default.

Resources

For a client that attaches a spreadsheet rather than calling a tool. There is no static list, since listing a person's spreadsheets is a Drive listing, and no subscriptions, since the Sheets API has no push.

URIWhat it is
gsheets://{spreadsheet}The card: every sheet with its exact title, id and size, plus named ranges, tables and protected ranges. Reads no cells
gsheets://{spreadsheet}/{sheet}That sheet's used range as CSV — the rows and columns holding something, not the sheet's allocated size. The sheet title is percent-encoded

Install

go install github.com/mmedum/google-sheets-mcp/v4/cmd/google-sheets-mcp@latest

Or take an archive for Linux, macOS or Windows, on amd64 or arm64, from the latest release, and verify it before you run it.

Claude Desktop users can open the .mcpb bundle from the same release. It installs the server and asks for the settings a client's configuration would carry: your OAuth client JSON, the profile, read-only, the destruct

Nur der Anfang wird gezeigt; den Rest findest du im Repo

PopNx fragen