Back to Browse

Gsheets MCP Server

by Freema
Developer ToolsModerate5.8MCP 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.8
Moderate5.8Moderate Risk

This MCP Google Sheets server demonstrates solid security practices with proper authentication via environment variables, comprehensive input validation, and no evidence of malicious code patterns. The codebase uses TypeScript with strict type checking and well-structured validation. Permissions align well with the stated purpose of Google Sheets integration. Minor code quality observations around environment variable parsing and test coverage do not significantly impact security. Supply chain analysis found 1 known vulnerability 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!