Andrew
Analyst-Developer
Categories
Templates by Andrew
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 AndrewAuto-reply to FAQs on WhatsApp using Postgres (Module "FAQ")
Who is this for? This workflow is designed for businesses or individuals who want to automate responses to frequently asked questions via WhatsApp, while managing their question-and-answer database using Postgres. What problem is this workflow solving? This workflow addresses the challenge of efficiently managing and automating responses to customer inquiries. It helps reduce manual effort and ensures quick access to information, while providing an option for customers to request live assistance when needed. What this workflow does It allows you to store questions and answers in a Postgres database. A link to a bot is shared with customers, enabling them to read the available questions and answers. If a customer does not find an answer to their query, they can request a consultation with a manager. Setup Create tables in Postgres DB Replace "n8n" in the provided SQL script with the name of your schema in the database. Run the SQL script in your database to set up the necessary tables. (The script is available in the workflow.) Add Credentials Set up the WhatsApp integration (OAuth and Account credentials). Connect the Postgres database by adding the necessary credentials. How to customize this workflow to your needs Modify the Postgres schema name in the SQL script to match your database configuration. Update the questions and answers in the database to suit the information you want to provide via the bot. Customize the WhatsApp integration settings to match your account credentials and API details.
By AndrewWhatsApp appointment scheduling with Google Calendar
Who is this for? This workflow is for service-based businesses and freelancers who want to automate booking appointments via WhatsApp without relying on third-party scheduling tools. It's perfect for small teams who want full control over the reservation system and calendar integration. What problem is this workflow solving? Manually coordinating bookings through messages can be inefficient and error-prone. This workflow streamlines the entire scheduling process-from user input to calendar event creation-saving time and avoiding double-bookings. It ensures users only choose from available time slots and automatically records the meeting in your Google Calendar. What this workflow does Sends a WhatsApp message with a reservation link. Collects the user's name and preferred date. Checks availability and shows only free time slots. Allows the user to choose a time slot. Automatically creates a Google Calendar event with the selected details. Saves all data to a Postgres database for future reference. Setup Create Tables in Postgres DB Open the provided SQL script and replace "n8n" with your Postgres schema name. Execute the script to create the required tables. Add Credentials WhatsApp: Set up your WhatsApp Business API credentials using OAuth and API keys. Postgres: Connect your database where the booking data will be stored. Google Calendar: Authorize access to your calendar for event creation.
By AndrewTelegram bot for item multi select and saving to Postgres (Module "Checkbox")
Who is this for? This template is for developers and automation specialists looking to create a Telegram bot that enables users to select items from a predefined list and save their choices to a Postgres database. What problem is this workflow solving? It provides a simple and efficient way to collect structured user input via Telegram and store it in a Postgres database, useful for inventory selection, order systems, or preference tracking. What this workflow does Displays a list of selectable options from a Postgres shop_list table in Telegram Saves the user’s selection back to the database Automatically deletes messages at each step to keep the chat clean Setup Create the required tables in Postgres Replace "n8n" in the provided SQL script with the appropriate schema name for your database Run the script to create the shop_list table Add necessary credentials in n8n Telegram: Connect your Telegram bot using the Bot Token Postgres: Add your Postgres DB credentials to allow the workflow to read/write data How to customize this workflow to your needs Modify the shop_list table to include your specific options. Adjust the Telegram messages and logic to match your use case.
By AndrewAutomate Telegram channel posts using Postgres (Module "Cross-Posting")
Who is this for? This template is ideal for users managing Telegram channels who want to automate the process of posting messages, including text and images, directly from an bot. What problem is this workflow solving? Manually posting content to multiple Telegram channels can be time-consuming and inconsistent. This workflow automates that process, enabling efficient and consistent content delivery to one or more channels. What this workflow does This workflow connects to a Postgres database to retrieve post content and automatically sends text or image posts to designated Telegram channels where the bot is an admin. It supports scheduling and content customization through the database. Setup Create the necessary tables in your Postgres database Open the SQL script provided in the workflow. Replace "n8n" with your actual schema name. Run the script in your database to set up the required tables. Add credentials Telegram: Create and connect a bot, ensuring it has admin access to the target channels. Postgres: Connect your Postgres instance using valid credentials. How to customize this workflow to your needs Modify the SQL script to match your specific table or schema naming conventions. Adjust the content format or post frequency directly from your database.
By AndrewAutomate testing and collect responses via Telegram in Postgres (module "Quiz")
Who is this for? This template is ideal for educators, HR professionals, and anyone looking to automate testing and collect responses through Telegram, while storing results in a Postgres database. What problem is this workflow solving? Manually organizing and managing tests can be time-consuming and prone to error. This workflow automates the test distribution, response collection, and scoring process, ensuring a seamless and efficient testing experience. What this workflow does Adds test content, including questions and answers, to a Postgres database Sends a Telegram bot link to test participants Automatically delivers the test via the Telegram bot Collects and stores responses Displays the participant's ranking at the end of the test Setup Create tables in Postgres Replace "n8n" in the provided SQL script with the name of your actual schema Run the script in your database to create the required tables Add credentials Set up and connect your Telegram credentials Set up and connect your Postgres credentials How to customize this workflow to your needs Modify the test content directly in the Postgres database Customize the Telegram bot messages to match your tone and branding. Adjust scoring logic if needed to reflect different evaluation methods.
By AndrewAutomate WhatsApp tests and rank results with PostgreSQL (Module "Quiz")
Who is this for? This workflow is designed for educators, HR teams, or anyone who needs to create and distribute quizzes or tests via WhatsApp and automatically store and analyze responses in a PostgreSQL database. What problem is this workflow solving? Managing tests or quizzes manually across platforms can be time-consuming and error-prone. This workflow automates the entire process — from test creation to distribution and result collection — providing an efficient way to manage assessments at scale. What this workflow does Adds test content (including questions and answers) to a PostgreSQL database. Allows users to take the test directly via WhatsApp. Displays a final ranking to test takers upon completion. Setup Create tables in PostgreSQL Open the SQL script provided in the workflow. Replace n8n with your actual database schema name. Run the script to set up the required tables. Add required credentials WhatsApp: Set up OAuth and connect your WhatsApp account. PostgreSQL: Add your Postgres DB credentials to n8n. How to customize this workflow to your needs Update the test questions and answers directly in the database. Modify the bot flow to suit your test structure or messaging preferences. Extend the ranking logic based on specific grading criteria or scoring rules.
By AndrewVerify Telegram channel subscriptions with access control using Postgres
Who is this for? This workflow is for Telegram bot developers or marketers who want to verify user subscriptions to specific Telegram channels and optionally reward them with downloadable files. What problem is this workflow solving? This workflow ensures users have subscribed to required Telegram channels before they are granted access to resources or rewards, such as Google Drive files. It automates the subscription verification process, saving time and reducing manual effort. What this workflow does Verifies if a user is subscribed to specific Telegram channels. Allows adding and removing channel IDs for verification. Sends referral links to users for subscription checks. Optionally grants access to Google Drive files upon successful verification (currently inactive) Setup Add the bot to your Telegram channels as an admin – this is required for the bot to check subscription status. Add channel IDs via the bot – these are the channels users will need to subscribe to. Send the referral link to users you want to verify. Remove channels anytime from the subscription check list if needed. Create tables in Postgres: Replace "n8n" in the provided SQL script with your DB schema name. Run the script in your Postgres DB. Add credentials: Telegram Postgres How to customize this workflow to your needs Modify the SQL script to suit your existing database structure. Adjust the logic to enable or disable file delivery from Google Drive.
By AndrewCentralized error monitoring & alerts via Telegram, Slack & other messengers
Who is this for? This workflow is designed for developers, DevOps engineers, and automation specialists who manage multiple n8n workflows and need a reliable way to monitor for failures and receive alerts in real time. What problem is this workflow solving? Monitoring multiple workflows can be challenging, especially when silent failures occur. This workflow helps ensure you're immediately informed whenever another workflow fails, reducing downtime and improving system reliability. What this workflow does The solution consists of two parts: ERROR NOTIFIER: A centralized workflow that sends alerts through your chosen communication channel (e.g., Telegram, WhatsApp, Gmail). ERROR ALERTER: A node snippet to be added to any workflow you want to monitor. It captures errors and triggers the ERROR NOTIFIER workflow. Once set up, this system provides real-time error alerts for all integrated workflows. Setup Import both workflows: ERROR NOTIFIER (centralized alert handler) ERROR ALERTER (to be added to your monitored workflows) Add credentials for your preferred alert channel: WhatsApp (OAuth or API) Telegram Gmail Discord Slack Activate the workflows: Ensure ERROR NOTIFIER is active and ready to receive triggers. Paste ERROR ALERTER at the end of each workflow you want to monitor, connecting it to the error branch. Sign up for a free consultation and find out how n8n can help you.
By AndrewTelegram giveaways among channel subscribers (Module "Giveaway")
Who is this for? This workflow is ideal for businesses or individuals who want to run Telegram-based giveaways that require users to subscribe to certain channels in order to participate. What problem is this workflow solving? Running a fair and trackable giveaway on Telegram can be difficult without a system that verifies subscriptions and manages participants. This workflow simplifies that process, ensuring only eligible users are included and enabling a smooth drawing process. What this workflow does The giveaway organizer specifies a list of Telegram channels for participants to must subscribe to. The organizer shares a bot link with users. Users start the bot, confirming their participation in the giveaway. The bot tracks eligible participants. The administrator complete the giveaway and select winners. Setup Create tables in your Postgres database Open the provided SQL script. Replace "n8n" with your schema name. Execute the script in your Postgres DB. Add credentials in n8n Telegram credentials (Bot token, etc.) Postgres database credentials How to customize this workflow to your needs Modify the SQL script to match your database schema if needed. Customize the Telegram bot messages and logic using the n8n Telegram nodes. Add additional nodes if you want to notify winners or log data in other services.
By AndrewManage Google Calendar events via WhatsApp with Gemini AI
Who is this for? This workflow is for businesses and individuals who want to automate calendar management via WhatsApp using n8n. It’s ideal for appointment-based services, consultants, and anyone who needs to streamline event scheduling, updates, or cancellations through a simple chat interface. What problem is this workflow solving? Manually managing calendar events is time-consuming and error-prone, especially when clients communicate through messaging apps like WhatsApp. This workflow solves the problem by connecting WhatsApp to Google Calendar, enabling users to manage events directly via chat, reducing administrative overhead and response times. What this workflow does This workflow enables WhatsApp-based interaction with Google Calendar. Users can: Create new events Update existing events Delete events Retrieve a list of scheduled events Optionally, AI (like ChatGPT or Gemini) can be used to interpret natural language inputs, making the interaction even smoother. Setup Add credentials: WhatsApp: Connect your WhatsApp API (OAuth or other supported method). Google Calendar: Add your Google account credentials to allow calendar access. AI (optional): Add credentials for ChatGPT, Gemini, or another language model if using AI for natural language parsing. Import the workflow into n8n and review all nodes. Test the WhatsApp webhook to ensure it’s receiving messages correctly. Connect to your Google Calendar and test event creation and retrieval.
By AndrewScrape business data from Google Maps via SerpAPI and export to Sheets & Excel
This workflow contains community nodes that are only compatible with the self-hosted version of n8n. Who is this for This workflow is perfect for marketers, researchers, and small business owners who need to quickly gather and review company listings from Google Maps. Whether you're building lead lists, scouting competitors, or researching potential partners, this automation speeds up the process by exporting results into a neat Excel or Google Sheet format. What problem is this workflow solving Manually searching Google Maps for companies and copying their data into spreadsheets is time-consuming and error-prone. This workflow automates the search and export process, saving hours of manual effort while improving accuracy and consistency. What this workflow does Takes a user’s search query via chat Scrapes company data from Google Maps based on that query Returns the results in a downloadable Excel file Saves the same data to a connected Google Sheets document for easy access and sharing Setup Add your credentials: Google Sheets Serp Run the workflow and enter your search request in the chat interface Retrieve your results from either: The Get XLSX node as an Excel file The linked Google Sheets file (copy Column Names from XLSX File to Google Sheets) Test the bot by sending a search query (e.g., "coffee shops in Berlin") - the bot will return the results automatically.
By Andrew