Google Sheets MCP Server
Allows reading and writing to Google Sheets using API key or service account authentication.
This server does not currently have a deployable release on Glama. Follow the repository's setup instructions to install and configure it for your MCP client, including any required credentials and local dependencies.
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.
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelog…
This server cannot be deployed
Maintenance
Related MCP Connectors
Read and write Google Sheets with your own service account: list tabs, read, append, update, export.
Google Sheets via Apify: write Apify datasets or JSON rows to a sheet, or read a sheet as JSON.
Write rows to Google Sheets (append, replace, update by key) or read a tab. No OAuth needed.
Query your Google Sheets as structured JSON: list sheets and tabs, read schemas, filter rows.
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.152 npmMIT
- AlicenseBqualityDmaintenanceProvides tools for reading, modifying, and analyzing Google Sheets, as well as searching and managing Google Drive spreadsheets with access control.25MIT
- AlicenseNot gradedqualityCmaintenanceEnables full CRUD over Google Sheets through a service account, including reading tabs and rows, finding rows by column value, appending, updating, deleting rows, and managing tabs.MIT