Chat with your email history using Telegram, Mistral and Pgvector for RAG
Who is this for? Everyone! Did you dream of asking an AI "what hotel did I stay in for holidays last summer?" or "what were my marks last semester like?". Dream no more, as vector similarity searches and this workflow are the foundations to make it possible (as long as the information appears in your e-mails 😅). 100% Local and Open Source! This workflow is designed to use locally-hosted open source. Ollama as LLM provider, nomic-embed-text as the embeddings model, and pgvector as the vector database engine, on top of Postgres. Structured AND Vectorized This workflow combines structured and semantic search on your e-mail. No need for enterprise setups! Leverage the convenience of n8n and open source to get a bleeding edge solution. Setup You will need a PGVector database with embeddings for all your email. Use my other template Gmail to Vector Embeddings with PGVector and Ollama to set it up in a breeze! Make a copy of my Email Assistant: Convert Natural Language to SQL Queries with Phi4-mini and PostgreSQL, you will need it for structured searches. Install this template and modify the Call the SQL composer Workflow step, to point at your copy of the SQL workflow. Adjust the rest of necessary steps: Telegram Trigger, AI Chat model, AI Embeddings... Activate the workflow and chat around!
By Alfonso CorrettiBuild a multichannel customer support AI assistant with Chatwoot & OpenRouter
Multichannel AI Assistant Demo for Chatwoot This simple n8n template demonstrates a Chatwoot integration that can: Receive new messages via a webhook. Retrieve conversation history. Process the message history into a format suitable for an LLM. Demonstrate an AI Assistant processing a user's query. Send the AI Assistant's response back to Chatwoot. Use Case: If you have multiple communication channels with your clients (e.g., Telegram, Instagram, WhatsApp, Facebook) integrated with Chatwoot, you can use this template as a starting point to build more sophisticated and tailored AI solutions that cover all channels at once. How it works A webhook receives the message created event from Chatwoot. The webhook data is then filtered to keep only the necessary information for a cleaner workflow. The workflow checks if the message is "incoming." This is crucial to prevent the assistant from replying to its own messages and creating endless loops. The conversation history is retrieved from Chatwoot via an API call using the HTTP Request node. This allows the assistant's interaction to be more natural and continuous without needing to store conversation history locally. A simple AI Assistant processes the conversation history and generates a response to the user based on its built-in knowledge base (see the prompt in the assistant node). The final HTTP Request node sends the AI-generated response back to the appropriate Chatwoot conversation. How to Use In Chatwoot, go to Settings → Integrations → Webhooks and add your n8n webhook URL. Be sure to select the message created event. In the HTTP Request nodes, replace the placeholder values: https://yourchatwooturl.com apiaccesstoken You can find these values on your Chatwoot super admin page. The LLM node is configured to use OpenRouter. Add your OpenRouter credentials, or replace the node with your preferred LLM provider. Requirements An API key for OpenRouter or credentials for your preferred LLM provider. A Chatwoot account with at least one integrated channel and super admin access to obtain the apiaccesstoken. Need Help Building Something More? Contact me on: Telegram: @ninesfork LinkedIn: George Zargaryan Happy Hacking! 🚀
By George ZargaryanTrack food calories via Telegram with GPT-4 Vision and Google Sheets
This workflow enables users to submit food images to a Telegram bot, which uses OpenAI’s GPT-4 Vision to identify the item and estimate its caloric value. The results are stored in Google Sheets and sent back to the user. What it does: Triggers on a photo sent via Telegram. Acknowledges the user with a sticky note message. Downloads the image file securely using Telegram's API. Sends the image to GPT-4 Vision with a prompt: “Describe this food and estimate its calories.” Logs the GPT response to a Google Sheet (with timestamp). Replies to the user with the result (e.g., food name and estimated calories). Use cases: Personal food tracking Nutrition logging via chat Meal journaling for fitness or health Requirements: Telegram Bot Token (via credentials) OpenAI GPT-4 Vision access Google Sheets credential with access to the target sheet Notes: You can extend this template to calculate daily totals, categorize meals (breakfast/lunch/dinner), or even integrate with calorie goals. The sticky note node confirms receipt to enhance UX. Ideal for wellness apps, chat-based food journals, or AI-powered health bots.
By ShivaTrack and analyze backlink opportunities with Bright Data MCP and GPT-4o
This workflow automatically identifies and tracks backlink opportunities by analyzing competitor link profiles and finding potential linking websites. It saves you time by eliminating the need to manually research backlink prospects and provides a systematic approach to link building and SEO improvement. Overview This workflow automatically scrapes competitor backlink profiles and analyzes potential linking opportunities by examining referring domains, anchor text patterns, and link quality metrics. It uses Bright Data to access backlink data sources and AI to intelligently identify high-value linking opportunities for your SEO strategy. Tools Used n8n: The automation platform that orchestrates the workflow Bright Data: For scraping backlink analysis platforms without being blocked OpenAI: AI agent for intelligent backlink opportunity analysis Google Sheets: For storing backlink opportunities and tracking data How to Install Import the Workflow: Download the .json file and import it into your n8n instance Configure Bright Data: Add your Bright Data credentials to the MCP Client node Set Up OpenAI: Configure your OpenAI API credentials Configure Google Sheets: Connect your Google Sheets account and set up your backlink tracking spreadsheet Customize: Define target domains and backlink analysis parameters Use Cases SEO Teams: Identify high-quality backlink opportunities for link building campaigns Content Marketing: Find websites that might be interested in linking to your content Competitive Analysis: Analyze competitor link profiles to discover new opportunities Digital PR: Identify potential media outlets and industry websites for outreach Connect with Me Website: https://www.nofluff.online YouTube: https://www.youtube.com/@YaronBeen/videos LinkedIn: https://www.linkedin.com/in/yaronbeen/ Get Bright Data: https://get.brightdata.com/1tndi4600b25 (Using this link supports my free workflows with a small commission) n8n automation backlinks seo linkbuilding brightdata webscraping seotools n8nworkflow workflow nocode linkanalysis backlinkresearch seoautomation linkprospecting digitalmarketing backlinkmonitoring seoanalysis linkopportunities competitoranalysis seoresearch linkstrategy backlinkanalysis domainanalysis linktracking seomonitoring searchmarketing organicseo linkbuilding seocampaigns
By Yaron BeenBeginner's Guide to Workflow Automation with OpenAI, LangChain & API Integrations
How it works This beginner-friendly workflow demonstrates the core building blocks of n8n. It guides you through: Triggers – Start workflows manually, on a schedule, via webhooks, or through chat. Data processing – Use Set and Code nodes to create, transform, and enrich data. Logic and branching – Apply conditions with IF nodes and merge different branches back together. API integrations – Fetch external data (e.g., users from an API), split arrays into individual items, and extract useful fields. AI-powered steps – Connect to OpenAI for generating fun facts or build interactive assistants with chat triggers, memory, and tools. Responses – Return structured results via webhooks or summary nodes. By the end, it demonstrates a full flow: creating data → transforming it → making decisions → calling APIs → using AI → responding with outputs. Set up steps Time required: 5–10 minutes. What you need: An n8n instance (cloud or self-hosted). Optional: API credentials (e.g., OpenAI) if you want to test AI features. Setup flow: Import this workflow. Add your API keys where needed (OpenAI, etc.). Trigger the workflow manually or test with webhooks. >👉 Detailed node explanations and examples are already included as sticky notes inside the workflow itself, so you can learn step by step as you explore.
By MeeliooBilibili video downloader with Google Drive upload & email notification
Bilibili Video Downloader with Google Drive Upload & Email Notification Automate downloading of Bilibili videos via the Bilibili Video Downloader API (RapidAPI), upload them to Google Drive, and notify users by email — all using n8n workflow automation. --- 🧠 Workflow Overview This n8n automation allows users to: Submit a Bilibili video URL. Fetch download info from the Bilibili Video Downloader API (RapidAPI). Automatically download and upload the video to Google Drive. Share the file and send an email notification to the user. --- ⚙️ Node-by-Node Explanation | Node | Function | | ---------------------------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------- | | On form submission | Triggers when a user submits the Bilibili video URL through the form. | | Fetch Bilibili Video Info from API | Sends the video URL to the Bilibili Video Downloader API (RapidAPI) to retrieve download info. | | Check API Response Status | Validates that the API returned a 200 success status before proceeding. | | Download Video File | Downloads the actual video from the provided resource URL. | | Upload Video to Google Drive | Uploads the downloaded video file to the user’s connected Google Drive. | | Google Drive Set Permission | Sets sharing permissions to make the uploaded video publicly accessible. | | Success Notification Email with Drive Link | Sends the Google Drive link to the user via email upon successful upload. | | Processing Delay | Adds a delay before executing error handling if something fails. | | Failure Notification Email | Sends an error notification to the user if download/upload fails. | --- 🧩 How to Configure Google Drive in n8n In n8n, open Credentials → New → Google Drive. Choose OAuth2 authentication. Follow the on-screen instructions to connect your Google account. Use the newly created credential in both Upload Video and Set Permission nodes. Test the connection to ensure access to your Drive. --- 🔑 How to Obtain Your RapidAPI Key To use the Bilibili Video Downloader API (RapidAPI): Visit bilibili videodownloade. Click Subscribe to Test (you can choose free or paid plans). Copy your x-rapidapi-key from the “Endpoints” section. Paste the key into your n8n Fetch Bilibili Video Info from API node header. Example header: json { "x-rapidapi-host": "bilibili-video-downloader.p.rapidapi.com", "x-rapidapi-key": "your-rapidapi-key-here" } --- 💡 Use Case This automation is ideal for: Content creators archiving Bilibili videos. Researchers collecting media resources. Teams that need centralized video storage in Google Drive. Automated content management workflows. --- 🚀 Benefits ✅ No manual downloads – fully automated. ✅ Secure cloud storage via Google Drive. ✅ Instant user notification on success or failure. ✅ Scalable for multiple users or URLs. ✅ Powered by the reliable Bilibili Video Downloader API (RapidAPI). --- 👥 Who Is This For n8n developers wanting to explore advanced workflow automations. Content managers handling large volumes of Bilibili content. Digital archivists storing video data in Google Drive. Educators sharing Bilibili educational videos securely. --- 🏁 Summary With this n8n workflow, you can seamlessly integrate the Bilibili Video Downloader API (RapidAPI) into your automation stack — enabling effortless video downloading, Google Drive uploading, and user notifications in one unified system.
By Sk developer Automate Gmail tasks with Gemini AI assistant and contact management
--- Use cases are many: Automate Gmail tasks such as sending, replying, labeling, deleting, and fetching emails — all with AI assistance. Perfect for YouTubers managing viewer emails, sales teams handling inquiries, freelancers responding to client requests, or professionals keeping their inbox organized. --- Good to know At time of writing, each Gemini request is billed per token. See Gemini Pricing for updated details. The workflow uses Gmail labels (e.g., youtube-viewers, sales-inquiry, meeting-request, potential-clients, collaboration-requests) for classification — make sure these exist in your Gmail account. --- How it works Chat Trigger: You interact with the agent via a chat interface (webhook). AI Agent: Gemini-powered assistant interprets your instructions (send, reply, label, delete, fetch emails). Email Actions: Based on your request, the assistant uses Gmail tools to act on emails (Send, Reply, Label, Delete, Get Many). Contact Lookup: If only a name is provided, the agent checks Google Sheets for the matching email address. If not found, it prompts you to add it. Memory: A buffer memory stores chat context so the assistant can maintain continuity across multiple interactions. Labeling: Emails can be auto-labeled for better organization (e.g., client inquiries, meeting requests). --- How to use Send commands like: “Reply to John’s email with a follow-up about the project.” “Label Sarah’s email as potential-client.” “Delete the latest spam email.” The Gmail Agent will handle the request instantly and keep everything logged properly. --- Requirements Gmail account connected with OAuth2 credentials Google Gemini API key for AI processing Google Sheets for contact management Pre-created Gmail labels for organization --- Customising this workflow Add new Gmail labels for your workflow (e.g., Invoices, Support Tickets*). Connect to a CRM (e.g., HubSpot, Notion, or Airtable) for syncing email data. Enhance AI replies with dynamic templates stored in Google Sheets. Extend chat commands to include batch actions (e.g., “Archive all emails older than 30 days”). ---
By Rakin JakariaGenerate ad images from campaign briefs with GPT-4o and OpenAI Image API
Description: Supercharge your marketing with this next-gen n8n workflow template, powered by GPT-4o! Instantly convert your campaign briefs into stunning, high-impact advertising images—no manual design work required. This automation captures your brand’s unique voice, visual style, and campaign goals, then uses GPT-4o-mini to craft ultra-specific prompts for OpenAI’s image generation API. Within seconds, you’ll receive vibrant, ready-to-use ad visuals, perfectly tailored for your audience and objectives. The workflow delivers: 🚀 Lightning-fast AI-generated ad images from your campaign insights 🎯 Brand-aligned, visually striking creatives—every time 📝 Automated prompt creation based on your tone, palette, and scene ideas 📐 High-resolution, square-format images (1024x1024) for maximum versatility 🔗 Downloadable files for instant campaign deployment 🌟 100% hands-free: just input your brief and let AI handle the rest Perfect for marketing teams, agencies, and entrepreneurs who want to scale creative production, boost consistency, and stand out with AI-powered ad visuals. Keywords: n8n GPT-4o image automation, AI ad creative generator, campaign brief to image, OpenAI marketing visuals, instant ad image workflow, automated creative production.
By Rahul Joshi