Google Sheets MCP Server
Allows reading and writing to Google Sheets using API key or service account authentication.
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@Google Sheets MCP Serverread the first 10 rows from my Google Sheet 'Budget'"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
Building a Remote MCP Server on Cloudflare (Without Auth)
This example allows you to deploy a remote MCP server that doesn't require authentication on Cloudflare Workers.
Get started:
This will deploy your MCP server to a URL like: remote-mcp-server-authless.<your-account>.workers.dev/mcp
Alternatively, you can use the command line below to get the remote MCP Server created on your local machine:
npm create cloudflare@latest -- my-mcp-server --template=cloudflare/ai/demos/remote-mcp-authlessRelated MCP server: mcp-google_sheets
Customizing your MCP Server
To add your own tools to the MCP server, define each tool inside the init() method of src/index.ts using this.server.tool(...).
Google Sheets: secrets no Cloudflare Worker
Este projeto lê planilhas com API key e/ou service account; escrever (update_cell) usa somente service account.
Nome do secret / variável | Uso |
| Opcional: leitura pública ( |
| Obrigatório para escrita: JSON completo da conta de serviço Google (projeto GCP → IAM → service account → chaves JSON). |
No dashboard Cloudflare: Workers & Pages → seu worker → Settings → Variables and Secrets → Add → Secret → nome GOOGLE_SERVICE_ACCOUNT_JSON → colar o JSON (idealmente minificado em uma linha).
CLI: npx wrangler secret put GOOGLE_SERVICE_ACCOUNT_JSON (o comando pede o valor de forma segura).
No Google Sheets, compartilhe a planilha com o endereço client_email do JSON (permissão de editor) para a service account conseguir gravar.
Connect to Cloudflare AI Playground
You can connect to your MCP server from the Cloudflare AI Playground, which is a remote MCP client:
Enter your deployed MCP server URL (
remote-mcp-server-authless.<your-account>.workers.dev/mcp)You can now use your MCP tools directly from the playground!
Connect Claude Desktop to your MCP server
You can also connect to your remote MCP server from local MCP clients, by using the mcp-remote proxy.
To connect to your MCP server from Claude Desktop, follow Anthropic's Quickstart and within Claude Desktop go to Settings > Developer > Edit Config.
Update with this configuration:
{
"mcpServers": {
"calculator": {
"command": "npx",
"args": [
"mcp-remote",
"http://localhost:8787/mcp" // or remote-mcp-server-authless.your-account.workers.dev/mcp
]
}
}
}Restart Claude and you should see the tools become available.
This server cannot be deployed
Maintenance
Related MCP Connectors
Query your Google Sheets as structured JSON: list sheets and tabs, read schemas, filter rows.
Connect AI assistants to Google Sheets through controlled tools for reading and updating rows.
Permissioned access to Gmail, Drive and Calendar via the user's own Google account
Google Docs MCP Pack — read, create, and edit Google Docs via OAuth.
Related MCP Servers
- AlicenseNot gradedqualityDmaintenanceEnables AI agents to read, write, and manage Google Sheets using the Google Sheets API v4.MIT
- AlicenseNot gradedqualityCmaintenanceEnables reading, writing, appending, and creating Google Sheets spreadsheets through MCP tools, with support for exploring spreadsheet structure and creating new sheets.1 npmMIT
- AlicenseBqualityBmaintenanceProvides tools for reading, modifying, and analyzing Google Sheets, as well as searching and managing Google Drive spreadsheets with access control.25MIT
- AlicenseAqualityBmaintenanceEnables natural language reading, searching, and editing of Google Sheets via MCP, with options for read-only mode and OAuth or service account authentication.10MIT