Go to example tasks
JSON to Google Sheets via API or AI Agent: Upsert Rows
Send JSON rows to a Google Sheet with one API call or from an AI agent through the Apify MCP server: rows with an existing id are updated in place, new ones are appended. No OAuth token that expires: the sheet is simply shared once. 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:API rows
Raw data (JSON)
id:1+1
name:Alice+1
status:active+1
Unique key column(s):id
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.
