Supabase and Telegram integration

Video Guide I prepared a detailed guide that showed the whole process of building an AI bot, from the simplest version to the most complex in a template. .png) Who is this for? This workflow is ideal for developers, chatbot enthusiasts, and businesses looking to build a dynamic Telegram bot with memory capabilities. The bot leverages OpenAI's assistant to interact with users and stores user data in Supabase for personalized conversations. What problem does this workflow solve? Many simple chatbots lack context awareness and user memory. This workflow solves that by integrating Supabase to keep track of user sessions (via What this workflow does This Telegram bot template connects with OpenAI to answer user queries while storing and retrieving user information from a Supabase database. The memory component ensures that the bot can reference past interactions, making it suitable for use cases such as customer support, virtual assistants, or any application where context retention is crucial. 1.Receive New Message: The bot listens for incoming messages from users in Telegram. Check User in Database: The workflow checks if the user is already in the Supabase database using the Create New User (if necessary): If the user does not exist, a new record is created in Supabase with the telegram_id and a unique Start or Continue Conversation with OpenAI: Based on the user’s context, the bot either creates a new thread or continues an existing one using the stored Merge Data: User-specific data and conversation context are merged. Send and Receive Messages: The message is sent to OpenAI, and the response is received and processed. Reply to User: The bot sends OpenAI’s response back to the user in Telegram. Setup Create a Telegram Bot using the Botfather and obtain the bot token. Set up Supabase: Create a new project and generate a Create a new table named create table public.telegram_users ( id uuid not null default gen_random_uuid (), date_created timestamp with time zone not null default (now() at time zone 'utc'::text), telegram_id bigint null, openai_thread_id text null, constraint telegram_users_pkey primary key (id) ) tablespace pg_default; OpenAI Setup: Create an OpenAI assistant and obtain the Customize your assistant’s personality or use cases according to your requirements. Environment Configuration in n8n: Configure the Telegram, Supabase, and OpenAI nodes with the appropriate credentials. Set up triggers for receiving messages and handling conversation logic. Set up OpenAI assistant ID in "++OPENAI - Run assistant++" node.

This workflow serves as a complete "AI Receptionist" for mortgage brokers or high-ticket service providers. It automates the messy process of qualifying leads, getting internal approval, and collecting sensitive client documents securely. The workflow is fully annotated with Sticky Notes to help you understand every step of the logic. Key Features Smart Qualification:** automatically filters leads based on income thresholds (e.g., >$80k) before they reach your inbox. Human-in-the-Loop:** Uses Telegram buttons to ask the broker for "Approve/Decline" confirmation before generating client emails. Generative AI:* Uses Google Gemini (2.5-flash-lite)* to write personalized, warm welcome emails based on the lead's specific loan type. Google Workspace Automation:** Automatically creates a unique Google Drive folder for the client and drafts the email in Gmail (with the upload link pre-inserted). Document Collection Portal:** Includes a validation loop that checks if the client uploaded all required files (ID, Payslip, Bank Statements) and notifies the broker of success or failure. Database Logging:** Keeps a "Source of Truth" log in Supabase for every lead action. Prerequisites To use this template, you will need credentials for: Google Cloud Console: Enable APIs for Drive, Gmail, and Gemini (PaLM). Telegram: A Bot Token and Chat ID for notifications. Supabase: A project URL and API Key (Database schema provided in the Sticky Notes). How to Configure Credentials: Set up your Google, Telegram, and Supabase credentials in n8n. Supabase Table: Create a table named leads_consolidated (schema details are in the workflow notes). Triggers: Ensure your n8n instance is publicly accessible so the Webhook and Form triggers function correctly. Telegram ID: Update the Chat ID fields in the Telegram nodes to your own ID. This template is designed to be modular—you can easily swap Supabase for Airtable or Gemini for OpenAI if preferred.

Facebook Story Replies → Telegram “Human Required” Routing + Supabase CRM This workflow automatically captures Facebook Story replies, normalizes incoming webhook payloads, stores them in Supabase, assigns them to the correct regional support team based on UTC time, and sends real-time notifications to Slack and Telegram. This workflow listens to Facebook Story reply webhooks, converts raw payloads into a clean data structure, saves each reply in Supabase with a pending status, and automatically assigns it to the Asia or Europe support team based on the current UTC time. Once assigned, notifications are sent to Slack and Telegram, ensuring no customer reply is missed. You receive: Real-time Facebook Story reply ingestion** Automatic support team assignment (Asia / Europe)** Centralized Supabase storage** Instant Slack & Telegram notifications** Alerts for replies outside support hours** Ideal for support teams handling high volumes of social media interactions with strict response-time requirements. Quick Start – Implementation Steps Add your Facebook Webhook credentials and verify the callback URL. Connect Supabase credentials and confirm the replies table exists. Configure UTC-based time window logic for your support regions. Connect Slack credentials and select the notification channel. Add Telegram Bot Token and target chat ID. Activate the workflow — live reply handling starts instantly. What It Does This workflow automates end-to-end handling of Facebook Story replies: Receives Story reply events from Facebook via webhook. Normalizes incoming payloads into a structured format. Stores replies in Supabase with a pending status. Checks current UTC time to identify the active support window. Assigns replies to Asia or Europe support teams. Updates reply status to assigned when routing succeeds. Sends notifications to Slack and Telegram. Raises alerts for replies outside support hours. Logs all actions for auditing and follow-up. This ensures consistent handling, assignment, and visibility of customer interactions. Who’s It For This workflow is ideal for: Social media support teams Customer success teams Digital marketing teams E-commerce support operations SaaS companies handling Facebook DMs Businesses requiring timezone-based support routing Requirements to Use This Workflow To run this workflow, you need: n8n instance** (cloud or self-hosted) Facebook App** with Webhook access Supabase project** + API credentials Slack workspace** with API permissions Telegram Bot Token** and chat ID Basic understanding of JSON payloads and UTC time logic How It Works Webhook Listener – Receives Facebook Story reply events. Normalize Payload – Converts raw webhook data into a clean format. Save to Supabase – Stores reply with pending status. Time Window Check – Evaluates current UTC time. Assign Support Team – Routes to Asia or Europe team. Update Status – Marks reply as assigned. Send Notifications – Alerts Slack and Telegram. Alert Handling – Flags replies outside support hours. Setup Steps Import the workflow JSON into your n8n instance. Configure the Facebook Webhook node and verify it with your Facebook App. Connect Supabase credentials and ensure the replies table includes: id platform story_id sender_id sender_name message status assigned_to timestamps Adjust support time windows (UTC) in the IF/Switch node. Connect Slack API credentials and choose the notification channel. Add Telegram Bot Token and chat ID. Test using sample Facebook Story reply payloads. Activate the workflow — production ready. How To Customize Nodes Customize Support Hours Modify the time-check logic node to: Change Asia / Europe support windows Add additional regions Handle weekends or holidays Customize Supabase Storage You can extend the table with: Response SLA Agent name Resolution status Follow-up notes Raw webhook payload Customize Notifications Slack & Telegram messages can include: Mentions (@channel, @support) Emojis for priority Direct links to CRM or dashboard Highlighted urgent keywords Customize Assignment Logic You may: Route based on message content Assign by priority or keywords Add AI-based sentiment classification Use round-robin agent assignment Add-Ons (Optional Enhancements) You can extend this workflow to: Add sentiment analysis (OpenAI) Auto-reply with predefined responses Create SLA breach alerts Integrate with CRM tools Generate daily or weekly reports Add dashboard visualization in Supabase Escalate urgent replies automatically Use Case Examples Social Media Support Routing Automatically assign story replies to the correct regional team. SLA Enforcement Ensure replies are handled within working hours. Multi-Channel Alerts Notify teams instantly via Slack and Telegram. Centralized Reply Tracking Store all interactions in Supabase for audits. Scalable Support Automation Handle growing message volumes without manual routing. Troubleshooting Guide | Issue | Possible Cause | Solution | |----------------------|--------------------------|-----------------------------------------------| | No webhook data | Webhook not verified | Re-check Facebook webhook verification | | Replies not assigned | Time logic mismatch | Validate UTC time windows | | No Slack alert | Invalid credentials | Reconnect Slack API | | Supabase insert fails| Column mismatch | Match table schema exactly | | Telegram alert missing | Wrong chat ID | Verify bot permissions | | Workflow inactive | Workflow not activated | Enable workflow | Need Help? If you need help extending this workflow like adding AI analysis, advanced routing logic, CRM integration or scaling it for high-volume social channels, our n8n team at WeblineIndia can assist with enterprise-grade automation solutions.

