Browse 12,955 Workflows

By Milan Vasarhelyi - SmoothWork

Video Introduction Want to automate your inbox or need a custom workflow? 📞 Book a Call | 💬 DM me on Linkedin What This Workflow Does This workflow creates an AI-powered chatbot that answers natural language questions about your QuickBooks data in real-time. Users can interact with a public chat interface to query customer information, balances, invoices, and other accounting data without needing to navigate the QuickBooks interface directly. The AI agent uses OpenAI's language model to understand questions and automatically retrieves the relevant data from QuickBooks. Key Features Natural Language Interface**: Ask questions like "How many customers do we have?" or "What's the total balance across all customers?" and get instant answers Public Chat URL**: Share a link with team members or stakeholders so they can access QuickBooks insights without direct system access Customizable Data Access**: Configure the QuickBooks tool to retrieve different resources (customers, invoices, expenses, bills, etc.) based on your needs Common Use Cases Enable non-accounting staff to get quick answers about customer data Provide executives with on-demand financial insights without training them on QuickBooks Create a self-service interface for sales teams to check customer balances Build internal support bots that can answer accounting questions Setup Requirements QuickBooks Developer Account: Register at developer.intuit.com and create a new app with Accounting permissions Credentials: Configure QuickBooks OAuth2 API credentials (Client ID, Client Secret, and Redirect URI from the Intuit Developer dashboard) and OpenAI API credentials Environment: Start with Sandbox mode for testing, then switch to Production after getting your app approved by Intuit Tool Configuration: The QuickBooks tool is pre-configured to retrieve all customer data, but you can modify the operation and filters to access different QuickBooks resources based on your requirements. An n8n automation workflow template by Milan Vasarhelyi - SmoothWork.

By Oneclick AI Squad

This n8n workflow ensures instant notifications to parents and staff during school emergencies. It processes incoming alerts via webhooks, filters active emergencies, and sends notifications through email and Slack. Key Features Instant Alerts**: Triggers notifications immediately upon detecting emergencies. Multi-Channel**: Sends alerts via email and Slack for broad reach. Automated Filtering**: Identifies and processes only active emergency alerts. Reliable Delivery**: Ensures notifications reach parents and staff swiftly. No Action Needed**: Skips inactive alerts without further processing. Workflow Process Webhook Trigger: Receives POST requests with emergency data. Filter Emergency Alerts: Checks and validates active emergency alerts. Send Email Alert: Delivers email notifications to parents and staff. Send Slack Alert: Posts real-time messages to a Slack channel. No Action for Inactive: Ignores and stops for inactive alerts. Setup Instructions Import Workflow**: Load the workflow into n8n using the import feature. Configure Webhook**: Set up a webhook URL to receive emergency data. Set Up Notifications**: Add email (e.g., Gmail) and Slack credentials. Activate**: Save and enable the workflow in n8n. Test**: Simulate an alert to ensure notifications work. Requirements n8n Instance**: Hosted or cloud-based n8n environment. Webhook Source**: System to send emergency data via POST. Email Service**: SMTP setup for email alerts. Slack Integration**: Configured Slack workspace for alerts. Customization Options Add Channels**: Include SMS or other platforms for alerts. Adjust Filters**: Modify criteria for active alerts. Custom Messages**: Tailor email/Slack content for clarity. An n8n automation workflow template by Oneclick AI Squad.

By EmailListVerify

This workflow allows to : scrape Google Maps data using SerpAPI discovery generic email addresses like contact@ using EmailListVerify API Who’s it for This template is designed to prepare cold outreach for local businesses like restaurants or hotels (you need to target a type of business that is listed on Google Maps). This template will generate a list of leads with phone numbers and email addresses. The email addresses you will get are generic, like contact@. This isn’t a problem if you are targeting small businesses, as the owner will most likely monitor those emails. However, if your ideal customer profile has more than 20 employees, I do not recommend using those email addresses for cold outreach. Requirement This template uses: Google Sheet to handle input and output data SerpAPI to scrape Google Maps (250 searches/month in the free plan) EmailListVerify to discover email (from $0.05 per email) Notes This template is an extension of Lucas Perret template (adding email discovery module). If there is some interest in it, I can make a similar template using Apify as an alternative to SerpAPI for Google Map scraping. An n8n automation workflow template by EmailListVerify.

By Rakin Jakaria

📄 AI Invoice Agent The AI Invoice Agent automates the invoice creation, email delivery, and status tracking process for client billing. It ensures invoices are generated, sent professionally, and updated in Google Sheets with minimal manual work. 🔹 How It Works Trigger Activated manually (Execute Workflow) when you want to process invoices. Fetch Invoices Reads client invoice data from a Google Sheet (Client Invoices). Filter Pending Invoices Passes through only invoices with Status = Pending. Prepare Invoice Data Collects and formats details: Invoice ID Client Name & Address Project Name Amount (USD) Invoice Date (today’s date) Due Date (7 days later) Loop Over Invoices Processes each invoice one by one. AI Email Draft Uses GPT-4.1-mini to generate a polite, professional email. Tone: friendly but business-oriented. Signed as Upward Engine Team. Extract Email Parts Separates subject and body from the AI output using an Information Extractor. Generate Invoice PDF Uses CraftMyPDF to create a formatted invoice PDF with: Company details (Upward Engine) Client details Invoice ID, Date, Due Date Amount due Footer message Send Email to Client Sends invoice email via Gmail, attaching the PDF invoice. Update Invoice Status Updates Google Sheets to mark the invoice as Completed. Saves Invoice ID, Date, Due Date, and updated status. Loop Continuation Continues until all pending invoices are processed. 🔹 Tools & Integrations Google Sheets** → Stores client & invoice data Filter Node** → Selects only Pending invoices GPT-4.1-mini (OpenAI)** → Generates professional emails Information Extractor** → Separates subject & body CraftMyPDF** → Creates PDF invoices Gmail** → Sends invoice emails with PDF attachments 🔹 Example Workflow ✅ Google Sheets: Invoice marked as Pending ➡️ AI generates email → “Invoice INV-1023 for Web Design Project – Due Sep 5” ➡️ PDF invoice created & attached ➡️ Email sent to client with subject + body ➡️ Status updated in Google Sheet → Completed ⚡ This agent ensures zero missed invoices, professional client communication, and up-to-date tracking — fully automated for agencies and small businesses. An n8n automation workflow template by Rakin Jakaria.

By Rakin Jakaria

Use cases are many: Let users book, check, reschedule, or cancel meetings directly from Telegram. Perfect for solopreneurs, agencies, or teams who want an AI-powered assistant that prevents double-bookings, manages Google Calendar, and even sends email invites automatically. Good to know At time of writing, this workflow uses OpenAI GPT-4.1-mini for natural conversation handling. See OpenAI Pricing for updated info. This workflow relies on Google Calendar for scheduling — if the model says “conflict found,” it means an event already exists in that time slot. How it works Telegram Chat**: A user types natural requests like “Book a meeting with Sarah tomorrow at 2 PM” or “Do I have meetings on Friday?”. AI Agent (OpenAI)**: Interprets the request, calculates dates (using Date & Time), and decides whether to create, update, or delete a meeting. Conflict Checking**: Before booking, the agent checks Google Calendar for existing events to avoid overlaps. Meeting Management**: Create: Adds new events with title, description, attendees. Update: Edits existing events. Delete: Cancels meetings if requested. Get: Lists all meetings for a date or time range. Notifications**: Replies instantly on Telegram and, if needed, sends a Gmail email with meeting details. Memory**: Keeps context of the conversation so users can speak naturally (“reschedule that meeting to 4 PM instead”). How to use Start a Telegram chat with the bot. Type a request in plain English (no need for structured inputs). The agent will confirm or suggest alternatives if a conflict exists. Meetings appear in Google Calendar and details can be emailed via Gmail. Requirements Telegram bot connected to n8n OpenAI API key (for AI-driven scheduling assistant) Google Calendar account (for event creation & conflict checking) Gmail account (for sending invites & confirmations) Customising this workflow Add support for multiple calendars (work, personal, shared). Change the conflict-resolution logic (e.g., auto-suggest nearest free slot). Include recurring meetings (weekly standups, monthly reviews). Add Slack or WhatsApp integration for multi-platform scheduling. Extend Gmail invites with calendar attachments (.ics files). 👉 Rakin Jakaria. An n8n automation workflow template by Rakin Jakaria.

By Rakin Jakaria

Use cases are many: Manage your Gmail inbox, schedule calendar events, and handle contact details — all from one central AI-powered assistant. Perfect for freelancers managing clients, agency owners who need streamlined communication, or busy professionals who want a personal AI secretary handling their email and calendar. Good to know At time of writing, each Gemini request is billed per token. See Gemini Pricing for the latest info. The workflow requires Gmail, Calendar, Sheets, and Telegram integrations. Ensure you’ve set up OAuth2 credentials correctly before running. How it works Triggers: The workflow listens for **new Gmail messages or Telegram commands. Smart AI Processing**: Incoming emails are summarized, classified (Client, Sponsorship, or Not Business), and labeled automatically. Auto-Replies**: Depending on classification, the assistant sends pre-written replies (e.g., client acknowledgment, sponsorship rates, or polite rejection). Calendar Management**: Through natural language requests in Telegram, you can schedule, update, or delete calendar events with conflict-checking in place. Contact Handling**: If you send an email to someone not yet in your database, the agent will prompt you for their email, add it to Google Sheets, and reuse it for future tasks. Memory**: The AI maintains conversation context, so repeated tasks feel seamless and natural. How to use Send commands via Telegram like: “Schedule a meeting with Sarah on Monday at 3 PM” “Send an email to David about the proposal” Watch as the assistant checks your calendar, sends emails, and keeps your contacts updated — all automatically. Requirements Gmail account (with labels created for Client, Sponsorship Request, and Not Business) Google Calendar for scheduling Google Sheets for contact management Google Gemini API key Telegram bot for live interaction Customising this workflow You can expand it to: Handle Slack or WhatsApp messages in addition to Telegram. Add more classification categories (e.g., Invoices, Personal, Leads). Extend auto-replies with dynamic templates stored in Google Sheets. Log all interactions to Notion or Airtable for a CRM-style history of communications. 👉 Rakin Jakaria. An n8n automation workflow template by Rakin Jakaria.

By Rakin Jakaria

Use Cases Analyze e-commerce product pages for conversion optimization, audit SaaS landing pages for signup improvements, or evaluate marketing campaign pages for better lead generation. Good to know At time of writing, Google Gemini API calls have usage costs. See Google AI Pricing for current rates. The workflow analyzes publicly accessible pages only - pages behind login walls or with restricted access won't work. Analysis quality depends on page content structure - heavily image-based pages may receive limited text-based recommendations. How it works User submits a landing page URL through the form trigger interface. The HTTP Request node fetches the complete HTML content from the target landing page. Content is converted from HTML to markdown format for cleaner AI processing and better text extraction. Google Gemini 2.5 Flash analyzes the page using expert CRO knowledge and 2024 conversion best practices. The AI generates specific, actionable recommendations based on actual page content rather than generic advice. Information Extractor processes the analysis into 5 prioritized improvement tips with relevant visual indicators. Results are delivered through a completion form showing concrete steps to improve conversion rates. How to use The form trigger is configured for direct URL submission but can be replaced with webhook triggers for integration into existing websites or apps. Multiple pages can be analyzed sequentially, though each requires a separate workflow execution. Recommendations focus on high-impact changes that don't require heavy development work. Requirements Google Gemini (PaLM) API account for AI-powered analysis Publicly accessible landing pages for analysis N8N instance with proper webhook configuration Customizing this workflow CRO analysis can be tailored for specific industries by modifying the AI system prompt - try focusing on e-commerce checkout flows, SaaS trial conversions, or local business lead capture forms. Add competitive analysis by incorporating multiple URL inputs and comparative recommendations. An n8n automation workflow template by Rakin Jakaria.

By Guillaume Duvernay

