Pricing

from $0.10 / 1,000 row writtens

Try for free

Go to Apify Store

Google Sheets Export: Append, Upsert & Sync

Try for free

Google Sheets export and sync for any Apify dataset, Actor run output or JSON rows. Append, replace or upsert by key column, with a summary of rows appended, updated and unchanged. Share the sheet with our bot email: no Google Cloud setup, no expiring tokens. $0.10 per 1,000 rows.

Pricing

from $0.10 / 1,000 row writtens

Rating

0.0

(0)

Developer

Brasspage

Actor stats

Bookmarked

Total users

Monthly active users

14 days ago

Last modified

Categories

Integrations

Automation

Developer tools

Security

Spreadsheet ID or URL

spreadsheetId

Optional

The Google Sheet to write to. Paste the full URL or only the ID (the part between /d/ and /edit). In Google Sheets click Share and add sheets-sync-test@brasspage-tools.iam.gserviceaccount.com as Editor (or the email of your own key, if you paste one below). With the shared login, the sheet also needs your Apify user ID in a cell named brasspage_owner (Data > Named ranges).

Type:string

Example:

https://docs.google.com/spreadsheets/d/1AbCdEfGhIjKlMnOpQrStUvWxYz/edit

Sheet (tab) name

sheetName

Optional

The tab to write to. If the tab does not exist, the Actor creates it. Empty = the first tab.

Type:string

Example:

Products

Mode

mode

Optional

append adds new rows. replace overwrites the tab. upsert updates the rows whose key columns match and adds the others (needs Key columns).

Type:string

Default:append

Options:

appendreplaceupsert

Key columns (for upsert and dedupe)

keyFields

Optional

One or more field names that identify a row, for example "url" or "sku". Upsert needs them. In append mode they skip rows whose key is already in the sheet. Nested fields use a slash, for example "product/id".

Type:array

Example:

[
  "url"
]

Your own service-account key (JSON, optional)

serviceAccountJson

Optional

Optional. Paste the whole JSON key file of your own Google Cloud service account, then share the spreadsheet with its "client_email" as Editor. The value is stored encrypted.

Type:string

OAuth client ID (optional)

oauthClientId

Optional

Only if you do not use a service account. Client ID of your own Google OAuth client.

Type:string

Example:

123456789012-abc123def456.apps.googleusercontent.com

OAuth client secret (optional)

oauthClientSecret

Optional

Client secret of the same OAuth client.

Type:string

OAuth refresh token (optional)

oauthRefreshToken

Optional

Refresh token with the scope https://www.googleapis.com/auth/spreadsheets. Tokens of OAuth apps in "Testing" status expire after 7 days.

Type:string

Dataset ID

datasetId

Optional

The Apify dataset to export, for example the default dataset of a scraper run (Storage > Datasets, or the run's Storage tab). In an integration, set it to {{resource.defaultDatasetId}}.

Type:string

Example:

aBcD1234eFgH5678i

Raw JSON rows

rows

Optional

An array of objects to write, for example [{"name": "A", "price": 10}]. Use this when the data does not come from a dataset.

Type:array

Example:

[
  {
    "name": "A",
    "price": 10
  }
]

Columns to export

columns

Optional

Pick and order the fields to write. Empty = all fields. Nested fields use a slash, for example "price/value" or "images/0".

Type:array

Example:

[
  "url",
  "title",
  "price/value",
  "price/currency"
]

Flatten nested fields

flattenNested

Optional

On: {"price": {"value": 5}} becomes a column "price/value". Off: nested objects are written as JSON text in one cell.

Type:boolean

Default:true

How Google reads the values

valueInputOption

Optional

RAW keeps text as text, so "00123" keeps its zeros and a value that starts with "=" is not run as a formula. USER_ENTERED makes Sheets parse values as if you typed them.

Type:string

Default:RAW

Options:

RAWUSER_ENTERED

🔥 Google News Search Scraper

powerai/google-news-search-scraper

Search Google News and export structured metadata with optional article enrichment.

PowerAI

Google Sheet Exporter

jupri/google-sheet-exporter

💫 Export Dataset to GoogleSheet

cat

849

4.9

(4)

Google Sheets Export & Scraper

sourabhbgp/google-sheets-export

Export any public Google Sheet to flat JSON rows, a full xlsx workbook, or both. Typed values, multi-tab, hyperlinks and formulas optional. No Google Cloud project, no OAuth, no API key — just paste a sharing URL.

Sourabh Kumar

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)

Notion Scraper - Markdown Export & RAG Sync

fetchfinch/notion-scraper-knowledge-base-sync

[🔄 Incremental sync] Export public Notion pages and databases to Markdown, JSON, HTML or RAG chunks. Crawl subpages and sync only changed content. Public pages need no login; connected private pages use your read-only Notion integration token.

Fetch Finch

Awesome Google News Scraper

sync-network/awesome-google-news-scraper

This tool scrapes content from Google News, streamlining the collection of latest the information on any topic. Its key feature is the ability to extract full-length articles, not just headlines. Customize results from brief summaries to complete content, revolutionizing your news gathering process.

Alam

109

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

Google Sheets Import & Export: Sync Datasets, Update Rows

s_actors/google-sheets-import-export

Send any Apify dataset or JSON to Google Sheets: append, replace, or update rows by a unique key (price and stock monitoring). No OAuth: share the sheet once. Auto-retries on Google limits, one tab per day, dedupe, column picking. Also reads sheets back to JSON.

Superior Actors

5.0

(1)

Remove Duplicates & Merge Datasets: Dedup, Only New

brasspage/dataset-dedup-merge

Dedup and merge Apify datasets: removes duplicate items by any fields, or by the whole item, and returns the unique items (or only the duplicates) with their original fields. Can skip items seen in earlier runs, for daily new results. Works with limited permissions. $0.02 per 1,000 items.

Brasspage

Github Issue Labels Sync

lukaskrivka/github-issue-labels-sync

Synchronize issue labels across repositories in your account. Choose a source repo and copy labels to other repos, optionally overriding and cleaning extra labels.