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 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 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). 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.
By AndrewCreate AI intelligence briefs from newsletters with Gemini, Slack, and Notion
This n8n template automatically processes your industry newsletters and creates AI-powered intelligence briefs that filter signal from noise. Perfect for busy professionals who need to stay informed without information overload, it delivers structured insights directly to Slack while optionally saving content questions to Notion. Who's it for Busy executives, product managers, and content creators at growing companies who subscribe to multiple industry newsletters but lack time to read them all. Ideal for teams that need to spot trends, generate content ideas, and share curated insights without drowning in information. How it works The workflow runs daily to fetch labeled emails from Gmail, combines all newsletter content, and sends it to an AI agent for intelligent analysis. The AI filters developments through your specific business lens, identifies only operationally relevant insights, and generates thought-provoking questions for content creation. Results are formatted as rich Slack messages using Block Kit, with optional Notion integration for tracking content ideas. Requirements Gmail account with newsletter labeling system OpenRouter API key for AI analysis (costs approximately $0.01-0.05 per run) or API key for a specific LLM Slack workspace with bot permissions for message posting Notion account with database setup (optional, for content question tracking) Perplexity API key (optional, for additional AI research capabilities) How to set up 1 Connect your Gmail, OpenRouter, and Slack credentials through n8n's secure credential system. Create a Gmail label for newsletters you want analyzed and setup in the "Get Labeled Newsletters" node. Update the Slack channel ID in the "Send to Slack" node. The template comes pre-configured with sample settings for tech companies, so you can run it immediately after credential setup. How to customize the workflow Edit the "Configuration" node to match your industry and audience - change the 13 pre-defined fields including target audience, business context, relevance filters, and content pillars. Adjust the cron expression in the trigger node for your timezone. Modify the Slack formatting code to change output appearance, or add additional destination nodes for email, Teams, or Discord. Remove Notion nodes if you only need Slack output. The AI analysis framework is fully customizable through the Configuration node, allowing you to adapt from the default tech company focus to any industry including healthcare, finance, marketing, or consulting.
By Harry Siggins