Google Sheets MCP Server

Google Sheets MCP Server

An MCP server that lets Claude, Cursor or any other MCP client read and write your Google Sheets: list a spreadsheet's tabs, read ranges, append or update rows, and export an Apify dataset to a tab.

It signs in with your own Google service account, so there's no shared quota, no OAuth app to approve, and nothing that expires. The service account can only open sheets you share with it.

Two ways to use it:

Apify starts the server when your agent calls it and stops it when it goes quiet. It is paid per use, billed to your own Apify account (prices below).

• Hosted on Apify (no install): apify.com/oldjard/google-sheets-mcp.

• Self-hosted (free): clone this repo and run it yourself. Same code.

Tools

Values are written as plain values, never as formulas. One call reads or writes at most 5,000 rows. If a tool can't do something (sheet not shared, a wrong tab name, a missing key), it returns a plain-English fix, for example the exact email to share the sheet with.

Google setup (about 5 minutes, once)

You need a Google service account: a robot Google user that only gets access to the sheets you share with it. It's free, and Google asks for no billing details to use the Sheets API.

Enable.

1. Open console.cloud.google.com, create a project and select it.
2. Open the Google Sheets API page and click

1. IAM & Admin > Service Accounts > Create service account. Name it, skip the optional role step, click Done.
2. Open the service account, Keys > Add key > Create new key > JSON. A .json file downloads.
3. Copy its clientemail. Share each Google Sheet your agent should use with that email as Editor**.
4. Turn the key into one line of base64: base64 -w0 key.json (on macOS: base64 -i key.json).

Some Google Workspace organizations block service-account keys. If step 4 says key creation is disabled by policy, use a personal Google account for the project; the sheet can live anywhere as long as it's shared with the email.

Connect: hosted on Apify

Use the URL https://oldjard--google-sheets-mcp.apify.actor/mcp with two headers. For Claude Code:

claude mcp add --transport http google-sheets https://oldjard--google-sheets-mcp.apify.actor/mcp \
  --header "Authorization: Bearer <your Apify API token>" \
  --header "X-Google-Service-Account-Key: <the base64 line>"

Other clients take the same URL and headers in their JSON config.

Pricing (hosted): $0.001 per successful tool call, $0.0004 per row that export_dataset writes. Failed calls, header rows and rows skipped as duplicates are free. Each server start costs $0.00005. As with any Apify Standby Actor, Apify also bills the platform usage of the run while your agent is connected and for a short idle period after (the server runs at 256 MB, so this is a fraction of a cent per session). The key travels over HTTPS to your own run, is held in memory only, and is never logged or stored.

Connect: self-hosted

Needs Node.js 24 or newer.

git clone https://github.com/joshuawhite389/google-sheets-mcp && cd google-sheets-mcp
npm install
PORT=3000 npm run serve

Shortened. The full README is on GitHub.