MCP server for Google Sheets: list, read, append, update, export a dataset. Your own service account. Hosted on Apify (pay per call) or self-hosted.
接入配置
选择客户端，复制配置，再按项目文档补齐环境变量。
claude mcp add --transport http google-sheets-server-joshuawhite389 https://oldjard--google-sheets-mcp.apify.actor/mcp --header 'Authorization: <AUTHORIZATION>' --header 'X-Google-Service-Account-Key: <X_GOOGLE_SERVICE_ACCOUNT_KEY>'~/.codex/config.toml
[mcp_servers.google-sheets-server-joshuawhite389]
url = "https://oldjard--google-sheets-mcp.apify.actor/mcp"
http_headers = { Authorization = "<AUTHORIZATION>", X-Google-Service-Account-Key = "<X_GOOGLE_SERVICE_ACCOUNT_KEY>" }
# codex mcp add google-sheets-server-joshuawhite389 --url https://oldjard--google-sheets-mcp.apify.actor/mcp~/.cursor/mcp.json
{
"mcpServers": {
"google-sheets-server-joshuawhite389": {
"url": "https://oldjard--google-sheets-mcp.apify.actor/mcp",
"headers": {
"Authorization": "<AUTHORIZATION>",
"X-Google-Service-Account-Key": "<X_GOOGLE_SERVICE_ACCOUNT_KEY>"
}
}
}
}.vscode/mcp.json
{
"servers": {
"google-sheets-server-joshuawhite389": {
"type": "http",
"url": "https://oldjard--google-sheets-mcp.apify.actor/mcp",
"headers": {
"Authorization": "<AUTHORIZATION>",
"X-Google-Service-Account-Key": "<X_GOOGLE_SERVICE_ACCOUNT_KEY>"
}
}
}
}~/.gemini/settings.json
{
"mcpServers": {
"google-sheets-server-joshuawhite389": {
"httpUrl": "https://oldjard--google-sheets-mcp.apify.actor/mcp",
"headers": {
"Authorization": "<AUTHORIZATION>",
"X-Google-Service-Account-Key": "<X_GOOGLE_SERVICE_ACCOUNT_KEY>"
}
}
}
}claude_desktop_config.json · Customize › Connectors › Add custom connector
{
"mcpServers": {
"google-sheets-server-joshuawhite389": {
"command": "npx",
"args": [
"-y",
"mcp-remote",
"https://oldjard--google-sheets-mcp.apify.actor/mcp",
"--header",
"Authorization:<AUTHORIZATION>",
"--header",
"X-Google-Service-Account-Key:<X_GOOGLE_SERVICE_ACCOUNT_KEY>"
]
}
}
}.trae/mcp.json
{
"mcpServers": {
"google-sheets-server-joshuawhite389": {
"url": "https://oldjard--google-sheets-mcp.apify.actor/mcp",
"headers": {
"Authorization": "<AUTHORIZATION>",
"X-Google-Service-Account-Key": "<X_GOOGLE_SERVICE_ACCOUNT_KEY>"
}
}
}
}