Loading MCP server directory, please wait...
Read and write Google Sheets with your own service account: list tabs, read, append, update, export.
npx @getmcp/cli add io.github.joshuawhite389/google-sheets-mcpRequires Node.js 18+. Community-contributed server. Review source before installing.
AuthorizationBearer <your Apify API token>. The hosted server is billed per successful tool call to your Apify account.
X-Google-Service-Account-KeyYour Google service account JSON key, base64-encoded on one line (base64 -w0 key.json).
Config file: ~/Library/Application Support/Claude/claude_desktop_config.json
{
"mcpServers": {
"io.github.joshuawhite389/google-sheets-mcp": {
"url": "https://oldjard--google-sheets-mcp.apify.actor/mcp",
"transport": "streamable-http",
"headers": {
"Authorization": "",
"X-Google-Service-Account-Key": ""
}
}
}
}