Google Sheets Import & Export (Ctrio Lab)
Writes Apify datasets or JSON rows to Google Sheets, or reads a sheet back as JSON
- 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-exportAdd to ~/.cursor/mcp.json
{
"mcpServers": {
"google-sheets": {
"url": "https://mcp.apify.com?tools=ctriolab/google-sheets-import-export"
}
}
}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)

Ha MCP
MCP serverMCP server for managing and automating Home Assistant from AI assistants
Runs locally- 8 tools
- Open source
- 7.9K GitHub stars
- Productivity

Concord MCP
MCP serverLocal-first MCP server for messaging and shared work-state between coding agents
Runs locally- Freemium
- 1.3K GitHub stars
- Developer tools

note1
MCP serverMCP server giving AI assistants search and summaries across your note1 meetings
- 4 tools
- Remote
- Free trial
- 1 GitHub star
- Productivity

ASTra
MCP serverLet agents read, edit, validate and undo Word .docx files with exact operations
Runs locally- 5 tools
- Freemium
- Files and documents

CalderFlow
MCP serverTurn notes or specs into editable flowcharts, timelines and funnels from an AI assistant
- 10 tools
- Remote
- Free
- Design and media

CARTESIAN ECU
MCP serverCheck and repair ECU and TCU flash-file checksums from Claude (Ultimate plan)
Not checked yet- 5 tools
- Remote
- Paid
- Files and documents