Skip to main content

Automation case study

Dashboard Subscription Campaign

A scheduled n8n reactivation pipeline that retrieves users from Strapi, evaluates Plaid connection and subscription state, segments records with explicit conditional logic, selects the appropriate email template, injects dynamic content, and processes users through pagination and batching.

Engineering case study by Jonas Viray, Full Stack Developer & AI Automation Engineer

Dashboard Subscription Campaign | automation by Jonas Viray

Overview

engineering summary

Problem → Architecture → Contribution → Result

Problem
Users who had not connected a bank account or were still on a freemium plan needed targeted follow-up, but manually identifying, segmenting, and contacting them would not scale.
Architecture
A scheduled n8n workflow retrieves users from Strapi through a REST API, evaluates Plaid connection and subscription state, segments users with conditional logic, selects the correct email template, injects dynamic content, and processes records in batches with pagination.
Contribution
Built the scheduled segmentation and delivery pipeline, including API retrieval, filtering rules, branching, batching, personalization, and template selection for different account states.
Result
The campaign can repeatedly identify the right users and deliver the appropriate reactivation or onboarding message without requiring manual list building and one-by-one outreach.

Tools in this workflow

  1. n8n
  2. Strapi
  3. REST API
  4. Plaid
  5. SMTP
  6. JavaScript
  7. Batch Processing
  8. Conditional Logic
  9. Scheduled Automation
  10. Dynamic Templating

Related service: API & Platform Integration Engineering

Planning a system with similar complexity?

Send the requirements, current stack, and constraints. I'll outline how I would structure the system, where the main risks are, and what an implementation path could look like.

All work