Abandoned-cart recovery — email, SMS and a discount in sequence

How it works

To create Microsoft SQL records from Gmail without manual input, use a ready-made scenario.

1. Starts when: Abandoned Cart Webhook
2. Then: Workflow Configuration
3. Then: Normalize Cart Data
4. Then: Fetch Cart Details
5. Then: Predict Abandonment Reason
6. Then: Personalization Engine
7. Check: Customer Segment Check
8. If yes: Device Type Check
9. If yes: Wait 1 Hour
10. Then: Check Order Status (1h)
11. Check: Check Order Completed (1h)
12. If yes: Mark Success - Order Completed (1h)
13. If no: Generate Email 1 Content
14. Then: Send Email 1
15. Then: Log Email 1 Touchpoint
16. Then: Attribution - Email 1
17. Then: Wait Until 4 Hours
18. Then: Check Order Status (4h)
19. Check: Check Order Completed (4h)
20. If yes: Mark Success - Order Completed (4h)
21. If no: Prepare SMS Content
22. Then: Send SMS with Discount
23. Then: Log SMS Touchpoint
24. Then: Wait Until 24 Hours
25. Then: Check Order Status (24h)
26. Check: Check Order Completed (24h)
27. If yes: Mark Success - Order Completed (24h)
28. If no: Generate Email 2 Content
29. Then: Send Email 2
30. Then: Log Email 2 Touchpoint
31. Then: Wait Until 48 Hours
32. Check: Check Order Completed (48h)
33. If yes: Mark Success - Order Completed (48h)
34. If no: Generate WhatsApp Message
35. Then: Send WhatsApp Message
36. Then: Hash Customer Data for Facebook
37. Then: Add to Retargeting Audience
38. Then: Merge Attribution - WhatsApp
39. Then: Merge Attribution - Email 2
40. Then: Merge Attribution - SMS
41. Check: Merge Attribution Data
42. Check: Check Cart Value Threshold
43. If yes: Notify High-Value Recovery
44. Then: Fetch Customer History

You can launch this Gmail + Microsoft SQL integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.