Prototype · Preview: every server in the official registry, synced every 30 minutes. Sign in with Google to write reviews.Prototype · updated every 30 min
PopNx MCPMCP servers for people who use AI · explained in plain words

Google Sheets MCP Server

by joshuawhite389version 0.2.0i★ 0iRuns in the cloudOfficial site ↗
Registry nameio.github.joshuawhite389/google-sheets-mcp

How to install

What it does

Read and write Google Sheets with your own service account: list tabs, read, append, update, export.

  • Connects Runs in the cloud
  • Account or key Needs Authorization, X-Google-Service-Account-Key
  • Category Docs, sheets & office work

Use together with

Skills that teach the AI this kind of work; they work alongside this one

MinerU

Transforms complex documents like PDFs and Office docs into LLM-ready markdown/JSON for your Agentic workflows.

by opendatalab★ 83,9191 skills

Skill · How-to guideNo license stated

watermarks-remover

A privacy-first app that strips AI watermarks from content you own.

by guillaumemeyer★ 27,7231 skills

Skill · How-to guide

obsidian-skills

Agent skills for Obsidian. Teach your agent to use Obsidian CLI and open formats including Markdown, Bases, JSON Canvas.

by kepano★ 53,104 (whole repo)5 skills

Skill · How-to guide

Why it ranks here

Lists are ordered by a usage score (out of 100) built from these parts

Popularity0/80GitHub stars or weekly downloads: the larger counts 60, the smaller 20
Freshness12/12Full marks for a release or code change within 30 days
Still answering8/8The cloud endpoint answered at the last check
Usage score20/100

Quality: Passed 3/5 basic checks (shown, not used for ordering) · Momentum: No data yet (Used only on the Trending tab)

Install

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

Let your AI install it with one sentence

Please install Google Sheets MCP Server. Follow https://mcp.popnx.com/i/joshuawhite389-google-sheets-mcp.md, show me the commands and wait for my OK before running them.

Paste it into an AI that can work on your computer (such as Claude Code or Cursor). It reads our steps, shows you the commands and waits for your OK. No key, no sign-up. · See the full text your AI reads

Passed 3/5 checks · What you ask goes through the maker’s server (oldjard--google-sheets-mcp.apify.actor) · ✓ Commands checked Nov 13, 2026

First: which AI do you use?

Pick your app and the steps appear below.

Works with Claude · about 5 min

You need a Google Sheets MCP Server key (create it on the maker’s site) · Set it up once on claude.ai or the desktop app, then use it in chat · free accounts can add 1 · on Team/Enterprise an Owner adds it

  1. Sign up and create a Google Sheets MCP Server key

    Open the maker’s site, sign up and create an API key for the next step. Check the maker’s site for pricing and free plans.

    Open the Google Sheets MCP Server site ↗

  2. Open Claude’s Connectors page

    CustomizeConnectors

    CustomizeConnectors1Add2https://…3Add4
  3. Click “Add” → “Custom” → “Web” and fill in these 2 fields

    Copy each value into the field with the same name in Claude, then click Continue

    Name · NameGoogle Sheets MCP Server
    Remote MCP server URL · Addresshttps://oldjard--google-sheets-mcp.apify.actor/mcp

    Under Request headers, add this name and value

    Header nameAuthorization
    ValueBearer <paste your key here>
    Header nameX-Google-Service-Account-Key
    Value<paste your key here>

    Paste the key only into the app’s field, never into a chat or to anyone

    Click Continue past the sign-in settings Claude detected · under Authentication choose what the maker says (Sign in now, Sign in when needed or No sign in), then click Add

  4. Turn it on in a chat

    +ConnectorsGoogle Sheets MCP Server

  5. Try it

    Use Google Sheets MCP Server and tell me what you can do for me, then show me one thing

    ✓ If Claude says it is using Google Sheets MCP Server or shows a Google Sheets MCP Server tool in the answer, you are connected

Menu names checked against Anthropic’s help page on Nov 11, 2026 · your screen may differ slightly by app version

ChatGPT cannot connect Google Sheets MCP Server yet

Google Sheets MCP Server needs your own key to connect, but OpenAI’s help page only describes OAuth sign-in; there is no key option we could verify

What you can do instead

A · Use an app that can connect Google Sheets MCP Server

  • You need a Google Sheets MCP Server key (create it on the maker’s site) · Set it up once on claude.ai or the desktop app, then use it in chat · free accounts can add 1 · on Team/Enterprise an Owner adds it
  • You need a Google Sheets MCP Server key (create it on the maker’s site)
  • You need a Google Sheets MCP Server key (create it on the maker’s site)
  • You need a Google Sheets MCP Server key (create it on the maker’s site)

B · Others in Docs, sheets & office work that work with ChatGPT