Subscription Renewal Reminder – Telegram & Supabase This workflow tracks upcoming subscription expiry dates stored in Supabase and automatically sends personalized renewal-reminder messages to each customer via Telegram. It is designed to be triggered by an HTTP Webhook (manually or on a schedule) and ensures that customers are notified a configurable number of days before their subscription lapses. > Community Template Disclaimer > This is a community-contributed n8n workflow template. It is provided “as-is” without official support from n8n GmbH. Always test thoroughly before using in production. Pre-conditions/Requirements Prerequisites n8n instance (self-hosted or n8n.cloud) Supabase project with a subscriptions table (id, customer_name, expiration_date, telegram_chat_id, notified) A Telegram Bot created via @BotFather Outbound HTTPS access from n8n to api.telegram.org and your Supabase project REST endpoint Required Credentials Supabase Service Role Key** – Full access for reading/writing the subscriptions table Telegram Bot Token** – To send messages from your bot n8n Webhook URL** – Auto-generated when you activate the workflow (ScrapeGraphAI API Key is not required for this non-scraping workflow.) Specific Setup Requirements | Environment Variable | Example Value | Purpose | |----------------------|--------------|---------| | SUPABASE_URL | https://xyzcompany.supabase.co | Base URL for Supabase REST API | | SUPABASE_KEY | eyJhbGciOiJI... | Service Role Key | | TELEGRAM_TOKEN | 609012345:AA... | Bot token obtained from BotFather | | REMINDER_DAYS | 3 | Days before expiry to notify | How it works This workflow tracks upcoming subscription expiry dates stored in Supabase and automatically sends personalized renewal-reminder messages to each customer via Telegram. It is triggered by an HTTP Webhook (manually or via external scheduler) and ensures that customers are notified a configurable number of days before their subscription lapses. Key Steps: Receive Trigger (Webhook)**: External call fires the workflow or an internal Cron node can be added. Set Static Parameters**: The Set node calculates “today + REMINDER_DAYS”. Query Supabase**: Fetch all subscriptions expiring on or before the calculated date and not yet notified. Branch Logic (If node)**: Check if any subscriptions were returned. Loop & Dispatch (Code + Telegram nodes)**: Iterate over each customer row, compose a message, and send via Telegram. Flag as Notified (Supabase Update)**: Update each processed row to prevent duplicate reminders. Respond to Webhook**: Return a concise JSON summary for logging or downstream integrations. Set up steps Setup Time: 15–20 minutes Create Telegram Bot a. Open Telegram and talk to @BotFather → /newbot b. Copy the given bot token; paste it into n8n Telegram credentials. Prepare Supabase a. Create a table named subscriptions with columns: id (uuid), customer_name (text), expiration_date (date), telegram_chat_id (text), notified (bool, default false) b. Obtain the Service Role Key from Project Settings → API. Import the Workflow a. In n8n, click Templates → Import and select “Subscription Renewal Reminder – Telegram & Supabase”. b. Replace placeholder credentials in the Supabase and Telegram nodes. Define Environment Variables (Optional but recommended) Add SUPABASE_URL, SUPABASE_KEY, TELEGRAM_TOKEN, and REMINDER_DAYS in Settings → Environment Variables for easy maintenance. Activate the Workflow Copy the production webhook URL and (optionally) set up a cron job or n8n Cron node to hit it daily. Node Descriptions Core Workflow Nodes: Webhook** – Entry point; triggers the workflow via HTTP request. Set (Calculate Target Date)** – Defines targetDate = today + REMINDER_DAYS. Supabase (Select)** – Retrieves expiring subscriptions that haven’t been notified. If (Rows > 0?)** – Determines whether to continue or exit early. Code (For-Each Loop)** – Iterates through each returned row to send messages and update status. Telegram** – Sends a personalized renewal reminder to the customer’s chat. Supabase (Update)** – Flags the subscription row as notified = true. Respond to Webhook** – Returns a JSON summary with counts of sent messages. Sticky Notes** – Inline documentation for maintainers (non-executable). Data Flow: Webhook → Set → Supabase (Select) → If → Code → Telegram → Supabase (Update) → Respond to Webhook Customization Examples Send Slack Notifications Instead of Telegram // Replace Telegram node with Slack node const message = Hi ${item.customer_name}, your subscription expires on ${item.expiration_date}.; return [{ text: message, channel: item.slack_channel_id }]; Notify 7 Days & 1 Day Before Expiry // In Set node items[0].json.reminderOffsets = [7, 1]; // days return items; Data Output Format The workflow outputs structured JSON data: { "totalSubscriptionsChecked": 42, "remindersSent": 13, "timestamp": "2024-05-27T09:15:22.000Z" } Troubleshooting Common Issues No messages sent – Check the If node; ensure REMINDER_DAYS is set correctly and the Supabase query returns rows. Telegram error 403 – The user hasn’t started a chat with your bot. Ask the customer to click “Start” in Telegram. Performance Tips Batch database updates instead of row-by-row when dealing with thousands of records. Cache Supabase responses if you expect multiple workflows to query the same data within seconds. Pro Tips: Use the Cron node inside n8n instead of external schedulers for a fully self-contained setup. Add an Email node after the Telegram node for multi-channel reminders. Store template messages in Supabase so non-developers can update wording without editing the workflow.

