Google Sheets MCP Server

io.github.joshuawhite389/google-sheets-mcp · v0.2.0

Read and write Google Sheets with your own service account: list tabs, read, append, update, export.

Website Source code Set it up

Connect Remote server

Terminal

claude mcp add --transport http google-sheets-mcp https://oldjard--google-sheets-mcp.apify.actor/mcp --header "Authorization: Bearer <YOUR_API_KEY>" --header "X-Google-Service-Account-Key: <X_GOOGLE_SERVICE_ACCOUNT_KEY>"

~/.cursor/mcp.json

{
  "mcpServers": {
    "google-sheets-mcp": {
      "url": "https://oldjard--google-sheets-mcp.apify.actor/mcp",
      "headers": {
        "Authorization": "Bearer <YOUR_API_KEY>",
        "X-Google-Service-Account-Key": "<X_GOOGLE_SERVICE_ACCOUNT_KEY>"
      }
    }
  }
}

.vscode/mcp.json

{
  "servers": {
    "google-sheets-mcp": {
      "type": "http",
      "url": "https://oldjard--google-sheets-mcp.apify.actor/mcp",
      "headers": {
        "Authorization": "Bearer <YOUR_API_KEY>",
        "X-Google-Service-Account-Key": "<X_GOOGLE_SERVICE_ACCOUNT_KEY>"
      }
    }
  }
}

Claude Desktop

Settings > Connectors > Add custom connector
URL: https://oldjard--google-sheets-mcp.apify.actor/mcp

Replace the values in angle brackets with your own. Keys stay on your machine; we never see them.

Tools

This server asks for a key before it lists its tools. Connect it with your own key to see them.

Headers

Name	Description
`Authorization` Required, secret	Bearer <your Apify API token>. The hosted server is billed per successful tool call to your Apify account.
`X-Google-Service-Account-Key` Required, secret	Your Google service account JSON key, base64-encoded on one line (base64 -w0 key.json).

Details

Endpoint	`https://oldjard--google-sheets-mcp.apify.actor/mcp` (Streamable HTTP)
First published	21 Oct 2026
Last updated	21 Oct 2026
Registry name	`io.github.joshuawhite389/google-sheets-mcp`

More search and web servers See all

Live status

Live, key required

Typical response: 389 ms
Answered: 100% of 2 checks
Last check: 13 Nov 2026

30 days agoToday

We connect daily without credentials and run initialize and tools/list.

Pair it with live search

Agents that use Google Sheets MCP Server often also need current facts. NestDaddy MCP gives your AI today's internet: web search, real-time breaking news and full page reading in one connector.

See NestDaddy MCP

For maintainers

[![NestDaddy MCP](https://nestdaddy.com/mcp/servers/io-github-joshuawhite389-google-sheets-mcp/badge.svg)](https://nestdaddy.com/mcp/servers/io-github-joshuawhite389-google-sheets-mcp)

Add the badge to your README. It turns green while your server passes our daily check. Listing details come from the official MCP registry; update them there.

Listing data from the official MCP registry. Status and tools from NestDaddy's daily check. Browse all MCP servers.