Stop the daily grind of checking multiple apps just to stay updated. This template automates the creation of recurring digests by querying a powerful AI assistant you build on the Super platform. First, create an assistant in Super (https://super.work/) and connect it to all your key data sources like Notion, Jira, Slack, and HubSpot. Then, use this n8n workflow to ask it a specific question on a recurring schedule (e.g., "What was the progress on our key projects yesterday?"). The workflow delivers a concise, AI-generated summary directly to a Slack channel of your choice. It's the easiest way to get the information that matters most, without the manual work. Who is this for? Team leads & managers:** Get automated daily or weekly reports on project progress, sales performance, or customer support trends without having to chase down information. Operations teams:** Monitor key business activities by receiving automated summaries from various sources in a single, convenient message. Anyone overwhelmed by information:** Replace manual check-ins across multiple platforms with a single, intelligent digest tailored to your needs. What problem does this solve? Eliminates manual reporting:** Frees you from the repetitive, time-consuming task of gathering updates from different tools every day. Centralizes key insights:** Delivers crucial information from all your connected apps (via your Super assistant) into a single, easy-to-read Slack message. Saves time and improves focus:** Start your day with a concise, actionable summary instead of context-switching between numerous tabs and dashboards. Makes powerful, data-connected AI accessible:** Simplifies the process of querying a sophisticated AI assistant on a recurring basis to get answers from your own company's data. How it works First, in Super: The process starts on the Super platform (https://super.work/), where you create a new assistant. You'll define its purpose with a prompt and connect it to your live data sources (e.g., your Jira projects, Notion databases, etc.). Scheduled trigger: The n8n workflow runs automatically on a schedule you define (e.g., every weekday morning at 8:30 AM). Define the recurring query: A Set node holds the specific question you want to ask your Super assistant each time the workflow runs. Query the Super assistant: An HTTP Request node sends this query, along with your unique assistant ID, to the Super API. Deliver the digest to Slack: Your Super assistant generates an answer based on the live data it can access. The workflow then formats this answer and posts it as a clear, concise message in your designated Slack channel. Setup Set up your Super assistant (Prerequisite): First, go to Super, create an assistant, connect it to your data sources, and copy its Assistant ID and your API Token. Configure the query: In the Set query node, write the question you want to ask your assistant on a recurring basis (e.g., "Summarize all new deals created in HubSpot yesterday."). Connect to the Super API: In the Query Super Assistant (HTTP Request) node: Paste your Assistant ID into the assistantId field in the body. Add your Super API Token for authentication. We recommend creating a "Generic Credential" of type "Bearer Token" for this. Connect Slack: In the Send digest in Slack node, select your Slack account and choose the channel where you want the digest to be posted. Set the schedule: Adjust the Schedule Trigger to your desired frequency and time. Activate the workflow, and your automated digests will start arriving as scheduled! Taking it further Change the destination:* Not a Slack user? Easily swap the *Slack* node for an *Email* node to send the digest to your inbox, or a *Google Sheets** node to log all digests over time. Create dynamic queries:* Use n8n's expression editor in the *Set query** node to make your questions dynamic. For example, you could automatically insert yesterday's date into the query each day. Build multi-step reports:* Chain multiple *HTTP Request** nodes to ask your Super assistant several different questions, then combine all the answers into a single, more comprehensive report. An n8n automation workflow template by Guillaume Duvernay.

By Joseph

This n8n workflow converts various file formats (.pdf, .doc, .png, .jpg, .webp) to clean markdown text using the datalab.to API. Perfect for AI agents, LLM processing, and RAG (Retrieval Augmented Generation) data preparation for vector databases. Workflow Description Input Trigger Node**: Form trigger or webhook to accept file uploads Supported Formats**: PDF documents, Word documents (.doc/.docx), and images (PNG, JPG, WEBP) Processing Steps File Validation: Check file type and size constraints HTTP Request Node: Method: POST to https://api.datalab.to/v1/marker Headers: X-API-Key with your datalab.to API key Body: Multipart form data with the file Response Processing: Extract the converted markdown text Output Formatting: Clean and structure the markdown for downstream use Output Clean, structured markdown text ready for: LLM prompt injection Vector database ingestion AI agent knowledge base processing Document analysis workflows Setup Instructions Get API Access: Sign up at datalab.to to obtain your API key Configure Credentials: Create a new credential in n8n Add Generic Header: X-API-Key with your API key as the value Import Workflow: Ready to process files immediately Use Cases AI Workflows**: Convert documents for LLM analysis and processing RAG Systems**: Prepare clean text for vector database ingestion Content Management**: Batch convert files to searchable markdown format Document Processing**: Extract text from mixed file types in automated pipelines The workflow handles the complexity of different file formats while delivering consistent, AI-ready markdown output for your automation needs. An n8n automation workflow template by Joseph.

By Rakin Jakaria

Who this is for This workflow is for content creators, digital marketers, or YouTube strategists who want to automatically discover trending videos in their niche, analyze engagement metrics, and get data-driven insights for their content strategy — all from one simple form submission. What this workflow does This workflow starts every time someone submits the YouTube Trends Finder Form. It then: Searches YouTube videos* based on your topic and specified time range using the *YouTube Data API**. Fetches detailed analytics** (views, likes, comments, engagement rates) for each video found. Calculates engagement rates** and filters out low-performing content (below 2% engagement). Applies smart filters** to exclude videos with less than 1000 views, content outside your timeframe, and hashtag-heavy titles. Removes duplicate videos** to ensure clean data. Creates a Google Spreadsheet** with all trending video data organized by performance metrics. Delivers the results** via a completion form with a direct link to your analytics report. Setup To set this workflow up: Form Trigger – Customize the "YouTube Trends Finder" form fields if needed (Topic Name, Last How Many Days). YouTube Data API – Add your YouTube OAuth2 credentials and API key in the respective nodes. Google Sheets – Connect your Google Sheets account for automatic report generation. Engagement Filters – Adjust the 2% engagement rate threshold based on your quality standards. View Filters – Modify the minimum view count (currently 1000+) in the filter conditions. Regional Settings – Update the region code (currently "US") to target specific geographic markets. How to customize this workflow to your needs Change the engagement rate threshold to be more or less strict based on your niche requirements. Add additional filters like video duration, subscriber count, or specific keywords to refine results. Modify the Google Sheets structure to include extra metrics like "Channel Name", "Video Duration", or "Trending Score". Switch to different output formats like CSV export or direct email reports instead of Google Sheets. An n8n automation workflow template by Rakin Jakaria.

By Rakin Jakaria

Who this is for This workflow is for freelancers, job seekers, or service providers who want to automatically apply to businesses by scraping their website information, extracting contact details, and sending personalized job application emails with AI-powered content — all from one form submission. What this workflow does This workflow starts every time someone submits the Job Applier Form. It then: Scrapes the target business website** to gather company information and contact details. Converts HTML content** to readable markdown format for better AI processing. Extracts email addresses* and creates a company summary using *GPT-5 AI**. Validates email addresses** to ensure they contain proper formatting (@ symbol check). Accesses your experience data* from a connected *Google Sheet** with your skills and portfolio. Generates personalized application emails* (subject + body) using *GPT-5** based on the job position and company info. Sends the application email* automatically via *Gmail** with your name as sender. Provides confirmation** through a completion form showing the AI's response. Setup To set this workflow up: Form Trigger – Customize the job application form fields (Target Business Website, Applying As dropdown with positions like Video Editor, SEO Expert, etc.). OpenAI GPT-5 – Add your OpenAI API credentials for both AI models used in the workflow. Google Sheets – Connect your sheet containing your working experience data, skills, and portfolio information. Gmail Account – Link your Gmail account for sending application emails automatically. Experience Data – Update the Google Sheet with your relevant skills, experience, and achievements for each job type. Sender Name – Modify the sender name in Gmail settings (currently set to "Jamal Mia"). How to customize this workflow to your needs Add more job positions to the dropdown menu (currently includes Video Editor, SEO Expert, Full-Stack Developer, Social Media Manager). Modify the AI prompt to reflect your unique value proposition and application style. Enhance email validation with additional checks like domain verification or email format patterns. Add follow-up scheduling to automatically send reminder emails after a certain period. Include attachment functionality to automatically attach your resume or portfolio to applications. Switch to different email providers or add multiple sender accounts for variety. An n8n automation workflow template by Rakin Jakaria.

By Ramon David

This workflow manages subscription billing reminders and data updates via Telegram. It runs daily at 8:00 AM to check for upcoming due subscriptions, formats relevant information, and sends reminders to users. It also processes user messages for subscription management—adding, updating, or retrieving billing info—using AI-powered natural language understanding. Main outcomes include automated subscription tracking, timely reminders, and conversational interaction through Telegram, reducing manual tracking efforts and improving billing accuracy. Automation Benefits Time & Cost Savings Manual Process: Several hours/week spent managing subscriptions and reminders manually. Automated Process: Workflow completes checks, reminders, and data updates in under a minute. Time Savings: Saves approximately 5 hours weekly, translating to significant productivity gains and cost reduction. ROI: Automation pays for itself within the first month due to saved labor. Error Reduction: Minimized manual entry errors, ensuring accurate billing records and timely reminders. Business Impact Solves the problem of manual subscription tracking and reminders. Scales effortlessly as subscription list grows. Opens new opportunities for proactive customer engagement, personalized messaging, and integrated billing insights. Setup Guide Prerequisites Google Sheets account with subscription data sheet. OpenAI API key with access to GPT-4. Telegram bot token with messaging permissions. Email SMTP setup if email reminders are used. API Configuration Google Sheets: Generate OAuth2 credentials, enable Sheets API, and authorize access. OpenAI: Create API key, set model to GPT-4, and test connectivity. Telegram: Create bot via BotFather, retrieve token, and set webhook URL. Webhook URL: Use the provided URL in the Telegram bot settings. Node-by-Node Setup OpenAI Chat Model: Enter API credentials, select GPT-4 model. Google Sheets: Input spreadsheet ID, sheet name, and ensure correct permissions. Telegram Nodes: Insert chat ID, message parsing, and response formatting. Schedule Trigger: Confirm cron expression for daily execution. For AI nodes, test with sample messages to verify formatting and extraction. Testing & Validation Run workflow manually. Confirm data is retrieved, processed, and responses sent. Verify subscription updates in Google Sheets. Check Telegram chats for correct message flow. N8N Documentation References Google Sheets Node OpenAI Node Telegram Node Schedule Trigger Maintenance & Troubleshooting Regular Maintenance (Monthly) Check API credentials and renew tokens if expired. Monitor workflow logs for errors. Review Google Sheets data for consistency. Update API keys when new versions or permissions are granted. Verify currency conversion accuracy periodically. Common Issues & Solutions Workflow not triggering: check schedule settings and webhook URLs. Data not updating: verify Google Sheets credentials and permissions. Incorrect responses: test AI prompt inputs and outputs. API failures: regenerate API keys or check quota limits. Reconfigure nodes if external API changes. Monitoring & Alerts Set up email or Slack alerts for failures. Regularly review execution logs. Track key metrics like successful runs, error rates, and response times. Support & Escalation Check n8n logs first for errors. Export workflow for support if needed. Use n8n community forums for common issues. Contact API providers for account-specific problems. Emergency procedures: restart workflow, regenerate tokens. Updates & Improvements Review workflow performance quarterly. Optimize AI prompts for better accuracy. Backup workflow configurations before major changes. Incorporate user feedback for feature enhancements. An n8n automation workflow template by Ramon David.

By Jez

🎯 Overview This n8n workflow automates the process of ingesting documents from multiple sources (Google Drive and web forms) into a Qdrant vector database for semantic search capabilities. It handles batch processing, document analysis, embedding generation, and vector storage - all while maintaining proper error handling and execution tracking. 🚀 Key Features Dual Input Sources**: Accepts files from both Google Drive folders and web form uploads Batch Processing**: Processes files one at a time to prevent memory issues and ensure reliability AI-Powered Analysis**: Uses Google Gemini to extract metadata and understand document context Vector Embeddings**: Generates OpenAI embeddings for semantic search capabilities Automated Cleanup**: Optionally deletes processed files from Google Drive (configurable) Loop Processing**: Handles multiple files efficiently with Split In Batches nodes Interactive Chat Interface**: Built-in chatbot for testing semantic search queries against indexed documents 📋 Use Cases Knowledge Base Creation**: Build searchable document repositories for organizations Document Compliance**: Process and index legal/regulatory documents (like Fair Work documents) Content Management**: Automatically categorize and store uploaded documents Research Libraries**: Create semantic search capabilities for research papers or reports Customer Support**: Enable instant answers to policy and documentation questions via chat interface 🔧 Workflow Components Input Methods Google Drive Integration Monitors a specific folder for new files Processes existing files in batch mode Supports automatic file conversion to PDF Web Form Upload Public-facing form for document submission Accepts PDF, DOCX, DOC, and CSV files Processes multiple file uploads in a single submission Processing Pipeline File Splitting: Separates multiple uploads into individual items Document Analysis: Google Gemini extracts document understanding Text Extraction: Converts documents to plain text Embedding Generation: Creates vector embeddings via OpenAI Vector Storage: Inserts documents with embeddings into Qdrant Loop Control: Manages batch processing with proper state handling Key Nodes Split In Batches**: Processes files one at a time with reset: false to maintain state Google Gemini**: Analyzes documents for context and metadata Langchain Vector Store**: Handles Qdrant insertion with embeddings HTTP Request**: Direct API calls for custom operations Chat Interface**: Interactive chatbot for testing vector search queries 🛠️ Technical Implementation Batch Processing Logic The workflow uses a clever looping mechanism: Split In Batches with batchSize: 1 ensures single-file processing reset: false maintains loop state across iterations Loop continues until all files are processed Error Handling All nodes include continueOnFail options where appropriate Execution logs are preserved for debugging File deletion only occurs after successful insertion Data Flow Form Upload → Split Files → Batch Loop → Analyze → Insert → Loop Back Google Drive → List Files → Batch Loop → Download → Analyze → Insert → Delete → Loop Back 📊 Performance Considerations Processing Time**: ~20-30 seconds per file Batch Size**: Set to 1 for reliability (configurable) Memory Usage**: Optimized for files under 10MB API Costs**: Uses OpenAI embeddings (text-embedding-3-large model) 🔐 Required Credentials Google Drive OAuth2: For file access and management OpenAI API: For embedding generation Qdrant API: For vector database operations Google Gemini API: For document analysis 💡 Implementation Tips Start Small: Test with a few files before processing large batches Monitor Costs: Track OpenAI API usage for embedding generation Backup First: Consider archiving instead of deleting processed files Check Collections: Ensure Qdrant collection exists before running 🎨 Customization Options Change Embedding Model**: Switch to text-embedding-3-small for cost savings Adjust Chunk Size**: Modify text splitting parameters for different document types Add Metadata**: Extend the Gemini prompt to extract specific fields Archive vs Delete**: Replace delete operation with move to "processed" folder 📈 Real-World Application This workflow was developed to process business documents and legal agreements, making them searchable through semantic queries. It's particularly useful for organizations dealing with large volumes of regulatory documentation that need to be quickly accessible and searchable. Chat Interface Testing The integrated chatbot interface allows users to: Query processed documents using natural language Test semantic search capabilities in real-time Verify document indexing and retrieval accuracy Ask questions about specific topics (e.g., "What are the pay rates for junior employees?") Get instant AI-powered responses based on the indexed content 🌟 Benefits Automation**: Eliminates manual document processing Scalability**: Handles individual files or bulk uploads Intelligence**: AI-powered understanding of document content Flexibility**: Multiple input sources and processing options Reliability**: Robust error handling and state management 👨‍💻 About the Creator Jeremy Dawes is the CEO of Jezweb, specializing in AI and automation deployment solutions. This workflow represents practical, production-ready automation that solves real business challenges while maintaining simplicity and reliability. 📝 Notes The workflow intelligently handles the n8n form upload pattern where multiple files create a single item with multiple binary properties (Files_0, Files_1, etc.) The Split In Batches pattern with reset: false is crucial for proper loop execution Direct API integration provides more control than pure Langchain implementations 🔗 Resources Qdrant Documentation OpenAI Embeddings n8n Documentation Jezweb - AI & Automation Solutions This workflow demonstrates practical automation that bridges document management with modern AI capabilities, creating intelligent document processing systems that scale with your needs. An n8n automation workflow template by Jez.

By Jaruphat J.

⚠️ Note: This template requires a community node and works only on self-hosted n8n installations. It uses the Typhoon OCR Python package, pdfseparate from poppler-utils, and custom command execution. Make sure to install all required dependencies locally. Who is this for? This template is designed for developers, back-office teams, and automation builders (especially in Thailand or Thai-speaking environments) who need to process multi-file, multi-page Thai PDFs and automatically export structured results to Google Sheets. It is ideal for: Government and enterprise document processing Thai-language invoices, memos, and official letters AI-powered automation pipelines that require Thai OCR What problem does this solve? Typhoon OCR is one of the most accurate OCR tools for Thai text, but integrating it into an end-to-end workflow usually requires manual scripting and handling multi-page PDFs. This template solves that by: Splitting PDFs into individual pages Running Typhoon OCR on each page Aggregating text back into a single file Using AI to extract structured fields Automatically saving structured data into Google Sheets What this workflow does Trigger:** Manual execution or any n8n trigger node Load Files:** Read PDFs from a local doc/multipage folder Split PDF Pages:** Use pdfinfo and pdfseparate to break PDFs into pages Typhoon OCR:** Run OCR on each page via Execute Command Aggregate:** Combine per-page OCR text LLM Extraction:** Use AI (e.g., GPT-4, OpenRouter) to extract fields into JSON Parse JSON:** Convert structured JSON into a tabular format Google Sheets:** Append one row per file into a Google Sheet Cleanup:** Delete temp split pages and move processed PDFs into a Completed folder Setup Install Requirements Python 3.10+ typhoon-ocr: pip install typhoon-ocr poppler-utils: provides pdfinfo, pdfseparate qpdf: backup page counting Create folders /doc/multipage for incoming files /doc/tmp for split pages /doc/multipage/Completed for processed files Google Sheet Create a Google Sheet with column headers like: book_id | date | subject | to | attach | detail | signed_by | signed_by2 | contact_phone | contact_email | contact_fax | download_url API Keys Export your TYPHOON_OCR_API_KEY and OPENAI_API_KEY (or use credentials in n8n) How to customize this workflow Replace the LLM provider in the “Structure Text to JSON with LLM” node (supports OpenRouter, OpenAI, etc.) Adjust the JSON schema and parsing logic to match your documents Update Google Sheets mapping to fit your desired fields Add trigger nodes (Dropbox, Google Drive, Webhook) to automate file ingestion About Typhoon OCR Typhoon is a multilingual LLM and NLP toolkit optimized for Thai. It includes typhoon-ocr, a Python OCR package designed for Thai-centric documents. It is open-source, highly accurate, and works well in automation pipelines. Perfect for government paperwork, PDF reports, and multi-language documents in Southeast Asia. Deployment Option You can also deploy this workflow easily using the Docker image provided in my GitHub repository: https://github.com/Jaruphat/n8n-ffmpeg-typhoon-ollama This Docker setup already includes n8n, ffmpeg, Typhoon OCR, and Ollama combined together, so you can run the whole environment without installing each dependency manually. An n8n automation workflow template by Jaruphat J..

By Pramod Rathoure

This workflow contains community nodes that are only compatible with the self-hosted version of n8n. 🚀 Automating Google Maps Lead Generation with n8n + Apify Finding quality leads can be time-consuming. What if you could scrape restaurant data from Google Maps, filter the best ones, and email a Morning Brew–style newsletter automatically? That’s exactly what this n8n workflow does. 🔎 What This Workflow Does Takes a location input (Bangkok or Bareilly in this case) Runs a Google Maps scraper via Apify Actor Extracts restaurant essentials (name, category, rating, reviews, address, phone, Google Maps link) Sorts & filters results (only high-review, highly-rated places) Saves data to Airtable for lead management Uses AI to generate a newsletter in a Morning Brew–style HTML email Emails the newsletter automatically to your chosen recipients 🛠️ Workflow Breakdown 1. Form Trigger User selects location from a dropdown (Bangkok or Bareilly) Submits form to kickstart the process 2. Google Maps Scraper Powered by Apify Collects up to 1,000 restaurants with details: Name Category Price Range Rating Reviews Address Phone Google Maps URL Skips closed places and pulls detailed contact data 3. Extract & Transform Data n8n Set node extracts only the essentials Formats them into a clean text block (Restaurant_Data) 4. Sort & Filter Sorted by**: Review Count (descending) Rating (descending) Filter*: Only restaurants with *500+ reviews 5. Airtable Lead Storage Each record is saved to Google Map Leads - Restaurants Airtable table Fields include: Title Category Price Range Rating Review Count Address Phone Location 6. AI-Powered Newsletter n8n’s LangChain + OpenAI node generates an HTML newsletter Tone**: Breezy, witty, like Morning Brew Content**: Sorted restaurant picks with ratings, reviews, and contact links Output is JSON with "Subject" and "Body" 7. Automatic Email Gmail node sends the newsletter directly to your inbox Example recipient: prath002@gmail.com 🎯 Why This Workflow Rocks End-to-End Automation**: From scraping → filtering → emailing, no manual effort Lead Enrichment**: Only keeps high-quality restaurants with strong social proof Scalable**: Works for any city you plug into the form Engaging Output**: AI crafts the results into a ready-to-send newsletter 🔮 Next Steps Add more cities to the dropdown for multi-location scraping Customize the email template for branding Integrate with CRM tools for automated outreach 👉 With just a few clicks, you can go from raw Google Maps data → polished newsletter → fresh leads in Airtable. That’s the power of n8n + Apify + AI. An n8n automation workflow template by Pramod Rathoure.

By Intuz

Disclaimer: Community nodes are used, and template can only be used on self-hosted n8n instances. This n8n template from Intuz provides a complete solution to automate your entire B2B lead generation pipeline, from discovering recently funded companies to drafting hyper-personalized outreach emails with AI. Who's this workflow for? Sales Development Representatives (SDRs) Business Development Teams Growth Hackers Startup Founders Marketing Agencies How it works 1. Scrape Funded Companies: The workflow begins by using Apify to scrape a target list of recently funded companies directly from a Crunchbase search. 2. Enrich with Apollo.io: It takes each company and uses the Apollo.io API to find key decision-makers (like VPs, Directors) and enrich their contact information, including finding their email addresses. 3. Populate Google Sheets: All the gathered lead data—company name, contact name, title, email, LinkedIn URL, etc.—is neatly organized and added to a Google Sheet. 4. AI-Personalized Email Crafting: The workflow sends the lead's information to OpenAI (GPT-4) with a highly specialized prompt, instructing it to write a concise, impactful, and hyper-personalized "first touch" cold email. 5. Update Lead List with Email Content: Finally, the unique, AI-generated email is saved back into the Google Sheet alongside the corresponding lead's information, making it ready for you to send. Pre-conditions and Requirements Before you can successfully execute this workflow, you must have the following accounts, credentials, and assets in place. 1. n8n Instance: You need an active n8n instance (self-hosted). 2. Apify Account & Crunchbase Access: Apify Account: A registered account on Apify. Crunchbase Account: An active, logged-in Crunchbase account (a paid subscription is recommended for accessing detailed search filters). 3. Apollo.io API: You need an Apollo.io plan that includes API access. You can generate the API from settings. 4. Google Sheet: Create a new Google Sheet to store your leads. The workflow is configured for two tabs: one for raw data ("HealthCare" in the template) and one for email generation ("Company sheet"). 5. OpenAI Account: An account with OpenAI with API access and billing set up. Setup Instructions 1. Apify Connection: Connect your Apify account in the Run an Actor node. You'll need an apify scrapper, here's the link In the Custom Body field, update the search.url with your target Crunchbase discovery URL and provide a valid cookie for authentication. 2. Apollo.io Connection: Connect your Apollo.io account using HTTP Header Authentication in the three Apollo nodes. You will need to provide your API key. 3. Google Sheets Connection: Connect your Google Sheets account. Create a spreadsheet and update the Document ID and Sheet Name in the three Google Sheets nodes to match yours. Ensure your sheet columns are set up to receive the data. 4. OpenAI Connection: Connect your OpenAI account in the Message a model node. The prompt is pre-engineered for high-quality output, but you can tailor it to better fit your specific value proposition. 5. Activate Workflow: Click "Execute workflow" to run the automation manually and watch your AI-powered lead list build itself. Customization Guide This workflow is a powerful template. To adapt it to your specific business needs, you should review and modify the following nodes. 1. Changing Your Target Companies (The Source) Node: Run an Actor What to change: The search.url parameter inside the customBody. How to do it: Go to Crunchbase and perform a search for your ideal companies (e.g., filter by different funding rounds, industry, location, keywords, etc.). Copy the URL from your browser's address bar after the search results have loaded. Paste this new URL as the value for "search.url" in the node. You can also adjust "count": 10 to pull more or fewer companies per run. Be mindful of Apify and Apollo credit usage. 2. Defining Your Ideal Contact Persona Node: Apollo - Get User What to change: The person_seniorities and person_titles arrays in the jsonBody. How to do it: 1. Seniority: Modify the person_seniorities list to match who you sell to. Examples: ["c_level", "founder"] or ["manager", "contributor"]. 2. Job Titles: This is crucial. Replace the existing list of titles ("engineering", "technology", etc.) with keywords relevant to your target buyer. For example, if you sell to marketing teams, you might use: ["marketing", "demand generation", "growth", "content", "brand"]. 3. Configuring Your Google Sheet Destination Nodes: Append or update row in sheet and Update row in sheet What to change: The documentId and sheetName. How to do it: Open your Google Sheet. The documentId is the long string of characters in the URL between /d/ and /edit. Copy and paste it into the "Document ID" field in both nodes. The sheetName (or Sheet ID/gid) needs to be set for your specific tabs. Make sure the sheet names/IDs in the nodes match the tabs in your document. Column Mapping: If you change the column names in your Google Sheet, you must update the column mapping inside these nodes to ensure the data is written to the correct place. 4. Tailoring the AI Email Generation Node: Message a model (OpenAI) What to change: The prompt, the model, and the input variables. How to do it: The Prompt: This is the heart of your outreach. Read the entire prompt carefully and edit it to reflect your company's value proposition, tone of voice, and specific call-to-action. Value Proposition: Change the line "We help them cut that specific infrastructure spend..." to match what your product does. Use a powerful, single data point if you have one. Call-to-Action (CTA): Modify the final question ("Curious if infra efficiency is on your roadmap...") to something that fits your sales process. Tone: Adjust the initial instructions (e.g., "Your tone is that of a peer...") if you want a different style. The Model: The workflow uses gpt-4.1. You can switch to a different model like gpt-4o (potentially better/faster) or gpt-3.5-turbo (much cheaper, but lower quality) depending on your budget and needs. Input Variables: The prompt uses {{ $json['Company Name'] }}, {{ $json['Person Designation'] }}, and {{ $json.Industry }}. If you want to add more personalization (e.g., based on a company's funding amount), you would first need to ensure that data is passed to this node, then add the new variable (e.g., {{ $json['Funding Amount'] }}) into the prompt. Connect with us Website: https://www.intuz.com/n8n-workflow-automation-templates Email: getstarted@intuz.com LinkedIn: https://www.linkedin.com/company/intuz Get Started: https://n8n.partnerlinks.io/intuz For Custom Workflow Automation Click here- Get Started. An n8n automation workflow template by Intuz.