Manage Supabase database with Telegram commands How it works Receive message — Telegram trigger captures incoming bot messages Validate user — Checks if sender's chat ID is in the authorized list Parse command — Extracts command type (/add, /list, etc.) and parameters Route & execute — Performs the appropriate Supabase operation (INSERT, SELECT, UPDATE, DELETE) Respond — Sends formatted results back to Telegram Turn your Telegram into a powerful database management interface. This workflow lets you create, read, update, delete, and search records in your Supabase database using simple chat commands — no SQL knowledge required. Who is this for? Small business owners, freelancers, and teams who need to manage data on the go without opening dashboards or writing queries. Perfect for inventory tracking, simple CRM, expense logging, or any scenario where you need quick mobile access to your database. What problem does it solve? Managing database records typically requires logging into admin panels or writing SQL queries. This workflow eliminates that friction by letting you interact with your data through familiar Telegram messages, from anywhere, on any device. Benefits Mobile database access** — Manage your data from anywhere using just your phone Zero SQL required** — Simple commands replace complex database queries Secure by default** — Only authorized Telegram users can access your data Instant feedback** — Get formatted responses confirming every operation Fully customizable** — Adapt to any table structure with minimal changes Available commands | Command | Format | Example | |---------|--------|---------| | /add | name, price, quantity, category | /add iPhone 15, 999.99, 50, electronics | | /list | [category] | /list or /list electronics | | /get | id | /get 15 | | /update | id field=value | /update 15 price=899 quantity=45 | | /delete | id | /delete 15 | | /search | text | /search iPhone | | /help | — | Shows all available commands | Set up steps Create your Telegram bot Message @BotFather on Telegram Send /newbot and follow the prompts Save the API token you receive Get your Telegram chat ID Message @userinfobot on Telegram It will reply with your chat ID number Create the Supabase table Run this SQL in your Supabase project's SQL Editor: CREATE TABLE products ( id SERIAL PRIMARY KEY, name TEXT NOT NULL, price DECIMAL(10,2), quantity INTEGER DEFAULT 0, category TEXT, created_at TIMESTAMP DEFAULT NOW() ); Configure the workflow Import the workflow into n8n Add your Telegram Bot credentials (using the API token from step 1) Add your Supabase credentials (Project URL + API Key from Supabase dashboard) Open the "Is Authorized?" node and replace 123456789 with your actual chat ID from step 2 Activate the workflow Test it Send /help to your bot to verify everything works! Customization Adding more authorized users Open the "Is Authorized?" node Click "Add condition" Add another OR condition: chatId equals [new user's chat ID] Using a different table Change products to your table name in all Supabase nodes Update the field parsing in the "Parse Command and Parameters" code node Update field mappings in "Supabase Insert Product" and "Prepare Update Data" nodes Adjust the help message in "Send Help Message" node Adding more fields Modify the command parsing logic in "Parse Command and Parameters" Add field mappings in the Supabase Insert node Update the "Prepare Update Data" Set node with new fields Update the help message Example use cases Inventory management** — Track stock levels from your phone while in the warehouse Simple CRM** — Add and lookup contacts on the go Expense tracking** — Log expenses as they happen Task management** — Create and update tasks without opening any app Field data collection** — Teams can submit data from anywhere Requirements n8n instance (cloud or self-hosted) Telegram account Supabase account (free tier works) Difficulty level: Intermediate Estimated setup time: 15-20 minutes Monthly operating cost: $0 (Telegram and Supabase free tiers)

Community Contest Tracker (FB Comments) → Sentiment Analysis → Telegram Winner Alerts + Airtable Proof This workflow automatically monitors a Facebook post, extracts comments, enforces a "past winner" blocklist, analyzes sentiment using AI to find positive entries, randomly selects a winner, stores them in Airtable and announces the result via Telegram. This workflow runs every night to manage your daily community giveaways. It fetches fresh comments from a specific Facebook post and cross-references users against a list of previous winners stored in Airtable to ensure fairness. It uses OpenAI to filter for genuinely positive sentiment (removing spam), selects a random winner, saves the record and sends a celebratory announcement to your Telegram channel. You receive: Daily automated comment collection** Fairness enforcement (Blocklist for past winners)** AI-powered sentiment filtering (Positive vibes only)** Automated winner selection & notification** Ideal for community managers and brand owners who want to run fair, high-engagement contests without manually reading hundreds of comments or tracking past winners in spreadsheets. Quick Start – Implementation Steps Add your Facebook Graph API Credentials in the HTTP Request node. Connect and configure your Airtable base (Winners Table). Add your OpenAI API Key for sentiment analysis. Connect your Telegram Bot credentials and set the Chat ID. Update the Post ID in the "Get FB Comments" node. Activate the workflow — daily contest automation begins instantly. What It Does This workflow automates the entire lifecycle of a social media contest: Daily Trigger: Runs automatically at 9:00 PM every day. Data Ingestion: Fetches the latest comments from Facebook and the full list of past winners from Airtable simultaneously. Pre-Processing: Creates a blocklist of users who won in the last 30 days. Filters out spam, short comments (e.g., single emojis) and blocklisted users. AI Analysis: Uses GPT-4o-mini to analyze the text of eligible comments. Filters specifically for "Positive" sentiment. Selection: Randomly picks one winner from the pool of positive comments. Storage: Saves the winner's Name, Facebook ID and Comment to Airtable. Notification: Sends a "Winner Announcement" to your public Telegram channel. If any errors occur (e.g., DB save fail), logs them to Supabase and alerts the Admin. This ensures your contests are fair, spam-free and consistently managed with zero manual effort. Who’s It For This workflow is ideal for: Social Media Managers Community Moderators Digital Marketing Agencies Brand Owners running daily giveaways Influencers managing high-volume comment sections Customer Experience teams rewarding positive feedback To run this workflow, you will need n8n instance** (cloud or self-hosted) Facebook Developer App** (Graph API Access Token) Airtable Base** + Personal Access Token OpenAI API Key** (or compatible LLM) Telegram Bot Token** Supabase Project** (Optional, for error logging) How It Works Daily Trigger – The schedule node initiates the process. Fetch Data – Comments are pulled from FB; Winners pulled from Airtable. Code Filter – JavaScript node removes past winners and low-quality spam. Sentiment Analysis – AI determines if the comment is Positive, Neutral or Negative. Pick Winner – A randomized logic block selects one "Positive" user. Record Keeping – The winner is officially logged in your database. Broadcast – The winner is announced to the community via Telegram. Setup Steps Import the provided n8n JSON file. Open Get FB Comments node → Add credentials and paste your specific Post ID. Open Get Past Winners node → Link to your Airtable "Winners" table. Open OpenAI Chat Model node → Add your API Key. Open Create a record (Airtable) → Map the fields: Name Facebook ID Date Open Send a text message (Telegram) → Add your Chat ID (e.g., @mychannel). Activate the workflow — done! How To Customize Nodes Customize Filtering Logic Modify the Pre-Filter (Blocklist) Code node: Change the minimum character length (default is 2). Adjust the "Blocklist" duration (e.g., allow users to win again after 7 days instead of 30). Customize AI Criteria Modify the Sentiment Analysis or OpenAI prompt: Look for "Creative" or "Humorous" comments instead of just "Positive". Filter for specific keywords related to your brand. Customize Notifications Replace Telegram with: Slack** (for internal team updates). Discord** (for gaming communities). Email** (SMTP/Gmail) to notify the marketing team. Customize Storage Replace Airtable with: Google Sheets Notion PostgreSQL / MySQL Add-Ons (Optional Enhancements) You can extend this workflow to: Auto-Reply:** Use the Facebook API to reply to the winner's comment automatically ("Congrats! DM us to claim."). Image Generation:** Use OpenAI DALL-E or Bannerbear to generate a "Winner Certificate" image. Cross-Posting:** Automatically post the winner's name to Twitter/X or LinkedIn. Sentiment Report:** Create a weekly summary of overall community sentiment (Positive vs Negative ratio). Prize Tiering:** Assign different prizes based on the quality of the comment. Use Case Examples Daily Product Giveaways Reward one user every day who comments why they love your product. Feedback Drives Encourage users to leave constructive feedback and reward the most helpful positive comment. Community Engagement Keep your group active by automating "Best Comment of the Day" rewards. Brand Loyalty Programs Track "Super Fans" by counting how many times they participate (even if they don't win). Troubleshooting Guide | Issue | Possible Cause | Solution | | :--- | :--- | :--- | | No comments found | Invalid Post ID or Token | Check Facebook Graph API token and Post ID. | | No winner selected | No positive comments | AI found no "Positive" sentiment. Check prompt or input data. | | Airtable Error | Field Mismatch | Ensure column names in Airtable match exactly (Name, Facebook ID). | | Telegram Error | Bot Permissions | Ensure the Bot is an Admin in the channel. | | Workflow Stuck | API Rate Limit | Check OpenAI or Facebook API usage limits. | Need Help? If you need help customizing or extending this workflow, adding multi-platform support (Instagram/YouTube), integrating complex prize logic or setting up advanced dashboards, feel free to hire n8n automation developers at WeblineIndia. We are happy to assist you with advanced automation solutions.