Picked from the most used in the same category, only ones that connect by address with no key

Works with Claude Code · about 5 min

You need a Google Sheets MCP Server key (create it on the maker’s site)

  1. Sign up and create a Google Sheets MCP Server key

    Open the maker’s site, sign up and create an API key for the next step. Check the maker’s site for pricing and free plans.

    Open the Google Sheets MCP Server site ↗

  2. Open Terminal

    Mac: press Command+Space and type Terminal · Windows: open PowerShell

  3. Paste this command and press Enter

    claude mcp add --transport http --scope user google-sheets https://oldjard--google-sheets-mcp.apify.actor/mcp --header 'Authorization: Bearer your-value' --header 'X-Google-Service-Account-Key: your-value'

    Replace “your-value” with your key before pressing Enter

    Paste the key only into the app’s field, never into a chat or to anyone

  4. Type /mcp in Claude Code

    You should see Google Sheets MCP Server listed as connected

  5. Try it

    Use Google Sheets MCP Server and tell me what you can do for me, then show me one thing

    ✓ If Claude Code says it is using Google Sheets MCP Server or shows a Google Sheets MCP Server tool in the answer, you are connected

Menu names checked against Anthropic’s help page on Nov 11, 2026 · your screen may differ slightly by app version

Works with Cursor · about 5 min

You need a Google Sheets MCP Server key (create it on the maker’s site)

  1. Sign up and create a Google Sheets MCP Server key

    Open the maker’s site, sign up and create an API key for the next step. Check the maker’s site for pricing and free plans.

    Open the Google Sheets MCP Server site ↗

  2. Click this button to open Cursor

    Open in Cursor

    Cursor asks you to confirm; click Install

  3. Fill in your key

    In the Google Sheets MCP Server settings, Authorization, X-Google-Service-Account-Key is empty; add your key and save

    Paste the key only into the app’s field, never into a chat or to anyone

  4. Open the AI chat in Cursor in Agent mode

  5. Try it

    Use Google Sheets MCP Server and tell me what you can do for me, then show me one thing

    ✓ If Cursor says it is using Google Sheets MCP Server or shows a Google Sheets MCP Server tool in the answer, you are connected

Menu names checked against Cursor’s help page on Nov 11, 2026 · your screen may differ slightly by app version

Works with VS Code · about 5 min

You need a Google Sheets MCP Server key (create it on the maker’s site)

  1. Sign up and create a Google Sheets MCP Server key

    Open the maker’s site, sign up and create an API key for the next step. Check the maker’s site for pricing and free plans.

    Open the Google Sheets MCP Server site ↗

  2. Click this button to open VS Code

    Open in VS Code

    VS Code asks you to confirm; click Install

  3. Fill in your key

    In the Google Sheets MCP Server settings, Authorization, X-Google-Service-Account-Key is empty; add your key and save

    Paste the key only into the app’s field, never into a chat or to anyone

  4. Open the AI chat in VS Code in Agent mode

  5. Try it

    Use Google Sheets MCP Server and tell me what you can do for me, then show me one thing

    ✓ If VS Code says it is using Google Sheets MCP Server or shows a Google Sheets MCP Server tool in the answer, you are connected

Menu names checked against VS Code’s help page on Nov 11, 2026 · your screen may differ slightly by app version

Other apps that use MCP, such as Windsurf, Zed or Gemini CLI, each add servers differently. See how in the app list.

See every app that uses MCP →

Address for apps that connect over the web

Addresshttps://oldjard--google-sheets-mcp.apify.actor/mcp

JSON settings are under “For developers” below

Stuck? Ask people who use Google Sheets MCP Server💬 Discussion →
For developers: Terminal commands and JSON settings

Over the web

Claude Code

claude mcp add --transport http --scope user google-sheets https://oldjard--google-sheets-mcp.apify.actor/mcp --header 'Authorization: Bearer your-value' --header 'X-Google-Service-Account-Key: your-value'

Cursor (~/.cursor/mcp.json)

{
  "mcpServers": {
    "google-sheets": {
      "url": "https://oldjard--google-sheets-mcp.apify.actor/mcp",
      "headers": {
        "Authorization": "Bearer your-value",
        "X-Google-Service-Account-Key": "your-value"
      }
    }
  }
}

VS Code (mcp.json)

{
  "servers": {
    "google-sheets": {
      "type": "http",
      "url": "https://oldjard--google-sheets-mcp.apify.actor/mcp",
      "headers": {
        "Authorization": "Bearer your-value",
        "X-Google-Service-Account-Key": "your-value"
      }
    }
  }
}

Values you fill in

  • Authorization secret required HTTP header
    Bearer . The hosted server is billed per successful tool call to your Apify account.
  • X-Google-Service-Account-Key secret required HTTP header
    Your Google service account JSON key, base64-encoded on one line (base64 -w0 key.json).

