Google Sheets MCP Server
Allows reading and writing to Google Sheets using API key or service account authentication.
Click on "Install 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: Google Sheets MCP Server
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 installed
Maintenance
Resources
Unclaimed servers have limited discoverability.
Looking for Admin?
If you are the server author, to access and configure the admin panel.
Latest Blog Posts
- Your AI Chatbot Just Exposed Your CEO's Salary to an InternBy Om-Shree-0709 on .Agent IdentityMCP SecurityOAuth Delegation
- Why MCP Servers Need Execution Sandboxing (And Why Your Current Stack Isn't Enough)By Om-Shree-0709 on .Agentic AiPrompt InjectionWebAssembly
MCP directory API
We provide all the information about MCP servers via our MCP API.
curl -X GET 'https://glama.ai/api/mcp/v1/servers/guigatrotta/gsheets-mcp-chatgpt-gt'
If you have feedback or need assistance with the MCP directory API, please join our Discord server