加载中…
Google Sheets integration with OAuth, spreadsheet management, batch operations, and formatting
Google Sheets 是 ChatHome Skills 收录的 MCP 条目，来源为 Official MCP Registry，质量分 100/100。 作为 Model Context Protocol 服务器，它向 Claude、Cursor、Copilot 等兼容 MCP 的 LLM 客户端暴露可直接调用的工具，让 agent 的能力超出模型内置范围。 该条目由 ChatHome Skills 的每日抓取从官方 registry 和 GitHub 发现查询中收录，每次运行都会重新核验仓库事实、新鲜度信号和安装元数据。 质量分综合了官方 registry 收录情况、可用安装命令、许可证完整性、仓库活跃度和 GitHub star 趋势，完整算法说明见来源页。安装命令已列于上方，可直接复制使用。 在将 Google Sheets 加入生产 agent 工作流前，请核对上方的最近更新日期和仓库状态——下方事实快照是最近一次抓取的时点值。
npx -y @mcp-z/mcp-sheets@2.4.2运行此命令前，请先核对上游源码。
{
"_meta": {
"io.modelcontextprotocol.registry/official": {
"status": "active",
"isLatest": true,
"updatedAt": "2026-10-12T16:12:20.156651Z",
"publishedAt": "2026-10-12T16:12:20.156651Z",
"statusChangedAt": "2026-10-12T16:12:20.156651Z"
}
},
"server": {
"name": "io.github.mcp-z/mcp-sheets",
"title": "Google Sheets",
"$schema": "https://static.modelcontextprotocol.io/schemas/2025-12-11/server.schema.json",
"version": "2.4.2",
"packages": [
{
"version": "2.4.2",
"transport": {
"type": "stdio"
},
"identifier": "@mcp-z/mcp-sheets",
"runtimeHint": "npx",
"registryType": "npm",
"packageArguments": [
{
"name": "--auth",
"type": "named",
"choices": [
"loopback-oauth",
"service-account"
],
"description": "Authentication mode"
},
{
"name": "--headless",
"type": "named",
"description": "Disable browser auto-open, return auth URL instead"
},
{
"name": "--redirect-uri",
"type": "named",
"description": "OAuth redirect URI (default: ephemeral loopback)"
},
{
"name": "--service-account-key-file",
"type": "named",
"description": "Path to service account JSON key file (overrides GOOGLE_SERVICE_ACCOUNT_KEY_FILE env var)"
},
{
"name": "--resource-store-uri",
"type": "named",
"description": "Override resource store URI for exported files"
},
{
"name": "--base-url",
"type": "named",
"description": "Override base URL for HTTP transport (used for OAuth/DCR endpoints and file links)"
},
{
"name": "--log-level",
"type": "named",
"choices": [
"debug",
"info",
"warn",
"error"
],
"description": "Override logging level"
}
],
"runtimeArguments": [
{
"name": "-y",
"type": "named"
}
],
"environmentVariables": [
{
"name": "GOOGLE_CLIENT_ID",
"isRequired": true,
"description": "Google OAuth client ID (required for OAuth authentication modes)",
"placeholder": "123456789-abcdefghijk.apps.googleusercontent.com"
},
{
"name": "GOOGLE_CLIENT_SECRET",
"isSecret": true,
"description": "Google OAuth client secret (optional for public clients)",
"placeholder": "GOCSPX-abcdefghijklmnop"
},
{
"name": "GOOGLE_SERVICE_ACCOUNT_KEY_FILE",
"description": "Path to service account JSON key file (required for service-account auth mode)",
"placeholder": "/path/to/service-account-key.json"
},
{
"name": "AUTH_MODE",
"value": "loopback-oauth",
"choices": [
"loopback-oauth",
"service-account"
],
"description": "Authentication mode",
"placeholder": "loopback-oauth"
},
{
"name": "HEADLESS",
"default": "false",
"description": "Disable browser auto-open, return auth URL instead (true/false)",
"placeholder": "false"
},
{
"name": "REDIRECT_URI",
"description": "OAuth redirect URI (optional, default: ephemeral loopback)",
"placeholder": "http://localhost:{PORT}/oauth/callback"
},
{
"name": "RESOURCE_STORE_URI",
"value": "file://~/.mcp-z/mcp-sheets/files",
"description": "Resource store URI for exported files (file://)",
"placeholder": "file://~/.mcp-z/mcp-sheets/files"
},
{
"name": "PORT",
"description": "HTTP server port (overrides --port)",
"placeholder": "3000"
},
{
"name": "BASE_URL",
"description": "Base URL for HTTP transport (used for OAuth/DCR endpoints and file links)",
"placeholder": "http://localhost:{PORT}"
},
{
"name": "LOG_LEVEL",
"value": "info",
"choices": [
"debug",
"info",
"warn",
"error"
],
"description": "Logging level",
"placeholder": "info"
}
]
},
{
"version": "2.4.2",
"transport": {
"url": "http://localhost:{PORT}/mcp",
"type": "streamable-http"
},
"identifier": "@mcp-z/mcp-sheets",
"runtimeHint": "npx",
"registryType": "npm",
"packageArguments": [
{
"name": "--port",
"type": "named",
"value": "9004",
"description": "HTTP server port"
},
{
"name": "--auth",
"type": "named",
"choices": [
"loopback-oauth",
"service-account",
"dcr"
],
"description": "Authentication mode"
},
{
"name": "--headless",
"type": "named",
"description": "Disable browser auto-open, return auth URL instead"
},
{
"name": "--redirect-uri",
"type": "named",
"description": "OAuth redirect URI (default: ephemeral loopback)"
},
{
"name": "--service-account-key-file",
"type": "named",
"description": "Path to service account JSON key file (overrides GOOGLE_SERVICE_ACCOUNT_KEY_FILE env var)"
},
{
"name": "--dcr-mode",
"type": "named",
"choices": [
"self-hosted",
"external"
],
"description": "DCR mode"
},
{
"name": "--dcr-verify-url",
"type": "named",
"description": "External verification endpoint URL (required for external DCR mode)"
},
{
"name": "--dcr-store-uri",
"type": "named",
"description": "DCR client storage URI (for self-hosted DCR mode)"
},
{
"name": "--resource-store-uri",
"type": "named",
"description": "Override resource store URI for exported files"
},
{
"name": "--base-url",
"type": "named",
"description": "Override base URL for HTTP transport (used for OAuth/DCR endpoints and file links)"
},
{
"name": "--log-level",
"type": "named",
"choices": [
"debug",
"info",
"warn",
"error"
],
"description": "Override logging level"
}
],
"runtimeArguments": [
{
"name": "-y",
"type": "named"
}
],
"environmentVariables": [
{
"name": "GOOGLE_CLIENT_ID",
"isRequired": true,
"description": "Google OAuth client ID (required for OAuth authentication modes)",
"placeholder": "123456789-abcdefghijk.apps.googleusercontent.com"
},
{
"name": "GOOGLE_CLIENT_SECRET",
"isSecret": true,
"description": "Google OAuth client secret (optional for public clients)",
"placeholder": "GOCSPX-abcdefghijklmnop"
},
{
"name": "GOOGLE_SERVICE_ACCOUNT_KEY_FILE",
"description": "Path to service account JSON key file (required for service-account auth mode)",
"placeholder": "/path/to/service-account-key.json"
},
{
"name": "AUTH_MODE",
"value": "loopback-oauth",
"choices": [
"loopback-oauth",
"service-account",
"dcr"
],
"description": "Authentication mode",
"placeholder": "loopback-oauth"
},
{
"name": "HEADLESS",
"default": "false",
"description": "Disable browser auto-open, return auth URL instead (true/false)",
"placeholder": "false"
},
{
"name": "REDIRECT_URI",
"description": "OAuth redirect URI (optional, default: ephemeral loopback)",
"placeholder": "http://localhost:{PORT}/oauth/callback"
},
{
"name": "DCR_MODE",
"choices": [
"self-hosted",
"external"
],
"default": "self-hosted",
"description": "Dynamic Client Registration mode",
"placeholder": "self-hosted"
},
{
"name": "DCR_VERIFY_URL",
"description": "External verification endpoint URL (required for external DCR mode)",
"placeholder": "https://example.com/verify"
},
{
"name": "DCR_STORE_URI",
"default": "file://~/.mcp-z/mcp-sheets/dcr.json",
"description": "DCR client storage URI (for self-hosted DCR mode)",
"placeholder": "file://~/.mcp-z/mcp-sheets/dcr.json"
},
{
"name": "RESOURCE_STORE_URI",
"value": "file://~/.mcp-z/mcp-sheets/files",
"description": "Resource store URI for exported files (file://)",
"placeholder": "file://~/.mcp-z/mcp-sheets/files"
},
{
"name": "PORT",
"description": "HTTP server port (overrides --port)",
"placeholder": "3000"
},
{
"name": "BASE_URL",
"description": "Base URL for HTTP transport (used for OAuth/DCR endpoints and file links)",
"placeholder": "http://localhost:{PORT}"
},
{
"name": "LOG_LEVEL",
"value": "info",
"choices": [
"debug",
"info",
"warn",
"error"
],
"description": "Logging level",
"placeholder": "info"
}
]
}
],
"websiteUrl": "https://github.com/mcp-z/mcp-sheets#readme",
"description": "Google Sheets integration with OAuth, spreadsheet management, batch operations, and formatting"
}
}