(Retail) Customer Cleanup API → Supabase and send Notification This workflow provides an API-first solution to validate, clean, deduplicate and store customer data in Supabase. It ensures consistent customer records, prevents duplicates and keeps both internal teams and customers informed through automated notifications. This workflow acts as a backend customer intake API. It validates and normalizes incoming customer data, checks for existing users in Supabase, stores new customers safely and returns clear API responses. Internal teams receive Slack and Telegram updates, while customers get an email confirmation on successful creation. You receive: Centralized customer data validation** Automatic duplicate prevention** Supabase-backed customer storage** Real-time API responses** Team notifications + user confirmation email** Ideal for retail, e-commerce and SaaS teams that want clean customer data without manual intervention. Quick Start – Implementation Steps Import the provided n8n workflow JSON. Configure Supabase credentials with read/write access. Connect Slack, Telegram and Gmail/SMTP credentials. Copy the Webhook URL and use it as your customer intake API. Activate the workflow — your customer API is live. What It Does This workflow automates customer data intake and processing: Receives customer data via a POST API call. Cleans and normalizes names, email and phone numbers. Validates required fields and formats using JavaScript. Aggregates clear, field-specific validation errors. Checks Supabase to prevent duplicate users. Stores valid, new customers in Supabase. Returns structured API responses (success, validation error or duplicate). Sends notifications to Slack and Telegram. Emails the customer after successful account creation. This ensures reliable, consistent customer records across systems. Who’s It For This workflow is ideal for: Retail and e-commerce platforms CRM and customer data teams SaaS product teams Backend automation teams Marketing teams needing clean contact lists Developers building API-driven systems Requirements to Use This Workflow To run this workflow, you need: n8n instance** (cloud or self-hosted) Supabase project** with a customers table Supabase service role key Slack workspace** with API access Telegram bot** + chat ID Gmail or SMTP account** for user notifications How It Works API Request – Client sends customer data to the webhook endpoint. Validation & Cleanup – JavaScript validates and formats data. Validation Fail – Returns 400 response with clear error messages. Duplicate Check – Supabase is queried using the email address. Duplicate Found – Returns 409 response without creating a record. Create Customer – New customer is saved in Supabase. Success Response – API confirms successful creation. Notifications – Slack, Telegram and customer email are triggered. Setup Steps Create a Supabase table with fields for customer data, validation status and errors. Add Supabase credentials to n8n. Import the workflow JSON into n8n. Configure the Webhook node and copy the API URL. Review the validation logic if custom rules are required. Configure Slack, Telegram and email credentials. Test using Postman for invalid, duplicate and valid requests. Activate the workflow. How To Customize Nodes Customize Validation Rules Update the JavaScript validation node to add country-specific phone rules or additional fields. Customize Duplicate Logic Extend duplicate checks to include phone numbers or other identifiers. Customize Notifications Modify Slack and Telegram messages, add emojis, mentions or execution metadata. Add-Ons (Optional Enhancements) You can extend this workflow to: Add API key authentication Enable rate limiting Log failed attempts separately Support multi-country phone validation Add CRM or email marketing sync Implement soft deletes or upserts Use Case Examples Customer Registration API Centralize customer creation for web and mobile apps. Data Hygiene Automation Prevent invalid or duplicate contacts in your database. Retail & CRM Integration Keep customer records consistent across systems. Marketing Readiness Ensure only clean, valid contacts enter campaigns. Troubleshooting Guide | Issue | Possible Cause | Solution | | ----------------------- | ----------------------------- | ----------------------------------- | | Validation always fails | Incorrect payload structure | Ensure data is sent in request body | | Duplicate user created | Duplicate check misconfigured | Verify Supabase filter conditions | | No Slack alert | Invalid credentials | Reconnect Slack API | | No email sent | Gmail/SMTP not configured | Verify sender account | | API not responding | Webhook not active | Activate the workflow | Need Help? If you need help customizing or extending this workflow, adding authentication, scaling for high traffic, integrating CRMs or enhancing validation, the n8n automation team at WeblineIndia can assist you with production-ready automation and integration support. Contact us today.

Facebook Page Comment Moderation Scoreboard → Team Report This workflow automatically monitors Facebook Page comments, analyzes them using AI for intent, toxicity & spam, stores moderation results in a database and sends a clear summary report to Slack and Telegram. This workflow runs every few hours to fetch Facebook Page comments and analyze them using OpenAI. Each comment is classified as positive, neutral or negative, checked for toxicity, spam & abusive language and then stored in Supabase. A simple moderation summary is sent to Slack and Telegram. You receive: Automated Facebook comment moderation AI-based intent, toxicity, and spam detection Database logging of all moderated comments Clean Slack & Telegram summary reports Ideal for teams that want visibility into comment quality without manually reviewing every message. Quick Start – Implementation Steps Import the workflow JSON into n8n. Add your Facebook Page access token to the HTTP Request node. Connect your OpenAI API key for comment analysis. Configure your Supabase table for storing moderation data. Connect Slack and Telegram credentials and choose target channels. Activate the workflow — moderation runs automatically. What It Does This workflow automates Facebook comment moderation by: Running on a scheduled interval (every 6 hours). Fetching recent comments from a Facebook Page. Preparing each comment for AI processing. Sending comments to OpenAI for moderation analysis. Extracting structured moderation data: Comment intent Toxicity score Spam detection Abusive language detection Flagging risky comments based on defined rules. Storing moderation results in Supabase. Generating a summary report. Sending the report to Slack and Telegram. This ensures consistent, repeatable moderation with no manual effort. Who’s It For This workflow is ideal for: Social media teams Community managers Marketing teams Customer support teams Moderation and trust & safety teams Businesses managing high-volume Facebook Pages Anyone wanting AI-assisted comment moderation Requirements to Use This Workflow To run this workflow, you need: n8n instance** (cloud or self-hosted) Facebook Page access token** OpenAI API key** Supabase project and table** Slack workspace** with API access Telegram bot** and chat ID Basic understanding of APIs and JSON (helpful but not required) How It Works Scheduled Trigger – Workflow starts automatically every 6 hours. Fetch Comments – Facebook Page comments are retrieved. Prepare Data – Comments are formatted for processing. AI Moderation – OpenAI analyzes each comment. Normalize Results – AI output is cleaned and standardized. Store Data – Moderation results are saved in Supabase. Aggregate Stats – Summary statistics are calculated. Send Alerts – Reports are sent to Slack and Telegram. Setup Steps Import the workflow JSON into n8n. Open the Fetch Facebook Page Comments node and add: Page ID Access token Connect your OpenAI account in the AI moderation node. Create a Supabase table and map fields correctly. Connect Slack and select a reporting channel. Connect Telegram and set the chat ID. Activate the workflow. How To Customize Nodes Customize Flagging Rules Update the normalization logic to: Change toxicity thresholds Flag only spam or abusive comments Add custom moderation rules Customize Storage You can extend Supabase fields to include: Language AI confidence score Reviewer notes Resolution status Customize Notifications Slack and Telegram messages can include: Emojis Mentions (@channel) Links to Facebook comments Severity labels Add-Ons (Optional Enhancements) You can extend this workflow to: Auto-hide or delete toxic comments Reply automatically to positive comments Detect language and region Generate daily or weekly moderation reports Build dashboards using Supabase or BI tools Add escalation alerts for high-risk comments Track trends over time Use Case Examples Community Moderation Automatically identify harmful or spam comments. Brand Reputation Monitoring Spot negative sentiment early and respond faster. Support Oversight Detect complaints or frustration in comments. Marketing Insights Measure positive vs negative engagement. Compliance & Auditing Keep historical moderation logs in a database. Troubleshooting Guide | Issue | Possible Cause | Solution | |-----|---------------|----------| | No comments fetched | Invalid Facebook token | Refresh token & permissions | | AI output invalid | Prompt formatting issue | Use strict JSON prompt | | Data not saved | Supabase mapping mismatch | Verify table fields | | Slack message missing | Channel or credential error | Recheck Slack config | | Telegram alert fails | Wrong chat ID | Confirm bot permissions | | Workflow not running | Trigger disabled | Enable Cron node | Need Help? If you need help customizing, scaling or extending this workflow — such as advanced moderation logic, dashboards, auto-actions or production hardening, then our n8n workflow development team at WeblineIndia can assist with expert automation solutions.

