How do I install Gsheets?

Gsheets is a local plugin. Install it using npm package: mcp-gsheets and add the generated configuration snippet to your AI app's MCP config file. Then restart your AI app.

Is Gsheets safe to use?

Gsheets scored 5.7/10 (moderate risk) in MCP Marketplace's automated security scan. It has 1 high or critical finding to review. It's listed, but review the security report on this page before installing.

What credentials does Gsheets need?

Gsheets requires the following credentials or environment variables: GOOGLE_PROJECT_ID, GOOGLE_APPLICATION_CREDENTIALS, GOOGLE_SERVICE_ACCOUNT_KEY, GOOGLE_PRIVATE_KEY, GOOGLE_CLIENT_EMAIL. You can find setup instructions on the server detail page.

What AI apps work with Gsheets?

Gsheets uses the Model Context Protocol (MCP) and works with any MCP-compatible AI app, including Claude, ChatGPT / Codex, Gemini, Copilot, Cursor, and more.

Back to Browse

Gsheets MCP Server

by Freema

Developer ToolsModerate5.7MCP RegistryLocal

Free

Server data from the Official MCP Registry

MCP server for Google Sheets API — read, write, format, batch operations.

About

MCP server for Google Sheets API — read, write, format, batch operations.

Security Report

5.7

Moderate5.7Moderate Risk

This is a well-structured MCP server for Google Sheets API integration with strong input validation, proper error handling, and appropriate permission scoping. The codebase uses TypeScript with comprehensive testing, follows secure credential handling patterns (env vars, no hardcoding), and demonstrates good security practices overall. No critical vulnerabilities or malicious patterns were identified. Supply chain analysis found 2 known vulnerabilities in dependencies (1 critical, 0 high severity). Package verification found 1 issue.

3 files analyzed · 7 issues found

Security scores are indicators to help you make informed decisions, not guarantees. Always review permissions before connecting any MCP server.

Permissions Required

This plugin requests these system permissions. Most are normal for its category.

env_vars

Check that this permission is expected for this type of plugin.

HTTP Network Access

Connects to external APIs or services over the internet.

File System Read

Reads files on your machine. Normal for tools that analyze or process local data.

What You'll Need

Set these up before or after installing:

Google Cloud project IDOptional

Environment variable: GOOGLE_PROJECT_ID

Path to service account key JSON file (auth method 1)Optional

Environment variable: GOOGLE_APPLICATION_CREDENTIALS

Service account key as JSON string (auth method 2)Required

Environment variable: GOOGLE_SERVICE_ACCOUNT_KEY

Service account private key in PEM format (auth method 3)Required

Environment variable: GOOGLE_PRIVATE_KEY

Service account email (auth method 3)Optional

Environment variable: GOOGLE_CLIENT_EMAIL

How to Install

Add this to your MCP configuration file:

{
  "mcpServers": {
    "io-github-freema-mcp-gsheets": {
      "env": {
        "GOOGLE_PROJECT_ID": "your-google-project-id-here",
        "GOOGLE_PRIVATE_KEY": "your-google-private-key-here",
        "GOOGLE_CLIENT_EMAIL": "your-google-client-email-here",
        "GOOGLE_SERVICE_ACCOUNT_KEY": "your-google-service-account-key-here",
        "GOOGLE_APPLICATION_CREDENTIALS": "your-google-application-credentials-here"
      },
      "args": [
        "-y",
        "mcp-gsheets"
      ],
      "command": "npx"
    }
  }
}

Reviews

No reviews yet

Be the first to review this server!

More Developer Tools MCP Servers

Git

Free

by Modelcontextprotocol · Developer Tools

Read, search, and manipulate Git repositories programmatically

Toleno

Free

by Toleno · Developer Tools

Toleno Network MCP Server — Manage your Toleno mining account with Claude AI using natural language.

mcp-creator-python

Free

by mcp-marketplace · Developer Tools

Create, build, and publish Python MCP servers to PyPI — conversationally.

Gsheets MCP Server

About

Security Report

Findings (7)Action required

Permissions Required

What You'll Need

How to Install

Reviews

No reviews yet

More Developer Tools MCP Servers

Git

Toleno

mcp-creator-python

MarkItDown

MCP Marketplace

FinAgent