Go to example tasks
Google Sheet to JSON API: Read Any Sheet
Turn any Google Sheet into JSON: one item per row, with the header row as field names. Numbers stay numbers. Use it to feed a sheet into another Actor, an AI agent or your app through the Apify API. Works with sheets shared with the Actor's e-mail or published as "Anyone with the link". 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:read
Header row (read mode):1
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.
