Pricing

from $0.05 / 1,000 row writtens

Try for free

Go to Apify Store

Google Sheets Import & Export (No OAuth, Reliable)

Try for free

Append, replace, upsert or read Google Sheets from any dataset. No Google sign-in to expire: just share the sheet. Chunked writes with retries, automatic new columns and clear error messages.

Pricing

from $0.05 / 1,000 row writtens

Rating

0.0

(0)

Developer

Stubborn Otter Software

Actor stats

Bookmarked

Total users

Monthly active users

4 days ago

Last modified

Categories

Google Sheet link

spreadsheet

Required

Paste your sheet's address from the browser (any Google Sheets link or ID works). The example link is our demo sheet: replace it with yours. Before the first run, click Share in your sheet and add this Actor's service account email (shown in the README) as Editor.

Type:string

What to do

mode

Optional

Append adds rows after the existing data. Replace clears the tab first. Upsert updates rows whose key column(s) match and appends the rest. Read exports the tab to this run's dataset.

Type:string

Default:append

Options:

appendreplaceupsertread

Tab name

sheetName

Optional

Which tab to use. Created automatically if it doesn't exist. Leave empty for the tab in your link (or the first tab).

Type:string

Dataset to write

datasetId

Optional

Pick the Apify dataset whose items become rows. In an integration (running after another Actor), set this to {{resource.defaultDatasetId}}.

Type:string

...or paste rows as JSON

data

Optional

A list of objects, one per row. Nested fields become columns like 'price.value'.

Type:array

Key column(s) for upsert

keyColumns

Optional

Columns that identify a row, e.g. 'url' or 'id'. Only used in upsert mode.

Type:array

Where to append

insertAt

Optional

Append below the existing rows (default) or at the top, right under the header row. Only used in append mode.

Type:string

Default:bottom

Options:

bottomtop

Only these columns (optional)

columns

Optional

Limit and order the columns written. Leave empty to write every field.

Type:array

Treat values as

valueInputOption

Optional

Plain values (default) write text exactly as given, so scraped text starting with '=' can't run as a formula. 'As if typed' lets Google interpret formulas, dates and numbers.

Type:string

Default:RAW

Options:

RAWUSER_ENTERED

Your own service account key (optional)

serviceAccountKey

Optional

Advanced: paste a Google Cloud service account JSON key to use your own account instead of ours. Share the sheet with that account's email.

Type:string

Dry run

dryRun

Optional

Check everything and report what would change, without writing.

Type:boolean

Default:false

GCP Uploader

circ_le/gcp-uploader

Upload datasets and KV store records to Google cloud storage

Cir◎cle

5.0

(1)

Firestore Import

drobnikj/firestore-import

Imports dataset items to Firestone DB.

Jakub Drobník

Engage Bay — Sushidata

sushidata/sushidata-engage-bay

Sushidata

Google Sheets Import and Export for Apify

bepolabs/google-sheets

Import tabs from a shared workbook, or export a dataset: append below the last entry, replace a tab, or merge by ID. Needs a service account for writing; public links read freely.

BEPO Labs

Google Sheets Import & Export (Reliable)

ensorcelling_melilot/google-sheets-sync

ensorcelling _melilot

Google Sheets Import & Export – Read, Append & Dedupe Rows

openharvest/google-sheets-import-export

Google Sheets import and export for Apify: read any sheet into a dataset, or append, replace and dedupe-append dataset or JSON rows into Google Sheets. Service-account key (no OAuth pop-ups) or keyless read of public sheets. Connect any Actor via datasetId.

Enes Bulanık

Google Sheets Export: Apify Dataset to Sheets

fernandosord/google-sheets-export

Write an Apify dataset, JSON URL or JSON array to a Google Sheets tab. Append, replace, upsert by key or append only new rows. New fields become new columns instead of breaking the run. Uses your own service account key; no Google sign-in prompt.

Plainsource

AI Visibility Tracker: ChatGPT, Gemini, Perplexity & AI Mode

brightgro/ai-visibility-check

Check whether ChatGPT, Gemini, Perplexity and Google AI Mode name your brand when people ask your prompts. For each prompt and engine: mentioned or not, how often, whether your domain is cited, which competitors appear, and the cited domains.

Brightgro LLC

Google Sheets Sync – Read, Append, Replace (service account)

petipeti/google-sheets-sync

Read, append or replace Google Sheets data from Apify datasets or JSON using your own Google service account. Retries Google quota errors instead of failing, restores the sheet if a replace fails.