Enterprise DNAEnterprise DNA

MCP Servers

freema/mcp-gsheets

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

Visit site ↗

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

Not checked yet. Dated facts such as prices, releases and repository activity appear here once we have confirmed them from a source.

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

Sources

Where this comes from

No sources recorded yet. Each source we check is listed here with the date we checked it.

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.

← Back to MCP ServersSubmit your own entry →