Enterprise DNAEnterprise DNA

MCP Servers

freema/mcp-gsheets

MCP server for Google Sheets - Read, write and manipulate spreadsheets through Claude Desktop

Our verdict

Not reviewed yet

We have not reviewed freema/mcp-gsheets yet

No one at Enterprise DNA has checked this listing against its sources. The description comes from public listings gathered automatically. Any fact below shows where it came from and when it was last checked.

How we review records

From the listing

About freema/mcp-gsheets

Connects Claude Desktop to Google Sheets with a wide set of actions, reading, writing, inserting rows, creating new sheets, and more, so you can manage a spreadsheet by describing what you want instead of clicking through menus. It covers the operations most small businesses actually use a spreadsheet for: tracking data, building simple workflows, and keeping shared sheets current. A solid pick if you want more spreadsheet control than a bare read and write connector.

Best for

Small businesses that want fuller spreadsheet control through Claude

Use cases

  • Add or update data in a shared spreadsheet from a plain-English request
  • Create a new sheet or tab to track a new project
  • Query spreadsheet data to inform a decision or answer a question
  • Build a simple recurring workflow that reads from and writes to a sheet

Notes

An MCP server that lets Claude Desktop read, write, and manipulate Google Sheets. It uses TypeScript and exposes spreadsheet operations as tools for the AI assistant.

69 stars on GitHub. Last updated 2026-05-12. Licensed MIT.

Pros

  • Direct integration with Claude Desktop for spreadsheet tasks
  • Open source with a permissive license for customization
  • Lightweight and focused on a single, well-defined capability

Cons

  • Limited to Google Sheets only, no other spreadsheet formats
  • Requires Claude Desktop and MCP setup, not a standalone tool
  • Relatively small community and few stars, may have limited support

Key facts

What we have checked

Days since the last commit
9
Checked GitHub
GitHub forks
24
Checked GitHub
GitHub stars
105
Checked GitHub
Days to a first reply on issues
273.5
Checked GitHub
Open issues
0
Checked GitHub
Releases in the last 90 days
3
Checked GitHub

Each value shows when we last confirmed it and where it came from. Values we have not confirmed are left out, never guessed.

How to use

How to set it up

As the listing publishes it. We have not run this install.

Install

claude mcp add mcp-gsheets npx mcp-gsheets@latest

Tools exposed

  • sheets_get_values
  • sheets_batch_get_values
  • sheets_get_metadata
  • sheets_check_access
  • sheets_update_values
  • sheets_batch_update_values
  • sheets_append_values
  • sheets_clear_values
  • sheets_insert_rows
  • sheets_delete_columns
  • sheets_delete_rows
  • sheets_insert_link
  • sheets_insert_date
  • sheets_create_spreadsheet
  • sheets_insert_sheet
  • sheets_delete_sheet
  • sheets_duplicate_sheet
  • sheets_copy_to
  • sheets_update_sheet_properties
  • sheets_batch_delete_sheets

Clients the listing names (not checked here)

Claude Desktop, Claude Code, Cursor, Cline

Example client config

{
  "mcpServers": {
    "mcp-gsheets": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-gsheets@latest"
      ],
      "env": {
        "GOOGLE_PROJECT_ID": "your-project-id",
        "GOOGLE_APPLICATION_CREDENTIALS": "/absolute/path/to/service-account-key.json"
      }
    }
  }
}

Install

Add freema/mcp-gsheets to your client

Not verified yet

Our lab has not run this server yet. "Config checked" on a client means the recipe matches that client's documented config format; it does not mean we ran it.

Claude Code

Config checked

Run in your terminal (runs on your computer)

claude mcp add --env GOOGLE_PROJECT_ID=YOUR_GOOGLE_PROJECT_ID --transport stdio freema-mcp-gsheets -- npx -y mcp-gsheets@1.10.3

Needs GOOGLE_PROJECT_ID: replace each YOUR_ value with your own.

Version 1.10.3 · From the Official MCP registry, read · Format checked against Claude Code's config docs

Claude Desktop

Config checked

Add to claude_desktop_config.json (runs on your computer)

{
  "mcpServers": {
    "freema-mcp-gsheets": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-gsheets@1.10.3"
      ],
      "env": {
        "GOOGLE_PROJECT_ID": "YOUR_GOOGLE_PROJECT_ID"
      }
    }
  }
}

Needs GOOGLE_PROJECT_ID: replace each YOUR_ value with your own.

Version 1.10.3 · From the Official MCP registry, read · Format checked against Claude Desktop's config docs

Cursor

Config checked

Add to .cursor/mcp.json (runs on your computer)

