📧 Multi-Channel Marketing Automation Funnel

---

Category: Marketing Automation | Difficulty: Intermediate

---

Description: A real-time behavior-triggered marketing funnel that responds to website actions the moment they happen. When a visitor abandons their cart, views the pricing page, or requests a demo, a webhook fires and the workflow routes them instantly to the right outreach — a cart recovery email with a discount code, a personalized pricing follow-up with a calendar link, or an SMS confirmation via Twilio. Every event also feeds a cumulative lead scoring engine: cart abandonment adds 30 points, pricing page views add 25, demo requests add 50. The moment a lead crosses 75 points, the sales team gets a hot lead alert on Slack with the email, total score, and latest action. Every event is logged to Google Sheets for a full behavioral audit trail.

---

The Problem

Marketing teams running email campaigns are sending the same message to everyone at the same time, regardless of what those people actually did on the website. A visitor who just abandoned a ₱12,000 cart gets the same weekly newsletter as someone who signed up six months ago and never opened anything. A prospect who just spent five minutes on the pricing page gets nothing — because there’s no system watching for that signal and acting on it.

Key pain points:

• 68% cart abandonment rate with zero automated recovery — every abandoned cart was revenue left on the table with no follow-up mechanism
• The 2-person marketing team was sending one broadcast email newsletter per week to the full list — same message regardless of what any individual had done on the site in the past 7 days
• Pricing page visits — averaging 140 per week from logged-in users — generating zero sales outreach despite being the clearest buying signal on the site
• No lead scoring meant the sales team had no way to distinguish a window shopper from someone who had viewed three products, visited pricing twice, and abandoned a ₱28,000 cart
• Demo/consultation requests confirmed only by email, with a 3-hour average response time — 2 consultations in Q3 were never confirmed and the prospects bought from a competitor
• Every behavioral signal — views, abandonment, consultation requests — existed in separate tools with no unified view or coordinated response

The Solution

A behavior-driven marketing pipeline built on n8n, triggered by a webhook that fires on three high-intent user actions tracked via custom JavaScript on the store. A JavaScript parser normalizes the event payload with safe defaults. A Switch node routes by event type — three distinct behaviors, three distinct responses. Cart abandonment triggers a personalized HTML recovery email with a 10% discount code (COMEBACK10) and a direct cart URL. Pricing page views trigger a warm follow-up email with a direct Calendly booking link for a free interior design consultation. Demo/consultation requests trigger a Twilio SMS confirmation to the prospect’s phone within seconds. After any outreach fires, a lead scoring node adds the event-specific point value to the prospect’s running total. When a lead crosses 75 points, a Slack alert fires to #hot-leads for immediate sales follow-up. Every event is logged to Google Sheets with the full score breakdown.

Who it was built for: A Philippine online furniture and home decor store averaging 340 weekly visitors, 68% cart abandonment rate, 140 weekly pricing page visits from logged-in users, and 8–12 consultation requests per week — with a 2-person marketing team sending one broadcast newsletter per week and no behavior-triggered outreach of any kind.

---

Results & Impact

Industry context: Behavior-triggered emails generate 3–5x higher open rates than broadcast campaigns. Cart abandonment emails sent within the first hour of abandonment recover 3× more revenue than those sent 24 hours later. At ₱94,200 recovered in 6 weeks, the pipeline paid for its build cost within the first 10 days.

---

Technical Details

Tech Stack: n8n · Webhook · Gmail · Twilio SMS · Slack · Google Sheets · JavaScript

How each tool is used:

• n8n — Orchestration; webhook receiver, event routing, score calculation, and conditional alerting
• Webhook — Receives POST events from a custom JavaScript snippet added to the store’s theme — fires on cart abandonment (detected via page unload with items in cart), pricing page visit (URL match on logged-in users), and consultation form submission
• JavaScript (parse) — Normalizes the raw event payload with safe defaults: unknown event type, missing email, missing name defaults to “there,” zero cart value, zero previous score — workflow never breaks on incomplete payloads from mobile browsers where some fields are occasionally omitted
• Switch node — Three-way router on event value: cart_abandoned → Gmail recovery, pricing_viewed → Gmail consultation invite, demo_requested → Twilio SMS. Clean separation per intent signal
• Gmail (cart recovery) — Personalized HTML email with first name, cart value in Philippine Peso, 10% discount code (COMEBACK10), and a direct cart restoration URL — fires within 90 seconds of abandonment detection
• Gmail (pricing follow-up) — Warm conversational email acknowledging the pricing page visit, referencing the store by name, and offering a no-pressure free interior design consultation via a direct Calendly link — sent within 60 seconds of the visit
• Twilio — SMS to the prospect’s mobile number confirming their consultation request with a reference number and opt-out instruction — the two-way SMS exchange eliminated the unconfirmed consultation problem from Q3
• JavaScript (lead score) — Event-to-point mapping: demo_requested = 50, cart_abandoned = 30, pricing_viewed = 25. Adds delta to previous_score from the payload, sets is_hot: true when total ≥ 75
• IF node — Routes hot leads (score ≥ 75) to Slack alert; all others go directly to Sheets logging
• Slack — Posts to #hot-leads with email, total score, triggering event, and cart value (if applicable) for immediate sales team action
• Google Sheets — Appends every event with timestamp, email, event type, score delta, total score, cart value, and hot lead flag — 180–220 rows per week, queryable for weekly behavioral analysis

