Connect AI assistants to Google Sheets through controlled tools for reading and updating rows.
Setup
Choose your client, copy the config, then fill in any required environment variables.
claude mcp add --transport http sheet-best https://mcp.sheetbest.com/ --header 'Authorization: <AUTHORIZATION>'~/.codex/config.toml
[mcp_servers.sheet-best]
url = "https://mcp.sheetbest.com/"
http_headers = { Authorization = "<AUTHORIZATION>" }
# codex mcp add sheet-best --url https://mcp.sheetbest.com/~/.cursor/mcp.json
{
"mcpServers": {
"sheet-best": {
"url": "https://mcp.sheetbest.com/",
"headers": {
"Authorization": "<AUTHORIZATION>"
}
}
}
}.vscode/mcp.json
{
"servers": {
"sheet-best": {
"type": "http",
"url": "https://mcp.sheetbest.com/",
"headers": {
"Authorization": "<AUTHORIZATION>"
}
}
}
}~/.gemini/settings.json
{
"mcpServers": {
"sheet-best": {
"httpUrl": "https://mcp.sheetbest.com/",
"headers": {
"Authorization": "<AUTHORIZATION>"
}
}
}
}claude_desktop_config.json · Customize › Connectors › Add custom connector
{
"mcpServers": {
"sheet-best": {
"command": "npx",
"args": [
"-y",
"mcp-remote",
"https://mcp.sheetbest.com/",
"--header",
"Authorization:<AUTHORIZATION>"
]
}
}
}.trae/mcp.json
{
"mcpServers": {
"sheet-best": {
"url": "https://mcp.sheetbest.com/",
"headers": {
"Authorization": "<AUTHORIZATION>"
}
}
}
}