Skip to main content
Glama
guigatrotta

Google Sheets MCP Server

by guigatrotta

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:

Deploy to Workers

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-authless

Related 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

GOOGLE_API_KEY

Opcional: leitura pública (read_sheet) com chave de API.

GOOGLE_SERVICE_ACCOUNT_JSON

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 → SettingsVariables and SecretsAddSecret → 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:

  1. Go to https://playground.ai.cloudflare.com/

  2. Enter your deployed MCP server URL (remote-mcp-server-authless.<your-account>.workers.dev/mcp)

  3. 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.

F
license - not found
-
quality - not tested
D
maintenance

Maintenance

Maintainers
Response time
Release cycle
Releases (12mo)
Commit activity

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

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