# Google Sheets MCP Server

> Google Sheets MCP Server is a freemium MCP server for productivity. Read and write Google Sheets through your own service account, hosted or self-run. It runs as a hosted remote server, so there is nothing to install locally.

- **Kind:** MCP server
- **Pricing:** Freemium
- **Platforms:** API, self-hosted, Web
- **Website:** https://apify.com/oldjard/google-sheets-mcp
- **Repository:** https://github.com/joshuawhite389/google-sheets-mcp
- **MCP Registry name:** io.github.joshuawhite389/google-sheets-mcp
- **Categories:** productivity, files and documents
- **Listing updated:** 2026-11-15

## About

Access goes through a Google service account that you create, not through a shared OAuth app, so there is no common quota and nothing expires. The account can only open spreadsheets you have explicitly shared with it as Editor, and a missing share or wrong tab name comes back as a plain-English fix, such as the exact email address to share with.

Five tools cover the work: list_sheets, read_range, append_rows, update_range and export_dataset. Appended objects are matched to header names, and new fields become new columns; rows already in the tab can be skipped. Values are written as plain values, never formulas, and one call reads or writes at most 5,000 rows. export_dataset sends an Apify dataset into a tab by appending, replacing or adding only new rows.

There are two ways to run it. The hosted version runs on Apify and is billed to your Apify account at $0.001 per successful tool call and $0.0004 per exported row, with failed calls free, plus Apify's platform usage. Alternatively, clone the repository and run it yourself on Node.js 24 or newer. Your base64-encoded key is sent in a header over HTTPS and held in memory only.

## Features

- **Five sheet tools:** List tabs, read ranges, append rows, update ranges and export datasets.
- **Your own service account:** No OAuth app to approve and no shared quota.
- **Header-aware appends:** Objects map to column names and new fields create columns.
- **Paged reads:** Long tabs return in pages with the next range to read.
- **Apify dataset export:** Write a dataset into a tab as append, replace or new rows only.
- **Hosted or self-run:** Use the pay-per-use Apify actor or run the code yourself.

## Good for

- Have an assistant log new leads to a sheet
- Read a range of cells to answer a question
- Fix a batch of cells in place
- Push scraped results from an Apify dataset into a tab
- Check which tabs exist in a spreadsheet

## Install

### Claude Code (Terminal)

```sh
claude mcp add --transport http google-sheets-mcp https://oldjard--google-sheets-mcp.apify.actor/mcp
```

### Claude Desktop (Settings → Connectors → Add custom connector)

```sh
https://oldjard--google-sheets-mcp.apify.actor/mcp
```

### Cursor (~/.cursor/mcp.json)

```json
{
  "mcpServers": {
    "google-sheets-mcp": {
      "url": "https://oldjard--google-sheets-mcp.apify.actor/mcp"
    }
  }
}
```

### VS Code (.vscode/mcp.json)

```json
{
  "servers": {
    "google-sheets-mcp": {
      "type": "http",
      "url": "https://oldjard--google-sheets-mcp.apify.actor/mcp"
    }
  }
}
```

### Windsurf (~/.codeium/windsurf/mcp_config.json)

```json
{
  "mcpServers": {
    "google-sheets-mcp": {
      "serverUrl": "https://oldjard--google-sheets-mcp.apify.actor/mcp"
    }
  }
}
```

### Other clients (your client's MCP settings (most use this shape))

```json
{
  "mcpServers": {
    "google-sheets-mcp": {
      "type": "http",
      "url": "https://oldjard--google-sheets-mcp.apify.actor/mcp"
    }
  }
}
```

## Tools

- `list_sheets`: Lists a spreadsheet's tabs with size and link.
- `read_range`: Reads cells from a range or whole tab, paging long results.
- `append_rows`: Adds rows below the last one, matching objects to header names.
- `update_range`: Overwrites cells from a top-left cell and grows the tab if needed.
- `export_dataset`: Writes an Apify dataset to a tab by appending, replacing or adding only new rows.

## FAQ

### How is the hosted version billed?

$0.001 per successful tool call and $0.0004 per exported row, plus Apify platform usage.

### Can it write formulas?

No. Values are written as plain values.

### How many rows per call?

At most 5,000.

### Is self-hosting free?

The README says yes; it needs Node.js 24 or newer.

### Which sheets can it open?

Only those shared with your service account's email.

### Is Google Sheets MCP Server free?

Google Sheets MCP Server has a free plan, with paid plans for more usage or features.

### How do I add Google Sheets MCP Server to Claude Code?

Run this command in your terminal: claude mcp add --transport http google-sheets-mcp https://oldjard--google-sheets-mcp.apify.actor/mcp

### What are the best alternatives to Google Sheets MCP Server?

The closest alternatives to Google Sheets MCP Server are Ha MCP, Concord MCP, note1, ASTra and CalderFlow.

## Alternatives

- [Ha MCP](https://ai-powered.com/mcp/ha-mcp): Ha MCP is an open-source MCP server for productivity.
- [Concord MCP](https://ai-powered.com/mcp/concord-mcp): Concord MCP is a freemium MCP server for developer tools.
- [note1](https://ai-powered.com/mcp/note1): note1 is an MCP server for productivity.
- [ASTra](https://ai-powered.com/mcp/astra): ASTra is a freemium MCP server for files and documents.
- [CalderFlow](https://ai-powered.com/mcp/calderflow): CalderFlow is a free MCP server for design and media.
- [CARTESIAN ECU](https://ai-powered.com/mcp/cartesian-ecu): CARTESIAN ECU is a paid MCP server for files and documents.
- [nicemails](https://ai-powered.com/mcp/nicemails): nicemails is a freemium MCP server for communication.
- [Invoices](https://ai-powered.com/mcp/invoices): Invoices is a paid MCP server for files and documents.

---
Source: https://ai-powered.com/mcp/google-sheets-mcp-server
