Chat with local LLMs using n8n and Ollama
Chat with local LLMs using n8n and Ollama This n8n workflow allows you to seamlessly interact with your self-hosted Large Language Models (LLMs) through a user-friendly chat interface. By connecting to Ollama, a powerful tool for managing local LLMs, you can send prompts and receive AI-generated responses directly within n8n. Use cases Private AI Interactions Ideal for scenarios where data privacy and confidentiality are important. Cost-Effective LLM Usage Avoid ongoing cloud API costs by running models on your own hardware. Experimentation & Learning A great way to explore and experiment with different LLMs in a local, controlled environment. Prototyping & Development Build and test AI-powered applications without relying on external services. How it works When chat message received: Captures the user's input from the chat interface. Chat LLM Chain: Sends the input to the Ollama server and receives the AI-generated response. Delivers the LLM's response back to the chat interface. Set up steps Make sure Ollama is installed and running on your machine before executing this workflow. Edit the Ollama address if different from the default.
By Mihai FarcasIntelligent email organization with AI-powered content classification for Gmail
This workflow leverages AI to intelligently analyze incoming Gmail messages and automatically apply relevant labels based on the email content. The default configuration includes the following labels: Newsletter: Subscription updates or promotional content. Inquiry: Emails requesting information or responses. Invoice: Billing and payment-related emails. Proposal: Business offers or collaboration opportunities. Action Required: Emails demanding immediate tasks or actions. Follow-up Reminder: Emails prompting follow-up actions. Task: Emails containing actionable tasks. Personal: Non-work-related emails. Urgent: Time-sensitive or critical communications. Bank: Banking alerts and financial statements. Job Update: Recruitment or job-related communications. Spam/Junk: Unwanted or irrelevant bulk emails. Social/Networking: Notifications from social platforms. Receipt: Purchase confirmations and receipts. Event Invite: Invitations or calendar-related messages. Subscription Renewal: Reminders for subscription expirations. System Notification: Technical alerts from services or systems. You can customize labels and definitions based on your specific use case. How it works: The workflow periodically retrieves new Gmail messages. Only emails without existing labels, regardless of read status, are sent to the AI for analysis. Email content (subject and body) is analyzed by an AI model to determine the appropriate label. Labels identified by the AI are applied to each email accordingly. Note: This workflow performs 100% better than the default Gmail trigger method, which is why the workflow was switched from Gmail trigger to a scheduled workflow. By selectively processing only unlabeled emails, it ensures comprehensive labeling while significantly reducing AI processing costs. Setup Steps: Configure credentials for Gmail and your chosen AI service (e.g., OpenAI). Ensure labels exist in your Gmail account matching the workflow definitions. Adjust the AI prompt to match your labeling needs. Optionally customize the polling interval (default: every 2 minutes). This workflow streamlines your email management, keeping your inbox organized effortlessly while optimizing resource usage.
By Niranjan GTrack SEO keyword rankings with Bright Data MCP and GPT-5.2 AI analysis
This workflow contains community nodes that are only compatible with the self-hosted version of n8n. This workflow automatically monitors keyword rankings across search engines to track SEO performance and identify optimization opportunities. It saves you time by eliminating the need to manually check keyword positions and provides comprehensive ranking data for strategic SEO decision making. Overview This workflow automatically scrapes search engine results pages (SERPs) to track keyword rankings, competitor positions, and search features. It uses Bright Data to access search results without restrictions and AI to intelligently parse ranking data, track changes, and identify SEO opportunities. Tools Used n8n: The automation platform that orchestrates the workflow Bright Data: For scraping search engine results without being blocked OpenAI: AI agent for intelligent ranking analysis and SEO insights Google Sheets: For storing keyword ranking data and tracking changes 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 ranking tracking spreadsheet Customize: Define target keywords and ranking monitoring parameters Use Cases SEO Teams: Track keyword performance and identify ranking improvements Content Marketing: Monitor content ranking success and optimization needs Competitive Analysis: Track competitor keyword rankings and strategies Digital Marketing: Measure organic search performance and ROI 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 keywordrankings seo searchrankings brightdata webscraping seotools n8nworkflow workflow nocode ranktracking keywordmonitoring seoautomation searchmarketing organicseo seoresearch rankinganalysis keywordanalysis searchengines seomonitoring digitalmarketing serp keywordtracking seoanalytics searchoptimization rankingreports keywordresearch seoinsights searchperformance
By Yaron BeenGenerate monthly financial reports with Gemini AI, SQL, and Outlook
๐ AI-Powered Business Performance Reporting Automation Unlock executive-level insights with ZERO manual work! This n8n template empowers you to automate your entire monthly business performance reporting using dynamic SQL queries, AI-driven analysis, and beautiful HTML dashboards โ all delivered directly to your inbox. --- ๐ฏ What This Automation Does ๐ Triggers automatically every month (5th of each month) ๐งฎ Fetches financial data from SQL (ERPNext or any database) ๐ Loops over cost centers to analyze each business unit individually ๐ Generates Profit & Loss reports, WIP, Employee stats, and vertical breakdowns ๐ค Uses Google Gemini 2.5 AI to perform advanced financial analysis ๐ Delivers a polished HTML report to your email inbox ๐ง Fully modular โ replace data source with Excel, Google Sheets, or APIs --- ๐งโ๐ซ Step-by-Step Video Tutorial ๐ฅ Watch the full tutorial on YouTube: [](https://youtu.be/yatQpQZLqg4) ๐ Learn how each node works and see the AI-generated report in action. --- ๐ Useful Links ๐ Sign up for n8n Cloud (recommended for non-tech users): ๐ https://n8n.syncbricks.com ๐ Download the step-by-step Guidebook (Free): ๐ https://lms.syncbricks.com/books/n8n ๐ Explore the full course on n8n (includes templates, workflows, and AI integrations): ๐ https://lms.syncbricks.com/courses/n8n --- ๐ Requirements โ n8n (Self-hosted or Cloud) โ SQL Database (MySQL / PostgreSQL / ERPNext) โ Microsoft Outlook or Gmail (to send the report) โ Gemini API Key (for AI analysis) โ Basic understanding of your data schema --- ๐ก Why Use This Template? โฑ Saves 2-3 days of manual work every month ๐ Improves financial visibility across business units ๐ค Great for CFOs, COOs, Finance Analysts, and BI teams ๐ Scales across multiple divisions and companies ๐ง Leverages AI for actionable insights and recommendations --- ๐งฉ Customize It Your Way Replace the SQL nodes with: Excel / Google Sheets Airtable / APIs Custom Applications Swap the AI model: OpenAI GPT Claude DeepSeek Adjust the report structure or HTML style --- ๐ Get Started Now ๐ฏ Import the JSON template โ Connect your data โ Receive business insights via email. Donโt let manual reporting slow down your decision-making. ๐ Sign up for n8n Cloud ๐ Learn n8n with Amjid ๐ Download Guide --- Created by Amjid Ali | SyncBricksโข โ Automation for Everyone
By Amjid AliConvert text to speech with OpenAI
How It Works This workflow sends an HTTP request to OpenAI's Text-to-Speech (TTS) model, returning an .mp3 audio recording of the provided text. This template is meant to be adapted for your individual use case, and requires a valid OpenAI credential. Gotchas Per OpenAI's Usage Policies, you must provide a clear disclosure to end users that the TTS voice they are hearing is AI-generated and not a human voice, if you are using this workflow to provide audio output to users.
By Kevin ColeAutomated PR code reviews with GitHub, GPT-4, and Google Sheets best practices
AI-Agent Code Review for GitHub Pull Requests Description: This n8n workflow automates the process of reviewing code changes in GitHub pull requests using an OpenAI-powered agent. It connects your GitHub repo, extracts modified files, analyzes diffs, and uses an AI agent to generate a code review based on your internal code best practices (fed from a Google Sheet). It ends by posting the review as a comment on the PR and tagging it with a visual label like โ Reviewed by AI. ๐ง What It Does Triggered on PR creation Extracts code diffs from the PR Formats and feeds them into an OpenAI prompt Enriches the prompt using a Google Sheet of Swift best practices Posts an AI-generated review as a comment on the PR Applies a PR label to visually mark reviewed PRs โ Prerequisites Before deploying this workflow, ensure you have the following: n8n Instance (Self-hosted or Cloud) GitHub Repository with PR activity OpenAI API Key for GPT-4o, GPT-4-turbo, or GPT-3.5 GitHub OAuth App (or PAT) connected to n8n to post comments and access PR diffs (Optional) Google Sheets API credentials if using the code best practices lookup node. โ๏ธ Setup Instructions Import the Workflow in n8n, click on Workflows โ Import from file or JSON Paste or upload the JSON code of this template Configure Triggers and Connections ๐ GitHub Trigger Node: PR Trigger Repository: Select the GitHub repo(s) to monitor Events: Set to pull_request Auth: Use GitHub OAuth2 credentials ๐ฅ HTTP Request Node: Get file's Diffs from PR No authentication needed; it uses dynamic path from trigger ๐ง OpenAI Model Node: OpenAI Chat Model Model: Select gpt-4o, gpt-4-turbo, or gpt-3.5-turbo Credential: Provide your OpenAI API Key ๐งโ๐ป Code Review Agent Node : Code Review Agent Connected to OpenAI and optionally to tools like Google Sheets ๐ฌ GitHub Comment Poster Uses GitHub API to post review comments back on PR Node: GitHub Robot Credential: Use the agent Github account (OAuth or PAT) Repo : Pick your owen Github Repository ๐ท๏ธ PR Labeler (optional) Adds label ReviewedByAI after successful comment Node: Add Label to PR Label : you ca customize the label text of your owen tag. ๐ Google Sheet Best Practices config (optional) Connects to a Google Sheet for coding guideline lookups, we can replace Google sheet by another tool or data base First prepare your best practices list with the clear description and the code bad/good examples Add al the best practices in your Google Sheet Configure the Code Best Practices node in the template : Credential : Use your Google Sheet account by OAuth2 URL : Add your Google Sheet document URL Sheet : Add the name of the best practices sheet
By Jihene๐ Automatically update stock portfolio from OneDrive to Excel
Seamlessly Sync and Update Data from a csv in OneDrive to Excel with n8n This workflow is perfect for users who need a reliable, automated way to transfer and organize data from OneDrive into Excelโespecially for tasks like portfolio tracking, inventory management, and record-keeping. By monitoring your OneDrive folder for new CSV files, it performs data cleaning, transformation, and real-time updates in an Excel sheet, ensuring only new or changed records are added. --- How it Works Automated Monitoring: Every minute, the workflow scans a designated OneDrive folder for new files. File Verification: It checks if the detected file is in CSV format; if not, the process stops with an error message. Data Extraction and Cleaning: CSV data is loaded, and irrelevant headers are removed before mapping to specified columns in Excel. Excel Update: The workflow maps data to your Excel sheet, updating only new or modified entries based on a unique identifier ("Ticker/ISIN"). Cleanup: To keep your OneDrive organized, processed files are deleted after updating Excel. --- Setup Steps Connect OneDrive and Excel Accounts: Link your Microsoft OneDrive and Excel accounts in n8n. Designate Folder and Worksheet: Specify the OneDrive folder for monitoring and the Excel sheet for data updates. Configure Sync Frequency and CSV Validation: Set the monitoring frequency to every minute and ensure the workflow identifies CSV files accurately. Once configured, this workflow offers a hands-free, efficient solution to keep your OneDrive and Excel data synchronized effortlessly.
By LouisCreate HubSpot contacts from LinkedIn post interactions
This workflow automatically does the following: Scrapes comments and likes from a LinkedIn post. Adds contact data (nominative and verified email address, gender, standardized first name and last name, all legal company information). Adds these contacts to Airtable. Sends an ultra-personalized cold email sequence. Sends a Linkedin invitation after the cold email sending. Pushes all contacts to HubSpot. Prerequisites A Phantombuster account and credentials A Lemlist account and credentials A Dropcontact account and credentials A HubSpot account and credentials How it works Cron node executes the workflow every hour. Phantombuster node (Launch agent) launches the "LinkedIn Post Likers" phantom and the "LinkedIn Post Commenters" phantom. Note that you have to create these phantoms before setting your workflow automation. Phantombuster node (Get Output agent) gets results from the previous phantoms. Dropcontact node fetches the new contact information and returns the data of the person and the company associated with the email address, job function, and all legal information. Airtable node (List) lists all the records in the Contacts table. IF node routes the workflow based on whether a contact is in Airtable. Set node sets the required data for the following nodes. Airtable node (Update) updates the record's name. Airtable node (Append) creates a record if the account doesn't exist yet. Lemlist node adds a contact to an existing campaign. Phantombuster node (Launch agent) launches the "LinkedIn Network Booster" phantom. Note that you have to create these phantoms before setting your automation. Hubspot node creates or updates the contacts in the HubSpot CRM.
By PaulineGet invoices from Xero
Companion workflow for Xero node docs
By amudhanMedical records automation with Mistral OCR & Google Sheets
This plug-and-play n8n workflow automates medical record digitization using Mistralโs OCR API and stores clean, structured data in Google Sheets. Whether you run a clinic or healthtech product, this no-code solution simplifies data entry from scanned or uploaded medical documents. ๐ Works seamlessly on both self-hosted and cloud-based n8n environments. ๐ฅ Who is this for? Hospitals and private clinics Healthtech platforms & startups Medical admin and document processing teams Clinical researchers and labs ๐ What problem does it solve? โ Manual entry from printed forms โ Unstructured, scattered records โ Errors in data transcription โ Inconsistent document storage โ This automation brings consistency, structure, and speed to the way you handle medical documents. โ What this workflow does Captures uploaded documents through a public form Uploads file to Mistral for OCR processing Extracts clean text from each page (PDF or image) Parses patient fields (Name, DOB, Diagnosis, Medications, etc.) Saves records into a structured Google Sheet ๐ ๏ธ Setup Instructions Step 1: Google Sheet Prep Create a Google Sheet with these columns (case-sensitive): Name, Date of Birth, Patient ID, Date of Visit, Referring Physician, Department, Symptoms, Blood Pressure, Heart Rate, Temperature, Lab Results, Diagnosis, Medications, Next Appointment, Notes Step 2: Mistral API Access Sign up at Mistral AI Get your API key Ensure your plan supports file upload & OCR endpoints Step 3: Google OAuth Credentials (Self-hosted or Cloud) Go to n8n โ Settings โ Credentials, and add: Google Sheets OAuth2 Scopes needed: https://www.googleapis.com/auth/spreadsheets Step 4: Import Workflow Go to Workflows > Import from File Upload your JSON file Replace: Google Sheet document ID in the "Google Sheets" node Your Mistral API key in HTTP Header Auth Step 5: (Optional) Make Form Public In Cloud-based n8n: You can expose the form as a public page Otherwise, connect it to your website form via webhook ๐งฉ Customization Tips Extract More Fields Update the "Data cleaning" node and extend the list of fields: const fields = ["Name", "Diagnosis", "Medications", "Symptoms", ...]; Add EHR or Database Integration After Google Sheets, chain your custom system: PostgreSQL Airtable Supabase MongoDB Change Output Format Want JSON or Markdown output for internal tools? Use the Set or Code node before the final output step. ๐งช Troubleshooting Issue Fix File upload fails Check Mistral API key and file type Google Sheets not updating Verify credentials and document ID No data parsed Check OCR quality; verify field labels in document Workflow not triggering Ensure webhook or form is configured correctly ๐ Self-Hosted vs Cloud Comparison Feature Self-Hosted n8n Cloud Public Form Access Manual setup Built-in OAuth App Config Required Pre-configured Storage Limits Depends on server Included with plan Scalability Fully customizable Scales automatically ๐ฃ Getting Support n8n Docs Mistral API Docs n8n Community Or reach out to: David Olusola (dimejicole21@gmail.com) ๐ Like this template? Give it a star in the template library and help other no-code builders discover it. "Turn scanned documents into structured data with zero code."
By David OlusolaAutomated YouTube channel lead generation & email outreach with Apify and ZeroBounce
Workflow Overview This sophisticated n8n automation is a powerful lead generation and outreach tool designed to transform YouTube channel research into actionable marketing opportunities. By intelligently connecting multiple services and APIs, this workflow: Discovers Targeted Channels: Scrapes YouTube channels based on specific keywords Extracts comprehensive channel metadata Identifies potential business opportunities Intelligent Lead Qualification: Filters channels with contact emails Validates email authenticity Ensures high-quality lead generation Personalized Outreach: Sends customized cold emails Leverages channel-specific personalization Automates initial contact process Key Benefits ๐ต๏ธ Automated Lead Discovery: Find potential collaborators or clients ๐ง Smart Filtering: Eliminate invalid or irrelevant leads ๐ง Personalized Outreach: Contextual, channel-specific communication โฑ๏ธ Time-Saving: Eliminate manual research and email hunting Workflow Architecture ๐ Stage 1: Channel Scraping Apify Integration: Scrapes YouTube channels Keyword-Based Search: Target specific niches Metadata Extraction: Collect channel details, emails ๐งฉ Stage 2: Lead Qualification Email Existence Check: Filter channels with contact info ZeroBounce Verification: Validate email authenticity Quality Control: Ensure only valid leads proceed ๐ฌ Stage 3: Personalized Outreach Gmail Integration: Send customized cold emails Dynamic Personalization: Use channel-specific details Automated Communication: Streamline initial contact Potential Use Cases Marketing Agencies: Find potential clients Influencer Marketers: Discover collaboration opportunities Content Creators: Network and expand professional connections Sales Teams: Generate targeted lead lists Recruitment Specialists: Identify industry professionals Setup Requirements Apify Account API token YouTube Scraper Actor Configured search keywords ZeroBounce Account Email verification API Validation credits Gmail Account OAuth2 authentication Configured sending profile n8n Installation Cloud or self-hosted instance Import workflow configuration Configure API credentials Future Enhancement Suggestions ๐ค AI-powered email personalization ๐ Advanced lead scoring mechanisms ๐ Automated follow-up sequences ๐ Integration with CRM platforms ๐ Multi-platform lead generation Ethical Considerations Respect email communication guidelines Comply with anti-spam regulations Provide clear opt-out mechanisms Maintain professional, value-driven outreach Connect With Me Ready to supercharge your lead generation? ๐ง Email: Yaron@nofluff.online ๐ฅ YouTube: @YaronBeen ๐ผ LinkedIn: Yaron Been Transform your outreach strategy with intelligent, automated workflows!
By Yaron BeenAutomated weather reports with OpenWeatherMap and Telegram โ๏ธ
Get a fun and clear weather report sent to your phone automatically! ๐ฐ --- --- This little bot wakes up, checks the weather for you, and builds a super simple summary of your day. What it does: ๐ก๏ธ Grabs the current temperature and what it actually feels like. ๐ Figures out the high and low for the whole day. ๐ Gives you a 5-day forecast so you can plan your week. โ๏ธ Sends it all to you in a clean Telegram message! Setup is easy: Just plug in your info for Telegram, add your location, and you're good to go! โจ
By M Sayed