mcp gsheets for Claude Code

io.github.freema/mcp-gsheets

MCP server for Google Sheets API — read, write, format, batch operations.

client:Claude Code transport:stdio runtime:npm

Install mcp gsheets in Claude Code

run in your project directory

claude mcp add mcp-gsheets -e GOOGLE_PROJECT_ID=<GOOGLE_PROJECT_ID> -e GOOGLE_APPLICATION_CREDENTIALS=<GOOGLE_APPLICATION_CREDENTIALS> -e GOOGLE_SERVICE_ACCOUNT_KEY=<GOOGLE_SERVICE_ACCOUNT_KEY> -e GOOGLE_PRIVATE_KEY=<GOOGLE_PRIVATE_KEY> -e GOOGLE_CLIENT_EMAIL=<GOOGLE_CLIENT_EMAIL> -- npx -y mcp-gsheets

Adds it for this project only. Append --scope user to make it available everywhere. Claude Code docs

mcp gsheets in other clients

Claude Desktop
Cursor
VS Code
Zed
Windsurf
Cline
Gemini CLI
Grok
LangChain

mcp gsheets MCP server