Klaviyo Abandoned Cart Recovery with Smart Discount Tiers — n8n Workflow
Recover abandoned Shopify carts through Klaviyo — with tiered discounts and no duplicate emails For Shopify store owners using Klaviyo who want cart-value-aware recovery offers instead of one flat discount for everyone. Klaviyo's built-in abandoned cart flow treats a £30 cart and a £300 cart the same. This n8n workflow polls your Shopify store every 2 hours, works out which discount tier each abandoned cart deserves (based on cart value AND how long ago it was abandoned), fires an event into Klaviyo that triggers your email flow, and logs every send to a Google Sheet. What it does (verifiably, in the JSON you download) Runs every 2 hours on a Schedule Trigger — fetches abandoned checkouts from Shopify's Admin REST API (/admin/api/2024-01/checkouts.json); the exact endpoint, scope (read_checkouts) and credential setup are in the README Sends each cart to Klaviyo exactly once — at the start of every run it reads the processed cart IDs back from your Google Sheet log and filters them out, so the 2-hour schedule never re-emails the same cart Assigns one of three discount tiers — CART10 / CART15 / CART20, chosen from a time-plus-cart-value matrix (fresh carts get the small nudge, cold high-value carts get the strongest offer); thresholds are six plainly-commented numbers you can edit Checks the Klaviyo profile exists, creates it if not (null-safe branching), then sends an "Abandoned Cart Recovery" event with cart value, code, tier and hours-abandoned — your Klaviyo flow does the actual emailing with {{ event.discount_code }} Logs every send to Google Sheets — cart ID, email, cart value, tier, code, timestamp — which doubles as the dedupe memory and your audit trail Skips guest checkouts (no email) and malformed rows instead of crashing What it does NOT do (read this before buying) It does not create discount codes in Shopify. You create the three codes (CART10, CART15, CART20) once in Shopify admin — the README gives the exact click-path; it takes about 5 minutes. Codes are shared per tier, not unique per customer. No automatic retry/alerting on API failures — failed calls show in n8n's execution log; you can attach your own n8n Error Workflow. Shopify-first. WooCommerce core has no abandoned-cart API; you'd need a plugin that exposes one and to adapt the fetch node (notes included, but untested on WooCommerce). Single store per workflow copy. Duplicate it for multiple stores. It connects services you already have — you need your own n8n instance (free self-hosted works), Shopify (any paid plan), Klaviyo (any plan) and a Google account. Setup Realistic first-time setup is 45–60 minutes: import the JSON, create a Shopify custom-app token, a Klaviyo private key, the three discount codes, and a Google Sheet with the provided column headers, then test one cart end-to-end. The README walks every step with exact menu paths. Zero maintenance after that. What's in the download klaviyo-abandoned-cart-recovery.json — the full 11-node workflow (validated importable n8n JSON) klaviyo-abandoned-cart-recovery-free.json — a lightweight webhook-driven version (no schedule/dedupe/logging) handy for testing your Klaviyo flow README.md — complete setup guide: n8n import, Shopify + Klaviyo + Google Sheets credentials, the 3 discount-code creation steps, how the dedupe works, tier-matrix customisation, troubleshooting, and an honest limitations list FAQ Will it email the same customer twice? Not for the same cart. Every processed cart ID is written to the Google Sheet and read back at the start of every run — a cart that was sent at 10:00 is filtered out of the 12:00 run. If the same customer abandons a new cart later, that new cart gets one email too. Do I need to know JavaScript? No. The two Code nodes ship pre-written; the only thing you'd ever edit is the six tier numbers, which are commented. What if I get stuck? Reply to your Gumroad receipt with a screenshot of your n8n execution log and I'll help you get it running.
Get it → coinmaster50.gumroad.com