Under maintenance

Pricing

from $0.08 / 1,000 row writtens

Try for free

Go to Apify Store

Google Sheets Sync: Import, Export & Upsert Datasets

Under maintenance

Try for free

Export any Apify dataset or actor run to Google Sheets, or import a sheet into a dataset: append, replace, upsert by key or mirror sync, retried through Google's rate limits. Runs after any actor as an integration. Share the sheet once; no Google sign-in. $0.10 per 1,000 rows.

Pricing

from $0.08 / 1,000 row writtens

Rating

0.0

(0)

Developer

CleanPull

Actor stats

Bookmarked

Total users

Monthly active users

2 hours ago

Last modified

Categories

Integrations

Automation

Developer tools

You can access the Google Sheets Sync: Import, Export & Upsert Datasets programmatically from your own applications by using the Apify API. You can also choose the language preference from below. To use the Apify API, you’ll need an Apify account and your API token, found in API & Integrations in Apify Console.

Python

JavaScript

CLI

OpenAPI

HTTP

MCP

$echo '{
<  "rawData": [
<    {
<      "sku": "SKU-1001",
<      "title": "Wireless headphones",
<      "price": 199,
<      "country": "US",
<      "inStock": true
<    },
<    {
<      "sku": "SKU-1002",
<      "title": "Air fryer 4 qt",
<      "price": 79.99,
<      "country": "US",
<      "inStock": true
<    },
<    {
<      "sku": "SKU-1003",
<      "title": "Desk lamp",
<      "price": 34.5,
<      "country": "DE",
<      "inStock": false
<    },
<    {
<      "sku": "SKU-1004",
<      "title": "Travel mug",
<      "price": 24,
<      "country": "FR",
<      "inStock": true
<    }
<  ]
<}' |
<apify call cleanpull/google-sheets-sync --silent --output-dataset

Google Sheets Sync: Export Apify Data to Sheets API through CLI

The Apify CLI is the official tool that allows you to use Google Sheets Sync: Import, Export & Upsert Datasets locally, providing convenience functions and automatic retries on errors.

Install Apify CLI

Using installation script (macOS/Linux):

$curl -fsSL https://apify.com/install-cli.sh | bash

Using installation script (Windows):

$irm https://apify.com/install-cli.ps1 | iex

Using Homebrew:

$brew install apify-cli

Using npm:

$npm install -g apify-cli

Other API clients include:

Google Sheets Sync: Import, Export & Upsert Datasets API in Python

Google Sheets Sync: Import, Export & Upsert Datasets API in JavaScript

Google Sheets Sync: Import, Export & Upsert Datasets OpenAPI definition

Google Sheets Sync: Import, Export & Upsert Datasets API

GCP Uploader

circ_le/gcp-uploader

Upload datasets and KV store records to Google cloud storage

Cir◎cle

5.0

(1)

Google Sheets Import & Export — Fast, Reliable Sync

surefetch/google-sheets

Import Apify datasets, JSON or CSV into Google Sheets and export sheets back to JSON. Append, replace and read modes. Built for reliability: automatic retries, exponential backoff, no OAuth tokens that expire.

Jonas Eckl

1.0

(1)

Google Sheet Exporter

jupri/google-sheet-exporter

💫 Export Dataset to GoogleSheet

cat

849

4.9

(4)

Google Sheets Import & Export

cypherstone/google-sheets-import-export

Read a Google Sheet into a dataset (public sheets need no key) and write datasets or JSON back - append, replace, or upsert - using a service account, with no interactive OAuth and automatic rate-limit retries.

Jeff Ralston

📗 Google Sheets Import & Export — Free Reads, No OAuth

srd836/google-sheets-import-export

Reading is FREE: pull any link-shared Google Sheet into a dataset with zero setup — no API key, no OAuth, no Google Cloud project, no card. Add a service account key to write: append, replace or upsert with deduplication, straight from any Apify dataset. You only pay for rows written — $1 per 1,000.

David González

Kafka Integration

brasil-scrapers/kafka-integration

This integration facilitates the processing of data from an Apify dataset and its delivery to a Kafka topic. It is configured via a schema that includes details about the dataset, Kafka configuration, and batch processing size.

Brasil Scrapers

✨LLMO & AI Search Auditor - /llms.txt [ChatGPT/Perplexity]

invaluable_rondeau/llmo-ai-search-readiness-auditor

✅ Score any domain (0-100) for ChatGPT Search, Perplexity, Claude & Gemini citation readiness ($15/1k domains). ✅ Audits /llms.txt, robots.txt AI crawlers (GPTBot/ClaudeBot), Schema.org JSON-LD & auto-generates a ready-to-deploy /llms.txt file.

PROOFNEXA

Send Legacy PhantomJS Crawler Results

drobnikj/send-crawler-results

This actor downloads results from Legacy PhantomJS Crawler task and sends them to email as attachments. It is designed to run from finish webhook.

Jakub Drobník

Google Sheets Sync — Reliable Import & Export

gravelly_caladium/google-sheets-sync

Reliable Google Sheets import & export: send Apify datasets or JSON to a sheet (append, replace, upsert with merge, dedupe) or import a sheet to a dataset. Auto-grows the grid, handles schema drift, retries rate limits, clear error messages.

Relay Data Tools

Google Sheets URL Monitor Actor

dtrungtin/google-sheets-url-monitor-actor

Google Sheets URL Monitor turns a plain spreadsheets into a **no-code web monitoring dashboard**. It reads the URLs listed in your sheet's `URL` column, visits each page in a real browser, extracts the values you care about (prices, titles), and writes the fresh values straight back into the sheet.