Automated WhatsApp lead nurturing with personalized messages via Postgres & Gallabox

n8n Workflow: WhatsApp Lead Nurturing (MQL)

🔄 Purpose This workflow fetches unqualified leads from Postgres at defined retry intervals, sends personalized WhatsApp template messages via Gallabox API, and logs message activity while updating lead status in the database.

---

🧩 Workflow Structure

1. Schedule Trigger - Type: n8n-nodes-base.scheduleTrigger - Runs the workflow automatically at set intervals (seconds-based). - Entry point of the workflow.

2. Execute a SQL query - Type: n8n-nodes-base.postgres - Fetches leads from mqlcontacts that: - Have count = 0, 1, 2, or 3. - Respect time delays: - count=1 → after 3 minutes - count=2 → after 5 minutes - count=3 → after 8 minutes - Must have disposition = unqualified.

3. Loop Over Items4 - Type: n8n-nodes-base.splitInBatches - Iterates over each lead individually. - Ensures one-by-one processing.

4. Code1 - Type: n8n-nodes-base.code - Selects message content based on: - Lead’s model (nexus, magnus, reo, general). - Current count (0–3). - Ensures personalized, varied message text.