Trello Task-Sync Assistant Description This n8n workflow automates task management by integrating Trello, Supabase, and Telegram to streamline card creation, user assignment, and due date notifications. It ensures seamless synchronization of Trello card data with a Supabase database and sends timely Telegram notifications to keep team members informed about task assignments and deadlines. Key Features Trello Card Syncing**: Automatically registers new Trello cards in Supabase and keeps card details (e.g., due dates, URLs) updated. User Management**: Tracks Trello user assignments in Supabase, creating new user entries and linking them to cards as needed. Real-Time Notifications**: Sends Telegram messages when users are added to or removed from Trello cards, using dynamic, engaging message templates. Due Date Reminders**: Schedules daily checks to notify users via Telegram about tasks due on the current day. Workflow Structure Trello Trigger Flow: Trigger: Activates when a new Trello card is created. Actions: Registers the card in Supabase (cards table) with details like ID, name, and board. Sets up a Trello webhook for real-time updates on the card. Syncs due date changes to Supabase. Detects member additions/removals, checks for existing users in Supabase, creates new user entries if needed, and links users to cards in the card_user table. Webhook Event Flow: Trigger: Processes Trello webhook events (e.g., member changes, due date updates). Actions: Validates event types (add/remove member). Maps Trello usernames to Telegram handles. Sends formatted Telegram notifications with card details and playful, randomized messages for engagement. Due-Date Notification Flow: Trigger: Runs twice daily (every 12 hours) via a scheduled trigger. Actions: Fetches cards due on the current day from Supabase. Retrieves assigned users for each card. Sends Telegram reminders with urgent, formatted messages including card name, board, URL, and due date. Technical Details Tools Used**: Trello: Triggers on card creation and updates via webhooks. Supabase: Stores card, user, and card-user relationship data in cards, users, and card_user tables. Telegram: Sends notifications using a bot. Credentials Required**: Trello API key and token. Supabase URL and key. Telegram bot token and chat ID. Scheduling**: Due date checks run every 12 hours (adjustable). Error Handling**: Includes checks for user existence and conditional logic to manage add/remove events. Use Case Ideal for teams using Trello for project management, this workflow ensures real-time data syncing with Supabase and keeps members informed via Telegram, reducing manual oversight and improving task accountability. It’s particularly useful for remote or distributed teams needing automated task tracking and reminders. Setup Requirements Configure Trello webhooks to point to the n8n webhook URL. Set up Supabase with the required tables (cards, users, card_user). Provide Telegram bot token and chat IDs Test the workflow by creating a Trello card, assigning a member, and setting a due date to verify Supabase entries and Telegram notifications. This workflow enhances productivity by automating task synchronization and communication, ensuring no deadline is missed.

Overview This template creates a smart FAQ bot on Telegram, powered by Google Gemini for intelligent answers and Supabase to store user data. The workflow can distinguish between new and existing users. How It Works Trigger: The workflow starts when a user sends any message to the Telegram Bot. Check User: It looks up the user's chat_id in a Supabase telegram_users table. Route (New vs. Existing): New User (True Path): If the user is not found, the workflow saves their chat_id to Supabase and sends a one-time welcome message. Existing User (False Path): If the user exists, the workflow proceeds to the AI step. Generate Answer: It loads a predefined FAQ context and combines it with the user's question. This is sent to Google Gemini via the AI Agent node. Send Response: The AI-generated answer is sent back to the user on Telegram. Setup Instructions Telegram: Connect your Telegram credentials to the Telegram Trigger and both Send a text message nodes. Supabase: Connect your Supabase credentials to the Find user in DB and Create a row nodes. You MUST have a table named telegram_users. This table MUST have a column named chat_id (type: text or varchar). Google Gemini: Connect your Google Gemini (Palm API) credentials to the Google Gemini Chat Model node. (REQUIRED) Customization: Open the Set FAQ Context node and change its contents with Questions (Q) and Answers (A) that are appropriate for your bot. Change the text in the Send a text message (Welcome Message) node as you want.

This n8n workflow monitors Donald Trump’s Truth Social posts and sends alerts to Telegram & Discord on auto-pilot. Stay instantly updated with every new post, repost, or reply without delays. The workflow fetches posts, processes and filters for freshness, then sends formatted alerts to Telegram and Discord (X optional) for multi-channel alerts. Perfect for media professionals, financial markets professional, traders, political analysts, social media managers, and enthusiasts who want to keep pulse on Trump’s latest Truth Social activity using fully automated, hands-free alerts. Note: Complete setup support and guide included with the workflow file. Who This Template Is For Media Professionals: Journalists and news outlets needing instant coverage of political developments Financial Market Professionals: Traders and analysts monitoring Trump's statements that may impact markets Political Analysts: Researchers tracking political messaging and communication patterns Social Media Managers: Content creators who need to respond quickly to political developments News Enthusiasts: Individuals who want immediate updates without constantly checking Truth Social How It Works Automated Monitoring System Schedule Trigger: Runs every 30 seconds (customizable from 5 seconds to longer intervals) Continuous Operation: Works 24/7 without manual intervention Data Processing & Filtering Post Extraction: Retrieves all new posts from Trump's Truth Social feed Content Processing: Parses posts, reposts, and replies into structured data Duplicate Prevention: Uses Supabase database to track already-sent posts and prevent spam Freshness Filter: Only sends alerts for genuinely new content Multi-Channel Alert Distribution Telegram Integration: Sends formatted alerts to your specified Telegram channel or chat Discord Integration: Simultaneously posts updates to your Discord server/channel Customizable Formatting: Messages include "JUST IN:" prefix for immediate recognition Real-time Delivery: Alerts sent within seconds of post detection. This template transforms manual social media monitoring into a professional, automated alert system that ensures you're always informed of Trump's Truth Social activity across your preferred communication channels.

