Shopify Abandoned Cart Recovery with GPT-4o Email + Twilio SMS

Recover abandoned Shopify carts automatically—using GPT-4o email + Twilio SMS

This n8n workflow detects abandoned carts in Shopify, waits one hour, then generates a personalized recovery email with OpenAI’s GPT-4o and follows up instantly via Twilio SMS. Every outreach attempt is logged to Google Sheets for clear tracking and optimization.

What this workflow does

• Listens for Shopify cart updates and checks whether the cart has no completion timestamp—treating those carts as abandoned.
• Waits 1 hour before messaging, giving shoppers time to complete checkout without interruption.
• Generates a short recovery email using OpenAI (GPT-4o). The workflow sends the cart’s line items to GPT-4o to create a warm message with a single call to action.
• Applies a discount code by adding COMEBACK10 to the data used for the outreach message.
• Sends the recovery email to the customer, then sends a follow-up SMS via Twilio.
• Logs the attempt in Google Sheets by appending a new row for reporting and future improvements.

Use cases

• You want an abandoned cart recovery system in n8n without manually writing emails every time products change.
• Your store needs email + SMS follow-ups to improve conversion rates while still respecting shopper timing (the 1-hour delay).
• You want operational visibility by logging outreach attempts to Google Sheets for QA, audits, or performance reviews.

Technical details

• n8n trigger logic: Shopify cart update trigger + set, wait, and filter.
• AI generation: OpenAI with GPT-4o to draft the recovery email from cart line items.
• Email delivery: Email Send via your SMTP/email provider credentials.
• SMS delivery: Twilio (configured From/To numbers and SMS text mapping).
• Logging: Google Sheets appending a row per recovery attempt.
• Supporting node: Sticky Note for workflow clarity.