Templates / WhatsApp product catalog bot with PostgreSQL database

WhatsApp product catalog bot with PostgreSQL database

Ready for 3.0

by Andrew ✓ · 2,195 views · created 2025-04-21 · Lead Nurturing

Ready 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 16 nodes and runs on WhatsApp events. Along the way it connects WhatsApp Business Cloud and Postgres.

How it runs

Trigger: On WhatsApp events.

  1. Initialization (Edit Fields (Set)): sets or maps fields
  2. Get Bot Status (Postgres): uses Postgres
  3. Start? (If): checks a condition and branches into true / false
  4. Starts (WhatsApp Business Cloud): uses WhatsApp Business Cloud
  5. Commands (Switch): routes items into branches
  6. Upsert Bot Status (Postgres): uses Postgres
  7. Main Menu (WhatsApp Business Cloud): uses WhatsApp Business Cloud
  8. List? (If): checks a condition and branches into true / false
  9. Get Card products (Postgres): uses Postgres
  10. Get Card products (Postgres): uses Postgres

…plus 5 more steps. See the full node list below.

Services it uses

WhatsApp Business CloudPostgres

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)

From the author

Who is this for? This workflow is designed for businesses or developers who want to integrate product information into a WhatsApp bot and allow users to retrieve details about products from a database. What problem is this workflow solving? This workflow…

Excerpt from Andrew's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.