MCP server
Google Sheets
Allow AI systems to read, write, and query spreadsheet data via Google Sheets.
- Pricing
- Open source
- Runs
- Locally or Remotely
- Version
- 1.2.1
- Listing updated
- 5 days ago
About Google Sheets
Google Sheets is an open-source MCP server. It can run locally on your machine or as a hosted remote server.
Install
Run in a terminal
claude mcp add google-sheets-mcp --env GOOGLE_ACCESS_TOKEN='<GOOGLE_ACCESS_TOKEN>' -- npx -y google-sheets-mcpAdd to claude_desktop_config.json
{
"mcpServers": {
"google-sheets-mcp": {
"command": "npx",
"args": [
"-y",
"google-sheets-mcp"
],
"env": {
"GOOGLE_ACCESS_TOKEN": "<GOOGLE_ACCESS_TOKEN>"
}
}
}
}Add to ~/.cursor/mcp.json
{
"mcpServers": {
"google-sheets-mcp": {
"command": "npx",
"args": [
"-y",
"google-sheets-mcp"
],
"env": {
"GOOGLE_ACCESS_TOKEN": "<GOOGLE_ACCESS_TOKEN>"
}
}
}
}Add to .vscode/mcp.json
{
"servers": {
"google-sheets-mcp": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"google-sheets-mcp"
],
"env": {
"GOOGLE_ACCESS_TOKEN": "<GOOGLE_ACCESS_TOKEN>"
}
}
}
}Add to ~/.codeium/windsurf/mcp_config.json
{
"mcpServers": {
"google-sheets-mcp": {
"command": "npx",
"args": [
"-y",
"google-sheets-mcp"
],
"env": {
"GOOGLE_ACCESS_TOKEN": "<GOOGLE_ACCESS_TOKEN>"
}
}
}
}Add to your client's MCP settings (most use this shape)
{
"mcpServers": {
"google-sheets-mcp": {
"command": "npx",
"args": [
"-y",
"google-sheets-mcp"
],
"env": {
"GOOGLE_ACCESS_TOKEN": "<GOOGLE_ACCESS_TOKEN>"
}
}
}
}Configuration
GOOGLE_ACCESS_TOKENGoogle OAuth access token with Sheets scopes.RequiredMCP_TRANSPORTTransport type.RequiredGOOGLE_CLIENT_IDGoogle OAuth client ID.RequiredGOOGLE_CLIENT_SECRETGoogle OAuth client secret.Required
Pricing
Open source
Google Sheets FAQ
Is Google Sheets free?
Yes. Google Sheets is open source, so you can use and self-host it for free.
How do I add Google Sheets to Claude Code?
Run this command in your terminal: claude mcp add google-sheets-mcp --env GOOGLE_ACCESS_TOKEN='<GOOGLE_ACCESS_TOKEN>' -- npx -y google-sheets-mcp