Go to example tasks
Hotel Rate Tracker in Google Sheets: Daily Competitor Prices
Build a hotel rate shopping sheet: Google Hotels prices for every hotel and check-in date, with the cheapest booking site and the official website price, updated in place after each daily run. Revenue managers get a live competitor rate grid in Google Sheets without paid rate shopping tools. 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:update
๐ Tab name:Hotel rates
Raw data (JSON)
entityId:sample-1+1
name:Sample Hotel Berlin+1
checkInDate:2026-10-10+1
pricePerNight:189+1
cheapestSource:Booking.com+1
officialPricePerNight:199+1
Unique key column(s):entityId,checkInDate
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.
