Manage coupon campaigns and customer chats with WhatsApp and PostgreSQL
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 116 nodes and runs when an HTTP GET request hits its webhook URL (plus 11 other triggers). Along the way it connects Postgres.
How it runs
Trigger: When an HTTP GET request hits its webhook URL (plus 11 other triggers).
- Respond with Dashboard HTML (Respond to Webhook): sends the response back to the webhook caller
- Postgres: run a query
- Get Stats Query (Postgres): run a query
- Switch Company Method (If): checks a condition and branches into true / false
- Switch Coupon Method (If): checks a condition and branches into true / false
- Get Messages (Postgres): run a query
- Switch Settings Method (If): checks a condition and branches into true / false
- Get Chat History (Postgres): run a query
- Repair Tables Schema (Postgres): run a query
- Get Customers (Postgres): run a query
…plus 94 more steps. See the full node list below.
Services it uses
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 (7)
- Webhook
n8n-nodes-base.webhook - Respond to Webhook
n8n-nodes-base.respondToWebhook - Postgres
n8n-nodes-base.postgres - If
n8n-nodes-base.if - Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest - Switch
n8n-nodes-base.switch
From the author
Coupon Bot Dashboard & WhatsApp Management System A complete bilingual admin dashboard and WhatsApp bot solution for managing discount coupons, partner companies, and customer conversations through an intuitive web interface and automated chatbot. What does…