Pricing

from $0.80 / 1,000 row writtens

Try for free

Go to Apify Store

Google Sheets Export & Sync for Apify Datasets

Try for free

Export an Apify dataset to Google Sheets: append, replace or upsert by key. Service account or Apps Script, works as an integration. $0.80 per 1,000 rows.

Pricing

from $0.80 / 1,000 row writtens

Rating

0.0

(0)

Developer

Ottomath

Actor stats

Bookmarked

Total users

Monthly active users

16 days ago

Last modified

Categories

Type

type

Optional

"summary" for the report of a run, "error" when something went wrong, "preview" for a run that only shows what it would write (all three are free).

Type:string

Example:

summary

Status

status

Optional

succeeded, stopped-early (maximum total charge or maxItems reached) or failed.

Type:string

Example:

succeeded

Message

message

Optional

The status message of the run.

Type:string

Example:

Done: appended 120 rows to "Sheet1" in "Leads".

Dataset ID

datasetId

Optional

The dataset that was exported, or read for a preview. Null when a preview used the built-in sample.

Type:string | null

Example:

WkzbQMuFYuamGv3YF

Spreadsheet ID

spreadsheetId

Optional

The spreadsheet that was written to.

Type:string | null

Example:

1AbCdEfGhIjKlMnOpQrStUvWxYz0123456789

Spreadsheet title

spreadsheetTitle

Optional

Title of the spreadsheet.

Type:string | null

Example:

Leads

Tab

sheetName

Optional

Name of the tab that was written to.

Type:string | null

Example:

Sheet1

Link to the tab

sheetUrl

Optional

Address of the tab in Google Sheets.

Type:string | null

Example:

https://docs.google.com/spreadsheets/d/1AbC.../edit#gid=0

Mode

mode

Optional

append, replace or upsert. "dry-run" in a preview item.

Type:string | null

Example:

append

Sign-in method

authMode

Optional

serviceAccount or appsScript.

Type:string | null

Example:

serviceAccount

Items read

rowsRead

Optional

Dataset items read in this run (at most 100 in a preview).

Type:integer

Example:

120

Rows appended

rowsAppended

Optional

Rows added to the tab (these are the charged rows, together with the updated rows).

Type:integer

Example:

120

Rows updated

rowsUpdated

Optional

Rows of the tab that were updated because their key matched (upsert only).

Type:integer

Example:

Items skipped

rowsSkipped

Optional

Items that were not written (in a preview: would not be written): no value in the key columns, a repeated key in the same batch (the last one is written) or an empty item.

Type:integer

Example:

Cells truncated

cellsTruncated

Optional

Cells cut to Google's limit of 50,000 characters.

Type:integer

Example:

Columns

columns

Optional

The columns of the tab after the run, in order. In a preview: the columns that would be written.

Type:string[]

Example:

[
  "url",
  "title",
  "price"
]

Items not read

itemsNotRead

Optional

Dataset items that were not read because the run stopped early.

Type:integer

Example:

Stopped early

stoppedEarly

Optional

chargeLimit or maxItems when the run stopped before the end of the dataset, otherwise null.

Type:string | null

Duration (ms)

durationMs

Optional

How long the run took.

Type:integer

Example:

4200

Error code

code

Optional

Error items only: a stable code. Input and dataset: INVALID_INPUT, NO_KEYS, DATASET_NOT_FOUND, DATASET_FORBIDDEN, DATASET_ERROR. Google: AUTH_FAILED, FORBIDDEN, NOT_FOUND, API_DISABLED, INVALID_TARGET, LIMIT, QUOTA, BAD_REQUEST, UNAVAILABLE, NETWORK, GOOGLE_ERROR. Apps Script: APPS_SCRIPT, APPS_SCRIPT_ACCESS, TOO_LARGE. Other: INTERNAL, INTERRUPTED.

Type:string

Example:

FORBIDDEN

Step

step

Optional

Error items only: what the Actor was doing, for example "append rows".

Type:string | null

Example:

append rows

HTTP status

httpStatus

Optional

Error items only: the HTTP status Google answered with, when there was one.

Type:integer | null

Example:

403

Reason

reason

Optional

Preview items only: why nothing was written, for example that no Google credentials were entered or that dryRun is on.

Type:string

Example:

No Google credentials were entered (neither a service account key nor an Apps Script web app address), so the Actor only shows what it would write and sends nothing to Google.

Sample rows

sampleRows

Optional

Preview items only: the first 5 rows that would be written, one object per row with the column names as keys. Text longer than 200 characters is shortened here.

Type:object[]

Example:

[
  {
    "id": "P-1001",
    "title": "Ceramic coffee mug",
    "price.amount": 12.9
  }
]

Rows that would be written

rowsThatWouldBeWritten

Optional

Preview items only: how many rows a real run would write for the items that were read. Skipped items are not counted.

Type:integer

Example:

Cells that would be truncated

cellsThatWouldBeTruncated

Optional

Preview items only: cells longer than Google's limit of 50,000 characters, which a real run would cut.

Type:integer

Example:

Next steps

nextSteps

Optional

Preview items only: warnings about the data (key column not found, items without a key, cells that would be cut), then what to do to write the rows.

Type:string[]

Example:

[
  "Run the Actor again with the credentials entered to write these rows."
]

GCP Uploader

circ_le/gcp-uploader

Upload datasets and KV store records to Google cloud storage

Cir◎cle

5.0

(1)

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

Engage Bay — Sushidata

sushidata/sushidata-engage-bay

Sushidata

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

Apify → Clay Pusher

robertsong13/apify---clay-pusher

Push results from the most recent Apify task run directly into Clay Webhook. Deduplicated and production-ready.

Grant Robertson

Monitor de Licitações PNCP (Brasil)

mateusalvescps/pncp-licitacoes-monitor

Encontra licitações, pregões e dispensas publicados no Portal Nacional de Contratações Públicas (PNCP) por palavra-chave, UF, valor e órgão. Ideal para alertas diários.

Mateus Alves

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 Export: Append, Upsert & Dedupe

codemagnet/google-sheets-export

Export Apify datasets or JSON to Google Sheets. Append, append only new rows, upsert by key, or replace with backup. Read tabs back into datasets.

Kirby Bookhart-Tsai

Google Sheets Export & Import

adhistory/google-sheets-export-actor

Send any Apify dataset or JSON to a Google Sheet (append, append only new rows with dedupe, or replace with backup), or import a sheet tab into a dataset. Public sheets import with no credentials. Works as an integration after any scraper.

Brandon Ob

Google Sheets Export: Apify Dataset to Sheets

plainsource/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.