ππ¦π€ Private & local Ollama self-hosted AI assistant
Transform your local N8N instance into a powerful chat interface using any local & private Ollama model, with zero cloud dependencies βοΈ. This workflow creates a structured chat experience that processes messages locally through a language model chain and returns formatted responses π¬. How it works π π Chat messages trigger the workflow π§ Messages are processed through Llama 3.2 via Ollama (or any other Ollama compatible model) π Responses are formatted as structured JSON β‘ Error handling ensures robust operation Set up steps π οΈ π₯ Install N8N and Ollama βοΈ Download Ollama 3.2 model (or other model) π Configure Ollama API credentials β¨ Import and activate workflow This template provides a foundation for building AI-powered chat applications while maintaining full control over your data and infrastructure π.
By Joseph LePageAutomate customer support issue resolution using AI text classifier
This n8n template is designed to assist and improve customer support team member capacity by automating the resolution of long-lived and forgotten JIRA issues. How it works Schedule Trigger runs daily to check for long-lived unresolved issues and imports them into the workflow. Each Issue is handled as a separate subworkflow by using an execute workflow node. This allows parallel processing. A report is generated from the issue using its comment history allowing the issue to be classified by AI - determining the state and progress of the issue. If determined to be resolved, sentiment analysis is performed to track customer satisfaction. If negative, a slack message is sent to escalate, otherwise the issue is closed automatically. If no response has been initiated, an AI agent will attempt to search and resolve the issue itself using similar resolved issues or from the notion database. If a solution is found, it is posted to the issue and closed. If the issue is blocked and waiting for responses, then a reminder message is added. How to use This template searches for JIRA issues which are older than 7 days which are not in the "Done" status. Ensure there are some issues that meet this criteria otherwise adjust the search query to suit. Works best if you frequently have long-lived issues that need resolving. Ensure the notion tool is configured as to not read documents you didn't intend it to ie. private and/or internal documentation. Requirements JIRA for issues management OpenAI for LLM Slack for notifications Customising this workflow Why not try classifying issues as they are created? One use-case may be for quality control such as ensuring reporting criteria is adhered to, summarising and rephrasing issue for easier reading or adjusting priority.
By JimleukAllow users to send a sequence of messages to an AI agent in Telegram
Use Case When creating chatbots that interface through applications such as Telegram and WhatsApp, users can often sends multiple shorter messages in quick succession, in place of a single, longer message. This workflow accounts for this behaviour. What it Does This workflow allows users to send several messages in quick succession, treating them as one coherent conversation instead of separate messages requiring individual responses. How it Works When messages arrive, they are stored in a Supabase PostgreSQL table The system waits briefly to see if additional messages arrive If no new messages arrive within the waiting period, all queued messages are: Combined and processed as a single conversation Responded to with one unified reply Deleted from the queue Setup Create a table in Supabase called messagequeue. It needs to have the following columns: userid (uint8), message (text), and message_id (uint8) Add your Telegram, Supabase, OpenAI, and PostgreSQL credentials Activate the workflow and test by sending multiple messages the Telegram bot in one go Wait ten seconds after which you will receive a single reply to all of your messages How to Modify it to Your Needs Change the value of Wait Amount in the Wait 10 Seconds node in order to to modify the buffering window Add a System Message to the AI Agent to tailor it to your specific use case Replace the OpenAI sub-node to use a different language model
By Chris CarrAutomate Your RFP Process with OpenAI Assistants
This n8n workflow demonstrates how to automate oftern time-consuming form filling tasks in the early stages of the tendering process; the Request for Proposal document or "RFP". It does this by utilising a company's knowledgebase to generating question-and-answer pairs using Large Language Models. How it works A buyer's RFP is submitted to the workflow as a digital document that can be parsed. Our first AI agent scans and extracts all questions from the document into list form. The supplier sets up an OpenAI assistant prior loaded with company brand, marketing and technical documents. The workflow loops through each of the buyer's questions and poses these to the OpenAI assistant. The assistant's answers are captured until all questions are satisified and are then exported into a new document for review. A sales team member is then able to use this document to respond quickly to the RFP before their competitors. Example Webhook Request curl --location 'https://<n8nwebhookurl>' \ --form 'id="RFP001"' \ --form 'title="BlueChip Travel and StarBus Web Services"' \ --form 'reply_to="jim@example.com"' \ --form 'data=@"k9pnbALxX/RFP Questionnaire.pdf"' Requirements An OpenAI account to use AI services. Customising the workflow OpenAI assistants is only one approach to hosting a company knowledgebase for AI to use. Exploring different solutions such as building your own RAG-powered database can sometimes yield better results in terms of control of how the data is managed and cost.
By JimleukAutomatically save & organize Outlook email attachments in OneDrive folders
Outlook to OneDrive This workflow automates the process of saving binary attachments from Outlook emails into newly created folders in OneDrive. It's ideal for users who regularly receive files and need them organized into separate folders without manual intervention. Each folder is automatically named based on the email subject and the current timestamp, allowing all attachments from that email to be stored inside the corresponding folder. This is particularly useful for streamlining document workflows, improving file traceability, and reducing the time spent on repetitive tasks like organizing client submissions, invoices, or internal reports. The configuration and setup of the workflow can be customized to meet the business or personal needs of the user. Its purpose is to automatically process binary attachments from Outlook emails and upload them to dynamically created folders in OneDrive. Overview Microsoft Outlook Trigger β Monitors your inbox for new emails. Filter β Ensures only emails with binary attachments proceed. Get Outlook Message β Retrieves the full email and downloads attachments. Create Folder β Makes a new folder in OneDrive based on the email subject and time. Split Out β Extracts each binary attachment. Mergeβ Combines folder and file data before upload. Upload File OneDrive β Uploads each binary file into the new folder. Need Help? Have Questions? For consulting and support, or if you have questions, please feel free to connect with me on LinkedIn or via email.
By Michael GulloExport CSV file to JSON
This workflow exports a local CSV file to a JSON file.
By LorenaBackup your workflows to GitHub -- in (subfolders)
Based on Jonathan & Solomon work. > The only addition I've made is a Set node. This node organizes workflows into subfolders within the GitHub repository based on their respective tags. How it works This workflow will backup your workflows to GitHub. It uses the n8n API node to export all workflows. It then loops over the data, checks in GitHub to see if a file exists that uses the credential's ID. Once checked it will: update the file on GitHub if it exists; create a new file if it doesn't exist; ignore if it's the same. Who is this for? People wanting to backup their workflows outside the server for safety purposes or to migrate to another server.
By NazmyGenerate AI avatar videos with HeyGen and Google Sheets integration
This template streamlines your AI Avatar Video Automation workflow by connecting Google sheets for Voice Text & AI Avatar Video Link storage, using HTTP Nodes for connecting Heygen API & AI Avatar/Voice Id for automated Video generation. Pre-requisites Before setting up this workflow, ensure you have: A Google account with access to Google Sheets A Heygen Account with API access in account's settings. n8n.io account with workflow access Setup Instructions Configure Data Source Create a Google Sheet with the following columns: Script/Voice Text & Final AI Avatar Video Link. Connect Google Sheet Add your Google sheet credentials in the βGoogle Sheetβ node Specify the folder path where your columns are stored. Configure the node to retrieve files based on filenames from your Google Sheet Set Up HTTP Node with Heygen API Credentials Configure the node to generate AI Video based on Script/Voice Text. Configure HTTP Node 2 Connect Heygen API Credentials Set up the API node to Get the AI Avatar Video Link. then finally setup Google sheet node again to get & upload the final AI Avatar video link in the column "the Final AI Avatar Video Link" Workflow Automation Setup Configure the scheduler node to run at your preferred frequency Set up error handling to notify you of any posting failures Execution Instructions After completing all connections, test the workflow. Monitor the execution in the n8n dashboard to ensure proper functioning View the βExecutionsβ tab to track successful and troubleshoot any errors. This template saves hours of manual AI Avatar video Creation Process. use this without the daily manual effort. Details Nodes used in workflow Manual Trigger Node Google Sheet Node 1 HTTP Node 1 HTTP Node 2 Google Sheets Node 2
By Sagarβ¨ Meta ads campaign report by period β auto-send via WhatsApp & email
Hi, Iβm Amanda π· I created this workflow with great care to help you simplify your daily reporting routine. If you manage Meta Ads campaigns, you know how time-consuming it can be to open Ads Manager, filter data, and build client reports. This automation does all that for you β pulling campaign data by period, calculating key metrics, filtering only what matters, and sending everything via WhatsApp or Email, fully formatted and ready to share. --- What it does Collects ad performance data from multiple accounts Filters campaigns and creatives with real results Calculates metrics like CPC, CTR, CPV, conversions, and spend Formats the report clearly and professionally Sends the report via WhatsApp (Evolution API) or Gmail Runs automatically every morning (optional schedule) --- Setup Guide Use this Google Sheet template to manage your accounts Connect Google Sheets, Gmail, and Meta Ads to n8n Set your action_type filters (lead, purchase, etc.) Customize your message and delivery time --- Requirements Google account connected to n8n Facebook Graph API access WhatsApp via Evolution API (optional) Basic n8n knowledge --- Want it customized for your business? Letβs chat β WhatsApp me (+55 17 99155-7874)
By Amanda BenksReal estate property search with SQL database and email delivery
Transform property searches into personalized experiences! This powerful automation delivers dream home matches straight to clients' inboxes with professional CSV reports - all from a simple web form. π What this workflow does Create a complete real estate search experience that works 24/7: β¨ Smart Web Form - Beautiful property search form captures client preferences π§ Dynamic SQL Builder - Intelligently creates optimized queries from user input β‘ Lightning Database Search - Scans 1000+ properties in milliseconds π Professional CSV Export - Excel-ready reports with complete property details π§ Automated Email Delivery - Personalized emails with property previews and attachments π― Perfect for: Real Estate Agents - Generate leads and impress clients with instant service Property Managers - Automate tenant matching and recommendations Brokerages - Provide 24/7 self-service property discovery Developers - Showcase available properties with professional automation π‘ Why this workflow is a game-changer > "From property search to professional report delivery in under 30 seconds!" β‘ Instant Results: Zero wait time for property matches π¨ Professional Output: Beautiful emails that showcase your expertise π± Mobile Optimized: Works flawlessly on all devices π§ Smart Filtering: Only searches criteria clients actually specify π Infinitely Scalable: Handles unlimited searches simultaneously π Real Estate Data Source Built on authentic US market data from the Github: ποΈ 1000+ Real Properties across all US states π° Actual Market Prices from legitimate listings π Complete Property Details (bedrooms, bathrooms, square footage, lot size) π Verified Locations with accurate cities, states, and ZIP codes π’ Broker Information for authentic real estate context π οΈ Quick Setup Guide Prerequisites Checklist β [ ] SQL Server database (MySQL/PostgreSQL also supported) [ ] Gmail account for automated emails [ ] n8n instance (cloud or self-hosted) [ ] 20 minutes setup time Step 1: Import Real Estate Data π₯ π Download the data πΎ Download CSV file (1000+ properties included) ποΈ Create SQL Server table with this exact schema: sql CREATE TABLE [REALTOR].[dbo].[realtorusaprice] ( brokered_by BIGINT, status NVARCHAR(50), price DECIMAL(12,2), bed INT, bath DECIMAL(3,1), acre_lot DECIMAL(10,8), street BIGINT, city NVARCHAR(100), state NVARCHAR(50), zip_code INT, house_size INT, prevsolddate NVARCHAR(50) ); π Import your CSV data into this table Step 2: Configure Database Connection π π Set up Microsoft SQL Server credentials in n8n β Test connection to ensure everything works π― Workflow is pre-configured for the table structure above Step 3: Gmail Setup (The Magic Touch) π§ π Visit Google Cloud Console π Create new project (or use existing) π Enable Gmail API in API Library π Create OAuth2 credentials (Web Application) βοΈ Add your n8n callback URL to authorized redirects π Configure Gmail OAuth2 credentials in n8n β¨ Authorize your Google account Step 4: Launch Your Property Search Portal π π Import this workflow template (form is pre-configured) π Copy your webhook URL from the Property Search Form node π Test with a sample property search π¨ Check email delivery with CSV attachment π Go live and start impressing clients! π¨ Customization Playground π·οΈ Personalize Your Brand javascript // Customize email subjects in the Gmail node "π Exclusive Properties Curated Just for You - ${results.length} Perfect Matches!" "β¨ Your Dream Home Portfolio - Handpicked by Our Experts" "π― Hot Market Alert - ${results.length} Premium Properties Inside!" π§ Advanced Enhancements π¨ HTML Email Templates: Create stunning visual emails with property images π Analytics Dashboard: Track popular searches and user engagement π Smart Alerts: Set up automated price drop notifications π± Mobile Integration: Connect to React Native or Flutter apps π€ AI Descriptions: Add ChatGPT for compelling property descriptions π Multi-Database Flexibility javascript // Easy database switching // MySQL: Replace Microsoft SQL node β MySQL node // PostgreSQL: Swap for PostgreSQL node // MongoDB: Use MongoDB node with JSON queries // Even CSV files: Use CSV reading nodes for smaller datasets π Advanced Features & Extensions π₯ Pro Tips for Power Users π Bulk Processing: Handle multiple searches simultaneously πΎ Smart Caching: Store popular searches for lightning-fast results π Lead Scoring: Track which properties generate most interest π Follow-up Automation: Schedule nurturing email sequences π― Integration Possibilities π’ CRM Connection: Auto-add qualified leads to your CRM π Calendar Integration: Add property viewing scheduling π Price Monitoring: Track market trends and price changes π± Social Media: Auto-share featured properties to social platforms π¬ Chat Integration: Connect to WhatsApp or SMS for instant alerts π Expand Your Real Estate Automation π Related Workflow Ideas π€ AI Property Valuation - Add machine learning for price predictions π Market Analysis Reports - Generate comprehensive market insights π± SMS Property Alerts - Instant text notifications for hot properties π’ Commercial Property Search - Adapt for office and retail spaces πΉ Investment ROI Calculator - Add financial analysis for investors ποΈ Neighborhood Analytics - Include school ratings and demographics π οΈ Technical Extensions π· Image Processing: Auto-resize and optimize property photos πΊοΈ Map Integration: Add interactive property location maps π± Progressive Web App: Create mobile app experience π Push Notifications: Real-time alerts for saved searches π Get Started Now Import this workflow template Configure your database and Gmail Customize branding and messaging Launch your professional property search portal Watch client satisfaction soar!
By DataMinexAutomate restaurant sales & inventory forecasting with Gemini AI & Google Sheets
This automated n8n workflow performs weekly forecasting of restaurant sales and raw material requirements using historical data from Google Sheets and AI predictions powered by Google Gemini. The forecast is then emailed to stakeholders for efficient planning and waste reduction. What is Google Gemini AI? Google Gemini is an advanced AI model that analyzes historical sales data, seasonal patterns, and market trends to generate accurate forecasts for restaurant sales and inventory requirements, helping optimize purchasing decisions and reduce waste. Good to Know Google Gemini AI forecasting accuracy improves over time with more historical data Weekly forecasting provides better strategic planning compared to daily predictions Google Sheets access must be properly authorized to avoid data sync issues Email notifications ensure timely review of weekly forecasts by stakeholders The system analyzes trends and predicts upcoming needs for efficient planning and waste reduction How It Works Trigger Weekly Forecast - Automatically starts the workflow every week at a scheduled time Load Historical Sales Data - Pulls weekly sales and material usage data from Google Sheets Format Input for AI Agent - Transforms raw data into a structured format suitable for the AI Agent Generate Forecast with AI - Uses Gemini AI to analyze trends and predict upcoming needs Interpret AI Forecast Output - Parses the AI's response into readable, usable JSON format Log Forecast to Google Sheets - Stores the new forecast data back into a Google Sheet Email Forecast Summary - Sends a summary of the forecast via Gmail for stakeholder review Data Sources The workflow utilizes Google Sheets as the primary data source: Historical Sales Data Sheet - Contains weekly sales and inventory data with columns: Week/Date (date) Menu Item (text) Sales Quantity (number) Revenue (currency) Raw Material Used (number) Inventory Level (number) Category (text) Forecast Output Sheet - Contains AI-generated predictions with columns: Forecast Week (date) Menu Item (text) Predicted Sales (number) Recommended Inventory (number) Material Requirements (number) Confidence Level (percentage) Notes (text) How to Use Import the workflow into n8n Configure Google Sheets API access and authorize the application Set up Gmail credentials for forecast report delivery Create the required Google Sheets with the specified column structures Configure Google Gemini AI API credentials Test with sample historical sales data to verify predictions and email delivery Adjust forecasting parameters based on your restaurant's specific needs Monitor and refine the system based on actual vs. predicted results Requirements Google Sheets API access Gmail API credentials Google Gemini AI API credentials Historical sales and inventory data for initial training Customizing This Workflow Modify the Generate Forecast with AI node to focus on specific menu categories, seasonal adjustments, or local market conditions. Adjust the email summary format to match your restaurant's reporting preferences and add additional data sources like supplier information, weather data, or special events calendar for more accurate predictions.
By Oneclick AI SquadDaily GitHub release notification by email
Automating daily notifications of the latest releases from a GitHub repository. This template is ideal for developers and project managers looking to stay up-to-date with software updates. How it Works: Daily Trigger: The workflow initiates daily using the Schedule Trigger node. Fetch Repository Data: The HTTP Request node retrieves the latest release details from the specified GitHub repository. Check if new: The IF node check if the release was done in the last 24 hours. Split Content: The Split Out node processes the JSON response to extract and structure relevant data. Convert Markdown: The Markdown node converts release notes from Markdown format to HTML, making them ready to use in emails. Send a notification by email Key Features: Simple to customize by modifying the GitHub URL. Automatically processes and formats release notes for better readability. Modular design, allowing integration with other workflows like Gmail or Slack notifications. Setup Steps: Modify Repository URL: Update the Sticky Note node with the URL of the repository you want to monitor. Modify SMTP details: Update the Send Email node with your SMTP details.
By Dionysus