Get product info from Postgres via WhatsApp bot (Module n8n "Catalog")

Who is this for?

This n8n 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 automates the process of managing and retrieving product information via WhatsApp, allowing businesses to easily share product details with customers without manual interaction.

What this workflow does

• It adds product data to a Postgres database.
• It enables a WhatsApp bot to retrieve a list of products.
• Users can select a product to receive detailed information about it.

Setup

1. Create Tables in Postgres DB
   • Modify the SQL script to replace “n8n” with your schema name.
   • Run the provided SQL script in your database (available in the workflow).
2. Add Credentials
   • Add WhatsApp credentials (OAuth, Account).
   • Add Postgres credentials to connect the bot to your database.

How to customize this workflow to your needs

• Update the database schema or table structure if you need additional product information.
• Modify the bot interaction to suit your specific product listing and display preferences.

Please check out my other items on Shop on Gumroad

You might also like something else☺️