AI Interior Design Assistant: Your Digital Design Partner What This System Does This n8n workflow transforms your Telegram into a professional interior design studio powered by artificial intelligence. Send a photo of furniture or a room space, and watch as the system intelligently catalogs items, documents spaces, and generates stunning custom interior designs tailored to your vision. The Magic Behind the Scenes Smart Image Recognition When you upload a photo, the system immediately springs into action with sophisticated image analysis: Furniture Detection**: Spots individual pieces like sofas, chairs, tables, and lamps with catalog-precision accuracy Room Analysis**: Identifies complete spaces, architectural features, lighting conditions, and existing design elements Style Classification**: Determines design styles from modern minimalist to traditional classic Material Recognition**: Identifies wood types, fabric textures, metal finishes, and color palettes Intelligent Database Management The workflow maintains three interconnected databases that work like a professional design firm's catalog system: Furniture Catalog (catalog_products) Comprehensive product details including style, materials, dimensions, and compatibility Professional descriptions written for interior designers Searchable tags for quick design matching High-quality image storage for visual reference Room Documentation (rooms) Detailed space analysis including size, style, and architectural features Color palette documentation and lighting assessment Existing furniture inventory for design planning Room-specific design recommendations Design Portfolio (ai_generated_images) Archive of all AI-generated interior designs Original prompts and design descriptions Searchable by style, room type, or specific elements Ready for client presentations or further modifications AI-Powered Design Generation The system's crown jewel is its ability to create stunning interior visualizations: Contextual Understanding: Combines room characteristics with catalog products to create realistic design scenarios Professional Prompting: Generates detailed, interior-design-specific prompts that result in high-quality, commercially viable designs Style Consistency: Maintains design coherence across different elements while respecting user preferences Modification Capabilities: Can reference and modify previous designs, allowing for iterative improvements The User Experience Journey Scenario 1: Building Your Furniture Catalog Upload: Send photos of furniture pieces via Telegram Analysis: AI examines each piece, identifying style, materials, dimensions, and design era Cataloging: Items are professionally documented with searchable metadata Confirmation: Receive detailed catalog entries for each piece Scenario 2: Documenting Your Spaces Room Photos: Share images of your living spaces Space Analysis: AI assesses room size, style, lighting, and architectural features Documentation: Complete room profiles are created for design planning Inventory: Existing furniture and design elements are noted Scenario 3: Creating Custom Designs Design Request: Ask for specific interior modifications or new layouts Smart Matching: System pulls relevant items from your catalog and room data AI Generation: Gemini 2.5 Flash creates photorealistic interior designs Instant Delivery: Receive professional-quality visualizations via Telegram Scenario 4: Design Evolution Reference Previous Work: Mention earlier designs you want to modify Contextual Modification: AI understands your reference and applies new changes Enhanced Generation: Creates updated designs building on previous concepts Continuous Improvement: Iterate until the design matches your vision Technical Sophistication Multi-AI Coordination OpenAI GPT-4**: Handles complex reasoning, database operations, and user interaction Google Gemini 2.5 Flash**: Specializes in high-quality image generation with interior design expertise Intelligent Routing**: Automatically determines whether to catalog, document, or generate based on context Professional Data Structure The database schema reflects real interior design workflows: Industry-standard categorization systems Professional terminology and measurements Design compatibility matrices Style and era classifications used by actual designers Seamless Integration Telegram Interface**: No app downloads or complex interfaces - just send photos and text Cloud Storage**: All images stored in Supabase with public URLs for easy access Real-time Processing**: Immediate feedback and rapid design generation Persistent Memory**: Everything is saved and searchable for future reference Why This Matters This workflow bridges the gap between professional interior design tools and accessible consumer technology. It provides: For Design Professionals: A powerful cataloging and visualization tool that streamlines client presentations and design iteration For Homeowners: Professional-level design capability without the cost or complexity of traditional design software For Businesses: A scalable solution for furniture visualization, space planning, and customer engagement The Innovation Factor Unlike simple design apps that work with generic templates, this system: Learns your specific furniture and spaces Maintains design continuity across projects Provides professional-quality outputs Scales from single rooms to complete home designs Integrates seamlessly into your daily communication workflow The result is a design assistant that feels less like software and more like having a professional interior designer available 24/7 through your phone. Future Possibilities This foundation supports expansion into: Room dimension calculations and space optimization Integration with furniture retailers for purchase links 3D room modeling and virtual reality previews Style preference learning and automated suggestions Multi-user collaboration for design teams The workflow represents a new paradigm where AI doesn't replace human creativity but amplifies it, making professional design capabilities accessible to anyone with a smartphone and an imagination.

What it does The job search process is filled with manual, frustrating tasks—reading endless job descriptions only to find the seniority is wrong, the role requires a language you don't speak, or a "hybrid" job has an impossible commute. This workflow acts as a personal AI assistant that automates the entire top of your job search funnel. It doesn't just find jobs; it reads the full description, checks the commute time from your home, filters by your specific criteria, and even compares the job requirements against your CV to calculate a match score. It's a personalized, decision-making engine that only alerts you to the opportunities that are a perfect fit. How it works The workflow is designed to be fully customized from a single Config node and runs in a multi-layered sequence to find and qualify job opportunities. Scrape Jobs: The workflow triggers and uses Apify to find new job postings on LinkedIn based on a list of keywords you define (e.g., "AI Workflow Engineer," "Automation Specialist"). AI Triage & Smart Filtering: For each job found, a Google Gemini AI performs an initial triage, extracting key data like the job's language, work model (Remote, Hybrid, On-site), and seniority level. The workflow then applies a series of smart filters based on your personal preferences: Language & Seniority: It discards any jobs that don't match your target language and experience level. Commute Check: For hybrid or on-site roles, it uses the Google Maps API to calculate the commute time from your home address and filters out any that exceed your maximum desired travel time. AI Deep Analysis vs. CV: For the handful of jobs that pass the initial filters, a second, more advanced Google Gemini agent performs a deep analysis. It compares the job description against your personal CV (which you paste into the config) to generate a summary, a list of key required skills, and a final match score (e.g., 8/10). Log & Alert: The final step is action. The full analysis of every qualified job is logged in a Supabase database for your records. However, only jobs with a match score above your set threshold will trigger an immediate, detailed alert in Telegram, ensuring you only focus on the best opportunities. Setup Instructions This workflow is designed for easy setup, with most personal preferences controlled from a single node. Required Credentials Apify: You will need an Apify API Token. Google Cloud: You will need credentials for a Google Cloud project with the Google AI (Gemini) and Google Maps APIs enabled. Supabase: You will need your Supabase Project URL and Service Role Key. Telegram: You will need a Telegram Bot Token and the Chat ID for the channel where you want to receive alerts. Step-by-Step Configuration Almost all customization is done in the Config node. Open it and set the following parameters to match your personal job search criteria: MyCV: Paste the full text of your CV/resume here. This is used by the AI to compare your skills against the job requirements. JobKeywords: Search keywords for jobs (e.g., "engineer", "product manager"). JobsToScrape: The maximum number of relevant job postings to scrape in each run. HomeLocation: Your home city and country (e.g., "Breda, Netherlands"). This is used as the starting point for calculating commute times for hybrid or onsite jobs. MaxCommuteMinutes: Your personal maximum one-way commute time in minutes. The workflow will filter out any jobs that require a longer travel time. TargetLanguage: Your preferred language for job postings. The workflow will filter out any jobs not written in this language. You can list multiple languages, separated by a comma. ExperienceLevel: The seniority level you are looking for. The AI will validate this against the job description. The value can be: "" → (Any) "internship" → (Internship) "entry" → (Entry Level) "associate" → (Associate) "mid_senior" → (Mid-Senior Level) "director" → (Director) "executive" → (Executive) Under10Applicants: Set to true if you only want to see jobs with fewer than 10 applicants. Set to false to see all jobs. After setting up the Config node, configure the Supabase and Telegram nodes with your specific credentials and table/chat details. How to Adapt the Template This workflow is a powerful framework for any search and qualification process. Change Job Source:* Swap the Apify* node to scrape different job boards, or use an RSS Feed Reader node to get jobs from sites that provide feeds. Refine AI Logic:* The prompts in the two Google Gemini* nodes are the core of the engine. You can edit them to extract different data points, change the scoring criteria, or even ask the AI to evaluate a company's culture based on the tone of the job description. Change the Database:* Replace the Supabase node with Airtable, *Google Sheets, or a traditional database node like Postgres to log your results. Modify Alerts:* Change the Telegram node to send alerts via Slack, *Discord, or Email. You could also add a step to automatically create a draft application or add the job to a personal CRM.