By Alex Huy

How it works This workflow automatically curates and sends a daily AI/Tech news digest by aggregating articles from premium tech publications and using AI to select the most relevant and trending stories. 🔄 Automated News Pipeline RSS Feed Collection - Fetches articles from 14 premium tech news sources (TechCrunch, MIT Tech Review, The Verge, Wired, etc.) Smart Article Filtering - Limits articles per source to ensure diverse coverage and prevent single-source domination Data Standardization - Cleans and structures article data (title, summary, link, date) for AI processing AI-Powered Curation - Uses Google Vertex AI to analyze articles and select top 10 most relevant/trending stories Newsletter Generation - Creates professional HTML newsletter with summaries and direct links Email Delivery - Automatically sends formatted digest via Gmail 🎯 Key Features Premium Sources** - Curates from 14 top-tier tech publications AI Quality Control** - Intelligent article selection and summarization Balanced Coverage** - Prevents source bias with smart filtering Professional Format** - Clean HTML newsletter design Scheduled Automation** - Daily delivery at customizable times Error Resilience** - Continues processing even if some feeds fail Setup Steps 1. 🔑 Required API Access Google Cloud Project** with Vertex AI API enabled Google Service Account** with AI Platform Developer role Gmail API** enabled for email sending 2. ☁️ Google Cloud Setup Create or select a Google Cloud Project Enable the Vertex AI API Create a service account with these permissions: AI Platform Developer Service Account User Download the service account JSON key Enable Gmail API for the same project 3. 🔐 n8n Credentials Configuration Add these credentials to your n8n instance: Google Service Account (for Vertex AI): Upload your service account JSON key Name it descriptively (e.g., "Vertex AI Service Account") Gmail OAuth2: Use your Google account credentials Authorize Gmail API access Required scopes: gmail.send 4. ⚙️ Workflow Configuration Import the workflow into your n8n instance Update node configurations: Google Vertex AI Model: Set your Google Cloud Project ID Send Newsletter Email: Update recipient email address Daily Newsletter Trigger: Adjust schedule time if needed Verify credentials are properly connected to respective nodes 5. 📰 RSS Sources Customization (Optional) The workflow includes 14 premium tech news sources: TechCrunch (AI & Startups) The Verge (AI section) MIT Technology Review Wired (AI/Science) VentureBeat (AI) ZDNet (AI topics) AI Trends Nature (Machine Learning) Towards Data Science NY Times Technology The Guardian Technology BBC Technology Nikkei Asia Technology To customize sources: Edit the "Configure RSS Sources" node Add/remove RSS feed URLs as needed Ensure feeds are active and properly formatted 6. 🚀 Testing & Deployment Manual Test: Execute the workflow manually to verify setup Check Email: Confirm newsletter arrives with proper formatting Verify AI Output: Ensure articles are relevant and well-summarized Schedule Activation: Enable the daily trigger for automated operation 💡 Customization Options Newsletter Timing: Default: 8:00 AM UTC daily Modify "triggerAtHour" in the Schedule Trigger node Add multiple daily sends if desired Content Focus: Adjust the AI prompt in "AI Tech News Curator" node Specify different topics (e.g., focus on startups, enterprise AI, etc.) Change output language or format Email Recipients: Update single recipient in Gmail node Or modify to send to multiple addresses Integrate with mailing list services Article Limits: Current: Max 5 articles per source Modify the filtering logic in "Filter & Balance Articles" node Adjust total article count in AI prompt 🔧 Troubleshooting Common Issues: RSS Feed Failures**: Individual feed failures won't stop the workflow AI Rate Limits**: Vertex AI has generous limits, but monitor usage Gmail Sending**: Ensure sender email is authorized in Gmail settings Missing Articles**: Some RSS feeds may be inactive - check source URLs Performance Tips: Monitor execution times during peak RSS activity Consider adding delays if hitting rate limits Archive old newsletters for reference This workflow transforms daily news consumption from manual browsing to curated, AI-powered intelligence delivered automatically to your inbox. An n8n automation workflow template by Alex Huy.

By R4wd0G

Who’s it for Teams that manage tasks in ClickUp and want those tasks reflected—and kept in sync—in Google Calendar automatically. How it works A ClickUp Trigger captures task events (create, update, delete). For new tasks, the workflow creates a Google Calendar event with the correct start/end. It stores a mapping between clickupTaskId and calendarEventId in a Google Sheet so later updates and deletions can target the right event. Multiple lanes (personal/school/tech/internship) let you route tasks to different calendars. How to set up Assign ClickUp OAuth, Google Calendar, and Google Sheets credentials to the nodes. Open the Configuration node and fill: calendarId_* for each lane sheetId and sheetTabName for the mapping sheet (optional) clickupTeamId Enable the ClickUp Trigger and run a manual test to validate mapping creation and event syncing. Requirements ClickUp workspace with OAuth permissions Google Calendar & Sheets access A Google Sheet for the event↔task mapping How to customize the workflow Edit the calendar routing in Edit Fields nodes or point them to different calendarId_* values. Adjust event colors/fields in Google Calendar nodes. Extend the mapping sheet with extra columns (e.g., status, labels) as needed. An n8n automation workflow template by R4wd0G.

By Rosh Ragel

Automatically Upload Expenses to QuickBooks from Google Sheets What It Does This n8n workflow template automates the process of uploading categorized expenses from Google Sheets into QuickBooks Online. It leverages your Google Sheets data to create expense entries in QuickBooks with minimal manual effort, streamlining the accounting process. Prerequisites QuickBooks Online Credential**: Set up your QuickBooks Online connection in n8n for expense creation. Google Sheets Credential**: Set up your Google Sheets connection in n8n to read and write data. How It Works Refresh Google Sheets Data: The workflow will first refresh the list of vendors and chart of accounts from your Google Sheets template. Import Bank Transactions: Open the provided Google Sheets template and copy-paste your transactions from your online banking CSV file. Categorize Transactions: Quickly categorize the transactions in Google Sheets, or assign this task to a team member. Run the Workflow: Once the transactions are categorized, run the workflow again, and each expense will be created automatically in QuickBooks Online. Example Use Cases Small Business Owners**: Automatically track and upload monthly expenses to QuickBooks Online without manually entering data. Accountants**: Automate the transfer of bank transactions to QuickBooks, streamlining the financial process. Bookkeepers**: Quickly categorize and upload business expenses to QuickBooks with minimal effort. Setup Instructions Connect Your Google Sheets and QuickBooks Credentials: In n8n, connect your Google Sheets and QuickBooks accounts. Follow the credential setup instructions for both services. Setup the Google Sheets Node: Link the specific Google Sheet that contains your expense data. Make sure the sheet includes the correct columns for transactions, vendors, and accounts. Setup the QuickBooks Node: Configure the QuickBooks Online node to create expense entries in QuickBooks from the data in your Google Sheets. Setup the HTTP Node for API Calls: Use the HTTP node to make custom API calls to QuickBooks Configure the QuickBooks Realm ID: Obtain the QuickBooks Realm ID from your QuickBooks Online Developer account to use for custom API calls. This ensures the workflow targets the correct QuickBooks instance. How to Use Import Transactions: Copy and paste your bank transactions from the CSV into the provided Google Sheets template. Categorize Transactions: Manually categorize the transactions in the sheet, or delegate this task to another person to ensure they’re correctly tagged (e.g., Utilities, Office Supplies, Travel). Run the Workflow: Execute the workflow to automatically upload the categorized expenses into QuickBooks. Verify in QuickBooks: After the workflow runs, log into QuickBooks Online to confirm the expenses have been created and categorized correctly. Free Google Sheets Template To get started quickly, download my free Google Sheets template that includes pre-configured sheets for bank transactions, vendors, and chart of accounts. This template will make it easier for you to import and categorize your expenses before running the n8n workflow. Download the Free Google Sheets Template Customization Options Category Mapping**: Customize how categories in Google Sheets are mapped to QuickBooks expense types. Additional API Calls**: Add custom API calls if you need extra functionality, such as creating custom reports or syncing additional data. Notifications**: Configure email or Slack notifications to alert you when the expenses have been successfully uploaded. Why It's Useful Time-Saving**: Automatically upload and categorize expenses in QuickBooks without needing to enter them manually. Error Reduction**: Minimize human error by automating the process of uploading and categorizing transactions. Efficiency**: Connects Google Sheets to QuickBooks, making it easy to manage expenses in one place without having to toggle between multiple apps. Accuracy**: Syncs data between Google Sheets and QuickBooks in a structured, automated way for consistent and reliable financial reporting. Flexibility**: Allow external users or lower-permission employees to categorize financial transactions without providing direct access to QBO. An n8n automation workflow template by Rosh Ragel.

By Evoort Solutions

