Creator Affiliate Campaign Automation
Finds Shopify orders tagged Instagram, compares them with Google Sheets, routes invalid creator handles for manual review, and adds or updates eligible orders.
Workflow
This is the real 13-step workflow used by the creator-order sync template. It includes the item loop and three-way branch from the working workflow, with only connection details removed.
Sync Shopify Orders to Google Sheets
Run Shopify to Instagram sheet sync
Start a sync of Shopify orders tagged Instagram into the connected Google Sheet.
Find Instagram orders
Retrieve Shopify orders tagged Instagram for this sync.
Read synced orders
Read existing Google Sheets rows so orders can be added or updated without duplicates.
Classify sync changes
Extract creator handles, calculate shipment status, and identify rows to add or update.
Process each Instagram order
Process each Instagram-tagged order independently so one problematic order does not affect the others.
Check creator handle
Route invalid creator handles to manual review and valid orders through the sync path.
Orders with a valid Instagram creator note continue through the sync path.
Queue valid order
Mark the valid order for downstream Google Sheets synchronization.
Orders without a valid creator handle are held for manual review.
Queue manual review
Record the order for manual review when its creator handle is missing or invalid.
A fallback path catches anything that does not match either condition.
Prepare new rows
Collect new Instagram orders for insertion into the sheet.
Prepare existing rows
Collect eligible existing orders for status updates.
Add new orders
Append newly discovered Instagram orders to Google Sheets.
Update order statuses
Update existing eligible orders in Google Sheets.
Summarize sync
Count orders added and updated for the completed run report.
Want to automate work like this for your team?
Join waitlist