π Learn n8n expressions with an interactive step-by-step tutorial for beginners
How it works This template is an interactive, step-by-step tutorial designed to teach you the most important skill in n8n: using expressions to access and manipulate data. If you know what JSON is but aren't sure how to pull a specific piece of information from one node and use it in another, this workflow is for you. It starts with a single "Source Data" node that acts as our filing cabinet, and then walks you through a series of lessons, each demonstrating a new technique for retrieving and transforming that data. You will learn how to: Access a simple value from a previous node. Use n8n's built-in selectors like .last() and .first(). Get a specific item from a list (Array). Drill down into nested data (Objects). Combine these techniques to access data in an array of objects. Go beyond simple retrieval by using JavaScript functions to do math or change text. Inspect data with utility functions like Object.keys() and JSON.stringify(). Summarize data from multiple items using .all() and arrow functions. Set up steps Setup time: 0 minutes! This workflow is a self-contained tutorial and requires no setup or external credentials. Click "Execute Workflow" to run the entire tutorial. Follow the flow from the "Source Data" node to the "Final Exam" node. For each lesson, click on the node to see how its expressions are configured in the parameters panel. Read the detailed sticky note next to each lessonβit breaks down exactly how the expression works and why. By the end, you'll have the foundational knowledge to connect data and build powerful, dynamic workflows in n8n.
Monitor favorite YouTube channels through RSS feeds and receive notifications
This workflow creates an automated system for monitoring and receiving notifications about new videos from your favorite YouTube channels through RSS feeds, with customizable email and Telegram notifications. π Key Features π‘ RSS Feed Management Accepts custom YouTube channel IDs or uses default channels Automatically creates RSS feeds for each YouTube channel Monitors channels for new video uploads Labels and filters recent videos within a 3-day window (change this as required) π¨ Multi-Channel Notification System Sends Telegram notifications with video thumbnails and links Delivers customized email notifications in two formats: Individual emails for each new video Single digest email containing all new videos βοΈ Content Processing Fetches detailed video information using YouTube API Creates responsive HTML email templates with video previews Includes video thumbnails, titles, descriptions, and direct links Maintains professional formatting across different email clients π οΈ Setup Requirements π API Configuration YouTube Data API credentials Gmail account for sending notifications Telegram bot token and chat ID OpenAI API key for content processing π Channel Management Add YouTube channel IDs through form input Configure default channel list Set notification preferences Adjust monitoring schedule This workflow is perfect for content creators, marketers, or anyone wanting to stay updated with their favorite YouTube channels through automated, professionally formatted notifications delivered via email and Telegram.
Build multi-client agentic RAG document processing pipeline with Supabase Vector DB
Ultimate n8n Agentic RAG Template Author: Cole Medin What is this? This template provides a complete implementation of an Agentic RAG (Retrieval Augmented Generation) system in n8n that can be extended easily for your specific use case and knowledge base. Unlike standard RAG which only performs simple lookups, this agent can reason about your knowledge base, self-improve retrieval, and dynamically switch between different tools based on the specific question. Why Agentic RAG? Standard RAG has significant limitations: Poor analysis of numerical/tabular data Missing context due to document chunking Inability to connect information across documents No dynamic tool selection based on question type What makes this template powerful: Intelligent tool selection: Switches between RAG lookups, SQL queries, or full document retrieval based on the question Complete document context: Accesses entire documents when needed instead of just chunks Accurate numerical analysis: Uses SQL for precise calculations on spreadsheet/tabular data Cross-document insights: Connects information across your entire knowledge base Multi-file processing: Handles multiple documents in a single workflow loop Efficient storage: Uses JSONB in Supabase to store tabular data without creating new tables for each CSV Getting Started Run the table creation nodes first to set up your database tables in Supabase Upload your documents through Google Drive (or swap out for a different file storage solution) The agent will process them automatically (chunking text, storing tabular data in Supabase) Start asking questions that leverage the agent's multiple reasoning approaches Customization This template provides a solid foundation that you can extend by: Tuning the system prompt for your specific use case Adding document metadata like summaries Implementing more advanced RAG techniques Optimizing for larger knowledge bases --- I do intend on making a local version of this agent very soon!
Automate invoice processing from Gmail with Azure GPT-4.1 and human verification
This workflow contains community nodes that are only compatible with the self-hosted version of n8n. This n8n workflow automates invoice management by integrating Gmail, PDF analysis, and Azure OpenAI GPT-4.1, with an optional human verification step for accuracy and control. It's ideal for businesses or individuals who regularly receive invoice emails and want to streamline their accounts payable process with minimal manual effort. The system continuously monitors Gmail for new messages from specified senders. When it detects an email with a PDF attachment and relevant subject line (e.g., "Invoice"), it automatically extracts text from the PDF, analyzes it using Azure OpenAI, and determines if it is a valid invoice. If the AI is uncertain, the workflow sends a manual approval request to a human reviewer. Valid invoices are saved to local storage with a timestamped filename, and a confirmation email is sent upon successful processing. π― Who This Is For Small to medium businesses Freelancers or consultants who receive invoices via email IT or automation teams looking to streamline document workflows Anyone using n8n with access to Gmail and Azure OpenAI β Features Gmail Monitoring β Automatically checks for new emails from trusted senders AI-Powered Invoice Detection β Uses Azure GPT-4.1 to intelligently verify PDF contents PDF Text Extraction β Extracts readable text for analysis Human-in-the-Loop Verification β Requests approval when AI confidence is low Secure File Storage β Saves invoices locally with structured filenames Email Notifications β Sends confirmations or manual review alerts βοΈ Setup Instructions Prerequisites An active n8n instance (self-hosted or cloud) A Gmail account with OAuth2 credentials An Azure OpenAI account with access to the GPT-4.1 model A local directory for saving invoices (e.g., C:/Test/Invoices/) Gmail OAuth2 Setup In n8n, create Gmail OAuth2 credentials. Configure it with Gmail API access (read emails and attachments). Update the Gmail Trigger node to filter by sender email (e.g., sender@gmail.com). Azure OpenAI Setup Create Azure OpenAI API credentials in n8n. Ensure your endpoint is correctly set and GPT-4.1 access is enabled. Link the credentials in the AI Analysis node. Customize Workflow Settings Sender Email β Update in Gmail Trigger Notification Email β Update in Send Notification node Save Directory β Change in Save Invoice node Testing the Workflow Send a test email from the configured sender with a PDF invoice. Wait for the workflow to trigger and check for: File saved in the directory Confirmation email received Manual review request (if needed) π Workflow Steps Gmail Trigger β Check for PDF Invoice β Extract PDF Text β Analyze with GPT-4.1 β β³ If Invoice: Save & Notify β³ If Uncertain: Request Human Review β³ If Not Invoice: Send Invalid Alert
Translate documents to multiple languages with Google Drive and DeepL
Who's it for This workflow is perfect for content creators, international teams, and businesses that need to translate documents into multiple languages automatically. Whether you're localizing documentation, translating marketing materials, or creating multilingual content, this workflow saves hours of manual work. What it does Automatically monitors a Google Drive folder for new documents (PDF, DOCX, TXT, or Markdown) and translates them into multiple languages using DeepL API. Each translated document is saved with a language-specific filename (e.g., documenten.pdf, documentzh.pdf) in a designated folder. You receive an email notification when all translations are complete. How it works Monitors a Google Drive folder for new files Detects file format (PDF/DOCX/TXT/Markdown) and extracts text Translates the content into your chosen languages (default: English, Chinese, Korean, Spanish, French, German) Saves translated files with language codes in the filename Sends an email notification with translation summary Optional: Records translation history in Notion database Set up instructions Requirements Google Drive account (for file storage) DeepL API key (free tier: 500,000 characters/month) Gmail account (for notifications) Notion account (optional, for tracking translation history) Setup steps Create Google Drive folders: Create a "Source" folder for original files Create a "Translated" folder for output Copy the folder IDs from the URLs Get DeepL API key: Sign up at DeepL API Copy your API key Configure the workflow: Open the "Configuration (Edit Here)" node (yellow node) Replace folder IDs with your own Set your notification email Choose target languages Set up credentials: Add Google Drive OAuth2 credentials Add DeepL API credentials Add Gmail OAuth2 credentials Activate the workflow and upload a test file! Customization options Change target languages: Edit the targetLanguages array in the Configuration node (supports 30+ languages) Adjust polling frequency: Change trigger from "every minute" to hourly or daily for batch processing Enable Notion tracking: Set enableNotion to true and provide your database ID Add more file formats: Extend the Switch node to handle additional file types Filter by file size: Add conditions to skip files larger than a certain size Supported languages EN (English), ZH (Chinese), KO (Korean), JA (Japanese), ES (Spanish), FR (French), DE (German), IT (Italian), PT (Portuguese), RU (Russian), and 20+ more. Performance Short files (1 page): ~30 seconds for 6 languages Medium files (10 pages): ~2 minutes for 6 languages Large files (100 pages): ~15 minutes for 6 languages Technical Details Trigger: Google Drive folder monitoring (1-minute polling) Translation: DeepL API with automatic source language detection Loop implementation: Split Out + Aggregate pattern for parallel translation Error handling: Catches API failures and sends email alerts Storage: Original file format preserved in translated outputs Notes DeepL free tier provides 500,000 characters/month (approximately 250 pages) For high-volume translation, consider upgrading to DeepL Pro The workflow creates new files instead of overwriting, preserving translation history Google Docs are automatically converted to the appropriate format before translation What You'll Learn This workflow demonstrates several n8n patterns: File format detection and routing (Switch node) Loop implementation with Split Out + Aggregate Binary data handling for file operations Conditional logic with IF nodes (optional features) Cross-node data references Error handling and user notifications Perfect for learning automation best practices while solving a real business problem!
Automate Open House lead management with SignSnapHome, Discord, and Twilio
π SignSnapHome.com Open House Lead Management System Automatically capture, qualify, and follow up with open house visitors in real-time This comprehensive n8n workflow transforms your SignSnap Home open house sign-ins into a complete lead management system with instant notifications, intelligent lead scoring, and automated multi-channel follow-ups. View full blog writeup and YouTube video here: Open House n8n + SignSnapHome Automation --- π― What This Workflow Does Transform every open house visitor into a managed lead with automated processing, scoring, and outreachβall without lifting a finger. Core Features πΈ Visual Lead Capture Automatically processes guest photos from sign-in Converts base64 images to proper binary format Displays guest photos as thumbnails in Discord notifications Supports JPEG, PNG, and other image formats π¨ Smart Lead Scoring System π΄ HOT Leads: No agent + high rating (4-5 stars) β Immediate follow-up priority π WARM Leads: Has agent but no buyer agreement β Potential opportunity π‘ MEDIUM Leads: Standard engagement level π΅ COLD Leads: Has agent with signed agreement OR low rating (1-2 stars) Color-coded Discord embeds for instant visual prioritization π Rich Discord Notifications Beautiful embed cards with all guest information Guest photo thumbnail displayed inline Conditional fields (rating only shows if you have it enabled) Custom field support - ANY extra form fields automatically included Timestamp, contact info, property details Lead priority badge and color coding π± Intelligent SMS Follow-up (via Twilio) Sends personalized text message if phone number provided Different messaging for leads with/without agents Professional, warm tone that encourages response Simple "thank you for visiting" approach π§ Professional Email Follow-up Beautiful HTML email template with gradient header Conditionally shows rating if available Different call-to-action based on agent status Branded footer with SignSnap Home mention Only sends if no phone number (SMS takes priority) Fallback to email if SMS not available βοΈ Flexible Custom Field Support Automatically detects and processes ANY custom fields No workflow modification needed for new form fields Formats field names nicely (snake_case β Title Case) Displays all custom fields in Discord notification Perfect for additional questions like buyer agreements, prequalification status, etc. --- π Workflow Structure Node Breakdown Webhook Trigger - Receives POST data from SignSnap Home Parse & Enrich Data - Extracts and processes all form data Separates standard vs custom fields Calculates lead priority score Formats timestamps and names Detects optional fields (like rating) Convert Image to Binary - Transforms base64 photo to n8n binary format Discord Notification - Sends rich embed with photo thumbnail Has Phone Number? - Conditional routing based on contact preference Send SMS (Twilio) - Priority follow-up via text message Has Email? - Fallback check if no phone provided Send Welcome Email - Professional HTML email follow-up --- β¨ Key Highlights Dynamic & Flexible No hardcoded fields - automatically adapts to YOUR SignSnap form Works with default fields AND any custom fields you add Rating field is completely optional Handles missing data gracefully Smart Routing SMS-first approach (higher engagement rates) Automatic fallback to email if no phone Only sends what makes sense for each lead Professional Presentation Discord: Visual dashboard for your team SMS: Quick, personal outreach Email: Professional, branded communication Lead Intelligence Automatic qualification based on agent status Rating consideration (when available) Buyer agreement detection Priority-based follow-up suggestions --- π§ Setup Requirements Services Needed SignSnap Home Account - For open house sign-in app Discord Webhook - For team notifications Twilio Account - For SMS (optional but recommended) SMTP Email - For email follow-ups (optional) Configuration Steps Import this workflow into your n8n instance Set up Discord webhook: Create a webhook in your Discord channel Replace YOURWEBHOOKID/YOURWEBHOOKTOKEN in the HTTP Request node Configure Twilio (if using SMS): Add Twilio credentials in n8n Set your Twilio phone number Configure Email (if using email): Add SMTP credentials in n8n Update the "from" email address Activate your workflow Copy the webhook URL from n8n Configure SignSnap Home: Go to your open house settings Add the n8n webhook URL as your automation endpoint Enable "Send on each submission" (not batch) --- π Optional Features You Can Add Rating Field Add a "What did you rate the house?" field (1-5 scale) Workflow automatically detects and displays it Affects lead scoring (high ratings = hotter leads) Buyer Agreement Field Add "Do you have a signed buyer agreement?" field Helps identify truly available leads Factors into WARM vs COLD lead classification Any Custom Fields Add ANY additional questions to your form They'll automatically appear in Discord notifications No workflow changes needed! --- π¨ Customization Ideas Modify Lead Scoring Edit the JavaScript in the "Parse & Enrich Data" node to adjust: Lead priority thresholds Color coding Scoring criteria Change Message Templates SMS message in "Send SMS (Twilio)" node Email HTML in "Send Welcome Email" node Discord embed structure in "Discord Notification" node Add More Automation Save to Google Sheets/Airtable Create tasks in your CRM Send to Slack instead of/in addition to Discord Add to email marketing list Trigger other workflows --- π‘ Use Cases Real Estate Agents: Instant lead capture and follow-up Property Managers: Track open house attendance Real Estate Teams: Centralized lead dashboard Brokerages: Multi-agent lead distribution Home Builders: Model home visitor tracking --- π Why This Workflow Rocks β Zero Manual Work - Completely automated from sign-in to follow-up β Intelligent - Smart lead scoring and routing β Flexible - Adapts to YOUR form fields β Professional - Polished notifications and outreach β Multi-Channel - Discord, SMS, and Email coverage β Visual - See guest photos instantly β Scalable - Handle unlimited open houses β Customizable - Easy to modify for your needs --- π What You Get Instant Visibility: See every visitor as they sign in Lead Intelligence: Know who's hot and who's not Fast Follow-up: Reach out while interest is hot Team Coordination: Everyone sees the same data Professional Image: Automated, timely communication Time Savings: Hours of manual work eliminated --- π Integration Details Webhook Endpoint: /signsnaphome-sign-in-trigger Method: POST Content-Type: application/json Expected Format: SignSnap Home standard output --- π Support & Customization This workflow is designed to work out-of-the-box with SignSnap Home, but can be adapted for: Other open house sign-in apps Different notification platforms Custom CRM integrations Additional automation steps --- β‘ Quick Start Summary Import workflow Add Discord webhook URL (Optional) Configure Twilio for SMS (Optional) Configure SMTP for email Activate workflow Copy webhook URL Add to SignSnap Home settings Start collecting leads! --- π― Perfect For Solo agents wanting to professionalize their follow-up Teams needing centralized lead management Brokerages tracking multiple open houses Anyone using SignSnap Home for open house sign-ins Transform your open house visitors into qualified, followed-up leads automatically. Never miss an opportunity again! --- Tags: real-estate, lead-management, automation, discord, twilio, sms, email, webhook, signsnap, open-house, crm Difficulty: Intermediate Nodes Used: 8 External Services: SignSnap Home, Discord, Twilio (optional), SMTP (optional)
Dual-channel workflow error alerts with WhatsApp & Gmail reporting
Error Handler: WhatsApp Alert & Gmail Report for Failed Workflows π― What This Template Does / How it Works This template provides a robust, two-step system for handling critical errors in your n8n workflows. It ensures that no workflow failure goes unnoticed, immediately notifying your team via a fast, urgent channel and providing a detailed record via a formal channel. Instant Trigger & Data Capture: The Error Trigger automatically captures all necessary metadata when an assigned workflow fails, including the error message and ID. Contact Configuration: The Set node centralizes and prepares recipient contact information (email and phone number) from the error data. Rapid Response: An urgent notification is sent via WhatsApp for immediate team awareness. Traceability & Record-Keeping: A short Wait node introduces a delay to prevent notification spam. Following the pause, a comprehensive report is sent via Gmail, ensuring a detailed record of the incident is archived. This design guarantees high-priority alerts are handled rapidly, while still maintaining essential documentation. Whoβs It For This template is ideal for Ops Teams, Developers, and Automation Engineers who rely on mission-critical n8n workflows (e.g., payment processing, lead capture, data synchronization). If a failure requires immediate human intervention, this system is essential. How to Set Up Setting up this robust error handler is quick and essential for workflow stability: Configure Credentials: Ensure you have the necessary credentials added to your n8n instance for: WhatsApp Business API (for the Send message node). Gmail (for the Send Email node). Define Recipients: In the setrecipientEMAIL/NUMBER node, replace the placeholder values with the actual email address and phone number of your incident team. Activate the Listener: Open the settings of the primary workflow you wish to monitor.Go to settings ,navigate to the Error Workflow field and select the name of this template (the Error Handler). Save Changes: Save both this Error Handler workflow and the primary workflow. Done! Any failure in the primary workflow will now automatically trigger this alert system. Requirements Gmail Account (Configured as a resource). WhatsApp Business API Access (Configured as a resource and a pre-approved template available).