🔍 Analyze Competitor Keywords with RapidAPI and Google Sheets Reporting 📄 Description This n8n workflow streamlines the process of analyzing SEO competitor keywords using the Competitor Keyword Analysis API on RapidAPI. It collects a website and country via form submission, calls the API to retrieve keyword metrics, reformats the response, and logs the results into Google Sheets — all automatically. It is ideal for SEO analysts, marketing teams, and agencies who need a hands-free solution for competitive keyword insights. 🧩 Node-by-Node Explanation 📝 On form submission (formTrigger) Starts the workflow when a user submits their website and country through a form. 🌐 Competitor Keyword Analysis (httpRequest) Sends a POST request to the Competitor Keyword Analysis API on RapidAPI with form input to fetch keyword data. 🔄 Reformat Code (code) Extracts the domainOrganicSearchKeywords array from the API response for structured processing. 📊 Google Sheets (googleSheets) Appends the cleaned keyword metrics into a Google Sheet for easy viewing and tracking. 🚀 Benefits of This Workflow ✅ Automates SEO research using the Competitor Keyword Analysis API. ✅ Eliminates manual data entry — results go straight into Google Sheets. ✅ Scalable and reusable for any number of websites or countries. ✅ Reformatting logic is built-in, so you get clean, analysis-ready data. 💼 Use Cases Marketing Agencies Use the Competitor Keyword Analysis API to gather insights for client websites and store the results automatically. In-house SEO Teams Quickly compare keyword performance across competitors and monitor shifts over time with historical Google Sheets logs. Freelancers and Consultants Provide fast, data-backed SEO reports using this automation with the Competitor Keyword Analysis API. Keyword Research Automation Make this flow part of a larger system for identifying keyword gaps, content opportunities, or campaign ideas. 📁 Output Example (Google Sheets) | keyword | searchVolume | cpc | competition | position | previousPosition | keywordDifficulty | |---------------|--------------|-----|-------------|----------|------------------|-------------------| | best laptops | 9900 | 2.3 | 0.87 | 5 | 7 | 55 | 🔐 How to Get Your API Key for the Competitor Keyword Analysis API Go to 👉 Competitor Keyword Analysis API - RapidAPI Click "Subscribe to Test" (you may need to sign up or log in). Choose a pricing plan (there’s a free tier for testing). After subscribing, click on the "Endpoints" tab. Your API Key will be visible in the "x-rapidapi-key" header. 🔑 Copy and paste this key into the httpRequest node in your workflow. ✅ Summary This workflow is a powerful no-code automation tool that leverages the Competitor Keyword Analysis API on RapidAPI to deliver real-time SEO insights directly to Google Sheets — saving time, boosting efficiency, and enabling smarter keyword strategy decisions. Create your free n8n account and set up the workflow in just a few minutes using the link below: 👉 Start Automating with n8n. An n8n automation workflow template by Evoort Solutions.

By R4wd0G

Who’s it for Operators and makers who capture tasks from custom forms, bots, or automations and want them to appear as time-boxed events in Google Calendar with minimal setup. How it works A Webhook receives a payload containing the task title and a due date (as Unix seconds). The workflow formats the date, checks the most recently updated events in your calendar to avoid duplicates, and creates a new 30-minute event (configurable). After creation, it optionally deletes the original task, keeping your Task list clean and your Calendar up to date. How to set up Select your Google Tasks and Google Calendar credentials. Open the Configuration node and set tasklistId, calendarId (use primary or a specific calendar), defaultMinutes, and eventColor. Send a sample POST to the Webhook with { TaskName, DueDateTimeSeconds }. Run once in manual mode and, if all looks good, activate. Requirements Google accounts for Tasks and Calendar. Appropriate scopes/permissions in the selected credentials. How to customize the workflow Change the event duration/color in Configuration. Adjust duplicate detection by modifying the Calendar search window and query. Map additional fields (e.g., description, attendees) on the Calendar node’s optional fields. Tags Google Calendar, Google Tasks, Webhook, Automation, Productivity Categories Productivity, Google, Calendar. An n8n automation workflow template by R4wd0G.

By Robert Breen

This workflow looks inside a Google Drive folder, parses each PDF invoice with PDF.co’s AI Invoice Parser, and appends vendor, amount, dates, and a link to the file into a Google Sheet. ⚙️ Setup Instructions 1) Connect Google Drive (OAuth2) In n8n → Credentials → New → Google Drive (OAuth2) Sign in to the Google account that owns your invoice PDFs and allow access. In the Get Parent Folder ID node, set your search to the folder name (e.g., n8n Invoices). In Get Invoice ID’s, ensure Filter → folderId uses the ID from the previous node (already wired in this template). > Tip: The workflow builds a Drive link like > https://drive.google.com/file/d/<FILE_ID> > Make sure those files are at least viewable via link (e.g., Anyone with the link – Viewer) so PDF.co can fetch them. 2) Connect PDF.co (AI Invoice Parser) Create a PDF.co account and copy your API Key. In n8n → Credentials → New → PDF.co API, paste your key and Save. In the AI Invoice Parser node, keep URL mapped to the Drive link coming from Convert to URL. The node is already set to use your PDF.co credentials. > What it does: Sends each Drive file URL to PDF.co’s AI Invoice Parser and returns structured JSON (vendor, totals, dates, line items, etc.). The next Set Fields node maps those fields to simple columns for Sheets. 3) Connect Google Sheets (OAuth2) In n8n → Credentials → New → Google Sheets (OAuth2) Log in with your Google account and grant access. In the Store Data in Google Sheets node, select your Spreadsheet and Sheet (this template is set to: Spreadsheet: Invoice Template (1a6QBIQkr7RsZtUZBi87NwhwgTbnr5hQl4J_ZOkr3F1U) Tab: Due (gid: 1002294955) The node is configured to Append or Update by Url so repeats won’t duplicate. Expected columns on the Due tab: Url (Drive link we generated) Vendor Invoice Date Total Due Date ▶️ How to Run Put your PDF invoices in the “n8n Invoices” folder (or the folder name you used). Click Execute Workflow in n8n. Watch items flow: Get Parent Folder ID → finds folder Get Invoice ID’s → lists files in that folder Convert to URL → turns each file ID into a shareable link AI Invoice Parser → extracts JSON from each PDF Set Fields → maps fields for Sheets Store Data in Google Sheets → appends/updates the Due sheet 🧩 Troubleshooting PDF.co can’t fetch the file:* Ensure your Drive file link is accessible (e.g., *Anyone with the link – Viewer**), or use a URL that PDF.co can reach. No rows added:* Confirm the *Google Sheets* credential is selected and the *Sheet tab** (gid) matches your target. Wrong folder:* Update the search string in *Get Parent Folder ID** to match your Drive folder name. 📬 Contact Need help customizing this (e.g., auto-sharing Drive links, enriching the Sheet, or pushing to Slack/Email)? 📧 robert@ynteractive.com 🔗 Robert Breen 🌐 ynteractive.com. An n8n automation workflow template by Robert Breen.

By Robert Breen

