Pricing

$0.50 / 1,000 row writtens

Try for free

Go to Apify Store

Google Sheets Import & Export (Reliable)

Try for free

Pricing

$0.50 / 1,000 row writtens

Rating

0.0

(0)

Developer

ensorcelling _melilot

Actor stats

Bookmarked

Total users

Monthly active users

9 days ago

Last modified

Categories

Spreadsheet URL or ID

spreadsheetId

Required

Paste the full Google Sheets URL or just its ID.

Type:string

Google service account key (JSON)

serviceAccountKey

Optional

Paste the whole JSON key file of a Google service account, then share your spreadsheet with that account's email as Editor. 2-minute setup in the README. Not needed to import a sheet shared as "Anyone with the link can view".

Type:string

Mode

mode

Optional

Export writes data into the sheet. Import reads the sheet into this run's dataset.

Type:string

Default:export

Options:

exportimport

Sheet (tab) name

sheetName

Optional

Created automatically if it doesn't exist.

Type:string

Default:Sheet1

Write mode

writeMode

Optional

Append adds rows below existing data. Replace clears the tab first. Upsert updates rows whose key already exists and adds the rest.

Type:string

Default:append

Options:

appendreplaceupsert

Key column (upsert)

keyColumn

Optional

Column that uniquely identifies a row, e.g. url or id.

Type:string

Dataset ID

datasetId

Optional

Dataset to export. When you add this Actor as an integration after another Actor, set this to {{resource.defaultDatasetId}}.

Type:string

Raw data (JSON array)

rawData

Optional

Alternatively, paste an array of objects to export.

Type:array

Only these fields

fields

Optional

Export only these top-level fields, in this order. Leave empty for all.

Type:array

Flatten nested data

flattenData

Optional

Turn nested objects into columns like address/city. If off, nested values are written as JSON text.

Type:boolean

Default:true

Flatten delimiter

delimiter

Optional

Separator used in flattened column names, e.g. address/city.

Type:string

Default:/

How Google reads values

valueInputOption

Optional

Raw keeps values exactly as they are (recommended; no surprise date or number conversions). User entered makes Google parse them like typed input, including formulas.

Type:string

Default:RAW

Options:

RAWUSER_ENTERED

Max rows

maxRows

Optional

Stop after this many rows. Leave empty for no limit.

Type:integer

Minimum:1

Google Sheets Import & Export

lukaskrivka/google-sheets

Import data from datasets or JSON files to Google Sheets. Programmatically process data in Sheets. Easier and faster than the official Google Sheets API and perfect for importing data from scraping.

Lukáš Křivka

4.8

(7)

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

Google Sheet Exporter

jupri/google-sheet-exporter

💫 Export Dataset to GoogleSheet

cat

849

4.9

(4)

Dataset Merge & Dedup Datasets — Filter, Join CSV & Excel

saliga/dataset-merge-dedupe

Merge Apify datasets, CSV, JSON and Excel files or Google Sheets into one table. Clean fields, normalise URLs, extract domains, filter, remove duplicates and join (VLOOKUP) in one run. Works with limited permissions. CSV and Excel exports free. $0.50 per 1,000 output rows.

Salih Küçükkayış

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

Firestore Import

apify/firestore-import

Seamlessly import data from Apify datasets into Firebase Firestore database. This integration allows full control over document IDs, conflict resolution (overwrite, merge, skip), and data transformation using a custom JavaScript function.

Apify

5.0

(5)

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 Sheets Import & Export: No OAuth, 1,000 Rows Free

bridgeworks/sheets-bridge

Export any Apify dataset to Google Sheets, or import a sheet into a dataset, using your own service account: no OAuth screen, no expiring tokens. The first 1,000 rows of every run are free. Append, replace, or upsert rows. Works as a run integration on any scraper.

Bridgeworks

Export Datasets to SFTP, FTP, Dropbox & Google Drive

charlesmarkette/dataset-delivery-export-to-sftp-ftp-dropbox-google-drive

Deliver any scraper's dataset as a CSV, JSON, JSONL or Excel file (optionally gzipped) to your own SFTP or FTPS server, Dropbox or Google Drive after every run. Atomic uploads, SFTP host-key pinning, retries, and one destination failing never blocks the others. $0.0045 per file delivered.