Purpose and Audience This n8n workflow template is designed to provide real-time alerts on new cryptocurrency exchange listings and delistings. It caters especially to crypto traders, investors, and enthusiasts who want to stay ahead of market changes by receiving timely notifications about token availability across major exchanges like Binance, Bybit, Coinbase, OKX, Upbit, Bithumb, and Hyperliquid. The alerts are delivered via popular communication channels Telegram, X (formerly Twitter), and Discord, ensuring you never miss important updates. What It Does The workflow continuously tracks new token listings announcement from Binance, Bybit, Coinbase, Bithumb, OKX, Upbit, and Hyperliquid futures exchange. It also monitors delistings announcement from Binance, Bybit, OKX, Upbit, and Coinbase. When a new listing or delisting announcement is detected, it automatically sends instant alerts to your subscribed Telegram groups or channels, X accounts, and Discord servers, helping you react quickly to market changes. Who Is It For This workflow is perfect for crypto traders, portfolio managers, market analysts, and anyone active in cryptocurrency investment or community management. By automating the alert process, it saves time and ensures you receive critical exchange listing updates immediately on your preferred platforms without manual monitoring. How to Setup Complete video tutorial setup guide is included with the workflow file. The step-by-step guide walks you through configuring API credentials, connecting your Telegram, X, and Discord accounts, and customizing alert preferences to fit your needs.

✉️ AI-Powered 3-Step B2B Pipeline — Lead Gen → Cold Outreach → AI Drafted Email Management Automate your outbound workflow from prospecting to AI-generated reply drafts in Gmail — all fully integrated with your database. Ideal for SDRs, founders, and growth agencies who want speed, personalization, and control without losing human review. 📌 Example: From a verified lead list to a qualified opportunity — fully tracked, classified, and pre-drafted with this automation. 🚀 What This Workflow Does Step 1 — Lead Generation Import leads from Apollo. Enrich and verify emails. Store results in Supabase/Postgres, Step 2 — Cold Outreach Send 3 step personalized sequences via Mailgun/SendGrid. Track delivery, opens, replies, and bounces directly in your DB. Step 3 — Email Management (AI Drafts) Process only incoming Gmail messages from contacts in your DB. Generate personalized reply drafts, label threads, update lead status, and alert your team via Slack/Telegram. 🔗 Integrated Services Database:** Supabase/Postgres Outbound Email:** Mailgun / SendGrid Inbound Email & Drafts:** Gmail (OAuth2) AI Models:** OpenAI / Anthropic (JSON mode for classification + drafting) Alerts:** Slack / Telegram (optional) 💼 What You Get Detailed setup guide Fully connected 3-step pipeline in n8n Ready-to-use database schema Pre-built AI prompts for intent classification and professional replies 📥 Perfect For SDR teams doing targeted outbound Agencies managing multiple client campaigns Founders building scalable outbound systems Sales ops needing a no-risk, review-first reply process 💡 Why You’ll Love It This isn’t just another outreach template — it’s a full sales engine. From verified leads to AI-drafted replies, every action is logged, tracked, and controlled for maximum conversions without sacrificing oversight.

Description This workflow transforms your quick event notes into polished LinkedIn posts. Simply send a message via Telegram with your event name and personal notes, and the system will match it with your calendar events, generate a professional LinkedIn post. And even if you don't feel like posting it on LinkedIn, it still serves you because it saves everything to your database for future reference. In this way you can build a personal library of your professional networking activities and insights! Who Is This For? Professional Networkers: Business professionals who attend events regularly and want to share insights on LinkedIn without spending time on content creation. Event Enthusiasts: Conference attendees, meetup participants, and workshop goers who want to document and share their experiences professionally. Busy Professionals: Anyone who wants to maintain an active LinkedIn presence but lacks time to craft posts from scratch after events. What Problem Does This Workflow Solve? After attending events, I struggle with several challenges: Time Constraints: Writing thoughtful LinkedIn posts takes time. Writer's Block: Difficulty transforming my raw notes and experiences into engaging social media content. Data Organization: Keeping track of event details, personal insights, and networking opportunities in one place. How It Works Telegram Input: Send a message to your Telegram bot with the format "Event Name: Your personal notes" Message Parsing: The system extracts the event name and your personal notes from the message Calendar Matching: Searches your Google Calendar for events from the past 7 days that match the event name Data Enrichment: Combines your personal notes with event details (date, location, attendees) from your calendar AI Content Generation: Uses Claude Opus 4 to transform your notes into a professional LinkedIn post with relevant hashtags Database Storage: Saves the complete event information and generated LinkedIn post to Supabase Ready to Post: Provides you with a polished LinkedIn post ready for publication Setup Instructions n8n (Cloud or self-hosted) Telegram Bot (Create via @BotFather) Google Calendar API (OAuth2 credentials) Anthropic API (Claude access) Supabase (Database and API credentials) My Supabase table consists these columns: Event Date (datetime) Event Title (text) Location (text) Personal Notes (text) LinkedIn Post (text) Created Date (datetime) This workflow transforms the tedious task of creating LinkedIn content into an automated, intelligent system that helps you maintain an active professional presence while building a valuable archive of your networking and learning experiences.