This workflow pulls marketing data from Google Sheets, aggregates spend by channel, generates an AI-written summary, and outputs a formatted PDF report using a custom HTML template on PDF.co. ⚙️ Setup Instructions 1️⃣ Prepare Your Google Sheet Copy this template into your Google Drive: Sample Marketing Data Add or update your marketing spend data in rows 2–100. Connect Google Sheets in n8n Go to n8n → Credentials → New → Google Sheets (OAuth2) Log in with your Google account and grant access Select the Spreadsheet ID and Worksheet in the workflow 2️⃣ Set Up PDF.co for PDF Reports Create a free account at PDF.co In PDF.co Dashboard → HTML to PDF Templates, create a new Mustache template Paste the HTML provided at the bottom of this description Save, and note your Template ID In n8n → Credentials → New → PDF.co API, paste your API Key and save In the workflow, select your PDF.co credential in the Create PDF node Replace the templateId with your Template ID 🧠 How It Works Google Sheets Node**: Pulls marketing spend data Summarize Nodes**: Aggregate total spend and spend per channel OpenAI Node**: Writes a daily summary of marketing performance Code Node**: Converts aggregated data into the correct shape for the PDF template PDF.co Node: Generates a final, formatted **PDF report 📬 Contact Need help customizing this (e.g., filtering by campaign, sending reports by email, or formatting your PDF)? 📧 robert@ynteractive.com 🔗 Robert Breen 🌐 ynteractive.com 📄 HTML Template (for PDF.co) > Paste this into a new HTML Template on PDF.co and reference its Template ID in your workflow. <!DOCTYPE html> <html> <head> <meta charset="utf-8" /> <title>Invoice {{invoiceNumber}}</title> <style> body { font-family: Arial, Helvetica, sans-serif; margin: 36px; color: #222; } .header { display: flex; justify-content: space-between; align-items: center; } .brand { max-height: 56px; } h1 { margin: 12px 0 4px; font-size: 22px; } .meta { font-size: 12px; color: #555; } .two-col { display: flex; gap: 24px; margin-top: 16px; } .box { flex: 1; border: 1px solid #ddd; padding: 12px; border-radius: 6px; } .label { font-size: 11px; color: #666; text-transform: uppercase; letter-spacing: .02em; } table { width: 100%; border-collapse: collapse; margin-top: 16px; } th, td { border-bottom: 1px solid #eee; padding: 10px 8px; font-size: 13px; } th { background: #fafafa; text-align: left; } tfoot td { border-top: 2px solid #ddd; font-size: 13px; } .right { text-align: right; } .totals td { padding: 6px 8px; } .grand { font-weight: 700; font-size: 14px; } .notes { margin-top: 18px; font-size: 12px; color: #444; } </style> </head> <body> Invoice {{invoiceNumber}} Date: {{invoiceDate}}   |   Due: {{dueDate}} {{#company.logoUrl}} {{/company.logoUrl}} From {{company.name}} {{company.address}} {{company.phone}} {{company.email}} Bill To {{billTo.name}} {{billTo.address}} {{billTo.email}} Description Qty Unit Price Line Total {{#items}} {{line}} {{description}} {{qty}} {{unitPriceFmt}} {{lineTotalFmt}} {{/items}} Subtotal {{subTotalFmt}} Tax ({{taxRatePct}}) {{taxAmountFmt}} Discount -{{discountFmt}} Total {{totalFmt}} Notes: {{notes}} Terms: {{terms}} </body> </html>. An n8n automation workflow template by Robert Breen.

By Ronnie Craig

AI Email Assistant - Smart Email Processing & Response 🤖 A sophisticated n8n workflow that transforms your email management with AI-powered classification, automatic responses, and intelligent organization. 🎯 What This Workflow Does This advanced AI email assistant automatically: Analyzes** incoming emails using intelligent classification Categorizes** messages by priority, urgency, and type Generates** context-aware draft responses in your voice Organizes** emails with smart labeling and filing Alerts** you to urgent messages instantly Manages** attachments with cloud storage integration Perfect for busy professionals, customer service teams, and anyone drowning in email! ✨ Key Features 🧠 Intelligent Email Analysis Context-Aware Processing**: Understands email threads and conversation history Smart Classification**: Automatically categorizes by priority, urgency, and required actions Multi-Criteria Assessment**: Evaluates response needs, follow-up requirements, team involvement Dynamic Label Management**: Syncs with your Gmail labels for consistent organization 📝 AI-Powered Response Generation Professional Draft Creation**: Generates contextually appropriate responses Tone Matching**: Mirrors the formality and style of incoming emails Multiple Response Options**: Provides alternatives for complex inquiries Customizable Voice**: Adapts to your business communication style 🔔 Smart Notification System Urgent Email Alerts**: Instant notifications for high-priority messages Telegram/Slack Integration**: Get alerts where you work Smart Filtering**: Only notifies when truly urgent Quick Action Links**: Direct links to Gmail for immediate response 📎 Advanced Attachment Management Automatic Cloud Upload**: Saves attachments to Google Drive Smart File Naming**: Organized by date, sender, and content Duplicate Detection**: Prevents redundant uploads File Type Filtering**: Optional filtering for security 🏷️ Intelligent Organization Auto-Labeling**: Applies relevant Gmail labels automatically Progress Tracking**: Marks emails as "processed" or "digested" Priority Indicators**: Visual priority levels in your inbox Category-Based Sorting**: Groups similar emails together 🛠️ Setup Instructions Prerequisites n8n instance (cloud or self-hosted) Gmail account with API access OpenAI API key (or compatible AI service) Google Drive account (for attachments) Telegram bot (optional, for alerts) Step 1: Import the Workflow Download AI_Email_Assistant_Community_Template.json In n8n, navigate to Templates → Import from File Select the downloaded JSON file The workflow will import as inactive Step 2: Configure Credentials Gmail Setup: Create Gmail OAuth2 credentials in n8n Configure the following nodes: Email_Trigger Get Conversation Thread Get Latest Message Content Create Draft Response Assign Classification Label Mark as Processed Get All Gmail Labels Test connections to ensure proper authentication AI Model Setup: Configure the AI Language Model node Options include: OpenAI (GPT-4, GPT-3.5-turbo) Anthropic Claude (recommended) Local LLMs via Ollama Add your API credentials Test the connection Google Drive Setup (Optional): Create Google Drive OAuth2 credentials Configure nodes: Upload to Google Drive Check Existing Attachments Replace YOUR_GOOGLE_DRIVE_FOLDER_ID with your folder ID Create a dedicated folder for email attachments Telegram Alerts (Optional): Create a Telegram bot via @BotFather Get your chat ID Configure the Send Urgent Alert node Replace YOUR_TELEGRAM_CHAT_ID with your actual chat ID Step 3: Customize AI Instructions Email Classification (AI Email Classifier node): Review the classification criteria in the system message Adjust urgency keywords for your business Modify priority levels based on your needs Customize category definitions Response Generation (AI Response Generator node): Update the response guidelines Replace [YOUR NAME] with your actual name Adjust tone and style preferences Add company-specific response templates Step 4: Configure Gmail Labels Create Custom Labels in Gmail: High Priority Medium Priority Low Priority Needs Response Urgent Follow Up Required Processed (or use existing labels) Update Label IDs: Run the workflow once to get label IDs Replace YOUR_PROCESSED_LABEL_ID in the "Mark as Processed" node Update any hardcoded label references Step 5: Test and Deploy Testing Process: Send yourself a test email Monitor the workflow execution Verify classification accuracy Check draft response quality Confirm labeling works correctly Test urgent alert functionality Fine-Tuning: Adjust AI prompts based on test results Refine classification criteria Update response templates Modify notification preferences Go Live: Activate the workflow Monitor initial performance Adjust settings as needed 📊 Email Classification System Priority Levels High**: Urgent matters requiring immediate attention Medium**: Important but not time-critical Low**: Routine or informational messages Classification Categories toReply**: Direct questions or requests requiring response urgent**: Immediate business impact or crisis situations dateRelated**: Time-sensitive events or deadlines attachmentsToUpload**: Financial docs or important files requiresFollowUp**: Multi-step processes or ongoing projects forwardToTeam**: Cross-departmental or collaborative items Response Generation Guidelines Professional Tone**: Business casual, warm but professional Context Awareness**: Considers email thread history Structured Responses**: Clear paragraphs with actionable next steps Placeholder System**: Uses [PLACEHOLDER] for missing information Alternative Options**: Provides multiple response choices for complex inquiries 🔧 Advanced Customization File Type Filtering // In Get Specific File Types node, modify: if (mimeType === 'application/pdf' || mimeType === 'text/xml' || mimeType === 'image/jpeg') { // Process file } Custom Urgency Keywords Update the AI classifier prompt with your business-specific urgent terms: Keywords: "URGENT", "EMERGENCY", "CRITICAL", "ASAP", "IMMEDIATE" Custom terms: "CLIENT ESCALATION", "SYSTEM DOWN", "LEGAL DEADLINE" Response Templates Customize the response generator with your company voice: Greeting style: "Hi [Name]" vs "Dear [Name]" Closing: "Best Regards" vs "Thank you" vs "Cheers" Company-specific phrases and terminology Integration Options CRM Systems**: Add nodes to create tasks in your CRM Project Management**: Auto-create tickets in Jira, Asana, etc. Calendar Integration**: Schedule follow-ups automatically Slack/Teams**: Alternative notification channels 🚨 Troubleshooting Common Issues 1. Gmail Authentication Errors Verify OAuth2 credentials are active Check Gmail API quotas Ensure proper scopes are configured 2. AI Classification Inconsistency Review and refine classification prompts Add more specific examples Adjust confidence thresholds 3. Response Generation Problems Validate AI model configuration Check API key and quotas Test with simpler email examples 4. Attachment Upload Failures Verify Google Drive permissions Check folder ID configuration Ensure sufficient storage space 5. Missing Notifications Test Telegram bot configuration Verify chat ID is correct Check urgency classification logic Performance Optimization Rate Limiting**: Gmail has API quotas - monitor usage Batch Processing**: Workflow processes one email at a time Error Handling**: Built-in retry logic for reliability Resource Management**: Monitor AI API costs and usage 📈 Best Practices 1. Email Management Regular Monitoring**: Review classifications weekly Label Hygiene**: Keep Gmail labels organized Feedback Loop**: Manually correct misclassifications Archive Strategy**: Set up auto-archiving for processed emails 2. AI Optimization Prompt Engineering**: Continuously refine AI instructions Example Training**: Add specific examples for your business Context Limits**: Monitor token usage and costs Model Selection**: Choose appropriate AI model for your needs 3. Security Considerations Credential Management**: Regularly rotate API keys Data Privacy**: Review what data is sent to AI services Access Control**: Limit workflow access to authorized users Audit Logging**: Monitor workflow executions 4. Workflow Maintenance Regular Updates**: Keep n8n and node versions current Backup Strategy**: Export workflow configurations regularly Documentation**: Keep setup notes and customizations documented Testing**: Test major changes in development environment first 🤝 Contributing to the Community This workflow template demonstrates: Comprehensive AI Integration**: Multiple AI touchpoints working together Production-Ready Architecture**: Error handling, retry logic, and monitoring Extensive Documentation**: Clear setup and customization guidance Flexible Configuration**: Adaptable to different business needs Best Practice Examples**: Security, performance, and maintenance considerations 📄 License & Support This workflow is provided free to the n8n community under MIT License. Community Resources: n8n Community Forum for questions GitHub Issues for bug reports Documentation updates welcome Professional Support: For enterprise deployments or custom modifications, consider: n8n Cloud for managed hosting Professional services for complex integrations Custom AI model training for specific use cases Transform your email workflow today! 🚀 This AI Email Assistant reduces email processing time by up to 90% while ensuring no important message goes unnoticed. Perfect for busy professionals who want to stay responsive without being overwhelmed by their inbox. An n8n automation workflow template by Ronnie Craig.

By Samuel Heredia

Data Extraction from MongoDB Overview This workflow exposes a public HTTP GET endpoint to read all documents from a MongoDB collection, with: Strict validation of the collection name Error handling with proper 4xx codes Response formatting (e.g., _id → id) and a consistent 2XX JSON envelope Workflow Steps Webhook Trigger: *A public GET endpoint receives requests with the collection name as a parameter*. The workflow begins with a webhook that listens for incoming HTTP GET requests. The endpoint follows this pattern: https://{{your-n8n-instance}}/webhook-test/{{uuid&gt}}/:nameCollection The :nameCollection parameter is passed directly in the URL and specifies the MongoDB collection to be queried. Example: https://yourdomain.com/webhook-test/abcd1234/orders would attempt to fetch all documents from the orders collection. Validation: *The collection name is checked against a set of rules to prevent invalid or unsafe queries*. Before querying the database, the collection name undergoes validation using a regular expression: ^(?!system\.)[a-zA-Z0-9._]{1,120}$ Purpose of validation: Blocks access to MongoDB’s reserved system.* collections. Prevents injection attacks by ensuring only alphanumeric characters, underscores, and dots are allowed. Enforces MongoDB’s length restrictions (max 120 characters). This step ensures the workflow cannot be exploited with malicious input. Conditional Check: *If the validation fails, the workflow stops and returns an error message. If it succeeds, it continues.* The workflow checks if the collection name passes validation. If valid ✅: proceeds to query MongoDB. If invalid ❌: immediately returns a structured HTTP 400 response, adhering to RESTful standards: { "code": 400, "message": "{{ $json.message }}" } MongoDB Query: *The workflow connects to MongoDB and retrieves all documents from the specified collection.* To use the MongoDB node, a proper database connection must be configured in n8n. This is done through MongoDB Credentials in the node settings: Create MongoDB Credentials in n8n Go to n8n → Credentials → New. Select MongoDB and Fill in the following fields: Host: The MongoDB server hostname or IP (e.g., cluster0.mongodb.net). Port: Default is 27017 for local deployments. Database: Name of the database (e.g., myDatabase). User: MongoDB username with read permissions. Password: Corresponding password. Connection Type: Standard for most cases, or Connection String if using a full URI. Replica Set / SRV Record: Enable if using MongoDB Atlas or a replica cluster. Using a Connection String (recommended for MongoDB Atlas) Example URI: mongodb+srv://<username>:<password>@cluster0.mongodb.net/myDatabase?retryWrites=true&w=majority Paste this into the Connection String field when selecting "Connection String" as the type. Verify the Connection After saving, test the credentials to confirm n8n can connect successfully to your MongoDB instance. Configure the MongoDB Node in the Workflow Operation: Find (to fetch documents). Collection: Dynamic value passed from the workflow (e.g., {{$json["nameCollection"]}}). Query: Leave empty to fetch all documents, or define filters if needed. Result: The MongoDB node will retrieve all documents from the specified collection and pass the dataset as JSON to the next node for processing. Data Formatting: *The retrieved documents are processed to adjust field names.* By default, MongoDB returns its unique identifier as _id. To align with common API conventions, this step renames _id → id. This small transformation simplifies downstream usage, making responses more intuitive for client applications. Response: *The cleaned dataset is returned as a structured JSON response to the original request.* The processed dataset is returned as the response to the original HTTP request. Clients receive a clean JSON payload with the expected format and renamed identifiers. Example response: [ { "id": "64f13c1e2f1a5e34d9b3e7f0", "name": "John Doe", "email": "john@example.com" }, { "id": "64f13c1e2f1a5e34d9b3e7f1", "name": "Jane Smith", "email": "jane@example.com" } ] Workflow Summary Webhook (GET) → Code (Validation) → IF (Validation Check) → MongoDB (Query) → Code (Transform IDs) → Respond to Webhook Key Benefits ✅ Security-first design: prevents unauthorized access or injection attacks. ✅ Standards compliance: uses HTTP status codes (400) for invalid requests. ✅ Clean API response: transforms MongoDB’s native _id into a more user-friendly id. ✅ Scalability: ready for integration with any frontend, third-party service, or analytics pipeline. An n8n automation workflow template by Samuel Heredia.

By Robert Breen

📖 Description Ask natural-language questions about your Pipedrive leads. This workflow pulls live lead data from Pipedrive and has OpenAI answer questions like “leads added this week”, “stuck leads by owner”, or “next activities due today.” Responses are grounded only in your Pipedrive data. ⚙️ Setup Instructions 1️⃣ Set Up OpenAI Connection Go to OpenAI Platform Navigate to OpenAI Billing Add funds to your billing account Copy your API key into the OpenAI credentials in n8n 2️⃣ Connect Pipedrive In Pipedrive → Personal preferences → API → copy your API token URL shortcut: https://{your-company}.pipedrive.com/settings/personal/api In n8n → Credentials → New → Pipedrive API Company domain: {your-company} (the subdomain in your Pipedrive URL) API Token: paste the token from step 1 → Save In the Pipedrive Tool node, select your Pipedrive credential and (optionally) set filters (e.g., owner, label, created time). 🗣️ Example Questions You Can Ask “Summarize leads added this week by owner.” “Which leads have no upcoming activity?” “Show overdue activities and who owns them.” “Top 10 leads by value that are still open.” “Leads created in the last 7 days with the label ‘Inbound’.” “What are the next actions due today?” “Which leads are stuck >14 days without updates?” “Give me a one-paragraph pipeline health summary.” 📬 Contact Need help extending this (e.g., posting summaries to Slack/Email or auto-creating activities)? 📧 robert@ynteractive.com 🔗 Robert Breen 🌐 ynteractive.com. An n8n automation workflow template by Robert Breen.

By Ronnie Craig

Healthcare Email Autoresponder - Daily Outreach 📧 A production-ready n8n workflow for automated healthcare email marketing with AI-powered personalization. 🎯 What This Workflow Does This automated email system sends daily personalized healthcare-themed emails to your contact list. Perfect for: Healthcare professionals building patient relationships Medical practices maintaining client engagement Wellness coaches staying connected with clients Health educators sharing daily motivation ✨ Key Features AI-Powered Personalization**: Uses OpenAI to customize each email with recipient's name Smart Rate Limiting**: Random 2-5 minute delays between emails to avoid spam filters Batch Processing**: Limits to 10 emails per run for better deliverability Email Tracking**: Updates Google Sheets to prevent duplicates and track progress Professional Templates**: Healthcare-themed content with customizable signatures Automated Scheduling**: Runs daily at 1 PM (customizable) 🛠️ Setup Instructions Prerequisites n8n instance (cloud or self-hosted) Gmail account for sending emails Google Sheets for contact management OpenAI API key Step 1: Import the Workflow Download the Healthcare_Email_Autoresponder_Community_Template.json file In n8n, go to Templates and click "Import from File" Select the downloaded JSON file The workflow will be imported as inactive Step 2: Configure Credentials Gmail OAuth2 Setup: Click on the "Send Email" node Create new Gmail OAuth2 credential Follow n8n's Gmail setup guide Test the connection Google Sheets Setup: Click on the "Healthcare_Contact_List" node Create new Google Sheets OAuth2 credential Replace YOUR_GOOGLE_SHEET_ID_HERE with your actual sheet ID Ensure your sheet has these columns: First Name Email Emailed (for tracking timestamps) OpenAI API Setup: Click on the "OpenAI Chat Model" node Create new OpenAI credential Add your OpenAI API key Select your preferred model (gpt-4o-mini recommended for cost efficiency) Step 3: Customize Your Email Template Click on the "AI Email Generator" node Edit the system message to include your details: Replace [YOUR NAME HERE] with your actual name Replace [YOUR TITLE HERE] with your professional title Replace [YOUR COMPANY HERE] with your company name Replace [YOUR PHONE NUMBER] with your phone number Replace [YOUR EMAIL] with your email address Replace [YOUR WEBSITE] with your website URL Step 4: Prepare Your Contact List Create a Google Sheet with the following structure: | First Name | Email | Emailed | |------------|-------------------|------------| | John | john@example.com | | | Jane | jane@example.com | | Important Notes: Leave the "Emailed" column empty initially The workflow will populate timestamps as emails are sent Only contacts with empty "Emailed" cells will receive emails Step 5: Test and Activate Test the workflow with a few sample contacts Check that emails are being generated and sent correctly Verify that Google Sheets is being updated with timestamps Once satisfied, activate the workflow 📊 Google Sheets Structure Your contact sheet should include these columns: First Name** (required): Used for personalization Email** (required): Recipient email address Emailed** (required): Timestamp tracking (leave empty initially) Optional columns you can add: Last Name Company Phone Notes ⚙️ Customization Options Change Email Frequency Edit the "Daily Trigger (1 PM)" node Modify the schedule (hourly, daily, weekly) Set preferred time zones Adjust Batch Size Edit the "Limit to 10 Contacts" node Change maxItems value (recommend staying under 50) Modify Wait Times Edit the "Random Wait (2-5min)" node Adjust the random delay formula Current: {{ Math.floor(Math.random() * 4) + 2 }} (2-5 minutes) Update Email Content Edit the system message in "AI Email Generator" node Change the joke, signature, or entire email structure Add seasonal content or special promotions 🔧 Troubleshooting Common Issues: Emails not sending Verify Gmail credentials are active Check email quota limits Ensure recipient emails are valid Google Sheets not updating Confirm sheet ID is correct Check column names match exactly Verify Google Sheets credentials AI not generating content Validate OpenAI API key Check API quota and billing Test with different model if needed Rate limiting issues Increase wait times between emails Reduce batch size Check Gmail sending limits 📈 Best Practices Start Small: Begin with 5-10 contacts to test deliverability Monitor Metrics: Track open rates and responses Respect Privacy: Include unsubscribe options Stay Relevant: Update content regularly Follow Regulations: Comply with CAN-SPAM and GDPR 🤝 Contributing to the Community This template is designed to be: Easy to understand**: Clear node names and documentation Production ready**: Includes error handling and rate limiting Customizable**: Template placeholders for personalization Well documented**: Comprehensive setup instructions Feel free to adapt this workflow for your specific healthcare niche! 📄 License This workflow template is provided free to the n8n community under MIT License. 🆘 Support For questions or issues: Check the n8n community forum Review n8n's official documentation Test each node individually to isolate problems Made with ❤️ for the n8n community. An n8n automation workflow template by Ronnie Craig.

By Ronnie Craig

AI Personal Assistant Telegram Bot Template Description Transform your Telegram into a powerful AI-powered personal assistant that manages your calendar, sends daily schedules, searches the web, and accesses your contacts - all through simple text messages. What This Template Does This workflow creates an intelligent Telegram bot that serves as your personal assistant, capable of: Daily Schedule Management**: Automatically checks your Google Calendar and emails you a formatted daily schedule summary Intelligent Conversations**: Uses OpenAI GPT-4o-mini with conversation memory for natural interactions Web Research**: Searches Wikipedia and the web using SerpAPI for any questions you have Contact Management**: Accesses your Google Sheets contact database to find email addresses and information Email Automation**: Sends emails on your behalf using Gmail integration Calendar Integration**: Reads and manages your Google Calendar events Target Users Busy Professionals** who need quick access to their schedule and want to automate daily planning Small Business Owners** who want an AI assistant for managing contacts and communications Personal Productivity Enthusiasts** who want to streamline their daily workflow Anyone** who prefers text-based interaction over switching between multiple apps Key Features ✅ Multi-Tool AI Agent: Combines Wikipedia, web search, calendar, email, and contacts in one interface ✅ Conversation Memory: Remembers context across multiple interactions ✅ Automatic Daily Scheduling: Proactive daily schedule emails ✅ Contact Intelligence: Automatically finds contact information before sending emails ✅ Telegram Integration: Works through the familiar Telegram interface Use Cases "What's on my schedule today?" → Receives formatted email with daily agenda "Send an email to John about the meeting" → Finds John's email and sends message "What's the weather in Paris?" → Gets current weather information via web search "Tell me about quantum computing" → Provides Wikipedia information "Schedule a meeting with Sarah tomorrow at 2 PM" → Creates calendar event Prerequisites Before setting up this template, you'll need accounts and API access for: Telegram Bot** (free via @BotFather) OpenAI API** (paid service) Google Calendar API** (free) Gmail API** (free) Google Sheets API** (free) SerpAPI** (freemium web search) Setup Instructions 1. Create Telegram Bot Message @BotFather on Telegram Use /newbot command and follow instructions Save your bot token for later 2. Set Up Google APIs Go to Google Cloud Console Create a new project or select existing Enable Google Calendar, Gmail, and Sheets APIs Create OAuth2 credentials Download credentials JSON file 3. Get API Keys OpenAI: Visit platform.openai.com, create API key SerpAPI: Sign up at serpapi.com, get API key 4. Configure Credentials in n8n Add Telegram Bot credentials using your bot token Set up Google OAuth2 for Calendar, Gmail, and Sheets Add OpenAI API credentials Add SerpAPI credentials 5. Customize the Workflow Update Calendar ID: Replace a________@gmail.com with your calendar Set Google Sheets ID: Replace the sheet ID with your contacts spreadsheet Modify System Message: Update the AI agent's instructions to match your preferences Adjust Memory Settings: Configure conversation memory window as needed 6. Test the Setup Activate the workflow Message your Telegram bot Verify all integrations are working Customization Options Change AI Model**: Switch between OpenAI models (GPT-3.5, GPT-4, etc.) Adjust Memory**: Modify conversation memory window length Add More Tools**: Integrate additional services like Notion, Slack, or weather APIs Modify Schedule**: Change when daily schedule emails are sent Customize Responses**: Update the system message to change assistant personality Important Notes Privacy**: This bot has access to your calendar, contacts, and email - ensure proper security API Costs**: OpenAI and SerpAPI usage will incur costs based on usage Rate Limits**: Be aware of API rate limits for each service Security**: Use environment variables for sensitive credentials Troubleshooting Bot not responding**: Check Telegram credentials and webhook configuration Calendar access issues**: Verify Google Calendar API permissions Email not sending**: Confirm Gmail API scopes include send permissions Memory not working**: Check that session keys are properly configured Support For issues with this template, check: n8n Community Forum Individual API service documentation Google Cloud Console for API errors OpenAI usage dashboard for model issues. An n8n automation workflow template by Ronnie Craig.

By Daniel Lianes

Auto-scrape Twitter accounts to WhatsApp groups This workflow provides automated access to real-time Twitter/X content through intelligent scraping and AI processing. It keeps you at the cutting edge of breaking news, emerging trends, and industry developments by eliminating the need to manually check multiple social media accounts and delivering curated updates directly to your communication channels. Overview This workflow automatically handles the complete Twitter monitoring process using advanced scraping techniques and AI analysis. It manages API authentication, multi-source data collection, intelligent content filtering, and message delivery with built-in error handling and rate limiting for reliable automation. Core Function: Real-time social media monitoring that transforms Twitter noise into actionable intelligence, ensuring you're always first to know about the latest trends, product launches, and industry shifts that shape your field. Key Capabilities Real-time trend detection** - Catch breaking news and emerging topics as they happen on X/Twitter Multi-source Twitter monitoring** - Track specific accounts AND trending keyword searches simultaneously AI-powered trend analysis** - Gemini 2.5 Pro filters noise and surfaces only the latest developments that matter Stay ahead of the curve** - Identify emerging technologies, viral discussions, and industry shifts before they go mainstream Flexible delivery options** - Pre-configured for WhatsApp, but easily adaptable for Telegram, Slack, Discord, or even blog content generation Rate limit protection** - Built-in delays and error handling using TwitterAPI.io's reliable, cost-effective infrastructure Tools Used n8n**: The automation platform orchestrating the entire workflow TwitterAPI.io**: Reliable access to Twitter/X data without API complexities OpenRouter**: Gateway to advanced AI models for content processing Gemini 2.5 Pro**: Google's latest AI for intelligent content analysis and formatting Evolution API**: WhatsApp Business API integration for message delivery Built-in Error Handling**: Automatic retry logic and comprehensive error management How to Install IMPORTANT: Before importing this workflow, you need to install the Evolution API community node: Install Community Node First: Go to Settings > Community Nodes in your n8n instance Add Evolution API: Install n8n-nodes-evolution-api package Restart n8n: Allow the new nodes to load properly Import the Workflow: Download the .json file and import it into your n8n instance Configure Twitter Access: Set up TwitterAPI.io credentials and add target accounts/keywords Set Up AI Processing: Add your OpenRouter API key for Gemini 2.5 Pro access Configure WhatsApp: Set up Evolution API and add your target group ID Test & Deploy: Run a test execution and schedule for daily operation Use Cases Stay Ahead of Breaking News**: Be the first to know about industry announcements, product launches, and major developments the moment they hit X/Twitter Spot Trends Before They Explode**: Identify emerging technologies, viral topics, and shifting conversations while they're still building momentum Competitive Intelligence**: Monitor what industry leaders, competitors, and influencers are discussing in real-time Brand Surveillance**: Track mentions, discussions, and sentiment around your brand as conversations develop Content Creation Pipeline**: Gather trending topics, viral discussions, and timely content ideas for blogs, newsletters, or social media strategy Market Research**: Collect real-time social sentiment and emerging market signals from X/Twitter conversations Multi-platform Distribution**: While configured for WhatsApp, the structured output can easily feed Telegram bots, Slack channels, Discord servers, or automated blog generation systems FIND YOUR WHATSAPP GROUPS The workflow includes a helper node to easily find your WhatsApp group IDs: Use the Fetch Groups node: The workflow includes a dedicated node that fetches all your available WhatsApp groups Run the helper: Execute just that node to see a list of all groups with their IDs Copy the group ID: Find your target group in the list and copy its ID Update the delivery node: Paste the group ID into the final WhatsApp sending node Group ID format: Always ends with @g.us (example: 120363419788967600@g.us) Pro tip: Test with a small private group first before deploying to your main team channels. Connect with Me LinkedIn**: https://www.linkedin.com/in/daniel-lianes/ Discovery Call**: https://cal.com/averis/asesoria Consulting Session**: https://cal.com/averis/consultoria-personalizada Was this helpful? Let me know! I truly hope this was helpful. Your feedback is very valuable and helps me create better resources. Want to take automation to the next level? If you're looking to optimize your business processes or need expert help with a project, here's how I can assist you: Advisory (Discovery Call): Do you have a process in your business that you'd like to automate but don't know where to start? In this initial call, we'll explore your needs and see if automation is the ideal solution for you. Schedule a Discovery Call Personalized Consulting (Paid Session): If you already have a specific problem, an integration challenge, or need hands-on help building a custom workflow, this session is for you. Together, we'll find a powerful solution for your case. Book Your Consulting Session Stay Up to Date For more tricks, ideas, and news about automation and AI, let's connect on LinkedIn! Follow me on LinkedIn #n8n #automation #twitter #whatsapp #ai #socialmedia #monitoring #intelligence #gemini #scraping #workflow #nocode #businessautomation #socialmonitoring #contentcuration #teamcommunication #brandmonitoring #trendanalysis #marketresearch #productivity. An n8n automation workflow template by Daniel Lianes.

By Omer Fayyaz

Efficient loop-less N8N Workflow Backup Automation to Google Drive This workflow eliminates traditional loop-based processing entirely, delivering unprecedented performance and reliability even when the number of workflows to be processed are large What Makes This Different: NO SplitInBatches node** - Traditional workflows use loops to process workflows one by one NO individual file uploads** - No more multiple Google Drive API calls NO batch error handling** - Eliminates complex loop iteration error management ALL workflows processed simultaneously** - Revolutionary single-operation approach Single compressed archive** - One ZIP file containing all workflows One Google Drive upload** - Maximum efficiency, minimum API usage Key Benefits of Non-Loop Architecture: 3-5x Faster Execution** - Eliminated loop overhead and multiple API calls Reduced API Costs** - Single upload instead of dozens of individual operations Higher Reliability** - Fewer failure points, centralized error handling Better Scalability** - Performance doesn't degrade with workflow count Large Workflow Support* - *Efficiently handles hundreds of workflows without performance degradation** Easier Maintenance** - Simpler workflow structure, easier debugging Cleaner Monitoring** - Single success/failure point instead of loop iterations Who's it for This template is designed for n8n users, DevOps engineers, system administrators, and IT professionals who need reliable, automated backup solutions for their n8n workflows. It's perfect for businesses and individuals who want to ensure their workflow automation investments are safely backed up with intelligent scheduling, compression, and cloud storage integration. How it works / What it does This workflow creates an intelligent, automated backup system that transforms n8n workflow backups from inefficient multi-file operations into streamlined single-archive automation. The system: Triggers automatically every 4 hours or manually on-demand Creates timestamped folders in Google Drive for organized backup storage Retrieves all n8n workflows via the n8n API in a single operation Converts workflows to JSON and aggregates binary data efficiently Compresses all workflows into a single ZIP archive (eliminating the need for loops) Uploads the compressed backup to Google Drive in one operation Provides real-time Slack notifications for monitoring and alerting Key Innovation: No Loops Required - Unlike traditional backup workflows that use SplitInBatches or loops to process workflows individually, this system processes all workflows simultaneously and creates a single compressed archive, dramatically improving performance and reliability. How to set up 1. Configure Google Drive API Credentials Set up Google Drive OAuth2 API credentials Ensure the service account has access to create folders and upload files Update the parent folder ID where backup folders will be created 2. Configure n8n API Access Set up internal n8n API credentials for workflow retrieval Ensure the API has permissions to read all workflows Configure retry settings for reliability 3. Set up Slack Notifications Configure Slack API credentials for the notification channel Update the channel ID where backup notifications will be sent Customize notification messages as needed 4. Schedule Configuration The workflow automatically runs every 4 hours Manual execution is available for immediate backups Adjust the schedule in the Schedule Trigger node as needed 5. Test the Integration Run a manual backup to verify all components work correctly Check Google Drive for the created backup folder and ZIP file Verify Slack notifications are received Requirements n8n instance** (self-hosted or cloud) with API access Google Drive account** with API access and sufficient storage Slack workspace** for notifications (optional but recommended) n8n workflows** that need regular backup protection How to customize the workflow Modify Backup Frequency Adjust the Schedule Trigger node for different intervals (hourly, daily, weekly) Add multiple schedule triggers for different backup types Implement conditional scheduling based on workflow changes Enhance Storage Strategy Add multiple Google Drive accounts for redundancy Implement backup rotation and retention policies Add compression options (ZIP, TAR, 7Z) for different use cases Expand Notification System Add email notifications for critical backup events Integrate with monitoring systems (PagerDuty, OpsGenie) Add backup success/failure metrics and reporting Security Enhancements Implement backup encryption before upload Add backup verification and integrity checks Set up access logging and audit trails Performance Optimizations Add parallel processing for large workflow collections Implement incremental backup strategies Add backup size monitoring and alerts Key Features Zero-loop architecture** - Processes all workflows simultaneously without batch processing Intelligent compression** - Single ZIP archive instead of multiple individual files Automated scheduling** - Runs every 4 hours with manual override capability Organized storage** - Timestamped folders with clear naming conventions Real-time monitoring** - Slack notifications for all backup events Error handling** - Centralized error management with graceful failure handling Scalable design** - Handles any number of workflows efficiently Technical Architecture Highlights Eliminated Inefficiencies No SplitInBatches node** - Replaced with direct workflow processing No individual file uploads** - Single compressed archive upload No loop iterations** - All workflows processed in one operation No batch error handling** - Centralized error management Performance Improvements Faster execution** - Eliminated loop overhead and multiple API calls Reduced API quota usage** - Single Google Drive upload per backup Better resource utilization** - Efficient memory and processing usage Improved reliability** - Fewer points of failure in the workflow Data Flow Optimization Parallel processing** - Folder creation and workflow retrieval happen simultaneously Efficient aggregation** - Code node processes all binaries at once Smart compression** - Single ZIP with all workflows included Streamlined upload** - One file transfer instead of multiple operations Use Cases Production n8n instances** requiring reliable backup protection Development teams** needing workflow version control and recovery DevOps automation** requiring disaster recovery capabilities Business continuity** planning for critical automation workflows Compliance requirements** for workflow documentation and backup Team collaboration** with shared workflow backup access Business Value Risk Mitigation** - Protects valuable automation investments Operational Efficiency** - Faster, more reliable backup processes Cost Reduction** - Lower storage costs and API usage Compliance Support** - Organized backup records for audits Team Productivity** - Reduced backup management overhead Scalability** - Handles growth without performance degradation This template revolutionizes n8n workflow backup by eliminating the complexity and inefficiency of traditional loop-based approaches, providing a robust, scalable solution that grows with your automation needs while maintaining the highest levels of reliability and performance. An n8n automation workflow template by Omer Fayyaz.

By Alexandra Spalato

Short Description This LinkedIn automation workflow monitors post comments for specific trigger words and automatically sends direct messages with lead magnets to engaged users. The system checks connection status, handles non-connected users with connection requests, and prevents duplicate outreach by tracking all interactions in a database. Key Features Comment Monitoring**: Scans LinkedIn post comments for customizable trigger words Connection Status Check**: Determines if users are 1st-degree connections Automated DMs**: Sends personalized messages with lead magnet links to connected users Connection Requests**: Asks non-connected users to connect via comment replies Duplicate Prevention**: Tracks interactions in NocoDB to avoid repeat messages Message Rotation**: Uses different comment reply variations for authenticity Batch Processing**: Handles multiple comments with built-in delays Who This Workflow Is For Content creators looking to convert post engagement into leads Coaches and consultants sharing valuable LinkedIn content Anyone wanting to automate lead capture from LinkedIn posts How It Works Setup: Configure post ID, trigger word, and lead magnet link via form Comment Extraction: Retrieves all comments from the specified post using Unipile Trigger Detection: Filters comments containing the specified trigger word Connection Check: Determines if commenters are 1st-degree connections Smart Routing: Connected users receive DMs, others get connection requests Database Logging: Records all interactions to prevent duplicates Setup Requirements Required Credentials Unipile API Key**: For LinkedIn API access NocoDB API Token**: For database tracking Database Structure **Table: leads linkedin_id: LinkedIn user ID name: User's full name headline: LinkedIn headline url: Profile URL date: Interaction date posts_id: Post reference connection_status: Network distance dm_status: Interaction type (sent/connection request) Customization Options Message Templates**: Modify DM and connection request messages Trigger Words**: Change the words that activate the workflow Timing**: Adjust delays between messages (8-12 seconds default) Reply Variations**: Add more comment reply options for authenticity Installation Instructions Import the workflow into your n8n instance Set up NocoDB database with required table structure Configure Unipile and NocoDB credentials Set environment variables for Unipile root URL and LinkedIn account ID Test with a sample post before full use. An n8n automation workflow template by Alexandra Spalato.

By Milan Vasarhelyi - SmoothWork

Video Introduction Want to automate your inbox or need a custom workflow? 📞 Book a Call | 💬 DM me on Linkedin Overview This workflow automatically exports customer balance data from QuickBooks to Google Sheets on a monthly basis. It eliminates manual data entry and creates a historical record of customer balances that updates automatically, making it easy to track payment trends, identify outstanding balances, and monitor customer financial health over time. Key Features Automated Monthly Reporting**: Runs on the first day of each month to capture a snapshot of all customer balances Clean Data Structure**: Extracts only the essential fields (Customer ID, Balance, Email, and Period) for easy analysis Historical Tracking**: Each monthly run appends new data to your Google Sheet, building a timeline of customer balances No Manual Work**: Once configured, the workflow runs completely hands-free Common Use Cases Track customer payment patterns and identify accounts with growing balances Create monthly reports for management or finance teams Build dashboards and visualizations from historical QuickBooks data Monitor customer account health without logging into QuickBooks Setup Requirements QuickBooks Developer Account: Register at developer.intuit.com and create a new app in the App Dashboard. Select the 'Accounting' scope for permissions. You'll receive a Client ID and Client Secret to configure your n8n credentials. Credentials: Set up QuickBooks OAuth2 credentials in n8n using your app's Client ID and Client Secret. Use 'Sandbox' environment for testing or 'Production' for live data (requires Intuit app approval). Also connect your Google Sheets account. Google Sheet: Create a spreadsheet with column headers matching the workflow output: Period, Id, Balance, and Email. Configuration Schedule**: The workflow runs monthly on the first day at 8 AM. Modify the Schedule Trigger to change timing or frequency Spreadsheet URL**: Update the 'Export to Google Sheets' node with your destination spreadsheet URL Data Fields**: Customize the 'Prepare Customer Data' node to extract different customer fields if needed. An n8n automation workflow template by Milan Vasarhelyi - SmoothWork.

By Milan Vasarhelyi - SmoothWork

Video Introduction Want to automate your inbox or need a custom workflow? 📞 Book a Call | 💬 DM me on Linkedin Workflow Overview This workflow creates a recipe finder web application that connects to the API Ninjas Recipe API using n8n's HTTP Request node. Users submit search queries through a public web form, which triggers an API call to fetch matching recipes. The results—including recipe title, ingredients, and cooking instructions—are displayed in a formatted completion page. Why This Workflow Is Valuable This template demonstrates API-to-API integration, a crucial skill for connecting services that don't have pre-built n8n nodes. By using direct API calls, you gain access to the full functionality of external services. This pattern can be adapted to integrate virtually any tool with an API into your n8n workflows. Common Use Cases Create public-facing forms that query external databases Build custom search tools for specialized APIs Integrate niche services without dedicated n8n nodes Learn header authentication for secure API connections Setup & Configuration Register for API Ninjas: Sign up at API Ninjas to access their Recipe API Get your API Key: Locate your API key in the API Ninjas dashboard Configure Credentials: In n8n, create a new Header Auth credential Set the header name to match the API requirement (e.g., 'X-Api-Key') Paste your API key as the value Apply this credential to the HTTP Request node The Form Trigger generates a public URL for users to submit queries. Customize the form title, field labels, and completion message HTML to match your needs. An n8n automation workflow template by Milan Vasarhelyi - SmoothWork.

By Ninja - Abbas

Overview This workflow automates quiz delivery from a Google Sheet directly into a Telegram group. It ensures that quizzes are posted one by one as polls, and once a quiz is sent, its status in the sheet is automatically updated to prevent duplication. If no pending quiz is available, the workflow notifies a separate Telegram channel to refill the sheet. Target Audience This template is designed for teachers, community managers, and Telegram group admins who want an easy way to run quizzes, trivia games, or knowledge checks without manual posting. Problem It Solves Manually sending quizzes is repetitive and prone to mistakes (like re-posting the same question). This template ensures quizzes are sent in order, tracked, and managed automatically with minimal human effort. Requirements An active Google account with Google Sheets enabled A Telegram bot token (via BotFather) Chat IDs for both the quiz group and the notification group Google Sheet Structure Create a sheet with the following columns: quiz_number | question | option_a | option_b | option_c | option_d | status status**: Use 🟨 for pending quizzes, ✅ once completed Setup Instructions Copy the workflow into your n8n instance. Add your Google Sheets credentials. Replace the YOUR_SHEET_ID placeholder with your sheet ID. Set environment variables: TELEGRAM_BOT_TOKEN TELEGRAM_CHAT_ID (for the group) TELEGRAM_NOTIFY_CHAT_ID (for refill notifications) Run the workflow. Customization Options Adjust the sheet name if not using “Sheet1” Change emoji markers (🟨 / ✅) to your preferred system Modify the Telegram notification message. An n8n automation workflow template by Ninja - Abbas.

By Oussama

Production-ready solution for controlling AI agent usage and preventing abuse while managing costs. 🎯 Problem Solved Unlimited AI interactions → Excessive API costs Service abuse → Uncontrolled resource consumption No built-in limits → Need for usage quotas ✅ Solution Overview Two-Part System: Main Flow: User interaction tracking + AI responses Reset Flow: Automated counter resets 🔄 How It Works User Message → Track Counter → Check Limit → Allow/Block → AI Response 🛠️ Core Components Main Workflow 📱 Telegram Trigger - Receives user messages 📊 Google Sheets Counter - Tracks messages per user 🔀 Switch Logic - Checks limits (default: 3 messages) 🤖 AI Agent - Processes allowed interactions 💬 Smart Responses - Delivers AI answers or limit warnings Auto-Reset System ⏰ Schedule Trigger - Runs every configurable interval 🔄 Bulk Counter Reset - Resets all users to 0 ⚙️ Configuration Message Limits Modify Switch Node conditions: > 3 messages → Block silently = 3 messages → Send limit warning < 3 messages → Allow AI response Reset Schedules Testing: Every 1 minute Hourly: 0 * * * * Daily: 0 0 * * * Weekly: 0 0 * * 0 📋 Setup Requirements Credentials Needed: 🤖 Telegram Bot Token 📊 Google Sheets API 🧠 AI Model *Google Sheets Structure: *Column A: User ID (Telegram chat.id) Column B: Message Counter 🎯 Perfect For 💰 Cost Control - Prevent runaway API costs 🛡️ Demo/Trial Bots - Limited interactions 🏢 Customer Service - Usage quotas 🎓 Educational Bots - Daily limits 🚫 Anti-Abuse - Fair usage policies 🚀 Key Benefits ✅ Cost Management - Control AI API expenses ✅ Fair Access - Equal usage for all users ✅ Production Ready - Robust error handling ✅ Flexible Limits - Easy adjustment ✅ Auto-Reset - No manual intervention ✅ User-Friendly - Clear limit messages 📝 Quick Customization Adjust Limits: Change Switch node values Reset Timing: Modify Schedule Trigger Custom Messages: Edit Telegram response nodes User Tiers: Add columns to Google Sheets. An n8n automation workflow template by Oussama.

By Max aka Mosheh

How it works • Webhook triggers from content creation system in Airtable • Downloads media (images/videos) from Airtable URLs • Uploads media to Postiz cloud storage • Schedules or publishes content across multiple platforms via Postiz API • Tracks publishing status back to Airtable for reporting Set up steps • Sign up for Postiz account at https://postiz.com/?ref=max • Connect your social media channels in Postiz dashboard • Get channel IDs and API key from Postiz settings • Add Postiz API key to n8n credentials (Header Auth) • Update channel IDs in "Prepare for Publish" node • Connect Airtable with your content database • Customize scheduling times per platform as needed • Full setup details in workflow sticky notes. An n8n automation workflow template by Max aka Mosheh.

By Tamer

🚀 AI Website Generator & Auto-Deployer Template Transform any idea into a live website in seconds! This AI-powered template generates professional, fully-functional websites from simple text descriptions and automatically deploys them to Netlify. ✨ What You Get Instant Website Creation: Just provide a name and description - our AI agent creates complete HTML files with embedded CSS/JavaScript, ready for immediate deployment. Professional Quality: Every website includes mobile-responsive design, modern CSS Grid/Flexbox layouts, SEO optimization, accessibility features, and smooth animations. No amateur-looking sites - only professional results. Zero-Config Deployment: Automatic Netlify deployment with SSL certificates, CDN distribution, and custom URLs. No technical setup required. 🛠️ AI-Powered Features Smart Content Generation**: Creates contextual, industry-appropriate content (no Lorem Ipsum) Adaptive Design**: Automatically detects website type (portfolio, business, landing page) and adapts accordingly Modern Tech Stack**: HTML5, CSS3 with variables, ES6+ JavaScript, cross-browser compatibility 💼 Perfect For Digital Agencies**: Rapid client prototyping and proposals Freelancers**: Quick turnaround projects Startups**: MVP landing pages Small Businesses**: Professional web presence without coding Marketers**: Campaign landing pages Designers**: Convert concepts to functional prototypes 🔧 Setup Requirements Required API Keys: Netlify Personal Access Token - Enables automatic deployment and domain management Gemini API Key - Powers AI content generation (alternatives: OpenAI GPT, Claude) Airtable Token (Optional) - Project tracking and analytics ⚡ Lightning-Fast Workflow Input project name and description AI generates complete website (under 30 seconds) Automatic quality validation Live deployment to Netlify Optional dashboard tracking 📈 Business Impact 95% time reduction** in development Eliminate coding hours** - focus on strategy Handle multiple projects** simultaneously Consistent quality** across all websites Impress clients** with rapid turnaround 💡 Real Examples "Modern UX designer portfolio" → Clean design with project galleries "Local bakery website with menu" → Appetizing layout with image galleries "SaaS product landing page" → Conversion-focused with pricing tables "Tech conference site" → Event layout with speaker bios and schedules Transform your web development workflow today!. An n8n automation workflow template by Tamer.

By Alberto

Title: Create a Privacy-Focused AI Assistant with Telegram, Ollama, and Whisper PersonalAssistant is a fully-local, intelligent AI agent that assists you with daily tasks through voice or text interaction via Telegram. It is designed for users who want the convenience of a smart assistant without sacrificing privacy or relying on paid APIs or cloud infrastructure. Prerequisites Before you begin, ensure you have the following set up: n8n Instance: A running instance of n8n. Telegram Bot: A Telegram bot created with a valid API token. You can create one by talking to the BotFather. Ollama: Ollama running locally with a downloaded language model (e.g., llama3.2:1b). Whisper ASR API: A local API endpoint for audio transcription using a Whisper model. This workflow is pre-configured for an endpoint at http://localhost:9000/asr. What It Can Do Respond to general questions: Get answers about weather, facts, reminders, and more. Handle tasks: Create and manage to-do lists. Provide inspiration: Get motivational quotes or affirmations. Journaling assistant: Use prompts to support mental clarity. Speech-to-Text: Convert Telegram voice messages into text for the AI to process. How It Works Input Handling (Text or Voice): The workflow triggers when you send a voice note or text message to your Telegram bot. Authorization: It first checks if the message is from an authorized Telegram User ID. Routing: A switch directs the workflow based on the message type. Text messages go directly to the AI, while voice messages are first sent for transcription. Transcription: Voice messages are sent to your local Whisper ASR API to be converted into text. LLM Reasoning: The text is processed by a local language model (like LLaMA 3.2) via Ollama, which generates a smart response. Telegram Response: The final answer is sent back to you as a text message in Telegram. Setup Instructions Configure Telegram Credentials: In the Telegram Trigger node, select your Telegram API credentials from the dropdown menu. Do the same for all other Telegram nodes in the workflow. Set Your User ID: In the Authorization Check If node, you must set your personal Telegram User ID to allow access. Click on the node. In the "Value 2" field, enter your numeric Telegram User ID. Tip: You can find your ID by sending a message to a bot like @userinfobot. Configure Whisper API URL: If your Whisper ASR service is running on a different URL, update the Whisper ASR HTTP Request node. Click on the node. Change the URL from http://localhost:9000/asr to your endpoint. Configure the Ollama Model: In the Ollama Chat Model node, select your Ollama credentials and specify the model you wish to use (e.g., llama3.2:1b). Activate Workflow: Save and activate the workflow. You can now send messages to your bot! Customization Change the AI Persona: Modify the prompt in the AI Agent node to change the assistant's personality, tone, or instructions. Use a Different AI Model: Simply change the model name in the Ollama Chat Model node to experiment with different local LLMs. Adjust Memory: In the Simple Memory node, you can change the Context Window Length to control how many past conversations the AI remembers. Add More Tools: Expand the workflow by connecting the AI Agent to other nodes like a calendar, a to-do list app, or a web search tool. Privacy-First by Design All data processing—including speech recognition, reasoning, and generation—happens entirely offline on your local machine. No voice recordings are sent to cloud servers. No chat data leaves your device. Operates even without an internet connection (once set up). An n8n automation workflow template by Alberto.

By Alberto

Daily AI News Digest with RSS, Llama 3.2 Summarization & Telegram Delivery AIDailyNews is an intelligent, privacy-focused agent that automatically collects, summarizes, and delivers daily news updates to your Telegram via local AI processing. It is designed to run entirely offline on devices like the Raspberry Pi 5, using no paid APIs or external cloud services. Prerequisites Before you begin, ensure you have the following set up: n8n Instance: A running instance of n8n. Local LLM Server (Ollama): This workflow requires Ollama to be running locally with a downloaded language model (e.g., llama3.2:1b). It's designed for deployment on a home server or a device like a Raspberry Pi 5. Telegram Bot: You need a Telegram bot with its API token. You can create one by talking to the BotFather. Telegram Chat ID: You'll need the numeric ID of the user or group chat where the news digest will be sent. How It Works Scheduled Trigger: The workflow runs automatically on a daily schedule. News Collection: It fetches the latest articles from multiple pre-configured RSS feeds. Filtering: It filters the articles to keep only those published on the previous day, ensuring you get a daily recap. Local Summarization: Each article's content is sent to your local Ollama instance. A large language model (LLM) like LLaMA 3.2 processes the text and generates a concise summary. Formatting & Delivery: The summarized news, along with the title, author, and link, is formatted into a clean message and sent to your specified Telegram chat. Setup Instructions Configure the Schedule: The workflow is set to run daily by default. If you wish to change the time or frequency, adjust the settings in the Schedule Trigger node. Add Your RSS Feeds: You can customize your news sources by modifying the RSS Read nodes. Change the URLs to your favorite feeds, or add/remove nodes to adjust the number of sources. Configure the Ollama Model: Click on the Ollama Model node. Select your Ollama API credentials from the dropdown. In the "Model" field, ensure the model name matches one that you have downloaded in Ollama (e.g., llama3.2:1b). Configure the Telegram Node: Click on the Send News Digest to Telegram node. Select your Telegram API credentials. In the Chat ID field, enter the numeric ID of the user or group you want to send the news to. (Tip: You can get this ID by sending a message to a bot like @userinfobot.) Activate Workflow: Save your changes and activate the workflow. You will now receive a daily news digest in your Telegram chat. Customization Change the Summary Style: Modify the prompt in the Summarize Article with Ollama node to change how the news is summarized. For example, you could ask for a single-paragraph summary instead of bullet points. Adjust Message Format: Edit the Text field in the Send News Digest to Telegram node to change the layout of the final message. You can use HTML for formatting like bold or italics. An n8n automation workflow template by Alberto.

By Avkash Kakdiya

How it works This workflow automates LinkedIn community engagement by monitoring post comments, filtering new ones, generating AI-powered replies, and posting responses directly on LinkedIn. It also logs all interactions into Google Sheets for tracking and analytics. Step-by-step Trigger & Fetch A Schedule Trigger runs the workflow every 10 minutes. The workflow fetches the latest comments on a specific LinkedIn post using LinkedIn’s API with token-based authentication. Filter for New Comments Retrieves the timestamp of the last processed comment from Google Sheets. Filters out previously handled comments, ensuring only fresh interactions are processed. AI-Powered Reply Generation Sends the new comment to OpenAI GPT-3.5 Turbo with a structured prompt. AI generates a professional, concise, and engaging LinkedIn-appropriate reply (max 2–3 sentences). Post Back to LinkedIn Automatically posts the AI-generated reply under the original comment thread. Maintains consistent formatting and actor identity. Data Logging Appends the original comment, AI response, and metadata into Google Sheets. Enables tracking, review, and future engagement analysis. Benefits Saves time by automating LinkedIn comment replies. Ensures responses are timely, professional, and on-brand. Maintains authentic engagement without manual effort. Prevents duplicate replies by filtering with timestamps. Creates a structured log in Google Sheets for auditing and analytics. An n8n automation workflow template by Avkash Kakdiya.

By Anoop

Query personal finance data in Notion via Telegram and WhatsApp Who’s it for This workflow is for individuals who track their finances in Notion and want quick answers via chat. Entrepreneurs, freelancers, and professionals can use it to check expenses, income, or budgets instantly without opening Notion. How it works The workflow acts as an Accountant Agent powered by Claude AI through OpenRouter. When you send a query like “Total expenses for August 2025” through Telegram or WhatsApp, the agent identifies the right Notion database, applies filters, and retrieves the requested data. It then replies with a summarized result directly to your phone. How to set up Clone the Personal Finance System Notion template into your workspace. Create a Telegram bot with BotFather and collect the bot token and chat ID. Get an API key from OpenRouter. Create a Notion integration token and connect it with your duplicated finance template. Set up WhatsApp Business credentials via Meta (WABA ID, Phone Number ID, and permanent access token). Requirements n8n instance (self-hosted or cloud) Accounts on Telegram, OpenRouter, Notion, and WhatsApp Business Your duplicated Personal Finance System Notion template How to customize the workflow You can extend the workflow to handle assets, liabilities, or budgets. Add more Notion databases, adjust query filters, or configure WhatsApp templates for automated financial updates. An n8n automation workflow template by Anoop.

By Roshan Ramani

Who's it for This template is designed for professionals, entrepreneurs, and busy individuals who receive high volumes of emails and want to automate their email management. Perfect for freelancers, small business owners, project managers, and anyone who struggles with email overload and wants AI-powered assistance for prioritizing and responding to messages. How it works The workflow creates an intelligent email processing system that monitors your Gmail inbox in real-time and categorizes every incoming email using Google Gemini AI. Here's what happens: Real-time Processing: Every minute, the system checks for new emails and uses AI to classify them into three categories: Category 0 (Needs Reply)**: Questions, meeting requests, urgent business matters Category 1 (Important Notifications)**: Bills, confirmations, system alerts, order updates Category 2 (Spam/Unimportant)**: Marketing emails, newsletters, promotional content Smart Response Generation: For emails requiring replies, AI generates professional responses and sends them to your Telegram for approval. Once approved, the reply is automatically sent from your Gmail account. Instant Notifications: Important emails get summarized and sent as quick Telegram notifications so you stay informed without checking email constantly. Daily Email Digest: Every morning at 8 AM, you receive a comprehensive summary of the previous day's emails, including action items, issues requiring attention, and follow-up tasks. How to set up Step 1: Gmail Configuration Connect your Gmail account using OAuth2 authentication Ensure Gmail API access is enabled in your Google Cloud Console Step 2: Telegram Setup Create a new Telegram bot using @BotFather Get your bot token and personal chat ID Configure the Telegram credentials in n8n Step 3: AI Configuration Set up Google Cloud account with Gemini API access Create API credentials for Google Palm/Gemini Add the credentials to your n8n instance Step 4: Workflow Customization Update all Telegram chat IDs with your personal chat ID Configure the daily trigger schedule according to your timezone Test the workflow with sample emails Requirements Gmail account** with API access enabled Telegram bot** and personal chat ID Google Cloud account** with Gemini API access n8n instance** (self-hosted or cloud) All sensitive information like API keys, chat IDs, and email addresses should be configured using n8n's credential system rather than hardcoding them in the workflow. How to customize the workflow Modify Classification Logic Edit the AI Email Classifier node's system prompt to adjust how emails are categorized based on your specific industry or email patterns. Adjust Scheduling Change the Daily 8AM Trigger to your preferred time zone and schedule for receiving email summaries. Personalize Response Style Customize the AI reply generator's system prompt to match your communication style, tone, and professional voice. Enhance Filtering Add additional filtering logic to process emails from specific senders, domains, or with particular keywords differently. Extend Notifications Configure multiple Telegram chats for different types of notifications (personal vs work) or add other messaging platforms. Security Best Practices Use n8n environment variables for sensitive configuration Store all credentials securely using n8n's credential management Avoid hardcoding personal information in node parameters Test thoroughly in a development environment before production use The workflow is designed to be flexible and easily adaptable to different email management needs while maintaining security and privacy standards. An n8n automation workflow template by Roshan Ramani.

By Lidia

Who’s it for Teams who want to automatically generate structured meeting minutes from uploaded transcripts and instantly share them in Slack. Perfect for startups, project teams, or any company that collects meeting transcripts in Google Drive. How it works / What it does This workflow automatically turns raw meeting transcripts into well-structured minutes in Markdown and posts them to Slack: Google Drive Trigger – Watches a specific folder. Any new transcript file added will start the workflow. Download File – Grabs the transcript. Prep Transcript – Converts the file into plain text and passes the transcript downstream. Message a Model – Sends the transcript to OpenAI GPT for summarization using a structured system prompt (action items, decisions, N/A placeholders). Make Minutes – Formats GPT’s response into a Markdown file. Slack: Send a message – Posts a Slack message announcing the auto-generated minutes. Slack: Upload a file – Uploads the full Markdown minutes file into the chosen Slack channel. End result: your Slack channel always has clear, standardized minutes right after a meeting. How to set up Google Drive Create a folder where you’ll drop transcript files. Configure the folder ID in the Google Drive Trigger node. OpenAI Add your OpenAI API credentials in the Message a Model node. Select a supported GPT model (e.g., gpt-4o-mini or gpt-4). Slack Connect your Slack account and set the target channel ID in the Slack nodes. Run the workflow and drop a transcript file into Drive. Minutes will appear in Slack automatically. Requirements Google Drive account (for transcript upload) OpenAI API key (for text summarization) Slack workspace (for message posting and file upload) How to customize the workflow Change summary structure*: Adjust the system prompt inside *Message a Model (e.g., shorter summaries, language other than English). Different output format*: Modify *Make Minutes to output plain text, PDF, or HTML instead of Markdown. New destinations**: Add more nodes to send minutes to email, Notion, or Confluence in parallel. Multiple triggers**: Replace Google Drive trigger with Webhook if you want to integrate with Zoom or MS Teams transcript exports. Good to know OpenAI API calls are billed separately. See OpenAI pricing. Files must be text-based (.txt or .md). For PDFs or docs, add a conversion step before summarization. Slack requires the bot user to be a member of the target channel, otherwise you’ll see a not_in_channel error. An n8n automation workflow template by Lidia.

By Guillaume Duvernay

Quick overview Automatically backs up every new version of your n8n workflows to Airtable on a schedule, then uses AI to generate a plain-English summary of each workflow and a one-sentence changelog of what changed since the last snapshot. How it works A Schedule Trigger runs the workflow at the frequency you set (for example, daily), starting with the Get all n8n workflows node, which fetches every workflow from your n8n instance via the n8n API. In parallel, Search all existing snapshots reads all previously stored version IDs from the Snapshots table in Airtable, and Match snapshot IDs (Merge, keepNonMatches) compares them against the current version ID of each workflow to isolate only the workflows with a new, unsaved version. Only keep new snapshots filters out any leftover items without a version ID before looping through the results with Loop Over Items. For each new version, Create or update workflow upserts a record in the Workflows table (matching on Workflow ID), setting the workflow name and creation time. Search all snapshots then retrieves the past snapshot count for that workflow, and the Check workflow status Code node decides whether the AI summary needs to be regenerated (on the 1st, 2nd, and every 5th snapshot). If a previous snapshot exists, Download previous snapshot and Extract from File1 pull the last stored .json backup from Airtable, and Document workflow differences (an OpenAI-backed LangChain chain, via OpenAI Chat Model1) compares it to the current workflow JSON to produce a one-sentence changelog. If it's the very first snapshot, State that this is the first version sets a fixed N/A - First identified version note instead. When Needs new workflow summary? is true, Re-summarise workflow calls the same AI model to generate a fresh, one-sentence description of the whole workflow's purpose, which Store new workflow summary saves back to the Workflows table's AI summary field. Store new snapshot* creates the new Snapshots record (version ID, update time, changelog, linked Workflow), then Get full workflow JSON, Move Binary Data, and Extract from File convert the full workflow JSON into a binary file. Store workflow file into Airtable (HTTP Request to the Airtable content API) uploads that file as an attachment to the snapshot's Workflow_file field, and a Wait node pauses 3 seconds before the loop continues, to stay under Airtable's API rate limits. Setup Duplicate the Airtable base template (linked in the workflow's sticky note) into your own Airtable account. It contains the two required tables: Workflows (workflow name, AI summary, linked snapshots) and Snapshots (n8n version ID, update time, AI changelog, Workflow_file attachment). Add your n8n API credentials to the Get all n8n workflows, Get full workflow JSON, and Create or update workflow (n8n node type) nodes so the workflow can list and read your instance's workflows. Add your Airtable credentials to all Airtable nodes (Search all existing snapshots, Search all snapshots, Create or update workflow, Download previous snapshot, Store new workflow summary, Store new snapshot) and remap each node's base and table to the base you just duplicated. Add an OpenAI (or compatible) credential to the OpenAI Chat Model1 node, which powers both the Document workflow differences and Re-summarise workflow AI chains. It defaults to gpt-4.1-nano; swap the model if you need higher quality summaries. In the Store workflow file into Airtable HTTP Request node, replace ` in the URL with your duplicated base's ID (starts with "app...", found in the base's Airtable URL). This node also needs an Airtable Token API credential (nodeCredentialType airtableTokenApi`) with attachment upload permission. Set your desired frequency on the Schedule Trigger node (for example, once daily) and activate the workflow. Requirements An n8n instance reachable via the n8n API (with an API key credential). An Airtable account with a base duplicated from the provided template, plus an Airtable API/token credential. An OpenAI (or compatible) API credential for the two AI summary/changelog steps. Customization Add a Slack or Email node at the end of the run to notify your team which workflows were backed up. Swap Airtable for Google Drive, Dropbox, Google Sheets, or Notion by adapting the storage and metadata nodes to those services. Edit the Check workflow status Code node's logic to change how often the full AI summary is regenerated (currently: 1st, 2nd, and every 5th snapshot), to control AI token usage. Additional info Duplicate the reference Airtable base before running this workflow: https://airtable.com/appPFFj6CUUhZyDPT/shrorM8k6HsUqBACB. The workflow uses Airtable's content upload API endpoint to store the workflow JSON as a file attachment directly from base64 data, avoiding a separate Drive/Dropbox upload step. An n8n automation workflow template by Guillaume Duvernay.

