Skip to content
MCP server

Google Sheets Import & Export (Ctrio Lab)

Writes Apify datasets or JSON rows to Google Sheets, or reads a sheet back as JSON

Install
Pricing
Paid
Platforms
API, Web
Runs
Remotely
Version
0.1.0
Listing updated
1 day ago

About Google Sheets Import & Export (Ctrio Lab)

Google Sheets Import & Export (Ctrio Lab) is a paid MCP server for productivity. It runs as a hosted remote server, so there is nothing to install locally.

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.

Install

Run in a terminal

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

Add to Settings → Connectors → Add custom connector

https://mcp.apify.com?tools=ctriolab/google-sheets-import-export
Install in CursorOpens Cursor, which asks you to confirm. Or add it by hand:

Add to ~/.cursor/mcp.json

{
  "mcpServers": {
    "google-sheets": {
      "url": "https://mcp.apify.com?tools=ctriolab/google-sheets-import-export"
    }
  }
}
Install in VS CodeOpens VS Code, which asks you to confirm. Or add it by hand:

Add to .vscode/mcp.json

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

Add to ~/.codeium/windsurf/mcp_config.json

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

Add to your client's MCP settings (most use this shape)

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

What it does

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

Pricing

Paid

Pay per event: $0.002 per run plus $0.05 per 1,000 rows

Prices change. Check apify.com before you buy.

Google Sheets Import & Export (Ctrio Lab) 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 to Google Sheets Import & Export (Ctrio Lab)

  1. Ha MCP

    MCP server

    MCP server for managing and automating Home Assistant from AI assistants

    Runs locally
    • 8 tools
    • Open source
    • 7.9K GitHub stars
    • Productivity
  2. Concord MCP

    MCP server

    Local-first MCP server for messaging and shared work-state between coding agents

    Runs locally
    • Freemium
    • 1.3K GitHub stars
    • Developer tools
  3. note1

    MCP server

    MCP server giving AI assistants search and summaries across your note1 meetings

    • 4 tools
    • Remote
    • Free trial
    • 1 GitHub star
    • Productivity
  4. ASTra

    MCP server

    Let agents read, edit, validate and undo Word .docx files with exact operations

    Runs locally
    • 5 tools
    • Freemium
    • Files and documents
  5. CalderFlow

    MCP server

    Turn notes or specs into editable flowcharts, timelines and funnels from an AI assistant

    • 10 tools
    • Remote
    • Free
    • Design and media
  6. CARTESIAN ECU

    MCP server

    Check and repair ECU and TCU flash-file checksums from Claude (Ultimate plan)

    Not checked yet
    • 5 tools
    • Remote
    • Paid
    • Files and documents