WhatsApp product catalog bot with PostgreSQL database
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 retr...
🔌 Nodes & Integrations Used (4)
📖 Implementation & Setup Guide
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 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 Basis version: - 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.
Additional version: - All features from Basis Version. - Get a list of product categories. - Get a list of products in a category. - Add product to cart. - Go to the cart or select more products. - Remove unnecessary items in the cart or clear the entire cart. - When all the desired items are in the cart, click Buy. - The bot will send you a payment link.
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.
⚡ How to import this workflow into n8n:
- Click the Direct Download JSON button above to save
WhatsApp product catalog bot with PostgreSQL database.json. - Log in to your n8n Cloud or self-hosted n8n instance.
- In your workflow canvas, click the menu in top-right and select Import from File (or paste the JSON directly).
- Configure your credentials (e.g. API keys, database URLs) in the corresponding node settings.
- Click Execute Workflow to test and switch to Active!
Related AI Agents Workflows
View All in AI Agents →5 ways to process images PDFs with Gemini AI in n8n
How it works Many users have asked in the support forum about different methods to analyze images and PDF documents with Google Gemini AI in n8n. This workfl...
7 AI Sales Assistant
Production-ready n8n automation template for 7 AI Sales Assistant built by AhiXLight. Seamlessly connects Airtop Tool, Slack, Airtop with 24 configured nodes.
AAVE portfolio professional AI agent Telegram Email GPT 4o
A next-generation AI-powered DeFi health monitor that tracks wallet positions across Aave V3 using GPT-4o and LangChain. It delivers human-readable reports v...
Access control for AI agents RBAC using Airtable and Telegram
Purpose This workflow allows granular control over the access to tools connected to AI Agents (including Multi-Agent setups) using Role Based Access Control....