Automated WhatsApp lead nurturing with personalized messages via Postgres & Gallabox
Ready for 3.0What this workflow does
This workflow has 7 nodes and runs on a schedule (every second). Along the way it connects Postgres. It also calls server.gallabox.com over HTTP.
How it runs
Trigger: On a schedule (every second).
- Execute a SQL query (Postgres): run a query
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Code: runs custom JavaScript code
- new_lead_ (HTTP Request): calls server.gallabox.com (POST)
- Insert rows in a table (Postgres): uses Postgres
- Update rows in a table (Postgres): update
Services it uses
HTTP calls to: server.gallabox.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (5)
- Postgres
n8n-nodes-base.postgres - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Code
n8n-nodes-base.code - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - HTTP Request
n8n-nodes-base.httpRequest
From the author
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…