This workflow contains community nodes that are only compatible with the self-hosted version of n8n. AI-Powered Cold Email Sequence Workflow for n8n Unlock advanced cold email automation and boost your outbound results with this robust n8n workflow, engineered for scale, personalization, and flexibility. Harness AI-driven email content, dynamic lead handling, and intelligent scheduling—without writing code. What’s Inside Intelligent Multi-Step Email Outreach Automate 3-step cold email sequences for every prospect—all fully personalized and contextually adapted through AI research and copy generation. Each contact receives tailored, timely emails designed to maximize engagement and reply rates. Automated Personalization at Scale For every new lead, the workflow: Researches company and role context** using AI Identifies key pain points** and crafts custom hooks Builds multi-language, well-formatted HTML emails** with a consistent, brand-aligned tone This produces authentic, individualized communication—far more effective than generic mail merges. Advanced Scheduling & Delivery Logic Smart scheduling**: Sends distributed across optimal days/hours (configurable for your market) Throttled delivery**: Drip batching and dynamic waits to preserve deliverability Automated follow-ups**: Gentle, contextual nudges at precise intervals if there’s no reply Lead Management & Expansion Seamless database integration**: Email history, logic, and lead data fully synchronized with your backend (Supabase support included) Integrated lead generation**: Suite includes a companion workflow for sourcing, deduplicating, and enriching leads using Apollo, GPT-4, and AI—feeds directly into your campaign pipeline Built for Reliability and Scale Resilient against errors and duplicate sends Multi-sender rotation** for reputation management Easily customizable scheduling, content, languages, and batch size Tracks all critical data fields, like send history and reply status Use Cases B2B Sales Development** Automated Candidate Outreach (Recruitment)** Newsletter or Event Drip Campaigns** Startup Go-to-Market Sequences** Agency Lead Generation** Template Highlights AI-Powered Personalization**: Cold emails crafted by GPT-4 and prompt engineering Omnichannel Scheduling**: Dynamic batching, throttling, sender rotation Works Out-of-the-Box**: Connects to Mailgun, OpenAI, Supabase—simply insert credentials and leads Companion Lead Gen Workflow: Includes Apollo–AI–database pipeline for continuous sourcing that you can acces **for free in my profile. Flexible & Modular**: Adapt language, schedule, templates, or trigger events as your strategy evolves Best Practice Features No PII or sensitive data embedded—safe for corporate teams Modular zones for sequence creation, delivery, and tracking—clarity and easy expansion Clearly-named nodes and logical flows, following n8n community standards Robust error handling for high deliverability and low maintenance Experience end-to-end intelligent email automation—powered by n8n, trusted integrations, and state-of-the-art AI. Both the cold outreach workflow and the lead generation template are included. Discover, engage, and convert—at scale.

N8N Hybrid RAG Chatbot with Multiple AI Agents One of the most powerful system in the market, this template creates a sophisticated, multi-agent hybrid RAG (Retrieval-Augmented Generation) chatbot that can handle diverse user queries by routing them to a “Supervisor AI agent”. The Supervisor agent will then send the request to “Expert AI agents”, agents specializing in specific domains. In addition, this system automates data ingestion from various sources (including websites and Google Drive), processes and stores the information in a vector database, and interacts with users through Telegram in multiple languages. For more powerful n8n templates, visit our website at aiautomationpro.org. Who’s it for? This template is ideal for: Developers and Businesses** looking to build a powerful, knowledge-based chatbot for customer support, internal knowledge management, or lead generation. AI Enthusiasts** who want to explore advanced concepts like multi-agent systems, RAG, and automated data pipelines. n8n Users** who want to build a scalable and customizable AI solution that integrates multiple services. Key Features Multi-Agent Architecture:** Utilizes a supervisor agent to route queries to specialized agents for different domains (e.g., Products, News, Academy). Automated Data Ingestion:** Automatically scrapes data from websites and syncs new or updated files from Google Drive. Retrieval-Augmented Generation (RAG):** Enriches the chatbot's knowledge by retrieving relevant information from a Supabase vector store and a Postgres database. Telegram Integration:** Provides a seamless, multi-language chat interface for users to interact with the bot. Dynamic Data Handling:** Automatically processes and embeds data from various sources like Google Docs, PDFs, and Word documents. Data Management:** Keeps the knowledge base up-to-date by automatically handling document creation, updates, and deletions. How it works The workflow is divided into three main parts: data ingestion, data management, and the chat interface. Data Ingestion & Processing: Web Scraping: The workflow fetches URLs from a Google Sheet, scrapes the content using Crawl4ai, cleans it with an AI agent, and saves it to a Google Doc. Google Drive Sync: It monitors specific Google Drive folders for new or updated files (Google Docs, PDFs, Word documents). Embedding & Storage: The content from these sources is then chunked, converted into vector embeddings using OpenAI, and stored in a Supabase vector database for efficient retrieval. Data Deletion: A scheduled trigger periodically checks a Google Sheet for records marked as "deleted." It then removes the corresponding data from the Supabase vector store and deletes the file from Google Drive to ensure the chatbot's knowledge remains current. Chat Interface & Logic (Telegram): User Input: The chatbot receives user messages via a Telegram trigger. Language Detection: It first detects the language of the query and translates it to English if necessary. Supervisor Agent: A central "Supervisor" AI agent analyzes the user's query. Agent Routing: Based on the query, the Supervisor delegates the task to the most appropriate specialized agent: News AI Agent: Handles questions about current events. Product AI Agent: Answers queries about product details from a Postgres database. Academy AI Agent: Responds to questions about courses and educational content. Response Generation: The selected agent processes the query, retrieves the necessary information using RAG, generates a response, and translates it back to the user's original language before sending it via Telegram. Requirements To use this template, you will need accounts and credentials for the following services: n8n OpenAI Supabase (for vector storage) Google Workspace (Google Drive, Google Sheets, Google Docs) Telegram Bot Postgres Database Crawl4AI Step-by-step Setup Configure Credentials: Add your API keys and credentials for all the required services (OpenAI, Supabase, Google, Telegram, Postgres) in the n8n Credentials section. Set up Google Drive: Create two folders in your Google Drive: one for documents scraped from websites and another for manual document uploads. Note the folder IDs. Set up Google Sheets: Clone the Google Sheet template, or create a Google Sheet with two tabs: Website Links and Manual Documents. In the Website Links tab, add columns for Link, Category Code, Is Scraped, and Is Deleted. In the Manual Documents tab, add columns for Document ID, Title, Category Code, and Is Deleted. Set up Supabase: Create a new project in Supabase. Run the provided SQL script to create the documents table for vector storage. Set up Postgres: Set up a Postgres database (in Supabase). Run the provided SQL script to create the products table to store product details. Configure the Main Workflow: Open the AIAutomationPro Ultimate RAG Chatbot main workflow. Update the Google Drive, Google Sheets, Supabase, and Postgres nodes with your specific Folder IDs, Sheet Names, and table names. Link the three sub-workflows (News AI Agent, Product AI Agent, Academy AI Agent) in the corresponding Workflow Tool nodes. Activate Workflows: Activate the main workflow and all three sub-flow workflows. Start Chatting: Send a message to your Telegram bot to start interacting with your new RAG chatbot. How to Customize the Workflow Add More Agents:** You can create new sub-workflows with specialized agents for different topics (e.g., a "Finance AI Agent"). Simply add a new Workflow Tool node in the main flow and update the Supervisor Agent's system prompt to include the new agent's capabilities. Change Data Sources:** Modify the data ingestion part of the workflow to pull data from other sources like Notion, HubSpot, or a CRM by adding the relevant n8n nodes. Adjust the AI Model:** You can switch to a different LLM by replacing the OpenAI Chat Model nodes. Modify Prompts:** Fine-tune the system prompts in the Agent nodes to alter the personality, instructions, or output format of the chatbot and its specialized agents.