By Robert Breen

This workflow fetches recent emails from Outlook and uses OpenAI to assign a category (e.g., Red, Yellow, Green). It then updates each message’s category in Outlook. ⚙️ Setup Instructions 1️⃣ Set Up Outlook Connection In n8n → Credentials → New → Microsoft Outlook OAuth2 API Log in with your Outlook account & approve access Attach this credential to the Get Messages from Outlook and Update Category nodes in the workflow (Optional) Adjust the limit field in Get Messages from Outlook if you want more/less than 5 results 2️⃣ Set Up OpenAI Connection Go to the OpenAI Platform Navigate to OpenAI Billing Add funds to your billing account Copy your API key into the OpenAI credentials in n8n and select it on the OpenAI Chat Model and Categorizing Agent nodes ✅ Notes The agent reads subject + bodyPreview and returns a JSON category. The Update Category node writes that category back to Outlook. You can tweak the category names or logic in the Categorizing Agent system message. 📬 Contact Need help customizing the categorization rules or routing categories to folders? 📧 robert@ynteractive.com 🔗 Robert Breen 🌐 ynteractive.com. An n8n automation workflow template by Robert Breen.

By Robert Breen

This workflow lets you chat with Reddit using OpenAI and the Reddit API. The chatbot pulls posts from a subreddit and uses GPT to answer your questions. ⚙️ Setup Instructions 2️⃣ Set Up OpenAI Connection Go to OpenAI Platform Navigate to OpenAI Billing Add funds to your billing account Copy your API key into the OpenAI credentials in n8n 2️⃣ Set Up Reddit API Go to Reddit Apps Click Create App → Choose script type Fill in: Name: (your choice) Redirect URI: http://localhost:8080 (or your n8n URL) Save → copy Client ID and Secret In n8n → Credentials → New → Reddit OAuth2 API Enter Client ID + Client Secret Log in with your Reddit account and approve access Attach this credential to the Reddit Tool node 🧠 How It Works Reddit Tool Node** → Fetches posts from chosen subreddit (e.g., r/n8n) OpenAI Agent** → Processes posts and your chat question Chatbot** → Returns summarized answers with Reddit context 📬 Contact Need help customizing this (e.g., targeting multiple subreddits or filtering posts)? 📧 robert@ynteractive.com 🔗 Robert Breen 🌐 ynteractive.com. An n8n automation workflow template by Robert Breen.

