# Google Sheets Import & Export (Ctrio Lab)

> Google Sheets Import & Export (Ctrio Lab) is a paid MCP server for productivity. Writes Apify datasets or JSON rows to Google Sheets, or reads a sheet back as JSON. It runs as a hosted remote server, so there is nothing to install locally.

- **Kind:** MCP server
- **Pricing:** Paid
- **Platforms:** API, Web
- **Website:** https://apify.com/ctriolab/google-sheets-import-export
- **MCP Registry name:** com.ctriolab/google-sheets
- **Categories:** productivity, files and documents
- **Listing updated:** 2026-11-16

## About

Most failed sheet exports come from setup, and this Apify Actor checks the key, sheet access, tab, range and Google's limits before writing anything. Errors name the fix, for example which service account email to share the sheet with.

Export can append or replace rows from a dataset or inline JSON, skip duplicates by a key column, and map, order or rename columns. Replace writes new data first and clears old rows afterwards, so the sheet is never left empty, and values are written as-is to avoid formula injection. Import reads a whole tab or an A1 range, and public sheets can be read without a key.

Authentication uses a Google service account key rather than an expiring login, so scheduled runs keep working. Pricing is pay per event: $0.002 per run start and $0.05 per 1,000 rows read or written, with skipped duplicates free.

## Features

- **Append or replace:** Writes dataset rows into a tab in either mode.
- **Duplicate skipping:** Skips rows matching a key column such as url or id.
- **Column mapping:** Keep, order or rename columns.
- **Sheet import:** Reads a tab or A1 range into a dataset as JSON or CSV.
- **Service account key:** No expiring login, so scheduled runs continue.
- **Retry on quota errors:** Backs off and retries on Google 429 responses.

## Good for

- Send scraper results to a Leads sheet after each run
- Read a sheet of URLs into a dataset
- Keep a sheet free of duplicate rows
- Refresh a report tab with a full replace

## Install

### Claude Code (Terminal)

```sh
claude mcp add --transport http google-sheets 'https://mcp.apify.com?tools=ctriolab/google-sheets-import-export'
```

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

```sh
https://mcp.apify.com?tools=ctriolab/google-sheets-import-export
```

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

```json
{
  "mcpServers": {
    "google-sheets": {
      "url": "https://mcp.apify.com?tools=ctriolab/google-sheets-import-export"
    }
  }
}
```

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

```json
{
  "servers": {
    "google-sheets": {
      "type": "http",
      "url": "https://mcp.apify.com?tools=ctriolab/google-sheets-import-export"
    }
  }
}
```

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

```json
{
  "mcpServers": {
    "google-sheets": {
      "serverUrl": "https://mcp.apify.com?tools=ctriolab/google-sheets-import-export"
    }
  }
}
```

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

```json
{
  "mcpServers": {
    "google-sheets": {
      "type": "http",
      "url": "https://mcp.apify.com?tools=ctriolab/google-sheets-import-export"
    }
  }
}
```

## FAQ

### Does it need a Google login?

It uses a service account JSON key that you share the sheet with; public sheets can be read without one.

### What does it cost?

$0.002 per run and $0.05 per 1,000 rows read or written; skipped duplicates are free.

### Can it exceed Google's limits?

It checks the 10,000,000 cell limit before writing.

### Can it create tabs on import?

No. Import does not create tabs.

### Is Google Sheets Import & Export (Ctrio Lab) free?

No. Google Sheets Import & Export (Ctrio Lab) is a paid product.

### How do I add Google Sheets Import & Export (Ctrio Lab) to Claude Code?

Run this command in your terminal: claude mcp add --transport http google-sheets 'https://mcp.apify.com?tools=ctriolab/google-sheets-import-export'

### What are the best alternatives to Google Sheets Import & Export (Ctrio Lab)?

The closest alternatives to Google Sheets Import & Export (Ctrio Lab) 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-import-and-export-ctrio-lab
