# Recover abandoned Shopify carts with OpenAI and SMTP data tables

> Quick overview This workflow captures Shopify checkout updates into an n8n Data Table, marks carts as purchased when Shopify orders are created, and every 15 minutes uses OpenAI to write localized abandoned-cart reminder emails that are sent via SMTP and logged back to the Data Table. How it works 1. Triggers on Shopify checkout updates and ignores checkouts that are completed or missing an email address. 2. Normalizes the checkout data (customer details, line items, totals, locale, and recovery URL) and upserts it into an n8n Data Table keyed by the checkout token. 3. Triggers on Shopify order creation events, extracts the checkout token, and updates the matching Data Table row to a purchased status to stop reminders. 4. Runs every 15 minutes, loads open carts from the Data Table, and selects only those due for a reminder based on last activity, prior reminders, consent rules, and configured limits. 5. Sends the cart context to OpenAI to generate a short subject and body in the custom

- **Domain**: `n8n-workflow-22635.n8n.io`
- **Provider**: n8n.io (https://n8n.io)
- **Kind**: workflow
- **Live-responds (last probe)**: None
- **Signed card**: False
- **Streaming**: False
- **Quality score**: 40%

## URLs
- Agent card: https://n8n.io/workflows/22635
- Page (HTML): https://agenstry.com/agents/n8n-workflow-22635.n8n.io
- Documentation: https://n8n.io/workflows/22635
