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.

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 ToolsLow Risk9.5MCP 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

9.5

Low Risk9.5Low Risk

Valid MCP server (1 strong, 1 medium validity signals). 1 code issue detected. 1 known CVE in dependencies Package registry verified. Imported from the Official MCP Registry. 1 finding(s) downgraded by scanner intelligence.

5 files analyzed · 3 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.

file_system

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

env_vars

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

Shell Command Execution

Runs commands on your machine. Be cautious — only use if you trust this plugin.

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 (3)

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-creator-typescript

FinAgent