AutomationMart
Home/Browse/WhatsApp product catalog bot with PostgreSQL database
n8n

WhatsApp product catalog bot with PostgreSQL database

n8nn8n16 modulesv1.0
WhatsApp

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

At a glance

WhatsApp product catalog bot with PostgreSQL database is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects WhatsApp. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
WhatsApp
Modules
16
Price
Free
Version
v1.0
WhatsApp product catalog bot with PostgreSQL database workflow diagram

About this workflow

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.

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 5

    Click Execute Workflow to test, then activate.

Setup guide

Setup guide included

Purchase to unlock the full step-by-step guide

Related N8n workflows

AI personal assistant with GPT-4o, RAG & voice for WhatsApp using Supabase

Intelligent AI Assistant with RAG & Voice for WhatsApp – Built with GPT-4o & Supabase --- 📌 About this workflow and its creator Hi! I’m Amanda, a creator of intelligent automations using n8n and Make. I’ve been building AI-powered workflows for over 2 years, always focused on usability and innovation. This one here is very special to me – a truly advanced AI assistant that reads, listens, interprets and responds like a real human 🤖✨ This ready-to-use workflow acts as a powerful AI personal assis

Free

Send scheduled WhatsApp order review requests (Part 2 of 2)

Automatically send WhatsApp order review requests from your queued orders. This template processes the Google Sheet queue created by Part 1 and sends personalized WhatsApp review requests via WhatsScale CRM. **How it works:** 1. Runs daily on schedule 2. Finds orders where Send Date is today or earlier 3. Looks up or creates CRM contact 4. Sends personalized order review request 5. Removes processed order from queue **Setup required:** - Google Sheets connection (same spreadsheet as Part 1) -

Free

Send WhatsApp template messages using a custom webhook

Automatically send WhatsApp template messages via a custom webhook. Connect CustomWebHook with WhatsApp Business Cloud for streamlined communication.

Free

Build a chatbot, voice and phone agent with Voiceflow, Google Calendar and RAG

Voiceflow is a no-code platform that allows you to design, prototype, and deploy conversational assistants across multiple channels—such as chat, voice, and phone—with advanced logic and natural language understanding. It supports integration with APIs, webhooks, and even tools like Twilio for phone agents. It's perfect for building customer support agents, voice bots, or intelligent assistants. This workflow connects n8n and Voiceflow with tools like Google Calendar

Free

Track SEO keyword position in Google SERP (Google Sheets + SerpAPI integration)

This n8n workflow automates scheduled checks for your target keywords’ positions in Google’s organic search results using SerpAPI. It logs new positions in Google Sheets, compares them to previous rankings, and sends notifications via WhatsApp and/or email based on the movement. --- Problem Statement & Target Audience Who is this for? This workflow is ideal for: - SEO specialists monitoring keyword rankings. - Website owners tracking performance. - Agencies managing multiple client campaigns.

Free

Send scheduled WhatsApp store review requests (Part 2 of 2)

Send scheduled WhatsApp store review requests from queued Shopify orders. Part 2 of 2 - requires Part 1 template to queue orders. HOW IT WORKS: - Runs daily (connect to scheduler) - Searches Google Sheet for orders where Send Date <= Today - Checks WhatsScale CRM for existing contact and tags - Sends personalized review request via WhatsApp - Removes processed orders from queue REQUIRES: - Part 1 template: "Queue Shopify orders for WhatsApp store review" - WhatsScale account - Same Google Shee

Free

Validate Auth0 JWT tokens using JWKS or signing cert

gt; Note: This template requires a self-hosted community edition of n8n. Does not work on cloud. Try It Out This n8n template shows how to validate API requests with Auth0 Authorization tokens. Auth0 doesn't work with the standard JWT auth option because: 1) Auth0 tokens use the RS256 algorithm. 2) RS256 JWT credentials in n8n require the user to use private and public keys and not secret phrase. 3) Auth0 does not give you access to your Auth0 instance private keys. The solution is to handle JWT

Free

Capture URL screenshots from Google Sheets with ScreenshotOne & save to Drive with Gmail alerts

Capture URL Screenshots Automatically from Google Sheets & Drive with ScreenshotOne & Gmail Alerts Summary This automation template streamlines the process of capturing screenshots for multiple URLs. Instead of manually visiting each URL, taking a screenshot, and organizing the results, this workflow automates everything. When a spreadsheet is added to a designated Google Drive folder, the template extracts URLs from the column named "Url." These URLs are then processed through ScreenshotOne to

Free

Reviews

No reviews yet

Be the first to buy and share your experience.

Leave a review

Sign in to share your experience with this workflow.

Log in to review
Free
No ratings yet

Create a free account to purchase workflows.

  • JSON blueprint — instant download
  • Setup guide PDF included
  • 5 downloads · valid 30 days
  • Works with n8n

Need help setting this up?

Book a 3-hour live setup session with an Agility consultant.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free