nobody? really hoping someone has done this with shopify
we do almost exactly this for a client. shopify sends a webhook on new orders. heres the setup:
1. in shopify admin > settings > notifications > create webhook for "order creation"
2. point it at your workflow webhook URL
3. workflow receives the full order payload (line items, customer info, totals, etc)
4. first node: write order to your orders table
5. condition node: check order.total_price > 100 for the personal email
6. another condition: check if customer.orders_count == 1 for first-time buyer flow
reliability: weve processed about 8000 orders through this and only had 2 failures, both were shopify API hiccups that retried successfully. so very reliable
one tip: shopify sends the webhook almost instantly but sometimes theres a 1-2 second delay. weve never seen it miss an order though
this is amazing thank you. the 8000 orders with 2 failures is very reassuring. setting this up this week
we do the same for 2 shopify stores. works great. also added a weekly summary workflow that calculates total orders, revenue, average order value from the table and emails it to the team every monday
bookmarking this for when we launch our store next month
