A local Google Sheets MCP server built for agent workflows in Claude Code and Claude Desktop: write API, script and file output into sheets, combine spreadsheets, refresh them on a schedule, across multiple Google accounts. Undo and formula-error checks on every write.
Setup
Choose your client, copy the config, then fill in any required environment variables.
claude mcp add sheets -- npx -y @sheetsmcp/server~/.codex/config.toml
[mcp_servers.sheets]
command = "npx"
args = ["-y", "@sheetsmcp/server"]
# codex mcp add sheets -- npx -y @sheetsmcp/server~/.cursor/mcp.json
{
"mcpServers": {
"sheets": {
"command": "npx",
"args": [
"-y",
"@sheetsmcp/server"
]
}
}
}.vscode/mcp.json
{
"servers": {
"sheets": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"@sheetsmcp/server"
]
}
}
}~/.gemini/settings.json
{
"mcpServers": {
"sheets": {
"command": "npx",
"args": [
"-y",
"@sheetsmcp/server"
]
}
}
}claude_desktop_config.json
{
"mcpServers": {
"sheets": {
"command": "npx",
"args": [
"-y",
"@sheetsmcp/server"
]
}
}
}.trae/mcp.json
{
"mcpServers": {
"sheets": {
"command": "npx",
"args": [
"-y",
"@sheetsmcp/server"
]
}
}
}