By Paul

AI-Powered Customer Service Automation with Smart Routing How it works Core Intelligence Pipeline • Multi-Layer Message Analysis - Every customer interaction passes through three specialized AI classifiers: privacy detection (identifies sensitive data and security requirements), intent recognition (categorizes requests as purchases, inquiries, complaints, technical support, or order tracking), and sentiment analysis (monitors emotional tone from neutral to critical frustration levels) • Dynamic Knowledge Integration - The system maintains live connections to your company's knowledge base and order management systems, automatically querying relevant information before crafting responses. This ensures accuracy and eliminates outdated information while providing real-time order status updates • Conversational Memory & Context - Advanced chat memory preserves conversation history across sessions, enabling the AI to maintain context, avoid repetitive responses, and build on previous interactions for more natural, human-like conversations • Intelligent Response Generation - The AI agent synthesizes information from multiple sources (knowledge base, order systems, conversation history) while adapting its tone and approach based on detected customer sentiment and privacy requirements Smart Escalation System • Automated Triage Classification - A sophisticated routing engine categorizes each interaction into four escalation levels: Normal (AI-handled routine inquiries), Human Request (explicit agent requests), Critical Complaint (serious issues requiring immediate attention), and Owner Escalation (extreme situations with legal implications or persistent anger) • Context-Aware Handoffs - When escalation is required, the system automatically generates comprehensive situation summaries for human agents, including conversation history, customer sentiment analysis, and specific issue classification • Multi-Channel Notifications - Escalated cases trigger appropriate alerts via email to designated team members based on severity level, ensuring proper resource allocation and response times Data Intelligence & Analytics • Comprehensive Interaction Logging - Every conversation is captured with full context including customer sentiment, intent classification, AI responses, and escalation decisions, creating a rich dataset for performance analysis and system improvement • Conversation Context Generation - For escalated cases, the system automatically produces detailed conversation summaries and context reports to help human agents understand the full situation before taking over Set up steps Platform Integration (20-30 minutes) • Messaging Platform Connection - Configure your primary communication channel (supports multiple messaging platforms) with proper API credentials and webhook setup for real-time message processing • AI Service Configuration - Connect OpenAI API credentials for the language models powering the classification engines and response generation • Database Setup - Establish connections to your customer database and order management systems for personalized responses and order tracking capabilities Knowledge Base Preparation (45-60 minutes) • Company Information Import - Upload or connect your existing knowledge base, including product catalogs, policy documents, FAQ sections, and troubleshooting guides • Order Database Integration - Link your order management system to enable real-time order status queries, shipping tracking, and return processing • Response Templates - Configure standard response patterns and company voice guidelines to ensure consistent brand communication Escalation & Routing Setup (15-25 minutes) • Team Structure Configuration - Define escalation paths and assign notification recipients for different severity levels (standard support, critical complaints, owner-level issues) • Email Integration - Connect email service for automated escalation notifications with customizable templates for different situation types • Escalation Triggers - Fine-tune the classification thresholds that determine when conversations require human intervention Testing & Optimization (30-45 minutes) • Conversation Flow Testing - Run comprehensive test scenarios covering various customer intents, sentiment levels, and escalation triggers to validate system responses • Knowledge Base Validation - Verify that the AI can accurately retrieve and apply information from your knowledge base for common customer queries • Escalation Path Verification - Test all escalation routes to ensure proper notifications and handoff procedures are functioning correctly • Performance Monitoring Setup - Configure analytics tracking to monitor response accuracy, escalation rates, and customer satisfaction metrics Advanced Configuration (Optional - 30-60 minutes) • Multi-Language Support - Configure language detection and response capabilities for international customer base • Custom Classification Rules - Adjust intent and sentiment classification parameters based on your specific business context and customer communication patterns • Integration Extensions - Connect additional business systems (CRM, billing, inventory) for enhanced customer service capabilities Technical Specifications AI Models & Processing • Powered by GPT-4 family models for natural language understanding and generation • Real-time voice transcription capabilities for multi-modal customer interactions • Structured output parsing for consistent data classification and routing decisions • Context-aware memory management with configurable conversation history retention Data Security & Privacy • Automatic detection of sensitive information with privacy-first handling protocols • Configurable data retention policies and secure storage of conversation logs • Customer verification requirements for accessing sensitive account information • GDPR-compliant data processing and storage practices Scalability & Performance • Modular architecture supporting easy integration of additional messaging platforms • Database-agnostic design (supports PostgreSQL, Supabase, and other systems) • Horizontal scaling capabilities for high-volume customer service operations • Real-time processing with minimal latency for immediate customer responses Detailed technical implementation guides, API configuration examples, and troubleshooting documentation are embedded within the workflow nodes for development teams. An n8n automation workflow template by Paul.

