Go to example tasks
Export Apify Dataset to Google Sheets Daily (Tab per Day)
Export every scraper run to Google Sheets with a new tab for each day, e.g. "Results 2026-10-01". Keeps a clean history without huge single tabs. Nested fields become readable columns, lists fit in one cell. No Google login or OAuth tokens that expire: share the sheet once with the Actor's e-mail. Try it on our demo sheet, then paste your own sheet link.
Google Sheets Import & Export: Sync Datasets, Update Rowss_actors/google-sheets-import-export
Status
Mode
Tab
Rows added
+5 fieldsTextNumberBooleanListObject
Input
๐ Google Sheet(required):https://docs.google.com/spreadsheets/d/1XEl1x1BNcQrfP1ZdDyBtvshMn7Pa50-I6eWy6etH9wk/edit
โ๏ธ Mode:append
๐ Tab name:Results {date}
Raw data (JSON)
product:Wireless Mouse+2
price:24.99+2
inStock:true+2
url:https://example.com/mouse+2
Add "exportedAt" column:true
Output fields
Status
Mode
Tab
Rows added
Rows updated
Duplicates skipped
Columns
New tab
Sheet
Sign up on Apify01
Create your Apify account to access the Google Sheets Import & Export: Sync Datasets, Update Rows.
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.