Descriptions are as written by the maker.

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

At a glance

Downloads per weeki
Not on npm/PyPI
Connection
Runs in the cloud
Transport
streamable-http
Latest versioni
0.2.0
Published to registryi
Oct 21, 2026
Code last changedi
Oct 21, 2026
Last checked
Nov 18, 2026
Maker
joshuawhite389
Website
apify.com
Registry status
Active

Which apps can use it

Based on how this server connects and on each app’s own docs, checked Nov 10, 2026.

Connect over the internet in

ClaudeGooseLM StudioMsty StudioCherry StudioCursorVS Code + GitHub CopilotVisual StudioWindsurf (Devin Desktop)ZedKiroClineContinueJetBrains AI AssistantClaude CodeCodex CLIGemini CLIOpenCodenodecodeWarpLibreChatOpen WebUIRaycast

All apps, with pros and cons →

Related guides

What it can do

The server asks you to sign in before it lists its tools.

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 19, 2026

  • ✓ Pass

    Maker matches the repo

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

  • ✓ Pass

    Still maintained

    Code last changed 29 days ago

  • ✓ Pass

    Has a licence

    Uses MIT

  • ! Caution

    Endpoint responds

    Refused access (HTTP 401) without offering OAuth sign-in. It may need a key, or it may be blocking bots; not confirmed.

  • ! Caution

    Sign-in with OAuth

    Needs a key or token that you copy and paste yourself

  • … Not checked yet

    No hidden instructions in tool descriptions

    Not checked yet; we read the tool list when we check the endpoint

What we check → · JSON

Makers: ask for a re-check or report wrong info
For makers: add a badge to your README

If you made this, paste this code into your README. The badge links back to this page.

