Sync Apify Data to Google Sheets with Composite Keys

Created by

Michael Bennett

Actor

Reliable Google Sheets Bridge

Keep a Google Sheet in sync with an Apify dataset using a composite upsert key (id + sku by default). Updates rows that match all key columns and appends the rest. Change the key column(s) to match columns that actually exist in your source dataset. The defaults are examples only. Add your credentials, spreadsheet, dataset, and adjust keyColumns as needed.

Try for free

Reliable Google Sheets Bridgegroundedvisionmedia/reliable-sheets-bridge

Record type

Status

Actor version

Operation

+10 fields

Input

Sheet/tab name:Sheet1

Sheet write mode:upsert

Upsert key columns:id+1

Output fields

Record type

Status

Actor version

Operation

Write mode

Sheet name

Rows read

Rows transferred

Rows updated

Rows appended

Column count

Key columns

Error code

Message

How it works

Sign up on Apify or log in

The Reliable Google Sheets Bridge Actor is ready to run with the inputs already set for "Sync Apify Data to Google Sheets with Composite Keys". Sign up or log in and you'll land in Apify Console with a copy of this exact task.

Start the "Sync Apify Data to Google Sheets with Composite Keys" task

The Reliable Google Sheets Bridge Actor will start running based on the input automatically. You can also change all the input fields, like sheet/tab name, sheet write mode, and more, to match your specific use case.

Receive the "Sync Apify Data to Google Sheets with Composite Keys" output

Monitor the progress in real time. You will be notified as soon as your dataset is complete and ready for review. Each result includes data such as record type, status, actor version, and more.

Integrate into your workflow

The final output is delivered in JSON, CSV, or Excel format, ready to be plugged into your workflow. You can also run the "Sync Apify Data to Google Sheets with Composite Keys" task via API.