Go to example tasks
Upsert Apify Dataset into Google Sheets
Created by
Michael Bennett
Update matching rows in Google Sheets and append new ones using a single key column. Default key is id—change keyColumns to match your sheet. Change the key column(s) to match columns that actually exist in your source dataset. The defaults are examples only. Provide service-account JSON, spreadsheet, tab, and source dataset before running.
Reliable Google Sheets Bridgegroundedvisionmedia/reliable-sheets-bridge
Record type
Status
Actor version
Operation
+10 fieldsTextNumberBooleanListObject
Input
Sheet/tab name:Sheet1
Sheet write mode:upsert
Upsert key columns:id
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
Sign up on Apify01
Create your Apify account to access the Reliable Google Sheets Bridge.
Start the run02
The Actor will start running based on the input automatically.
Receive the output03
Monitor the progress in real-time. You will be notified as soon as your dataset is complete and ready for review.
Integrate into your workflow04
The final output is delivered in JSON, CSV, or Excel format, ready to be plugged into your workflow.