[![Featured on PopNx MCP](https://mcp.popnx.com/badge/joshuawhite389-google-sheets-mcp.svg)](https://mcp.popnx.com/en/servers/joshuawhite389-google-sheets-mcp)

Discussion

Ask, share a tip or report that it does not work. Sorted by what people marked helpful.

No posts yet. Be the first to ask or share.

Posts here are written by users, not the PopNx team.

Sign in to post

User reviews

No reviews yet

Sign in to write a review

Compared with others in Docs, sheets & office worki

  • More stars than 0% of the other 4126 servers in this category
  • Published to the registry more recently than 52% of the other 4126 servers in this category
  • Basic checks equal to or better than 10% of the other 4126 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 Google Sheets MCP Server safe?

It passed 3 of 5 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?

You need to fill in: Authorization, X-Google-Service-Account-Key

Does it run on my computer or in the cloud?

It runs in the maker’s cloud. Connect over the internet with nothing to install, but what you send passes through the maker’s servers.

Is it still maintained?

The GitHub repo last changed 29 days ago, and the latest version (0.2.0) reached the registry 29 days ago.

Which apps can use it?

Apps that support MCP, such as Claude Desktop, Claude Code, Cursor and VS Code. It connects by URL, so apps that accept remote MCP servers work too, such as ChatGPT on the web (full MCP on Business and above; Pro read-only).

What can I use instead?

In the same category: Puter MCP, XcodeBuildMCP, Vexa, Atlassian Rovo MCP Server, Anki MCP Server

Similar alternatives

Same category, other makers, commands already checked. Official ones first, then by stars.

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

Puter MCP

Puter MCP enables AI tools to interact with Puter: manage files, websites, workers, and more

by HeyPuterWidely used★ 44.2KUpdated 5 months ago

Runs in the cloud✓ service owner · puter.com

XcodeBuildMCP

XcodeBuildMCP provides tools for Xcode project management, simulator management, and app utilities.

by getsentryWidely used↓ 130.5K/wk shared package★ 6.6KUpdated 4 months ago

Runs on your computer✓ service owner · xcodebuildmcp.com

Vexa

Meeting bot and transcripts for Google Meet, Teams and Zoom. Live or after, speakers labelled.

by Vexa-aiWidely used★ 3KUpdated 2 months ago

Runs in the cloud✓ service owner · vexa.ai

Atlassian Rovo MCP Server

Atlassian’s official server lets AI search and manage Jira work and Confluence pages. Connects to Atlassian’s cloud with OAuth sign-in.

by atlassianGrowing★ 1.2KUpdated 2 months ago

Runs in the cloud✓ service owner · atlassian.com

Anki MCP Server

MCP server for Anki flashcards: adaptive review, notes, media, and deck management via AnkiConnect.

by ankimcpGrowing↓ 1.1K/wk★ 567Updated last month

Runs on your computer✓ service owner · ankimcp.ai
Compared with similar ones
This one
Google Sheets MCP Server
Puter MCPXcodeBuildMCPVexaAtlassian Rovo MCP ServerAnki MCP Server
Runs whereRuns in the cloud, nothing to installRuns in the cloud, nothing to installInstalls on your computerRuns in the cloud, nothing to installRuns in the cloud, nothing to installInstalls on your computer
Needs a keyYesNoNoYesNoNo
Add with + in ClaudeNoNoNoNoYesNo
Basic checks3/54/43/32/44/43/3
LicenseMITAGPL-3.0MITApache-2.0Apache-2.0MIT
PriceNo cost listed in the registryNo cost listed in the registryNo cost listed in the registryNo cost listed in the registryNo cost listed in the registryNo cost listed in the registry

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.

Google Sheets MCP Server

An MCP server that lets Claude, Cursor or any other MCP client read and write your Google Sheets: list a spreadsheet's tabs, read ranges, append or update rows, and export an Apify dataset to a tab.

It signs in with your own Google service account, so there's no shared quota, no OAuth app to approve, and nothing that expires. The service account can only open sheets you share with it.

Two ways to use it:

  • Hosted on Apify (no install): apify.com/oldjard/google-sheets-mcp. Apify starts the server when your agent calls it and stops it when it goes quiet. It is paid per use, billed to your own Apify account (prices below).
  • Self-hosted (free): clone this repo and run it yourself. Same code.

Tools

ToolWhat it does
list_sheetsLists a spreadsheet's tabs, with their size and link
read_rangeReads cells (Leads!A1:D50, A1:D50, or a whole tab). Long tabs come back in pages, with the next range to read
append_rowsAdds rows under the last one. Objects are matched to the header by name (new fields become columns). Arrays are written as they are. Can skip rows already in the tab
update_rangeOverwrites cells from a top-left cell, and grows the tab if needed
export_datasetWrites an Apify dataset to a tab: append, replace, or only new rows

Values are written as plain values, never as formulas. One call reads or writes at most 5,000 rows. If a tool can't do something (sheet not shared, a wrong tab name, a missing key), it returns a plain-English fix, for example the exact email to share the sheet with.

Google setup (about 5 minutes, once)

You need a Google service account: a robot Google user that only gets access to the sheets you share with it. It's free, and Google asks for no billing details to use the Sheets API.

  1. Open console.cloud.google.com, create a project and select it.
  2. Open the Google Sheets API page and click Enable.
  3. IAM & Admin > Service Accounts > Create service account. Name it, skip the optional role step, click Done.
  4. Open the service account, Keys > Add key > Create new key > JSON. A .json file downloads.
  5. Copy its client_email. Share each Google Sheet your agent should use with that email as Editor.
  6. Turn the key into one line of base64: base64 -w0 key.json (on macOS: base64 -i key.json).

Some Google Workspace organizations block service-account keys. If step 4 says key creation is disabled by policy, use a personal Google account for the project; the sheet can live anywhere as long as it's shared with the email.

Connect: hosted on Apify

Use the URL https://oldjard--google-sheets-mcp.apify.actor/mcp with two headers. For Claude Code:

claude mcp add --transport http google-sheets https://oldjard--google-sheets-mcp.apify.actor/mcp \

--header "Authorization: Bearer " \ --header "X-Google-Service-Account-Key: "

Other clients take the same URL and headers in their JSON config.

Pricing (hosted): $0.001 per successful tool call, $0.0004 per row that export_dataset writes. Failed calls, header rows and rows skipped as duplicates are free. Each server start costs $0.00005. As with any Apify Standby Actor, Apify also bills the platform usage of the run while your agent is connected and for a short idle period after (the server runs at 256 MB, so this is a fraction of a cent per session). The key travels over HTTPS to your own run, is held in memory only, and is never logged or stored.

Connect: self-hosted

Needs Node.js 24 or newer.

git clone https://github.com/joshuawhite389/google-sheets-mcp && cd google-sheets-mcp

npm install PORT=3000 npm run serve

Then point your client at http://localhost:3000/mcp with the X-Google-Service-Account-Key header (no Apify token needed; export_dataset then reads datasets from the local ./storage folder). The Dockerfile builds the same server for Apify; to run it elsewhere, set APIFY_META_ORIGIN=STANDBY and ACTOR_WEB_SERVER_PORT.

Limits worth knowing

  • Google allows 10 million cells per spreadsheet and 50,000 characters per cell.
  • A service account gets Google's standard quota of 60 write requests per minute. Rate limits and Google hiccups are retried with backoff.

Development

npm test          # unit tests against a fake Google API that verifies the signed sign-in

npm run e2e # the real server process, driven by a real MCP client, against the fake Google npm run typecheck

Related

Dataset to Pinecone & Qdrant Vector Export (an Apify Actor, not an MCP server) chunks and embeds a scraped dataset into your own Pinecone or Qdrant index.

License

MIT