{
  "mcpServers": {
    "freema-mcp-gsheets": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-gsheets@1.10.3"
      ],
      "env": {
        "GOOGLE_PROJECT_ID": "YOUR_GOOGLE_PROJECT_ID"
      }
    }
  }
}

Needs GOOGLE_PROJECT_ID: replace each YOUR_ value with your own.

Version 1.10.3 · From the Official MCP registry, read · Format checked against Cursor's config docs

VS Code

Config checked

Add to .vscode/mcp.json (runs on your computer)

{
  "inputs": [
    {
      "type": "promptString",
      "id": "google-project-id",
      "description": "Google Cloud project ID",
      "password": true
    }
  ],
  "servers": {
    "freema-mcp-gsheets": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "mcp-gsheets@1.10.3"
      ],
      "env": {
        "GOOGLE_PROJECT_ID": "${input:google-project-id}"
      }
    }
  }
}

Needs GOOGLE_PROJECT_ID: replace each YOUR_ value with your own.

Version 1.10.3 · From the Official MCP registry, read · Format checked against VS Code's config docs

Codex

Config checked

Add to ~/.codex/config.toml (runs on your computer)

[mcp_servers.freema-mcp-gsheets]
command = "npx"
args = ["-y", "mcp-gsheets@1.10.3"]
env_vars = ["GOOGLE_PROJECT_ID"]

Needs GOOGLE_PROJECT_ID: replace each YOUR_ value with your own.

Version 1.10.3 · From the Official MCP registry, read · Format checked against Codex's config docs

  • ChatGPT: ChatGPT connects only to remote servers that need no API key.

Recipes come from the server's entry in the official MCP registry. Check the package name before you run it, and keep keys out of shared files.

Works with

What freema/mcp-gsheets connects to

5 clients, each with how we know and when we checked.

Works withTypeHow we knowChecked
Claude CodeClientInstall recipe matches the client's documented formatRuns locally, version 1.10.3Config checkedClaude Code docs
Claude DesktopClientInstall recipe matches the client's documented formatRuns locally, version 1.10.3Config checkedClaude Desktop docs
CursorClientInstall recipe matches the client's documented formatRuns locally, version 1.10.3Config checkedCursor docs
VS CodeClientInstall recipe matches the client's documented formatRuns locally, version 1.10.3Config checkedVS Code docs
CodexClientInstall recipe matches the client's documented formatRuns locally, version 1.10.3Config checkedCodex docs

Stars and usage

How freema/mcp-gsheets is growing

GitHub stars

104 to 105

stars. 28 Oct 2026 to 17 Nov 2026, 4 readings.

Source: GitHub. Checked .

Health and security

Is freema/mcp-gsheets looked after, and what do its setup files show

Health score

45 out of 100

Does someone look after this repository? It does not say the code is good or safe. Worked out from GitHub signals checked . How it is worked out

PartPointsWhat we saw
Recent activity30 of 30Last push 9 days ago
Releases15 of 153 releases in 90 days
Issue replies0 of 20First reply in 273.5 days (median)
Maintainer0 of 15Owned by a single user
Official source0 of 20Community server

Security check static checks

100 out of 100

Reads what is published about the server: package advisories, licence, secrets in the documented setup and tool permissions. Nothing is installed or run, so this is not a security assessment. Checked by edna-static-v1 npm:mcp-gsheets@1.11.0. What it checks

Licence: MIT

  • Note Asks for GOOGLE_APPLICATION_CREDENTIALS through environment variables.
  • Note The lab has not recorded this server's tool list yet, so tool permissions were not checked.
Tool permissions (2)
  • GOOGLE_APPLICATION_CREDENTIALS, environment variable it asks for (a secret)
  • GOOGLE_PROJECT_ID, environment variable it asks for

Sources

Where this comes from

  • GitHubRegistry

    Checked · Days since the last commit, GitHub forks, GitHub stars, Days to a first reply on issues, Open issues, Releases in the last 90 days

A source shows what was published when we checked it. It does not certify security, performance or a working installation. Read our method.

Changelog

What changed

No changes recorded yet. Releases, price changes and deprecations appear here, with their dates, once we track them for this record.

Pairs with

Other entries in the index that connect to this one. Click through to see the chain.

Free 27-page guide

Get the free Developer’s Field Guide

A 27-page field guide to the AI coding workflow with Claude. Claude Code, MCP servers, the prompt patterns that work, and what to delegate. Free.

Enter your work email. We send it straight over, plus a few short notes worth knowing. Unsubscribe any time.

No spam. Unsubscribe any time.