By Fakhar Khan

Multi-Agent AI Healthcare Assistant Demo ⚠️ EDUCATIONAL DEMONSTRATION ONLY - NOT FOR PRODUCTION MEDICAL USE ⚠️ A comprehensive demonstration of n8n's advanced multi-agent AI orchestration capabilities, showcasing how to build sophisticated conversational AI systems with specialized agent coordination. 🎯 What This Demo Shows Advanced Multi-Agent Architecture: Main Orchestrator Agent** - Traffic controller and decision maker Patient Registration Agent** - Specialized data collection and validation Appointment Scheduler Agent** - Complex multi-step booking workflows Medical Report Analyzer** - Document processing and analysis Prescription Medicine Analyzer** - Medicine verification and safety checks Technical Learning Objectives: Multi-agent coordination patterns Conditional agent routing and tool selection Memory management across conversations Multi-modal input processing (text, audio, images, documents) Complex state management in AI workflows External system integration (Google Sheets, WhatsApp, OpenAI) 🏗️ Architecture Highlights Multi-Modal Processing Pipeline: Text Messages** → Direct agent processing Audio Messages** → Transcription → Text processing → Audio response Images** → Vision analysis → Context integration Documents** → PDF extraction → Content analysis Agent Specialization: Each agent has focused responsibilities and constraints Intelligent document classification and routing Context-aware tool selection Error handling and recovery mechanisms Memory & State Management: Session-based conversation persistence Context sharing between specialized agents Multi-step workflow state tracking 🔧 Technical Implementation Key n8n Features Demonstrated: @n8n/n8n-nodes-langchain.agent - Main orchestrator @n8n/n8n-nodes-langchain.agentTool - Specialized sub-agents @n8n/n8n-nodes-langchain.memoryPostgresChat - Conversation memory n8n-nodes-base.googleSheetsTool - External data integration Complex conditional logic and routing Integration Patterns: WhatsApp Business API integration OpenAI GPT-4 model orchestration Google Sheets as data backend PostgreSQL for conversation memory Multi-step document processing 📚 Learning Value For n8n Developers: Enterprise-grade workflow architecture patterns AI agent orchestration best practices Complex conditional logic implementation Memory management in conversational AI Multi-modal data processing techniques Error handling and recovery strategies For AI Engineers: Agent specialization and coordination Tool calling and function integration Context management across conversations Multi-step workflow design Production workflow considerations ⚙️ Setup Requirements Required Credentials: OpenAI API Key (GPT-4 access recommended) WhatsApp Business API credentials Google Sheets OAuth2 API PostgreSQL database connection External Dependencies: Google Sheets database (template structure provided) WhatsApp Business Account PostgreSQL database for conversation memory 🚨 Important Disclaimers Educational Use Only: This is a DEMONSTRATION of n8n capabilities NOT suitable for actual medical use** NOT HIPAA compliant** Use only with fictional/test data Production Considerations: Requires proper security implementation Needs compliance review for medical use Consider HIPAA-compliant alternatives for healthcare Implement proper data encryption and access controls 🎓 Educational Applications Perfect for Learning: Advanced n8n workflow patterns Multi-agent AI system design Complex automation architecture Integration pattern best practices Conversational AI development Workshop & Training Use: AI automation workshops n8n advanced training sessions Multi-agent system demonstrations Integration pattern tutorials 🔄 Workflow Components Main Flow: WhatsApp message reception and media processing Input classification and routing Main agent orchestration and tool selection Specialized agent execution Response formatting and delivery Sub-Agents: Registration Tool** - Patient data collection Scheduler Tool** - Appointment booking logic Report Analyzer** - Medical document analysis Medicine Analyzer** - Prescription verification 💡 Customization Ideas Extend the Demo: Add more specialized agents Implement different communication channels Integrate with other healthcare APIs Add more sophisticated document processing Implement advanced analytics and reporting Adapt for Other Industries: Customer service automation Educational assistance systems E-commerce support workflows Technical support orchestration 🎯 Perfect for: Learning advanced n8n patterns, AI system architecture, multi-agent coordination ⏱️ Setup Time: 30-45 minutes (with credentials) 📈 Skill Level: Intermediate to Advanced 🏷️ Tags: AI Agents, Multi-Agent Systems, Healthcare Demo, Educational, Advanced Workflows. An n8n automation workflow template by Fakhar Khan.