Workflow architecture (11 nodes, parse → switch → outreach → score → threshold → log): Webhook → JS Parse → Switch (3 routes) → [Cart Email / Pricing Email / Demo SMS] → JS Lead Score → IF Hot (≥75) → [True: Slack Alert] / [False: Sheets Log] → Respond to Webhook

Complexity highlights:

• Event-typed Switch routing — the Switch node handles three distinct event types with named outputs, making the routing logic readable and extensible — adding a fourth event (e.g., wishlist_added) is a single new case without touching any existing logic
• Cumulative scoring via payload — lead score accumulates across sessions by passing previous_score in each event payload, allowing the score to build over multiple visits without a database lookup on every event. A prospect who views pricing (25 points) on Monday and abandons a cart (30 points) on Wednesday crosses 55 points cumulatively — the next pricing view pushes them to 80 and fires the hot lead alert
• Score weighting by intent proximity — demo request (50) > cart abandonment (30) > pricing view (25) reflects the actual conversion likelihood of each signal. A single demo request alone doesn’t cross the 75-point threshold, requiring a second intent signal — this prevents single-action false positives flooding the Slack channel
• 90-second cart recovery timing — the webhook fires on page unload detection with a 60-second debounce to filter users who immediately return, with the Gmail node firing within 30 seconds of receipt. The 90-second end-to-end time puts the recovery email in the prospect’s inbox while the browsing session is still warm
• Multi-channel demo confirmation — the Twilio SMS fires simultaneously with the lead scoring node on demo_requested events, meaning high-intent prospects receive an SMS confirmation before the sales team even sees the Slack alert
• Hot lead threshold tuned in production — the initial threshold was set at 75 points, lowered to 70 in week 3 after reviewing the Sheets log and finding several high-value cart abandoners (₱20,000+ carts) scoring 55 points without triggering alerts. Threshold is a single JavaScript value — the adjustment took 30 seconds

Note on scope: Mailchimp/ActiveCampaign list sync, A/B subject line testing, dynamic audience segmentation, and dormant lead re-engagement are not in the current build. A v2 would add: a Mailchimp node to sync hot leads and their scores into a dedicated high-intent segment, a random split node for A/B testing the cart recovery subject line (“You left something behind” vs. “10% off — just for you”), and a scheduled Monday workflow that checks Sheets for prospects who scored 40+ but haven’t triggered an event in 14+ days and sends a re-engagement email.

---

Context & Social Proof

• Build timeline: 3 days — Day 1: Custom JavaScript tracking snippet for cart abandonment detection (the most technically complex part — required debounce logic to filter false positives from slow page loads), pricing page URL matching for logged-in users, and consultation form webhook. Day 2: n8n workflow build across all three event types, lead scoring logic, and Slack hot lead formatting. Day 3: Gmail and Twilio copy writing and testing, Sheets schema, threshold calibration review with the marketing team, and live testing with real sessions
• Your role: Solo build — custom JavaScript tracking implementation, webhook schema design, Switch routing logic, cart recovery and pricing follow-up email copy, Twilio SMS integration, lead scoring algorithm with cumulative payload pattern, hot lead threshold calibration, and Sheets logging schema
• Deployment: n8n cloud receiving webhook POSTs from custom tracking script added to store theme in one <script> tag — no Shopify app install, no third-party integration, no change to existing marketing tools
• Client quote: “We were just sending the same newsletter every week and hoping for the best. The first week this went live, we got three people back to complete their carts — two of them were carts we would never have known about. The SMS confirmation for consultations alone was worth it. We had two no-shows in Q3 because people forgot they requested a call. That hasn’t happened once since.” — Co-owner, online furniture and home decor store, Philippines
• Reusability: Event list, scoring weights, hot lead threshold, email copy, and Twilio sender number are the only client-specific configurations. The Switch-route-score-alert architecture deploys unchanged for any e-commerce or B2B SaaS store with trackable behavioral events

---

Use Cases & Ideal Buyer

Best fit for:

• Philippine e-commerce stores with cart abandonment rates above 60% and no recovery automation — the single highest-ROI automation available for most online stores
• B2B SaaS companies where pricing page visits are a documented buying signal being completely ignored by the sales team
• Marketing teams sending broadcast emails to everyone instead of responding to what individual visitors are actually doing on the site
• Sales teams that want to know the moment a lead crosses a meaningful intent threshold — not at end of day, not during a weekly CRM review, right now

Can also be adapted for:

• SaaS product-led growth — trigger on in-app events (feature limit reached, upgrade page visited, trial day 7 with no key action completed) instead of website behavior
• Real estate — trigger on property listing views (3+ views of same listing), mortgage calculator use, or contact form starts with incomplete submission
• EdTech — trigger on course preview views, syllabus downloads exceeding 60 seconds on page, or enrollment page abandonment after reaching the payment step
• Subscription businesses — trigger on cancellation page visits or plan downgrade attempts, routing to a retention email with a loyalty offer before the cancellation completes