Workflows
Browse 12,955 Workflows
Workflows are deterministic, multi-step pipelines that chain models, tools and agents in a fixed order — the predictable counterpart to an autonomous agent. Each entry records its platform and complexity, so the setup cost is visible before you import it.
3361–3408 of 12,955
By Roshan Ramani
Who's it for Business owners, freelancers, and professionals who use Cal.com or Calendly for scheduling and want instant WhatsApp notifications for all booking activities without constantly checking their email or calendar apps. What it does This workflow automatically monitors your calendar booking events from both Cal.com and Calendly, then sends beautifully formatted WhatsApp messages to notify you of: New bookings with guest details Rescheduled meetings with old vs new times Cancelled appointments Meeting completion notifications (Cal.com only) The AI agent intelligently formats each message with emojis, proper spacing, and all relevant booking information including guest names, emails, dates, times, locations, and notes. How it saves you time Stop checking multiple platforms: Instead of constantly monitoring email notifications, calendar apps, and booking dashboards, get everything instantly on WhatsApp - the app you're already using throughout the day. Immediate awareness: Know about booking changes the moment they happen, not hours later when you finally check your email. This means you can quickly adjust your schedule, prepare for meetings, or reach out to clients if needed. Mobile-first notifications: Since most people check WhatsApp more frequently than email, you'll never miss important booking updates again. Perfect for busy professionals who are often away from their desk. How it works When a booking event occurs on either platform, the workflow captures the data, merges it through an aggregator, then uses Google Gemini AI to generate a professionally formatted WhatsApp message that gets sent instantly to your phone. Requirements Cal.com and/or Calendly account with API access WhatsApp Business API credentials Google API key for Gemini Active webhook endpoints for both calendar services How to customize Update the recipient phone number in the WhatsApp node Modify message templates in the AI Agent's system prompt Add additional calendar platforms by connecting more trigger nodes Customize emoji usage and message formatting to match your brand. An n8n automation workflow template by Roshan Ramani.
- 4 nodes
- Automation
- AI
By Oneclick AI Squad
This automated n8n workflow tracks hourly cloud spending across AWS, Azure, and GCP. It detects cost spikes or budget overruns in real time, tags affected resources, and sends alerts via email, WhatsApp, or Slack. This ensures proactive cost management and prevents budget breaches. Good to Know AWS, Azure, and GCP APIs must have read access to billing data. Use secure credentials for API keys or service accounts. The workflow runs every hour for near real-time cost tracking. Alerts can be sent to multiple channels (Email, WhatsApp, Slack). Tags are applied automatically to affected resources for easy tracking. How It Works Hourly Cron Trigger – Starts the workflow every hour to fetch updated billing data. AWS Billing Fetch – Retrieves latest cost and usage data via AWS Cost Explorer API. Azure Billing Fetch – Retrieves subscription cost data from Azure Cost Management API. GCP Billing Fetch – Retrieves project-level spend data using GCP Cloud Billing API. Data Parser – Combines and cleans data from all three clouds into a unified format. Cost Spike Detector – Identifies unusual spending patterns or budget overruns. Owner Identifier – Matches resources to their respective owners or teams. Auto-Tag Resource – Tags the affected resource for quick identification and follow-up. Alert Sender – Sends notifications through Email, WhatsApp, and Slack with detailed cost reports. How to Use Import the workflow into n8n. Configure credentials for AWS, Azure, and GCP billing APIs. Set your budget threshold in the Cost Spike Detector node. Test the workflow to ensure all APIs fetch data correctly. Adjust the Cron Trigger for your preferred monitoring frequency. Monitor alert logs to track and manage cost spikes. Requirements AWS Access Key & Secret Key with Cost Explorer Read Permissions. Azure Client ID, Tenant ID, Client Secret with Cost Management Reader Role. GCP Service Account JSON Key with Billing Account Viewer Role. Customizing This Workflow Change the trigger frequency in the Cron node (e.g., every 15 min for faster alerts). Modify alert channels to include additional messaging platforms. Adjust cost spike detection thresholds to suit your organization’s budget rules. Extend the Data Parser to generate more detailed cost breakdowns. Want a tailored workflow for your business? Our experts can craft it quickly Contact our team. An n8n automation workflow template by Oneclick AI Squad.
- 5 nodes
- Automation
By Matthew
Instagram Hashtag Lead Generation Automate the process of finding and qualifying Instagram leads based on hashtags. This workflow reads hashtags from Google Sheets, scrapes Instagram for posts using Apify, analyzes caption content and language, compiles unique usernames, gathers detailed user info, and filters leads based on follower count. How It Works Fetch Hashtags The workflow starts and pulls a list of hashtags from a Google Sheet. Scrape Instagram Posts For each hashtag, it builds Instagram explore URLs and scrapes posts using Apify. Analyze Captions Each caption is cleaned, hashtags and links are removed, and language/content is analyzed (English/French/Spanish). Extract & Filter Usernames Usernames are combined and deduplicated, their Instagram profiles scraped for follower counts and other details. Qualified Leads Only users with followers in your target range are kept as qualified leads for outreach or analysis. Requirements An n8n instance. Apify API key. Google account with a Sheet containing hashtags. Apify Instagram Scraper actor access. The Google Sheet should have a column with hashtags. Setup Instructions Add Credentials In n8n, add your Apify API key and Google Sheets credentials. Configure Google Sheets Nodes Choose your credentials, spreadsheet, and sheet name in the “Get list of Hashtags” node. Configure Apify Request Nodes Enter your Apify API key and select the Instagram scraper actors. Adjust Filtering Edit the min/max follower count in the relevant filter node to match your needs. Test & Run Manually execute the workflow or add a trigger to run on a schedule. Customization Options 💡 Trigger:** Add a schedule or webhook to automate execution. Language Filtering:** Modify keyword lists or add language detection logic. Lead Output:** Extend the workflow to save leads to a CRM or send notifications. Details Nodes used in workflow: Manual Trigger Google Sheets Code HTTP Request (Apify) IF (Conditional) Aggregate Remove Duplicates Sticky Note. An n8n automation workflow template by Matthew.
- 3 nodes
- Automation
By franck fambou
Overview This intelligent chatbot workflow enables natural language conversations with your documents, supporting multiple file formats including PDFs, Word documents, Excel spreadsheets, and text files. Built with advanced RAG (Retrieval-Augmented Generation) technology, this chatbot can understand, analyze, and answer questions about your document content with contextual accuracy and intelligent responses. How It Works Intelligent Document Processing & Conversation Pipeline: Multi-Format Document Ingestion**: Automatically processes and indexes various document formats (PDF, DOCX, XLSX, TXT, etc.) Smart Content Chunking**: Breaks down documents into meaningful segments while preserving context and relationships Vector Database Storage**: Creates searchable embeddings for fast and accurate information retrieval Contextual Conversation Engine**: Uses AI to understand user queries and retrieve relevant document sections Natural Language Responses**: Generates human-like responses with citations and source references Multi-Turn Conversations**: Maintains conversation history and context across multiple interactions Real-Time Processing**: Instant responses with live document updates and dynamic content refresh Setup Instructions Estimated Setup Time: 15-20 minutes Prerequisites n8n instance (v0.200.0 or higher recommended) OpenAI/Gemini API key for embeddings and chat completion Vector database service (optional: Pinecone, Weaviate, or Qdrant) File storage service (optional: Google Drive, Dropbox, AWS S3) Web server for chatbot interface (optional) Configuration Steps Configure Document Input Sources Set up file upload webhook for direct document submission Configure cloud storage watchers for automatic document processing Add support for multiple file formats and size limits Set up document validation and security checks Setup Document Processing Pipeline Configure text extraction engines for different file types Set up intelligent chunking parameters (chunk size, overlap, boundaries) Add metadata extraction for document categorization Configure OCR for scanned documents (optional) Configure Vector Database Set up your chosen vector database credentials Configure embedding model settings (Gemini models/text-embedding-004 recommended) Set up collection/index structure for document storage Configure search parameters and similarity thresholds Setup AI Chat Engine Add your AI service API credentials (Gemini, Claude, etc.) Configure conversation prompts and system instructions Set up context window management and token optimization Add response formatting and citation rules Configure Chat Interface Set up webhook endpoints for chat API Configure session management and conversation history Add authentication and rate limiting (optional) Set up real-time updates and streaming responses Setup Monitoring & Analytics Configure conversation logging and analytics Set up performance monitoring for response times Add usage tracking and cost monitoring Configure error handling and failover mechanisms Use Cases Business & Enterprise Knowledge Base Queries**: Ask questions about company policies, procedures, and documentation Contract Analysis**: Query legal documents, contracts, and compliance materials Training Materials**: Interactive learning with training manuals and educational content Financial Reports**: Analyze and discuss financial statements, budgets, and forecasts Research & Academia Research Paper Analysis**: Discuss findings, methodologies, and citations from academic papers Literature Reviews**: Compare and contrast multiple research documents Thesis Support**: Get insights from reference materials and research data Grant Proposals**: Analyze requirements and optimize proposal content Legal & Compliance Legal Document Review**: Query contracts, agreements, and legal texts Regulatory Compliance**: Understand compliance requirements from regulatory documents Case Law Research**: Analyze legal precedents and court decisions Policy Analysis**: Interpret organizational policies and procedures Technical Documentation API Documentation**: Interactive queries about technical specifications User Manuals**: Get help and guidance from product documentation Code Documentation**: Understand codebases and technical implementations Troubleshooting Guides**: Interactive problem-solving with technical guides Personal Productivity Document Summarization**: Get quick summaries of long documents Information Extraction**: Find specific data points across multiple documents Content Research**: Research topics across your personal document library Meeting Notes**: Query and analyze meeting transcripts and notes Key Features Advanced Document Processing Multi-Format Support**: PDF, DOCX, XLSX, TXT, PPTX, and more Intelligent Chunking**: Context-aware document segmentation Metadata Extraction**: Automatic categorization and tagging OCR Integration**: Process scanned documents and images with text Intelligent Conversation Contextual Understanding**: Maintains conversation context and document relationships Source Attribution**: Provides citations and references for all answers Multi-Document Queries**: Compare and analyze across multiple documents Follow-up Questions**: Natural conversation flow with clarifying questions Performance & Scalability Fast Retrieval**: Vector-based semantic search for instant responses Scalable Architecture**: Handle large document collections efficiently Batch Processing**: Process multiple documents simultaneously Caching System**: Optimized response times with intelligent caching Security & Privacy Document Encryption**: Secure storage and transmission of sensitive documents Access Control**: User-based permissions and document access restrictions Audit Logging**: Complete conversation and access audit trails Data Retention**: Configurable data retention and deletion policies Technical Architecture Document Processing Flow File Upload → Format Detection → Text Extraction → Content Chunking Metadata Extraction → Embedding Generation → Vector Storage → Index Creation Conversation Flow User Query → Intent Analysis → Vector Search → Context Retrieval Response Generation → Source Attribution → Answer Formatting → Delivery Supported File Formats Documents**: PDF, DOC, DOCX, RTF, TXT, MD Spreadsheets**: XLS, XLSX, CSV Presentations**: PPT, PPTX Images**: PNG, JPG (with OCR) Archives**: ZIP (auto-extracts supported formats) Web**: HTML, XML Integration Options Chat Interfaces Web Widget**: Embeddable chat widget for websites API Endpoints**: RESTful API for custom integrations Slack/Teams**: Direct integration with team collaboration tools Mobile Apps**: API-first design for mobile application integration Data Sources Cloud Storage**: Google Drive, Dropbox, OneDrive, AWS S3 Document Systems**: SharePoint, Confluence, Notion Email**: Process attachments from email systems CRM/ERP**: Integration with business systems Performance Specifications Response Time**: < 3 seconds for typical queries Document Capacity**: Supports collections of 10,000+ documents Concurrent Users**: Scales to handle multiple simultaneous conversations Accuracy**: >90% relevance for domain-specific queries Advanced Configuration Options Customization Custom Prompts**: Tailor AI behavior for specific use cases Branding**: Customize chat interface with your company branding Language Support**: Multi-language document processing and responses Domain Expertise**: Fine-tune for specific industries or domains Analytics & Monitoring Usage Analytics**: Track popular queries and document usage Performance Metrics**: Monitor response times and accuracy User Feedback**: Collect ratings and improve responses A/B Testing**: Test different configurations and prompts Troubleshooting & Support Common Issues Slow Responses**: Check vector database performance and API limits Inaccurate Answers**: Review chunking strategy and embedding quality Format Errors**: Verify document formats and processing capabilities Memory Issues**: Monitor token usage and context window limits Optimization Tips Use clear, specific questions for best results Ensure documents are well-formatted with proper headers Regular vector database maintenance for optimal performance Monitor API usage to optimize costs and performance. An n8n automation workflow template by franck fambou.
- 8 nodes
- Automation
- AI
By franck fambou
Overview This comprehensive workflow transforms Excel spreadsheets into professional, AI-generated reports with automated analysis and insights. Whether you're dealing with financial data, customer tracking, sales metrics, inventory management, or any structured data in Excel format, this template leverages artificial intelligence to create detailed, actionable reports with visualizations and key findings. How It Works Automated Report Generation Pipeline: File Processing Trigger**: Workflow initiates when Excel files are uploaded through a web form or file system Data Extraction & Validation**: Automatically reads Excel sheets, validates data structure, and identifies key metrics AI-Powered Analysis**: Uses advanced language models to analyze data patterns, trends, and anomalies Report Generation**: Creates comprehensive reports with executive summaries, detailed analysis, and actionable recommendations Multi-Format Output**: Generates reports in various formats (PDF, HTML, Word) with embedded charts and visualizations Automated Distribution**: Sends completed reports via email or saves to designated cloud storage locations Setup Instructions Estimated Setup Time: 10-15 minutes Prerequisites n8n instance (v0.200.0 or higher) OpenAI/Claude API key for AI analysis Email service credentials (for report distribution) Cloud storage access (Google Drive, Dropbox, etc.) - optional Configuration Steps Configure File Input Trigger Set up webhook or file system trigger for Excel file uploads Configure accepted file formats (.xlsx, .xls, .csv) Add file size and validation checks Setup Data Processing Nodes Configure Excel file reader with sheet selection options Set up data validation and cleaning processes Define column mapping and data type recognition Configure AI Analysis Engine Add your AI service API credentials (OpenAI, Anthropic, etc.) Customize analysis prompts based on your data types Set up context-aware report generation parameters Setup Report Generation Configure report templates for different data types Set up chart generation and data visualization options Define output formats and styling preferences Configure Distribution Channels Set up email service for automated report delivery Configure cloud storage integration for report archiving Add notification systems for completion alerts Use Cases Financial Reporting Budget Analysis**: Analyze spending patterns and budget variance reports P&L Statements**: Generate profit and loss summaries with trend analysis Cash Flow Reports**: Create comprehensive cash flow analysis with forecasting Expense Tracking**: Automated expense categorization and spending insights Sales & CRM Analytics Sales Performance**: Generate sales team performance reports with KPIs Customer Analysis**: Create customer segmentation and lifetime value reports Lead Tracking**: Analyze conversion funnels and lead quality metrics Territory Management**: Regional sales analysis and market penetration reports Operations Management Inventory Reports**: Stock level analysis with reorder recommendations Project Tracking**: Progress reports with timeline and resource analysis Quality Metrics**: Performance dashboards with trend identification Resource Planning**: Capacity utilization and allocation reports HR & Administrative Employee Performance**: Generate comprehensive performance review reports Attendance Tracking**: Analyze attendance patterns and productivity metrics Training Records**: Skills gap analysis and training effectiveness reports Compliance Reporting**: Regulatory compliance status and audit reports Key Features Intelligent Data Recognition**: Automatically identifies data types and relationships Contextual Analysis**: AI provides industry-specific insights and recommendations Professional Formatting**: Clean, corporate-ready report layouts Interactive Visualizations**: Embedded charts, graphs, and data visualizations Executive Summaries**: AI-generated executive summaries highlighting key findings Trend Analysis**: Historical data comparison and future projections Anomaly Detection**: Automatically flags unusual patterns or outliers Multi-Language Support**: Generate reports in multiple languages Batch Processing**: Handle multiple files simultaneously Error Handling**: Robust error management with detailed logging Technical Requirements n8n instance with sufficient memory for Excel processing (minimum 2GB RAM recommended) AI service API access (OpenAI GPT-4, Claude, or similar) Email service (Gmail, Outlook, SendGrid, etc.) Optional: Cloud storage service credentials Stable internet connectivity for AI API calls Supported Data Types Financial Data**: Revenue, expenses, budgets, forecasts Sales Data**: Transactions, leads, customer information, pipeline data Operational Data**: Inventory, production metrics, quality scores HR Data**: Employee records, performance metrics, attendance Marketing Data**: Campaign metrics, conversion rates, ROI analysis Custom Data**: Any structured Excel data with clear column headers Output Options PDF Reports**: Professional PDF documents with embedded charts HTML Dashboards**: Interactive web-based reports Word Documents**: Editable Word reports with tables and charts Excel Summaries**: Enhanced Excel files with analysis sheets PowerPoint Presentations**: Executive presentation slides Advanced Features Custom Branding**: Add your company logo and branding to reports Scheduled Processing**: Set up automated report generation schedules Template Customization**: Create custom report templates for different data types Integration Ready**: Easy integration with existing business systems Audit Trail**: Complete logging of all processing steps and data changes Support & Troubleshooting For optimal performance, ensure your Excel files have clear column headers and consistent data formatting. The AI analysis works best with clean, well-structured data. For complex financial calculations, verify results against your existing systems during initial setup. An n8n automation workflow template by franck fambou.
- 8 nodes
- Automation
- AI
By Davidson Ahuruezenma
AI-Powered Academic Assignment Generator This n8n workflow template automates the complete academic assignment generation process from student queries to professional document delivery. Students submit assignment requests via Telegram, and the workflow generates comprehensive, plagiarism-free academic content using Google Gemini AI, formats it into professional PDF documents, and delivers downloadable links while maintaining complete records. What does this workflow do? 📱 Telegram Integration**: Receives structured assignment requests from students 🤖 AI Content Generation**: Creates comprehensive academic answers (500+ words per question) 📄 Professional Formatting**: Generates university-standard HTML/PDF documents ☁️ Cloud Storage**: Automatically stores files in organized Google Drive folders 📊 Record Keeping**: Maintains complete assignment database in Google Sheets 🔄 End-to-End Automation**: Complete pipeline from query to document delivery How it works The workflow processes student assignment requests through 16 interconnected nodes, handling everything from input parsing to final document delivery: Input → AI Processing → Document Generation → Storage & Delivery Setup Requirements Credentials needed: Telegram Bot Token** (for receiving/sending messages) Google Gemini API Key** (for AI content generation) Google Sheets API** (for record keeping) Google Drive API** (for file storage) PDFCrowd API** (for PDF conversion) Pre-setup steps: Create a Telegram bot and obtain the bot token Set up Google Drive folder structure for file organization Create Google Sheets template with proper column headers Configure API rate limits and usage quotas Workflow Breakdown 🔌 Input Processing Nodes Student Query Intake Bot (Telegram Trigger) Student Query Intake Bot (Telegram Trigger) Listens for incoming student messages with assignment details Monitors specific chat ID for authorized users Triggers workflow when structured assignment requests are received Structured Data Parser (Code Node) Extracts student information using regex patterns Parses: Name, Faculty, Department, Level, Course, Registration Number Automatically sets current date and handles missing data Outputs clean JSON structure for AI processing 🤖 AI Processing Nodes Student Assignment Auto-Composer (LangChain Agent) Main AI orchestrator for assignment generation Uses structured prompts for consistent academic formatting Generates 500-word answers per question with APA citations Ensures plagiarism-free, original academic content Generator Model (Google Gemini Chat) Primary AI model for high-quality content generation Handles complex academic writing and formatting requirements Fallback Model Generator (Google Gemini - Gemma) Backup AI model ensuring workflow reliability Activates when primary model encounters issues Structured Output Parser (LangChain) Validates AI-generated content against JSON schema Enforces required field compliance and format consistency Auto-fixes common formatting issues 🔧 Processing & Error Handling Error Handler (Code Node) Handles text processing errors and data type issues Converts non-string values and provides error recovery Ensures workflow continuity even with problematic data Wait Node Introduces strategic 2-second delay for processing stability Allows AI processing to complete before next steps 📊 Data Management Nodes Edit Fields (Set Node) Maps AI output to Google Sheets column structure Ensures data consistency for database storage Long Essay Record Sheet (Google Sheets) Stores complete assignment records with metadata Maintains comprehensive student assignment database Uses Name field as unique identifier for record updates 📄 Document Generation Nodes Static HTML Builder (LangChain Agent) Converts structured data into professional HTML documents Applies academic formatting: Times New Roman, 12pt, double-spaced Creates university-standard document structure HTTP Request (PDF Conversion) Converts HTML to high-quality PDF using PDFCrowd API Maintains academic formatting and professional appearance Uses student name for file identification ☁️ Storage & Delivery Nodes Upload File (Google Drive) Stores generated PDFs in organized Drive folders Creates shareable links for easy access Maintains systematic file organization Send Text Message (Telegram) Delivers Google Drive download link to student Completes the automation cycle with instant access Input Format Students should format their Telegram messages as follows: Name: John Doe Faculty: Engineering Department: Computer Science Level: 200L Course: CSC 201 - Data Structures Reg number: 2024001234 Question: Explain the concept of Big O notation Compare different sorting algorithms Discuss the applications of binary trees Features ✨ Intelligent Processing Smart Input Parsing**: Handles unstructured text inputs automatically Multi-Question Support**: Processes complex assignment requirements Data Validation**: Ensures complete and accurate information capture 🎓 Academic Excellence University Standards**: Professional formatting and citation styles Original Content**: Plagiarism-free AI-generated assignments Comprehensive Answers**: 500+ words per question with detailed explanations 🛡️ Reliability & Error Handling Fallback Systems**: Multiple AI models for continuous operation Error Recovery**: Automatic handling of processing issues Data Integrity**: Schema validation and field verification Use Cases This workflow template is perfect for: 📚 Educational Institutions**: Automate student assignment processing and grading assistance 👨🎓 Academic Support Services**: Provide structured learning assistance and content generation 🏫 Online Learning Platforms**: Integrate assignment automation into educational systems 📝 Content Creation Services**: Generate academic-quality content for educational purposes 🤖 AI Learning Projects**: Implement complex AI workflows with multiple service integrations Output Examples Generated Assignment Features: Professional formatting** with Times New Roman, 12pt font, double-spacing Complete academic structure** including headers, student information, questions, and references Comprehensive answers** averaging 500+ words per question with detailed explanations Proper citations** in APA format with authentic academic references PDF delivery** through shareable Google Drive links Database Records: Complete student information tracking Assignment question and answer storage Timestamp and metadata preservation Easy retrieval and analysis capabilities Performance & Reliability Processing Time: 2-3 minutes per assignment Success Rate: >95% with fallback mechanisms Content Quality: University-standard academic writing Scalability: Handles multiple concurrent requests Error Recovery: Automatic retry and alternative processing paths Customization Options Easily configurable elements: Chat IDs**: Modify for different Telegram groups or users AI Models**: Switch between different Google Gemini models Document Formatting**: Adjust academic standards and styling Storage Locations**: Configure Google Drive folders and naming conventions Database Fields**: Modify Google Sheets columns and data structure Advanced customizations: Add support for different document formats (Word, LaTeX) Integrate additional AI providers (OpenAI, Claude, etc.) Implement grading and feedback mechanisms Add multi-language support Create batch processing capabilities Getting Started Import the workflow into your n8n instance Configure credentials for all required services Set up Telegram bot and obtain necessary permissions Create Google Drive folders and Google Sheets template AI-Powered Academic Assignment Test with sample data to ensure proper functionality Deploy and monitor for production use Tags academic education ai telegram google-sheets pdf-generation automation langchain assignment student-support. An n8n automation workflow template by Davidson Ahuruezenma.
- 8 nodes
- Automation
- AI
By Oriol Seguí
Web Consultation & Crawling Chatbot with Google Sheets Memory Who is this workflow for? This workflow is designed for SEO analysts, content creators, marketing agencies, and developers who need to index a website and then interact with its content as if it were a chatbot. ⚠ Note: if the site contains many pages, AI token consumption can generate high costs, especially during the initial crawling and analysis phase. 1. Initial Mode (first use with a URL) When the user enters a URL for the first time: URL validation using AI (gpt-5-nano). Automatic sitemap discovery via robots.txt. Relevant sitemap selection (pages, posts, categories, or tags) using GPT-4o according to configured options. (Includes “OPTIONS” node to precisely choose which types of URLs to process) Crawling of all selected pages: Downloads HTML of each page. Converts HTML to Markdown. AI analysis to extract: Detected language. Heading hierarchy (H1, H2, etc.). Internal and external links. Content summary. Structured storage in Google Sheets: Lang H1 and hierarchy External URLs Internal URLs Summary Content Data schema (flag to enable agent mode) When finished, the sheet is marked with Data schema = true, signaling that the site is indexed. 2. Agent Mode (subsequent queries) If the URL has already been indexed (Data schema = true): The chat becomes a LangChain Agent that: Reads the database in Google Sheets. Can perform real-time HTTP requests if it needs updated information. Responds as if it were the website, using stored and live data. This allows the user to ask questions such as: "What’s on the contact page?" "How many external links are there on the homepage?" "Give me all the H1 headings from the services pages" "What CTA would you suggest for my page?" "How would you expand X content?" Use cases Build a chatbot that answers questions about a website’s content. Index and analyze full websites for future queries. SEO tool to list headings, links, and content summaries. Assistant for quick exploration of a site’s structure. Generate improvement recommendations and content strategies from site data. An n8n automation workflow template by Oriol Seguí.
- 8 nodes
- Automation
- AI
By Olivier
This workflow contains community nodes that are only compatible with the self-hosted version of n8n. This template generates structured synthetic company content using live web data from the Bedrijfsdata.nl API combined with an LLM. Provide a company domain (directly or via a Bedrijfsdata.nl ID) and the workflow retrieves relevant website and search engine content, then produces ready-to-use descriptions of the company, its offerings, and its target audience. ✨ Features Create high-quality Dutch-language company descriptions on demand Automatically pull live web content via Bedrijfsdata.nl RAG Domain & RAG Search Structured JSON output for consistent downstream use (e.g., CRM updates, lead qualification) Flexible trigger: run from ProspectPro ID, domain input, or another workflow Secure, modular, and extendable structure (error handling included) 🏢 Example Output The workflow produces structured content fields you can directly use in your sales, marketing, or enrichment flows: company_description** – 1-2 paragraph summary of the company products_and_services** – detailed overview of offerings target_audience** – specific characteristics of ideal customers (e.g., industry, location, company size, software usage) Example: { "company_description": "Bedrijfsdata.nl B.V. is een Nederlands bedrijf dat uitgebreide data levert over meer dan 3,7 miljoen bedrijven in Nederland...", "products_and_services": "Het bedrijf biedt API-toegang tot bedrijfsprofielen, sectoranalyses, en SEO-gegevens...", "target_audience": "Nederlandse MKB's die behoefte hebben aan actuele bedrijfsinformatie voor marketing- of salesdoeleinden..." } ⚙ Requirements n8n instance or cloud workspace Install the Bedrijfsdata.nl n8n Verified Community Node OpenAI API credentials (tested with gpt-4.1-mini and gpt-3.5-turbo) Bedrijfsdata.nl developer account (14-day free trial, 500 credits) 🔧 Setup Instructions 1. Trigger configuration Use Bedrijfsdata.nl ID (default) or provide a domain directly Can be called from another workflow using “Execute Workflow” 2. Configure API credentials Bedrijfsdata.nl API key OpenAI API key 3. Customize Output (Optional) Adjust prompt in the LLM node to create other types of synthetic content Extend structured output schema for your use case 4. Integrate with Your Stack Example node included to update HubSpot descriptions Replace or extend to match your CRM, database, or messaging tools 🔐 Security Notes Input validation for required domain Dedicated error branches for invalid input, API errors, LLM errors, and downstream integration errors RAG content checks before running the LLM 🧪 Testing Run workflow with a Bedrijfsdata.nl ID linked to a company with a known website Review generated JSON output Verify content accuracy before production use 📌 About Bedrijfsdata.nl Bedrijfsdata.nl operates the most comprehensive company database in the Netherlands. With real-time data on 3.7M+ businesses and AI-ready APIs, we help Dutch SMEs enrich their CRM, workflows, and marketing automation. Built on 25+ years of experience in data collection and enrichment, our technology brings corporate-grade data quality to every organisation. Website: https://www.bedrijfsdata.nl Developers: https://developers.bedrijfsdata.nl API docs: https://docs.bedrijfsdata.nl 📞 Support Email: klantenservice@bedrijfsdata.nl Phone: +31 20 789 50 50 Support hours: Monday–Friday, 09:00–17:00 CET. An n8n automation workflow template by Olivier.
- 5 nodes
- Automation
- AI
By InfyOm Technologies
✅ What problem does this workflow solve? Most e-commerce chatbots are transactional; they answer one question at a time and forget your context right after. This workflow changes that. It introduces a smart, memory-enabled shopping assistant that remembers user preferences, past orders, and previous queries to offer deeply personalized, natural conversations. ⚙️ What does this workflow do? Accepts real-time chat messages from users. Uses Zep Memory to store and recall personalized context. Integrates with: 🛒 Product Inventory 📦 Order History 📜 Return Policy Answers complex queries based on historical context. Provides: Personalized product recommendations Context-aware order lookups Seamless return processing Policy discussions with minimal user input 🧠 Why Context & Memory Matter Traditional bots: ❌ Forget what the user said 2 messages ago ❌ Ask repetitive questions (name, order ID, etc.) ❌ Can’t personalize beyond basic filters With Zep-powered memory, your bot: ✅ Remembers preferences (e.g., favorite categories, past questions) ✅ Builds persistent context across sessions ✅ Gives dynamic, user-specific replies (e.g., "You ordered this last week…") ✅ Offers a frictionless support experience 🔧 Setup Instructions 🧠 Zep Memory Setup Create a Zep instance and connect it via the Zep Memory node. It will automatically store user conversations and summarize facts. 💬 Chat Trigger Use the "When chat message received" trigger to initiate the conversation workflow. 🤖 AI Agent Configuration Connect: Chat Model → OpenAI GPT-4 or GPT-3.5 Memory → Zep Tools: Get_Orders – Fetch user order history from Google Sheets Get_Inventory – Recommend products based on stock and preferences Get_ReturnPolicy – Answer policy-related questions 📄 Google Sheets Store orders, inventory, and return policies in structured sheets. Use read access nodes to fetch data dynamically during conversations. 🧠 How it Works – Step-by-Step Chat Trigger – User sends a message. AI Agent (w/ Zep Memory): Reads past interactions to build context. Pulls memory facts (e.g., "User prefers men's sneakers"). Uses External Tools: Looks up orders, return policies, or available products. Generates Personalized Response using OpenAI. Reply Sent Back to the user through chat. 🧩 What the Bot Can Do 🛍 Suggest products based on past browsing or purchase behavior. 📦 Check order status and history without requiring the user to provide order IDs. 📃 Explain return policies in detail, adapting answers based on context. 🤖 Engage in more human-like conversations across multiple sessions. 👤 Who can use this? This is ideal for: 🛒 E-commerce store owners 🤖 Product-focused AI startups 📦 Customer service teams 🧠 Developers building intelligent commerce bots If you're building a chatbot that goes beyond canned responses, this memory-first shopping assistant is the upgrade you need. 🛠 Customization Ideas Connect with Shopify, WooCommerce, or Notion instead of Google Sheets. Add payment processing or shipping tracking integrations. Customize the memory expiration or fact-summarization rules in Zep. Integrate with voice AI to make it work as a phone-based shopping assistant. 🚀 Ready to Launch? Just connect: ✅ OpenAI Chat Model ✅ Zep Memory Engine ✅ Your Product/Order/Policy Sheets And you’re ready to deliver truly personalized shopping conversations. An n8n automation workflow template by InfyOm Technologies.
- 3 nodes
- Automation
- AI
By Arlene Martin
*Use Case: * Analyze images with multiple subjects. In this use case I have a bookshelf and am extracting and verifying book titles/authors from a bookshelf photo. *How it works: * 1) Webhook receives an image url from a front end in which a user can upload a picture. In this use case, it is an image of a book shelf. 2) Edit Field (Set): Saves image in a consistent location so AI can find it. 3) Analyze Image: Image is analyzed. Extracts titles from the book spines 4) Code: Splits extracted subjects to single item to be able to validate each item separately. Books are individualized to their own entity 5) *HTTP Request *validates each subject. Queries Google Books to validate books in case only partial titles were found. 6) Edit Field (Set): Tidies the result. 7) Code: Aggregates and deduplicates Titles and authors are aggregate into a list 8) Respond to Webhook returns list to front end How to use: Use with a frontend that can capture images and receive back the result. For this use case Supabase was used to store images from which the image analyzer could reference. An n8n automation workflow template by Arlene Martin.
- 3 nodes
- Automation
- AI
By Dr. Firas
Auto-Generate Social Media Videos with GPT-5 and Publish via Blotato > ⚠️ Disclaimer: This workflow uses Community Nodes (Blotato) and requires a self-hosted n8n instance with "Verified Community Nodes" enabled. 👥 Who is this for? This workflow is perfect for: Content creators and influencers who post regularly on social media Marketing teams that want to scale branded video production Solo entrepreneurs looking to automate their video marketing Agencies managing multi-client social media publishing 💡 What problem is this workflow solving? Creating high-quality video content and publishing consistently on multiple platforms is time-consuming. You often need to: Write compelling captions and titles Adapt content to fit each platform’s requirements Publish manually or across disconnected tools This workflow automates the entire process — from idea to publishing — so you can focus on growth and creativity, not logistics. ⚙️ What this workflow does Receives a video idea via Telegram Saves metadata to Google Sheets Transcribes the video using OpenAI Whisper Generates a catchy title and caption using GPT-5 Uploads the final media to Blotato Publishes the video automatically to: TikTok Instagram YouTube Shorts Facebook X (Twitter) Threads LinkedIn Pinterest Bluesky Updates the post status in Google Sheets Sends confirmation via Telegram 🧰 Setup Before launching the workflow, make sure to: Create a Blotato Pro account and generate your API Key Enable Verified Community Nodes in the n8n Admin Panel Install the Blotato community node in n8n Create your Blotato credential using the API key Make a copy of this Google Sheet template Ensure your Google Drive folder with videos is shared publicly (viewable by anyone with the link) Link your Telegram Bot and configure the trigger node Follow the sticky note instructions inside the workflow 🛠️ How to customize this workflow Modify the GPT-5 prompt to reflect your brand voice or campaign tone Add/remove social platforms depending on your strategy Include additional AI modules (e.g., for voiceover or thumbnails) Insert review/approval steps (via Slack, email, or Telegram) Connect Airtable, Notion, or your CRM to track results This is your all-in-one AI video publishing engine, built for automation, scale, and growth across the social web. 📄 Documentation: Notion Guide Need help customizing? Contact me for consulting and support : Linkedin / Youtube. An n8n automation workflow template by Dr. Firas.
- 7 nodes
- Automation
- AI
By Rodrigo
How it works This workflow creates a complete AI-powered restaurant ordering system through WhatsApp. It receives customer messages, processes multimedia content (text, voice, images, PDFs, location), uses GPT-4 to understand customer intent and manage conversations, handles the complete ordering flow from menu selection to payment verification, and sends formatted orders to restaurant staff. The system maintains conversation memory, verifies payment receipts using OCR, and provides automated responses in multiple languages. Who's it for Restaurant owners, food delivery services, and hospitality businesses looking to automate customer service and order management through WhatsApp without hiring additional staff. Requirements WhatsApp Business API account OpenAI API key (GPT-4/GPT-4o access recommended) Supabase account (for conversation memory and vector storage) Google Drive account (for menu images and QR codes) Google Maps API key (for location services) Gemini API key (for PDF processing) How to set up Configure credentials - Add your WhatsApp Business API, OpenAI, Supabase, Google Drive, and Gemini API credentials to n8n Update phone numbers - Replace [PHONE_NUMBER] placeholders with your actual restaurant and staff phone numbers Customize restaurant details - Replace [RESTAURANT_NAME], [RESTAURANT_OWNER_NAME], and [BANK_ACCOUNT_NUMBER] with your information Upload menu images - Add your menu images to Google Drive and update the file IDs Set up Supabase - Create tables for chat memory and upload your menu/restaurant information to the vector database Configure AI prompts - Update the restaurant information in the AI agent system messages Test the workflow - Send test messages to verify all integrations work How to customize the workflow Menu management**: Update Google Drive file IDs to display your current menu images Payment verification**: Modify the receipt analysis logic to match your bank's receipt format Order formatting**: Customize the order confirmation template sent to kitchen staff AI personality**: Adjust the restaurant agent's tone and responses in the system prompts Languages**: The AI supports multiple languages - customize welcome messages for your target market Business hours**: Add time-based logic to handle orders outside operating hours Delivery zones**: Integrate with your delivery area logic using the location processing features. An n8n automation workflow template by Rodrigo.
- 9 nodes
- Automation
- AI
By Colton Randolph
This n8n workflow automatically scrapes TechCrunch articles, filters for AI-related content using OpenAI, and delivers curated summaries to your Slack channels. Perfect for individuals or teams who need to stay current on artificial intelligence developments without manually browsing tech news sites. Who's it for AI product teams tracking industry developments and competitive moves Tech investors monitoring AI startup coverage and funding announcements Marketing teams following AI trends for content and positioning strategies Executives needing daily AI industry briefings without manual research overhead Development teams staying current on AI tools, frameworks, and breakthrough technologies How it works The workflow runs on a daily schedule, crawling a specificed amount of TechCrunch articles from the current year. Firecrawl extracts clean markdown content while bypassing anti-bot measures and handling JavaScript rendering automatically. Each article gets analyzed by an AI research assistant that determines if the content relates to artificial intelligence, machine learning, AI companies, or AI technology. Articles marked as "NOT_AI_RELATED" get filtered out automatically. For AI-relevant articles, OpenAI generates focused 3-bullet-point summaries that capture key insights. These summaries get delivered to your specified Slack channel with the original TechCrunch article title and source link for deeper reading. How to set up Configure Firecrawl: Add your Firecrawl API key to the HTTP Request node Set OpenAI credentials: Add your OpenAI API key to the AI Agent node Connect Slack: Configure your Slack webhook URL and target channel Adjust scheduling: Set your preferred trigger frequency (daily recommended) Test the workflow: Run manually to verify article extraction and Slack delivery Requirements Firecrawl account** with API access for TechCrunch web scraping OpenAI API key** for AI content analysis and summarization Slack workspace** with webhook permissions for message delivery n8n instance** (cloud or self-hosted) for workflow execution How to customize the workflow Source expansion: Modify the HTTP node URL to target additional tech publications beyond TechCrunch, or adjust the article limit and date filtering for different coverage needs. AI focus refinement: Update the OpenAI prompt to focus on specific AI verticals like generative AI, robotics, or ML infrastructure. Add company names or technology terms to the relevance filtering logic. Summary formats: Change from 3-bullet summaries to executive briefs, technical analyses, or competitive intelligence reports by modifying the OpenAI summarization prompt. Multi-channel delivery: Extend beyond Slack to email notifications, Microsoft Teams, or database storage for historical trend analysis and executive dashboards. An n8n automation workflow template by Colton Randolph.
- 5 nodes
- Automation
- AI
By Khairul Muhtadin
Map content topics to the right WordPress categories automatically. WP Category Toolkit reads your WordPress categories via REST API, lets a GPT-5-mini model decide which IDs fit your topic, and hands back a clean mapping. No more copy-paste guesswork, tagging errors drop, and your site stays organized. Last updated: September 2026. Why Use WP Category Toolkit? Saves time:** Manual category lookup becomes a batch job measured in minutes. Stops messy tagging:** Consistent category assignments, so archives and SEO behave. Measurable improvement:** Faster publish cycles with far fewer category fixes (manual mapping errors down ~90%). Competitive edge:** An LLM reads topic intent, so categories match meaning, not guesswork. Perfect For Content Managers:** Keep large WordPress catalogs neat without spreadsheet gymnastics. Agencies:** Onboard client sites faster by automating taxonomy mapping across projects. Developers & Automators:** Drop an LLM-powered mapping step into content pipelines without building custom classifiers. How It Works Trigger: Manual start. Kick it off when you are ready to map categories. Process: Pulls all site categories from your WordPress REST endpoint, aggregates the list, and feeds the source content plus current topic into the mapping step. Smart Logic: A Chain LLM node (Category-Mapping) uses a small prompt to decide which WordPress category IDs match the content topic (GPT-5-mini handles the reasoning). Output: A clean category ID mapping you can paste into your Body Post WordPress node or use to patch posts automatically. Quick Setup Import JSON file to your n8n instances Add credentials: WordPress API credential & Azure OpenAI (GPT-5-mini) credential, or you can use the standard OpenAI node Update: Replace the WP endpoint URL (REST API docs) and any post-body endpoints you will write back to Test: Run with a sample post and copy the output mapping into your Body Post WordPress node to confirm IDs match expected categories You'll Need Active n8n instances WordPress REST API access and credentials (wp-json access) Azure OpenAI account with access to GPT-5-mini Integrations: WordPress API node, Chain LLM / Azure OpenAI node (Optional) Staging WordPress site to test mappings safely Level Up Ideas Auto-write category descriptions based on mapped content using the LLM. Patch posts automatically after mapping so mapping becomes truly zero-touch. Add fallback heuristics: if the LLM is uncertain, route to a Slack or Microsoft Teams approval step. Quick Answers What do I feed it? Your content topic plus your site's category list pulled from the WordPress REST API. What comes back? A clean mapping of WordPress category IDs matched to your topic. Which model decides? GPT-5-mini (Azure OpenAI), guided by a small mapping prompt. Made by: khmuhtadin Tags: WordPress, Categories, AI, n8n Category: WordPress Need custom work? Contact me Additional info Built with n8n. Need an assessment on your business? Feel free to reach out at https://khmuhtadin.com/consultation/. An n8n automation workflow template by Khairul Muhtadin.
- 3 nodes
- 479 views
- Automation
- AI
By Paul
Supercharge Your HighLevel CRM with the Power of GPT-5 Unleash the full potential of your HighLevel CRM by adding an intelligent GPT-5 Agent that does more than just follow commands — it understands context, retrieves the right data, and executes actions instantly. This marketplace solution transforms how you work: Act Instantly** – Create, update, and manage contacts, opportunities, tasks, and calendars with natural language commands. Work Smarter, Not Harder** – The agent pulls context from your internal documents, spreadsheets, and even the web before acting, ensuring every move is informed and precise. Never Miss a Detail** – It searches your knowledge base, Google Drive, and Supabase vectors to fill in missing info so you don’t have to. Boost Team Productivity** – Automate repetitive CRM work, cut manual data entry, and free up hours every week. Close Deals Faster** – Instantly update opportunities, schedule meetings, and follow up on leads without switching tabs. Stay Organized Effortlessly** – One AI agent orchestrates it all — from booking appointments to updating deal stages — directly inside HighLevel. Why This Is a Game-Changer Other tools require constant babysitting. This agent thinks ahead, checks context, and ensures every action in your CRM is accurate, complete, and ready to move your business forward. ⚡ Stop clicking through endless menus. Let GPT-5 + HighLevel automation work for you. ✅ Boost conversions ✅ Automate admin work ✅ Keep your CRM data flawless Get it now and watch your CRM become your smartest sales assistant. An n8n automation workflow template by Paul.
- 14 nodes
- Automation
- AI
By shae
How it works This AI Customer Success Risk Prediction workflow revolutionizes customer retention by predicting churn risk 30-90 days before it happens. Here's the high-level flow: Daily Data Collection → AI Multi-Signal Analysis → Risk Scoring & Prediction → Smart Risk Routing → AI-Generated Personalized Interventions → CRM Updates & Team Alerts The system automatically gathers data from your product analytics, support system, billing platform, and email tools, then uses GPT-4 to analyze patterns and predict which customers are at risk. It creates personalized intervention strategies and routes them based on urgency level. Set up steps Time to set up: Approximately 45 minutes Prerequisites: Active accounts with your analytics platform, support system, billing provider, CRM, and AI provider Step 1: Import & Configure Workflow (5 minutes) Import the workflow JSON into your n8n instance Review the 3 comprehensive sticky notes for context Understand the AI analysis logic and intervention strategies Step 2: Set Environment Variables (10 minutes) Configure these critical variables: ANALYTICS_API_URL and ANALYTICS_API_KEY HIGH_RISK_SLACK_CHANNEL (for critical alerts) CS_TEAM_EMAIL (intervention sender) CRM_BASE_URL and CALENDAR_BOOKING_URL Step 3: Configure API Credentials (20 minutes) Set up secure credential connections for: OpenAI/Anthropic API (AI analysis engine) Analytics platform (Mixpanel/Amplitude/GA) Support system (Zendesk/Intercom) Billing platform (Stripe/Chargebee) HubSpot CRM (risk data storage) Slack API (team notifications) SMTP/SendGrid (email delivery) Step 4: Customize AI Prompts & Risk Thresholds (8 minutes) Review and adjust the AI analysis prompts for your business Modify risk score thresholds (Critical 90+, High 70-89, Medium 40-69) Customize intervention email templates and tone Set your specific risk factors (usage patterns, support indicators) Step 5: Test & Activate (2 minutes) Run a test execution with sample customer data Verify AI analysis generates appropriate risk scores Check that interventions are routed correctly Activate the daily cron schedule. An n8n automation workflow template by shae.
- 6 nodes
- Automation
By shae
How it works This Lead Capture & Auto-Qualification workflow transforms raw leads into qualified prospects through intelligent automation. Here's the high-level flow: Lead Intake → Data Validation → Enrichment → Scoring → Smart Routing → CRM Integration & Notifications The system captures leads from any source, validates the data, enriches it with company intelligence, scores based on qualification criteria, and automatically routes high-value prospects to sales while nurturing lower-priority leads. Set up steps Time to set up: Approximately 30-45 minutes Prerequisites: Active accounts with HubSpot, Clearbit, Apollo, and Slack Step 1: Import Workflow (2 minutes) Copy the workflow JSON and import into your n8n instance The workflow will appear with all nodes and sticky note documentation Step 2: Configure Environment Variables (5 minutes) Set these in your n8n environment: APOLLO_API_URL SLACK_SALES_CHANNEL_ID SLACK_MARKETING_CHANNEL_ID CRM_ASSIGNMENT_URL Step 3: Set Up API Credentials (15 minutes) Create credential connections for: Clearbit API (enrichment) Apollo API (HTTP Header Auth) HubSpot API (CRM integration) Slack API (notifications) Step 4: Customize Scoring Logic (10 minutes) Review the qualification criteria in the Code node Adjust scoring weights based on your ideal customer profile Modify industry targeting and company size thresholds Step 5: Test & Activate (8 minutes) Send test webhook requests to validate the flow Verify CRM contact creation and Slack notifications Activate the workflow for live lead processing. An n8n automation workflow template by shae.
- 5 nodes
- Automation
By DataMinex
Transform property searches into personalized experiences! This powerful automation delivers dream home matches straight to clients' inboxes with professional CSV reports - all from a simple web form. 🚀 What this workflow does Create a complete real estate search experience that works 24/7: ✨ Smart Web Form - Beautiful property search form captures client preferences 🧠 Dynamic SQL Builder - Intelligently creates optimized queries from user input ⚡ Lightning Database Search - Scans 1000+ properties in milliseconds 📊 Professional CSV Export - Excel-ready reports with complete property details 📧 Automated Email Delivery - Personalized emails with property previews and attachments 🎯 Perfect for: Real Estate Agents** - Generate leads and impress clients with instant service Property Managers** - Automate tenant matching and recommendations Brokerages** - Provide 24/7 self-service property discovery Developers** - Showcase available properties with professional automation 💡 Why this workflow is a game-changer > "From property search to professional report delivery in under 30 seconds!" ⚡ Instant Results: Zero wait time for property matches 🎨 Professional Output: Beautiful emails that showcase your expertise 📱 Mobile Optimized: Works flawlessly on all devices 🧠 Smart Filtering: Only searches criteria clients actually specify 📈 Infinitely Scalable: Handles unlimited searches simultaneously 📊 Real Estate Data Source Built on authentic US market data from the Github: 🏘️ 1000+ Real Properties across all US states 💰 Actual Market Prices from legitimate listings 🏠 Complete Property Details (bedrooms, bathrooms, square footage, lot size) 📍 Verified Locations with accurate cities, states, and ZIP codes 🏢 Broker Information for authentic real estate context 🛠️ Quick Setup Guide Prerequisites Checklist ✅ [ ] SQL Server database (MySQL/PostgreSQL also supported) [ ] Gmail account for automated emails [ ] n8n instance (cloud or self-hosted) [ ] 20 minutes setup time Step 1: Import Real Estate Data 📥 🌟 Download the data 💾 Download CSV file (1000+ properties included) 🗄️ Create SQL Server table with this exact schema: CREATE TABLE [REALTOR].[dbo].[realtor_usa_price] ( brokered_by BIGINT, status NVARCHAR(50), price DECIMAL(12,2), bed INT, bath DECIMAL(3,1), acre_lot DECIMAL(10,8), street BIGINT, city NVARCHAR(100), state NVARCHAR(50), zip_code INT, house_size INT, prev_sold_date NVARCHAR(50) ); 📊 Import your CSV data into this table Step 2: Configure Database Connection 🔗 🔐 Set up Microsoft SQL Server credentials in n8n ✅ Test connection to ensure everything works 🎯 Workflow is pre-configured for the table structure above Step 3: Gmail Setup (The Magic Touch) 📧 🌐 Visit Google Cloud Console 🆕 Create new project (or use existing) 🔓 Enable Gmail API in API Library 🔑 Create OAuth2 credentials (Web Application) ⚙️ Add your n8n callback URL to authorized redirects 🔗 Configure Gmail OAuth2 credentials in n8n ✨ Authorize your Google account Step 4: Launch Your Property Search Portal 🚀 📋 Import this workflow template (form is pre-configured) 🌍 Copy your webhook URL from the Property Search Form node 🔍 Test with a sample property search 📨 Check email delivery with CSV attachment 🎉 Go live and start impressing clients! 🎨 Customization Playground 🏷️ Personalize Your Brand // Customize email subjects in the Gmail node "🏠 Exclusive Properties Curated Just for You - ${results.length} Perfect Matches!" "✨ Your Dream Home Portfolio - Handpicked by Our Experts" "🎯 Hot Market Alert - ${results.length} Premium Properties Inside!" 🔧 Advanced Enhancements 🎨 HTML Email Templates**: Create stunning visual emails with property images 📊 Analytics Dashboard**: Track popular searches and user engagement 🔔 Smart Alerts**: Set up automated price drop notifications 📱 Mobile Integration**: Connect to React Native or Flutter apps 🤖 AI Descriptions**: Add ChatGPT for compelling property descriptions 🌍 Multi-Database Flexibility // Easy database switching // MySQL: Replace Microsoft SQL node → MySQL node // PostgreSQL: Swap for PostgreSQL node // MongoDB: Use MongoDB node with JSON queries // Even CSV files: Use CSV reading nodes for smaller datasets 🚀 Advanced Features & Extensions 🔥 Pro Tips for Power Users 🔄 Bulk Processing**: Handle multiple searches simultaneously 💾 Smart Caching**: Store popular searches for lightning-fast results 📈 Lead Scoring**: Track which properties generate most interest 📅 Follow-up Automation**: Schedule nurturing email sequences 🎯 Integration Possibilities 🏢 CRM Connection**: Auto-add qualified leads to your CRM 📅 Calendar Integration**: Add property viewing scheduling 📊 Price Monitoring**: Track market trends and price changes 📱 Social Media**: Auto-share featured properties to social platforms 💬 Chat Integration**: Connect to WhatsApp or SMS for instant alerts 🔗 Expand Your Real Estate Automation 🌟 Related Workflow Ideas 🤖 AI Property Valuation - Add machine learning for price predictions 📊 Market Analysis Reports - Generate comprehensive market insights 📱 SMS Property Alerts - Instant text notifications for hot properties 🏢 Commercial Property Search - Adapt for office and retail spaces 💹 Investment ROI Calculator - Add financial analysis for investors 🏘️ Neighborhood Analytics - Include school ratings and demographics 🛠️ Technical Extensions 📷 Image Processing: Auto-resize and optimize property photos 🗺️ Map Integration: Add interactive property location maps 📱 Progressive Web App: Create mobile app experience 🔔 Push Notifications: Real-time alerts for saved searches 🚀 Get Started Now Import this workflow template Configure your database and Gmail Customize branding and messaging Launch your professional property search portal Watch client satisfaction soar!. An n8n automation workflow template by DataMinex.
- 3 nodes
- Automation
By AI/ML API | D1m7asis
This workflow contains community nodes that are only compatible with the self-hosted version of n8n. 🎬 GPT-5 Cinematic Video Generator (n8n + AI/ML API + Google Veo-3) This n8n workflow transforms even a single word into a fully rendered cinematic video using Google Veo-3 image-to-video and prompt expansion with GPT-5. Ideal for rapid creative prototyping, content creation, and AI-driven video production. 🚀 Key Features Ultra-Short Input Ready** – Works with just one keyword or a short idea. AI Prompt Expansion** – GPT-5 adds cinematic elements: camera motion, mood, color palette, and composition. Automated Video Generation** – Veo-3 i2v model creates smooth, visually appealing clips. Smart Polling** – Waits until video is ready, with success/fail handling. Direct Output** – Returns ready-to-use video URL for download or publishing. 🛠 Setup Guide Create AI/ML API Credentials Get your API key from AI/ML API Keys. In n8n > Credentials, add AI/ML account (Bearer token). (Optional) Change Image Source Edit the Set image URL node to point to your desired still image for video generation. Run from Chat Send a word or short phrase via Chat Trigger to start the process. (Optional) Extend Output Add Google Drive upload, YouTube publish, or database logging nodes for a complete content pipeline. 💡 How It Works Trigger – Receives chat input (keyword or brief). Prompt Expansion – GPT-5 turns it into a cinematic, Veo-3-optimized description. Video Creation – Sends prompt + image to Veo-3 image-to-video. Polling – Checks generation status every 30 seconds until complete. Result – Returns direct video URL, ready for your next steps. An n8n automation workflow template by AI/ML API | D1m7asis.
- 1 nodes
- Automation
By Intuz
This n8n template from Intuz provides a complete solution to automate your expense approval and accounting process. It seamlessly connects an Airtable base, where expenses are submitted, to your QuickBooks account, eliminating manual data entry and ensuring financial records are always up-to-date. Who's this workflow for? Accountants & Bookkeepers Small Business Owners Finance Teams Operations Managers How it works 1. Trigger on New Expense: The workflow starts automatically when a new expense record is added to your Airtable base. 2. Filter for Approval: It checks if the expense's Status field is marked as "Approved". Unapproved items are ignored. 3. Create Expense in QuickBooks: For every approved item, the workflow creates a new expense record in QuickBooks, mapping data like amount, date, vendor, and accounts directly from Airtable. 4. Download and Upload Receipt: It downloads the receipt from the URL provided in Airtable and uploads it as an attachment to the corresponding expense record in QuickBooks. 5. Update Airtable Status: Once the expense and receipt are successfully logged in QuickBooks, the workflow updates the record's Status in Airtable to "Done", closing the loop. Setup Instructions 1. Airtable Configuration: Create an Airtable base with a table for your expenses. Ensure your table includes the following columns: Status, Receipt URL, Amount, Date, Memo, QBO Vendor ID, QBO Expense Account ID, and QBO Payment Account ID. Connect your Airtable account to n8n. In the Airtable Trigger, Search records, and Update record nodes, select your credentials and specify your Base ID and Table ID. 2. QuickBooks Configuration: Connect your QuickBooks account to n8n using OAuth2 credentials. In the QBO-Create Expense and QBO-Upload File nodes, replace {YOUR_QUICKBOOKS_COMPANY_ID} in the URL with your actual QuickBooks Company ID. Ensure the Vendor ID and Account IDs in your Airtable records correspond to valid IDs in your QuickBooks account. 3. Activate Workflow: Save the workflow and toggle the "Active" switch to ON. Your expense management is now fully automated! 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 Worflow Automation Click here- Get Started. An n8n automation workflow template by Intuz.
- 2 nodes
- 334 views
- Automation
By Fakhar Khan
How it works Receives chat messages from customers requesting table reservations. Uses an AI Agent with OpenAI Chat Model to understand and process requests. Checks table information, availability, and existing reservations from Google Sheets. Calculates guest counts and reservation timing using the Calculator node. Updates table availability and reservation records in real-time. Handles reservation changes, including updates and cancellations. Set up steps Add credentials** for OpenAI (Chat Model) and Google Sheets. In the AI Agent node, link: Chat Model → OpenAI Chat Model node. Memory → Simple Memory node. Tools → Calculator and Google Sheets nodes for reservation data handling. Configure Google Sheets nodes: Get Table Information (read sheet) Get Table Availability (read sheet) Get Table Reservations (read sheet) Update Table Availability (update sheet) Update Reservations (append sheet) Cancel Reservations (delete sheet) Ensure your sheets have consistent column names for table IDs, dates, times, and guest counts. Test by sending a reservation request through the chat trigger and verify updates in the Google Sheets. An n8n automation workflow template by Fakhar Khan.
- 4 nodes
- Automation
- AI
By Luis Acosta
🎧 Upload Podcast Episodes to Spotify via RSS & Google Drive Skip the manual steps and publish your podcast episodes to Spotify in minutes — fully automated. This workflow takes your finished audio, uploads it to Google Drive, updates your podcast’s RSS feed in GitHub, and pushes it live on Spotify and other platforms linked to that feed. No more copy-pasting links or manually editing XML files — everything happens in one click. It’s perfect for podcasters who already have an RSS feed connected to Spotify for Podcasters and want a repeatable, hands-free publishing process. 💡 What this workflow does ✅ Reads your finished MP3 from a local path or previous automation step ☁️ Uploads the audio to Google Drive and creates a public share link 📄 Fetches your existing rss.xml file from GitHub ➕ Appends a new <item> entry with title, description, publication date, and MP3 link 🔄 Commits the updated RSS file back to GitHub, triggering updates on Spotify 🎯 Ensures your episode appears on Spotify once your RSS is already linked in Spotify for Podcasters 🛠 What you’ll need A Google Drive account with OAuth credentials and a target folder ID A GitHub repository containing your rss.xml file An RSS feed connected to Spotify for Podcasters (set this up once before running the workflow) An MP3 file that meets Spotify’s audio format requirements ✨ Use cases Automate weekly or daily podcast publishing to Spotify Push your AI-generated podcast episodes live without manual editing Maintain a single source of truth for your feed in GitHub while streaming across multiple platforms 📬 Contact & Feedback Need help customizing this? Have ideas for improvement? 📩 Luis.acosta@news2podcast.com Or DM me on Twitter @guanchehacker If you’re building something more advanced with audio + AI, like fully automated podcast creation and publishing, let’s talk — I might have the missing piece you need. An n8n automation workflow template by Luis Acosta.
- 3 nodes
- Automation
By Avkash Kakdiya
How it works This workflow starts whenever you add a new company name to a Google Sheet. It checks if the company name is filled in, then uses AI to find more details about the company like industry, size, location, and website. Next, it looks for the company in your HubSpot CRM. If the company is not there, it adds it automatically. Finally, it updates the Google Sheet with all the new company information so you have everything organized in one place. Step-by-step 1. Start with Google Sheets The workflow watches your Google Sheet for new company names. It ignores any empty or incomplete entries. 2. Get Company Details Uses AI (OpenAI GPT-4o-mini) to find more information about the company. Formats the AI results so they can be used easily. 3. Check and Update HubSpot Searches your HubSpot CRM to see if the company already exists. If the company is new, it creates a record in HubSpot with the AI details. 4. Save Everything in Google Sheets Prepares the enriched data for saving. Adds or updates the company information in the Google Sheet for easy tracking. Why use this? Automatically adds useful company info without manual work. Keeps your CRM clean by avoiding duplicates. Stores all updated company details in one place for easy access. Runs smoothly in the background without you needing to do anything after setup. An n8n automation workflow template by Avkash Kakdiya.
- 3 nodes
- Automation
- AI
By Avkash Kakdiya
How it works This workflow automatically collects a list of companies from Google Sheets, searches for their competitors using SerpAPI, extracts up to 10 relevant competitor names with source links, and logs the results into both Google Sheets and Airtable. It runs on a set schedule, cleans and formats the company list, processes each entry individually, checks if competitors exist, and separates results into successful and “no competitors found” lists for organized tracking. Step-by-step 1. Trigger & Input Auto Run (Scheduled) – Executes every day at the set time (e.g., 9 AM). Read Companies Sheet – Pulls the list of companies from a Google Sheet (List column). Clean & Format Company List – Removes empty rows, trims names, and attaches row numbers for tracking. Loop Over Companies – Processes each company one at a time in batches. 2. Competitor Search Search Company Competitors (SerpAPI) – Sends a query like "{Company} competitors" to SerpAPI, retrieving structured search results in JSON format. 3. Data Extraction & Validation Extract Competitor Data from Search – Parses SerpAPI results to: Identify the company name Extract up to 10 competitor names Capture the top source URL Count total search results Has Competitors? – Checks if any competitors were found: Yes → Proceeds to logging No → Logs in “no results” list 4. Logging Results Log to Result Sheet – Appends or updates competitor data into the results Google Sheet. Log Companies Without Results – Records companies with zero competitors found in a separate section of the results sheet. Sync to Airtable – Pushes all results (successful or not) into Airtable for unified storage and analysis. Benefits Automated Competitor Research – Eliminates the need for manual Google searching. Daily Insights – Runs automatically at your chosen schedule. Clean Data Output – Stores structured competitor lists with sources for easy review. Multi-Destination Sync – Saves to both Google Sheets and Airtable for flexibility. Scalable & Hands-Free – Handles hundreds of companies without extra effort. An n8n automation workflow template by Avkash Kakdiya.
- 4 nodes
- Automation
By Oneclick AI Squad
This automated n8n workflow enables launching AWS EC2 instances directly from a Google Sheets document. Users can specify instance details (e.g., region, instance type, key pair) in a Google Sheet, triggering the workflow to create EC2 instances via the AWS API. The workflow updates the sheet with instance information and sends confirmation emails. Fundamental Aspects Google Sheets Trigger**: Initiates the workflow when a new row is added or updated in the Google Sheet. Extract Instance Details**: Parses region, instance type, key pair name, and instance name from the sheet. Validate Inputs**: Checks for required fields and valid AWS configurations. Launch EC2 Instance**: Uses the AWS EC2 API to launch the specified instance. Update Google Sheet**: Adds instance ID and status to the sheet. Send Confirmation Email**: Notifies the user via email with instance details. Setup Instructions Import the Workflow into n8n**: Download the workflow JSON and import it via the n8n interface. Configure API Credentials**: Set up Google Sheets API credentials with appropriate permissions. Configure AWS IAM credentials with EC2 launch permissions. Configure SMTP credentials for email notifications. Prepare Google Sheet**: Create a sheet with columns for region, instance type, key pair name, instance name, instance ID, and status. Run the Workflow**: Activate the Google Sheets trigger and test by adding a row with instance details. Verify Responses**: Check the Google Sheet for updated instance IDs and emails for confirmation. Adjust Parameters**: Fine-tune AWS region settings or email templates as needed. Technical Dependencies Google Sheets API**: For reading and writing data. AWS EC2 API**: For launching and managing instances. SMTP Service**: For sending confirmation emails. n8n**: For workflow automation and integration. Customization Possibilities Add Instance Types**: Support additional EC2 instance types. Enhance Validation**: Add checks for AWS limits or quotas. Support Tags**: Include custom tags for launched instances. Add Logging**: Integrate with a logging service for workflow tracking. Customize Emails**: Adjust email content or add attachments. An n8n automation workflow template by Oneclick AI Squad.
- 2 nodes
- Automation
By Oneclick AI Squad
This automated n8n workflow enables the creation and management of AWS RDS databases through email interactions. Users can send emails with commands such as "Create RDS" or "Delete RDS," including details like database engine, instance class, and credentials. The workflow parses the email, uses Terraform to execute the requested action on AWS RDS, updates a Google Sheet with the status, and sends a confirmation email. Fundamental Aspects Gmail Trigger**: Initiates the workflow upon receiving a new email in Gmail. Parse Email Content**: Analyzes the email body to extract the command (create or delete) and database details like region, identifier, engine, and credentials. Manage RDS Instance**: Executes Terraform commands to create or delete the AWS RDS database instance based on the parsed details. Wait For Data**: Pauses the workflow to allow time for the RDS operation to complete and data to become available. Update Google Sheet**: Appends or updates the Google Sheet with the database instance details, status, and any relevant IDs. Send Confirmation Email**: Formats and sends a response email confirming the action taken, including success/failure details. Setup Instructions Import the Workflow into n8n**: Download the workflow JSON and import it via the n8n interface. Configure API Credentials**: Set up Gmail API credentials for email triggering and sending. Configure AWS credentials with RDS management permissions. Set up Google Sheets API credentials with read/write access. Ensure Terraform is integrated or nodes are configured for Terraform execution. Prepare Google Sheet**: Create a sheet with columns for database identifier, engine, instance class, status, and other relevant fields. Run the Workflow**: Activate the Gmail trigger and test by sending an email with a create or delete command. Verify Responses**: Check the Google Sheet for updates and your email for confirmation messages. Adjust Parameters**: Fine-tune Terraform variables, email parsing logic, or wait times as needed. Columns For The Google Sheet: Database Identifier: Unique identifier for the RDS instance (e.g., var.db_identifier). Engine: Database engine type (e.g., MySQL, PostgreSQL) (e.g., var.db_engine). Instance Class: RDS instance class (e.g., var.instance_class) (e.g., db.t3.micro). Allocated Storage: Storage size in GB (e.g., var.allocated_storage) (e.g., 20). Region: AWS region for the instance (e.g., var.aws_region) (e.g., us-east-1). Username: Database admin username (e.g., var.db_username) (e.g., admin). Password: Database admin password (e.g., var.db_password) (e.g., SecurePassword123). Status: Current status of the RDS instance (e.g., creating, deleted). Database Name: Name or tag for the database (e.g., var.db_name) (e.g., MyRDSDatabase). Technical Dependencies Gmail API**: For receiving trigger emails and sending confirmations. AWS RDS API**: For database management (via Terraform). Google Sheets API**: For logging and updating database status. Terraform**: For infrastructure-as-code management of RDS instances. n8n**: For workflow automation and node integrations. Customization Possibilities Support Additional Commands**: Extend to include update or snapshot operations for RDS instances. Enhance Parsing**: Improve email content analysis with AI for better intent detection. Add Database Engines**: Include support for more RDS engines like Oracle or SQL Server. Integrate Monitoring**: Add nodes to monitor RDS performance and alert via email. Customize Sheets**: Modify sheet columns or add visualizations for database metrics. Security Enhancements**: Incorporate additional validation for sensitive credentials in emails. Want a tailored workflow for your business? Our experts can craft it quickly Contact our team. An n8n automation workflow template by Oneclick AI Squad.
- 3 nodes
- Automation
By Intuz
This n8n template from Intuz provides a complete and automated solution for full-cycle invoicing, orchestrating a seamless flow between Airtable, QuickBooks, and Stripe. This is the ultimate sales-to-cash automation. When a deal in Airtable is marked "Approved for Invoicing," this workflow intelligently syncs customer data across QuickBooks and Stripe (creating them if they don't exist), generates an official QuickBooks invoice, creates a Stripe payment link, and then updates the original Airtable record with all the new IDs and links. Eliminate manual data entry and keep your systems perfectly in sync. Who's this workflow for? Finance, Accounting, and Operations Teams SalesOps and RevOps Teams Small Business Owners and Founders Agencies and Freelancers How It Works: 1. Airtable Trigger & Approval Gate: The workflow starts when a record in your Airtable base is updated. An If node immediately checks if the Status field is set to "Approved for Invoicing." If not, the workflow for that item stops. 2. Customer Sync (QuickBooks & Stripe): The workflow searches for the customer in both QuickBooks and Stripe using the details from Airtable. Using If nodes, it intelligently checks if the customer exists. If a customer is not found in either platform, it creates a new one. This "find-or-create" logic prevents duplicate records. 3. Update Airtable with IDs: Once the customer IDs from both QuickBooks and Stripe are secured (either found or newly created), the workflow updates the original Airtable record with these new IDs for future reference. 4. Generate Financials: Stripe Payment Link: It sends an HTTP request to Stripe to create a unique, ready-to-use payment link for the specified amount. QuickBooks Invoice: It fetches your product list from QuickBooks, finds the matching item from the Airtable record, and generates a formal, detailed invoice. 5. Close the Loop: In the final step, the workflow updates the Airtable record one last time to: Add the QuickBooks Invoice #. Add the Stripe Payment Link. Change the Status to "Invoiced." Step-by-Step Setup Instructions This is an advanced workflow. Follow these setup steps carefully. 1. Connect Your Credentials Airtable: Create and connect a Personal Access Token with data.records:read and data.records:write scopes. QuickBooks: Connect your QuickBooks Online account using OAuth2 credentials. Stripe: Connect your Stripe account using your Secret Key. 2. Airtable Base Setup (Crucial) Your Airtable base must have a table with the following columns. The names must match exactly: Deal Name (Text) Client Name (Text) Client Email (Email) Status (Single-select with options: Draft, Approved for Invoicing, Invoiced) QuickBooks Customer ID (Text) Stripe Customer ID (Text) Stripe Payment Link (URL) QuickBooks Invoice # (Text) Stripe Price Id (Text - The API ID of your price in Stripe, e.g., price_123...) Quantity (Number) Quickbooks Product Name (Text) Created (Created Time) - This is used by the trigger. 3. Configure the n8n Nodes All Airtable Nodes: In each Airtable node, select your Base and Table from the dropdown lists. Get all Quickbook products (HTTP Request Node): You must replace {YOUR_QUICKBOOKS_COMPANY_ID} in the URL with your actual QuickBooks Company ID (also known as a Realm ID). 4. Activate the Workflow Save the workflow and toggle the Active switch to "on". The workflow will now trigger whenever the Created field is updated for a record in your Airtable base. Customization Guidance Changing the Trigger Status: If you use a different status than "Approved for Invoicing," simply update the value in the "IF - Status Check" node. Modifying Invoice Details: You can customize the Description or other line item details in the "Create an invoice" (QuickBooks) node by pulling more fields from your Airtable record. Adding Email Notifications: To notify a customer when their invoice is ready, add a Gmail or SendGrid node after the last Airtable Update node. You can include the Stripe Payment Link and a PDF of the QuickBooks invoice directly in the email. Advanced Error Handling: For a production environment, consider connecting the false output of the various IF nodes or using the .onError() workflow setting to send a Slack or email alert if a customer can't be found or an API call fails. Support For further support, or to develop a custom workflow, reach out to: 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 Worflow Automation Click here- Get Started. An n8n automation workflow template by Intuz.
- 5 nodes
- 1,406 views
- Automation
By Rahul Joshi
Description: Automate your personal email management with this AI-powered inbox triage system built entirely in n8n. This template connects Gmail, Azure OpenAI (GPT-4o-mini), and Notion to classify, summarize, and store your incoming emails—helping you focus only on what matters. The workflow fetches unread emails from Gmail, runs them through a custom AI classification model (Important, Ignore, Delegate, Reply Later), creates clear summaries, and stores the results in Notion for future reference. No more clutter—your inbox is automatically sorted, prioritized, and documented. ✅ What This Template Does (Step-by-Step): 📧 Fetch Unread Emails from Gmail Retrieves only unread, inbox-labeled emails via Gmail API. Captures sender, subject, and email content for processing. 🔄 Split Emails for Individual Process- ing Breaks down bulk email retrieval into single-item batches for parallel AI classification. ✏️ Clean & Structure Email Data Extracts subject, sender, and message text. Removes unnecessary metadata for cleaner AI inputs. 🤖 AI Classification with Azure OpenAI (GPT-4o-mini) Categorizes emails into Important, Ignore, Delegate, or Reply Later. Uses a precise, prompt-engineered LLM chain for consistent results. 📊 Generate Clear, Actionable Summaries Combines classification and key email details into concise summaries. 📈 Aggregate Results into a Digest Merges all processed email summaries into a batch report. 🗂 Store Insights in Notion Saves structured summaries and classifications into a Notion page for easy tracking and retrieval. 🎯 Perfect For: Busy professionals who want a clutter-free inbox. Founders & executives managing high email volume. Remote teams needing quick email triage and visibility. Productivity enthusiasts looking to integrate AI into their workflow. ⚙️ Built With: Gmail API (email retrieval) n8n Split In Batches (parallel processing) Azure OpenAI GPT-4o-mini (classification & summarization) Notion API (data storage & archiving) 🌟 Key Benefits: ✅ Saves hours of manual email triage. 🔍 Ensures no important emails are missed. 🧠 AI-driven, consistent prioritization. 📒 Centralized email intelligence in Notion. 🛠 Fully no-code and customizable. An n8n automation workflow template by Rahul Joshi.
- 5 nodes
- Automation
- AI
By Oneclick AI Squad
This automated n8n workflow transforms uploaded radiology images into professional, patient-friendly PDF reports. It uses AI-powered image analysis to interpret medical scans, simplify technical terms, and produce clear explanations. The reports are formatted, converted to PDF, stored in a database, and sent directly to patients via email, ensuring both accuracy and accessibility. 🏥 Workflow Overview: Simple Process Flow: Upload Image → 2. AI Analysis → 3. Generate Report → 4. Send to Patient 🔧 How It Works: Webhook Trigger - Receives image uploads via POST request Extract Image Data - Processes patient info and image data AI Image Analysis - Uses GPT-4 Vision to analyze the radiology image Process Analysis - Structures the AI response into readable sections Generate PDF Report - Creates a beautiful HTML report Convert to PDF - Converts HTML to downloadable PDF Save to Database - Logs all reports in Google Sheets Email Patient - Sends the report via email Return Response - Confirms successful processing 📊 Key Features: AI-Powered Analysis** using GPT-4 Vision Patient-Friendly Language** (no medical jargon) Professional PDF Reports** with clear sections Email Delivery** with report attachment Database Logging** for record keeping Simple Webhook Interface** for easy integration 🚀 Usage Example: Send POST request to webhook with: { "patient_name": "John Smith", "patient_id": "P12345", "scan_type": "X-Ray", "body_part": "Chest", "image_url": "https://example.com/xray.jpg", "doctor_name": "Dr. Johnson", "patient_email": "john@email.com" } ⚙️ Required Setup: OpenAI API - For GPT-4 Vision image analysis PDF Conversion Service - HTML to PDF converter Gmail Account - For sending reports Google Sheets - For logging reports Replace YOUR_REPORTS_SHEET_ID with your actual sheet ID Want a tailored workflow for your business? Our experts can craft it quickly Contact our team. An n8n automation workflow template by Oneclick AI Squad.
- 4 nodes
- Automation
By Patrik Schick
How it works Every hour, the workflow checks the RSS feed https://www.artificialintelligence-news.com/feed/ for new articles. For each new item, it extracts the title, snippet, and full content, then sends them to an AI model to summarize and optionally translate. The processed summary is passed to another AI model (with a personalized “Patrik” assistant tone) to generate a newsletter-style text. Finally, the result is saved as a draft email in Gmail, ready to review and send. How to use Set your preferred language in the Information Extractor system prompt. Update the RSS feed URL if you want to pull articles from a different source. Customize the assistant tone in the Message a model node for your newsletter style. Connect your Gmail account to the Create a draft node. Activate the workflow — every hour it will fetch new articles, generate newsletter content, and save them as Gmail drafts. Customising this workflow Change the source: Replace the RSS feed URL in the RSS Feed Trigger node. Language & length: Edit the system prompt in the Information Extractor to set your preferred language and summary style. Tone & format: Adjust the Message a model node to define the assistant’s personality, structure (headlines, bullets, CTA), or output as HTML. Email settings: Change the subject, sender, or draft folder in the Create a draft node. Frequency: Modify the trigger schedule to run daily, weekly, or at custom intervals. An n8n automation workflow template by Patrik Schick.
- 4 nodes
- Automation
- AI
By Vlad Arbatov
Summary Send a number to your Telegram bot (e.g., 2) and get a neatly formatted digest of all Gmail newsletters received since that date. Each email is summarized by an LLM into concise topics, merged into a single Telegram message, automatically split into chunks to fit Telegram limits, and safely formatted as HTML. What this workflow does Triggers on your Telegram message containing a number of days, e.g., 1, 2, 7 Fetches all Gmail messages since that date using a custom search query, optionally filtered by senders Retrieves and decodes each email’s HTML, subject, sender name, date Prompts an LLM (GPT‑4.1‑mini) to produce a consistent JSON summary of topics per email Merges topics from all emails into a single digest Builds a readable, enumerated message (with bold titles) Splits it into 3 500‑char parts and sanitizes Markdown to Telegram‑safe HTML Sends the digest to your Telegram chat with preview disabled Apps and credentials Gmail OAuth2: Gmail account Telegram: Telegram account (bot) OpenAI: OpenAi account Typical use cases Personal or team daily/weekly newsletter digests in Telegram Curated feeds from selected senders compiled on demand Lightweight knowledge briefings without leaving Telegram How it works (node-by-node) Telegram Trigger Waits for your message (e.g., "2"). Chat ID is restricted to your Telegram ID for safety. Get days (Code) Takes the numeric daysAgo from the Telegram message text Computes YYYY/MM/DD for Gmail’s after: filter Get many messages (Gmail → getAll, returnAll: true) Uses a custom q filter like: =(from:@.com) OR (from:@.com) OR (from:@.com -"__") after:{{ $json.dateString }} Returns a list of message IDs Loop Over Items (Split in Batches) Iterates through each message ID Get a message (Gmail → get) Retrieves the full message/payload for the current email Get message data (Code) Extracts HTML from Gmail’s payload (body/parts) Normalizes sender to just the name Formats the date as DD.MM.YYYY Passes html, subject, from, date forward Clean (Code) Converts DD.MM.YYYY → MM.DD (for prompt brevity) Passes html, subject, from, date to the LLM Message a model (OpenAI, model: gpt‑4.1‑mini, JSON output) Prompt instructs: Produce JSON: { "topics": [ { "title", "descr", "subject", "from", "date" } ] } Split multi-news blocks into separate topics Combine or ignore specific blocks for particular senders (placeholders __) Keep subject untranslated; other values in __ language Injects subject/from/date/html from the current email Loop Over Items (continues) After all iterations complete, the aggregated per-email results are available Merge (Code) Flattens the topics arrays from all processed emails into one combined topics list Create TG message (Code) Renders an enumerated list: 1. Title (bold) Short description Original subject From — Date Split (Code) Splits into 3 500‑character chunks to stay below Telegram’s 4 096 limit with HTML overhead Sanitize (Code) Escapes &, <, > Fixes unbalanced * and _ Converts basic Markdown markers to Telegram HTML Send a message (Telegram) Sends each part with parse_mode=HTML, previews disabled Node map | Node | Type | Purpose | |---|---|---| | Telegram Trigger | Trigger | Receive daysAgo command from Telegram | | Get days | Code | Compute Gmail after:YYYY/MM/DD from daysAgo | | Get many messages | Gmail (getAll) | Search emails since date with custom from: filters | | Loop Over Items | Split in Batches | Iterate messages one-by-one | | Get a message | Gmail (get) | Fetch full message payload | | Get message data | Code | Extract HTML/subject/from/date; normalize sender and date | | Clean | Code | Reformat date and forward fields to LLM | | Message a model | OpenAI | Summarize email into JSON topics | | Merge | Code | Merge topics from all emails | | Create TG message | Code | Build human-friendly digest text | | Split | Code | Chunk into 3 500‑char parts | | Sanitize | Code | Escape HTML and map Markdown to Telegram HTML | | Send a message | Telegram | Deliver digest to Telegram chat | Before you start Create a Telegram bot and get its token (via @BotFather) Get your Telegram user ID to restrict access Connect Gmail OAuth2 in n8n Add your OpenAI API key Import the provided workflow JSON into n8n Setup instructions 1) Telegram Telegram Trigger node: additionalFields.chatIds = your Telegram user ID Send a message node: chatId = your Telegram user ID parse_mode = HTML disable_web_page_preview = true 2) Gmail Connect a Gmail OAuth2 credential (Gmail account) In Get many messages, adjust filters.q to your senders and rules: Example: =(from:news@publisher.com) OR (from:briefs@media.com -"promo") after:{{ $json.dateString }} If needed, add label: or category: filters 3) OpenAI Message a model: Model: gpt‑4.1‑mini (can swap to gpt‑4o‑mini or your preferred) Update the prompt placeholders: __ language → your target language __ sender rules → your special cases (combine blocks, ignore sections) 4) Safety and formatting Keep parse_mode=HTML in Telegram The Sanitize node is designed for ` and ` only; avoid other HTML tags The Split node uses 3 500 chars per part to stay safe under Telegram limits How to use In Telegram, send a number indicating “days ago” Example: 2 → will query Gmail after the date 2 days ago The workflow compiles and returns a digest in your chat Rerun anytime with a new number Customization ideas Labels instead of global search: q = label:Newsletters after:{{ $json.dateString }} Time window control: add before: or exact date ranges Different language: set the __ language in the LLM prompt Model choice: swap to cheaper/faster models if volume is high Chunk size: adjust from 3 500 to your needs Formatting: tweak Create TG message to include links parsed from HTML (if you add an HTML parser step) Limits and notes Telegram messages are limited to ~4 096 characters; we chunk to 3 500 per part Gmail “after:” uses YYYY/MM/DD and Google’s interpretation of dates; your n8n server time influences the computed date LLM usage incurs cost and latency proportional to email size and count HTML extraction is robust for typical Gmail structures but may need tweaks for exotic MIME layouts Privacy and safety Emails are sent to OpenAI for summarization—ensure that’s acceptable for your data policies The Telegram Trigger restricts chat access; keep your chatIds locked down Avoid sending raw HTML to Telegram; rely on the Sanitize node Sample output format (Telegram) Bold topic title One-sentence description Original Subject Line → Sender Name — DD.MM.YYYY Next topic title ... Tips and troubleshooting Got empty digests? Check Gmail filters.q and make sure there really are emails after the computed date Model errors or empty JSON? Lower prompt complexity or switch model HTML formatting issues in Telegram? Ensure parse_mode=HTML and keep only `, ` Long messages not fully delivered? Reduce chunk size from 3 500 Tags gmail, telegram, openai, llm, newsletters, digest, summarization, automation Changelog v1: Initial release with sender filters, topic merging, Telegram HTML sanitization, and on-demand time window via Telegram message. An n8n automation workflow template by Vlad Arbatov.
- 4 nodes
- Automation
- AI
By Oneclick AI Squad
This n8n workflow monitors blood stock levels daily and sends alerts when availability is low. It fetches data from a Google Sheet, checks stock status, and notifies via WhatsApp. Key Features Daily Monitoring**: Checks blood stock every day. Automated Alerts**: Sends notifications when stock is low. Real-Time Updates**: Uses live data from Google Sheets. Efficient Delivery**: Alerts sent instantly via WhatsApp. Continuous Check**: Loops to ensure ongoing monitoring. Workflow Process Daily Check Blood Stock: Triggers the workflow daily. Fetch Blood Stock: Reads data from a Google Sheet. Get All Stock: Collects all available blood stock details. Check Stock Availability: Analyzes stock levels for low thresholds. Send Alert Message: Sends WhatsApp alerts if stock is low. Sheet Columns Blood Type**: Type of blood (e.g., A+, O-). Quantity**: Current stock amount. Threshold**: Minimum acceptable stock level. Last Updated**: Date and time of last update. Status**: Current status (e.g., Low, Sufficient). Setup Instructions Import Workflow**: Add the workflow to n8n via the import option. Configure Sheet**: Set up a Google Sheet with blood stock data. Set Up WhatsApp**: Configure WhatsApp API credentials in n8n. Activate**: Save and enable the workflow. Test**: Simulate low stock to verify alerts. Requirements n8n Instance**: Hosted or cloud-based n8n setup. Google Sheets**: Access with stock data. WhatsApp API**: Integration for sending alerts. Admin Access**: For monitoring and updates. Customization Options Adjust Threshold**: Change low stock limits. Add Channels**: Include email or SMS alerts. Update Frequency**: Modify daily trigger time. An n8n automation workflow template by Oneclick AI Squad.
- 3 nodes
- Automation
By Genzi
Description A comprehensive real estate chatbot automation system that handles customer inquiries, property searches, and appointment scheduling through intelligent conversation flows and email processing. How it works? This template creates an end-to-end real estate automation system that handles customer inquiries from initial contact through appointment booking. 1. Customer Entry Point Webhook receives customer messages from chat interface Link detection checks if customer shared property URLs Smart routing - if property link found, fetch details immediately; otherwise proceed to chat 2. AI Content Processing Content filter (PRIORITY) - blocks non-real estate queries upfront Information extraction - scans messages for personal details and property requirements Human handoff detection - identifies requests for live agent assistance 3. Data Collection Phase Sequential gathering: Personal info (name → phone → email) then property needs Smart validation - phone format, email structure, budget parsing No redundancy - never asks for information already provided PostgreSQL storage - saves customer data and conversation memory 4. Property Search & Matching Database query filters properties by type, location, budget, availability Image enhancement - fetches property photos from media storage Results ranking - returns top 5 matches sorted by price 5. AI Response Generation GPT-4 formatting creates engaging, professional property listings Visual enhancement - includes property images and key details Personalized tone - acknowledges customer preferences 6. Appointment Automation Gmail monitoring - checks for appointment confirmations every hour Calendar integration - creates, updates, deletes appointments automatically Smart scheduling - checks availability, suggests alternatives for conflicts Email responses - sends confirmations and follow-ups Intelligence Features Context Awareness Remembers conversation history across sessions Builds complete customer profile progressively Maintains property preferences throughout interaction Smart Extraction Recognizes property types: HDB, Condo, Apartment Parses locations and MRT preferences automatically Handles various budget formats (SGD 2,500, $2500, etc.) Identifies timeline requirements and citizenship status Professional Handoffs Detects human agent requests with keyword matching Collects complete customer context before transfer Sends structured handoff emails with all requirements Ensures smooth transition to live agents Technical Components AI Models OpenAI GPT-4 - Main conversation handling and response formatting GPT-4 Mini - Appointment processing and email management LangChain Memory - Conversation context retention Database Integration PostgreSQL - Customer data, property listings, conversation history Property search with multi-criteria filtering Media storage integration for property images Communication Channels Webhook API - Primary chat interface Gmail integration - Appointment confirmations and notifications Google Calendar - Automated scheduling and availability checking Setup Requirements Configure database - PostgreSQL with property and customer tables Set up integrations - Gmail, Google Calendar, OpenAI API Customize prompts - Adjust AI responses for your brand Test workflow - Verify end-to-end functionality Monitor performance - Track conversation success rates The system is designed to handle the complete customer journey from initial inquiry to scheduled property viewing, with intelligent automation reducing manual work while maintaining high service quality. An n8n automation workflow template by Genzi.
- 6 nodes
- Automation
- AI
By Oneclick AI Squad
This n8n workflow monitors medical equipment usage by reading data daily at 6 AM from a Google Sheet, processes alerts for maintenance or calibration, and sends notifications to technicians and supervisors. Good to Know Runs daily at 6 AM via cron trigger. Requires Google Sheet with equipment data. Sends alerts via email and WhatsApp. Logs all activities in the Google Sheet. Google Sheet Structure Sheet: A: Equipment ID | B: Equipment Name | C: Last Maintenance Date | D: Usage Hours E: Calibration Due | F: Status | G: Technician Email | H: Supervisor Email | I: Last Alert Date Sample Data: E001 | MRI Machine | 2025-07-01 | 150 | 2025-08-15 | Active | tech1@hospital.com | sup1@hospital.com | 2025-08-01 E002 | X-Ray Unit | 2025-06-15 | 200 | 2025-08-10 | Overdue | tech2@hospital.com | sup2@hospital.com | 2025-08-05 How It Works Daily Equipment Check (6 AM)** - Triggers the workflow. Read Equipment Data** - Fetches data from Google Sheet. Process Equipment Alerts** - Identifies maintenance needs. Task Break For 5 Sec** - Adds a delay for processing. Filter Equipment with Alerts** - Filters equipment needing attention. Send Technician Email** - Notifies technicians via email. Send Message (message: send)** - Sends WhatsApp alerts to technicians. Send Critical Alert to Supervisors** - Escalates critical issues via email and WhatsApp. Filter Overdue Equipment** - Identifies overdue maintenance. Update Equipment Status** - Updates sheet with new statuses. Log Maintenance Alerts** - Logs alerts in the sheet. How to Use Import workflow JSON into n8n. Configure nodes with Google Sheet ID, email, and WhatsApp API credentials. Add equipment data to the Google Sheet. Test manually, then activate for daily runs. Requirements Google Sheet with specified structure. Google service account credentials. Email SMTP setup (e.g., Gmail). WhatsApp Business API token. n8n instance. Customizing This Workflow Adjust cron time for different schedules. Modify alert thresholds in the Process Equipment Alerts node. Update notification templates in email and WhatsApp nodes. Extend filters for additional equipment statuses. Want a tailored workflow for your business? Our experts can craft it quickly Contact our team. An n8n automation workflow template by Oneclick AI Squad.
- 4 nodes
- Automation
By WeblineIndia
🌡 IoT Sensor Data Cleaner + InfluxDB Logger (n8n | Webhook | Function | InfluxDB) This workflow accepts raw sensor data from IoT devices via webhook, applies basic cleaning and transformation logic, and writes the cleaned data to an InfluxDB instance for time-series tracking. Perfect for renewable energy sites, smart farms and environmental monitoring setups using dashboards like Grafana or Chronograf. ⚡ Quick Implementation Steps Import the workflow JSON into your n8n instance. Edit the Set Config node to include your InfluxDB credentials and measurement name. Use the webhook URL (/webhook/sensor-data) in your IoT device or form to send sensor data. Start monitoring your data directly in InfluxDB! 🎯 Who’s It For IoT developers and integrators. Renewable energy and environmental monitoring teams. Data engineers working with time-series data. Smart agriculture and utility automation platforms. 🛠 Requirements | Tool | Purpose | |------|---------| | n8n Instance | For automation | | InfluxDB (v1 or v2) | To store time-series sensor data | | IoT Device or Platform | To POST sensor data | | Function Node | To filter and transform data | 🧠 What It Does Accepts JSON-formatted sensor data via HTTP POST. Validates the data (removes invalid or noisy readings). Applies transformation (rounding, timestamp formatting). Pushes the cleaned data to InfluxDB for real-time visualization. 🧩 Workflow Components Webhook Node:** Exposes an HTTP endpoint to receive sensor data. Function Node:** Filters out-of-range values, formats timestamp, rounds data. Set Node:** Stores configurable values like InfluxDB host, user/pass, and measurement name. InfluxDB Node:** Writes valid records into the specified database bucket. 🔧 How To Set Up – Step-by-Step Import Workflow: Upload the provided .json file into your n8n workspace. Edit Configuration Node: Update InfluxDB connection info in the Set Config node: influxDbHost, influxDbDatabase, influxDbUsername, influxDbPassword measurement: What you want to name the data set (e.g., sensor_readings) Send Data to Webhook: Webhook URL: https://your-n8n/webhook/sensor-data Example payload: { "temperature": 78.3, "humidity": 44.2, "voltage": 395.7, "timestamp": "2024-06-01T12:00:00Z" } View in InfluxDB: Log in to your InfluxDB/Grafana dashboard and query the new measurement. ✨ How To Customize | Customization | Method | |---------------|--------| | Add more fields (e.g., wind_speed) | Update the Function & InfluxDB nodes | | Add field/unit conversion | Use math in the Function node | | Send email alerts on anomalies | Add IF → Email branch after Function node | | Store in parallel in Google Sheets | Add Google Sheets node for hybrid logging | ➕ Add‑ons (Advanced) | Add-on | Description | |--------|-------------| | 📊 Grafana Integration | Real-time charts using InfluxDB | | 📧 Email on Faulty Data | Notify if voltage < 0 or temperature too high | | 🧠 AI Filtering | Add OpenAI or TensorFlow for anomaly detection | | 🗃 Dual Logging | Save data to both InfluxDB and BigQuery/Sheets | 📈 Use Case Examples Remote solar inverter sends temperature and voltage via webhook. Environmental sensor hub logs humidity and air quality data every minute. Smart greenhouse logs climate control sensor metrics. Edge IoT devices periodically report health and diagnostics remotely. 🧯 Troubleshooting Guide | Issue | Cause | Solution | |-------|-------|----------| | No data logged in InfluxDB | Invalid credentials or DB name | Recheck InfluxDB values in config | | Webhook not triggered | Wrong method or endpoint | Confirm it is a POST to /webhook/sensor-data | | Data gets filtered | Readings outside valid range | Check logic in Function node | | Data not appearing in dashboard | Influx write format error | Inspect InfluxDB log and field names | 📞 Need Assistance? Need help integrating this workflow into your energy monitoring system or need InfluxDB dashboards built for you? 👉 Contact WeblineIndia | Experts in workflow automation and time-series analytics. An n8n automation workflow template by WeblineIndia.
- 1 nodes
- Automation
By Oneclick AI Squad
This automated n8n workflow reads patient data from Google Sheets daily at 8 AM, sends email and WhatsApp reports to doctors, alerts staff for critical patients, and logs activities back to sheets. Good to Know Runs daily at 8 AM via cron trigger. Filters active patients only. Requires Google service account, Gmail app password, and WhatsApp API token. Logs all sent reports in a dedicated sheet. How It Works Cron Trigger** - Schedules daily run at 8 AM. Google Sheets (Read)** - Fetches patient data from "Patients" sheet. Filter Node** - Selects active patients. Code Node** - Processes data, creates report content, checks for critical conditions. Email Send Node** - Sends reports to doctors via Gmail. HTTP Request Node** - Sends WhatsApp messages. Filter Critical** - Identifies critical patients. Critical Alert Email** - Notifies hospital staff. Google Sheets (Write)** - Logs reports to "Reports_Log" sheet. Google Sheet Structure Sheet 1: A: Patient ID | B: Patient Name | C: Age | D: Current Condition E: Temperature | F: Blood Pressure | G: Heart Rate | H: Current Medication I: Doctor Email | J: Doctor WhatsApp | K: Priority | L: Status | M: Last Updated Sample Data: P001 | John Doe | 45 | Stable | 98.6 | 120/80 | 72 | Aspirin | dr@hospital.com | +1234567890 | Normal | Active | 2024-01-15 P002 | Jane Smith | 32 | Fever | 101.8 | 130/85 | 88 | Tylenol | dr2@hospital.com | +1987654321 | Critical | Active | 2024-01-15 Sheet 2: A: Report Date | B: Patient ID | C: Patient Name | D: Status | E: Sent How to Use Import workflow JSON into n8n. Configure nodes with Google credentials, sheet ID, Gmail app password, WhatsApp token. Add patients to Google Sheet with "Active" status. Test manually, then activate for daily runs. Requirements Google Sheet with specified structure. Google Cloud service account JSON. Gmail with 2FA and app password. WhatsApp Business API token. n8n instance. Customizing This Workflow Adjust cron expression for different schedule. Modify Code Node for custom report formats or critical thresholds. Update email/WhatsApp nodes for additional recipients or templates. Extend filters for more patient statuses. An n8n automation workflow template by Oneclick AI Squad.
- 4 nodes
- Automation
By Oneclick AI Squad
This automated n8n workflow automates AWS S3 bucket and file operations (create, delete, upload, download, copy, list) by parsing simple email commands and sending back success or error confirmations. Good to Know The workflow processes email requests via a Start Workflow (GET Request) node. Data extraction from emails identifies S3 operation commands. Error handling is included for invalid or missing email data. Responses are sent via email for each action performed. How It Works Start Workflow (GET Request)** - Captures incoming email requests. Extract Data from Email** - Parses email content to extract S3 operation commands. Check Task Type** - Validates the type of task (e.g., create bucket, delete file). Create a Bucket** - Creates a new S3 bucket. Delete a Bucket** - Deletes an existing S3 bucket. Copy a File** - Copies a file within S3. Delete a File** - Deletes a file from S3. Download a File** - Downloads a file from S3. Upload a File** - Uploads a file to S3. Get Many Files** - Lists multiple files in a bucket. Check Success or Fail** - Determines the outcome of the operation. Send Success Email** - Sends a success confirmation email. Send Failed Email** - Sends a failure notification email. How to Use Import the workflow into n8n. Configure the Start Workflow (GET Request) node to receive email commands. Test the workflow with sample email commands (e.g., "create bucket: my-bucket", "upload file: document.pdf"). Monitor email responses and adjust command parsing if needed. Example Email for Testing List files from the bucket json-test in Mumbai region. Requirements AWS S3 credentials configured in n8n. Email service integration (e.g., SMTP settings). n8n environment with workflow execution permissions. Customizing This Workflow Adjust the Extract Data from Email node to support additional command formats. Modify the Send Success Email or Send Failed Email nodes to customize messages. Update the S3 nodes to include additional bucket or file attributes. An n8n automation workflow template by Oneclick AI Squad.
- 3 nodes
- Automation
By WeblineIndia
YouTube Transcription, Summarization & Translation to Google Docs This workflow automates the end-to-end process of converting YouTube videos into structured, multilingual written content. It transcribes the video's speech, optionally summarizes it, translates it into the chosen language and stores the result in a well-formatted Google Doc—ready for review, sharing or publication. Who’s It For Content creators and bloggers repurposing video content. Educators and researchers converting lectures into readable notes. Marketing teams localizing video material for international audiences. Students summarizing and translating study material. YouTube viewers who want written notes or blog-ready formats. How It Works A Webhook triggers the flow with inputs: youtube_url, language and enable_summary. A Code node formats these inputs into videoId, originalUrl, language and enable_summary. An HTTP Request node sends the video to Supadata API for full transcription. Another Code node combines all transcript segments into one body of text. The Basic LLM Chain node uses the Google Gemini Chat Model to summarize and translate the transcript if requested. A Google Docs node creates a new document with a title based on videoId and language. A final Google Docs node appends the processed summary and translation into the created document. How to Set Up Webhook Input: Send a POST request with three fields: youtube_url, language, enable_summary. Configure Supadata API: Add the HTTP URL and Authorization Header for transcription. Set up Gemini Chat Model: Use Google Vertex AI/Gemini integration in the Basic LLM Chain node. Create Google Docs Credentials: Connect your Google account using OAuth2. Document Naming Logic: You may adjust document titles using expressions (e.g., {{ videoId }} - {{ language }}). Requirements Supadata API key (or any video-to-text API). Google account with Google Docs access. Google Gemini access via n8n’s LLM integration. n8n Cloud or self-hosted instance. Basic understanding of webhook setup (or a form frontend). How to Customize Change LLM model:** Swap Gemini with GPT-4 or Claude in the LLM Chain node. Summarization toggle:** Use the enable_summary flag to control verbosity. Document layout:** Customize headings, font styles and content sections in Google Docs. Multiple languages:** Extend the workflow to translate into multiple languages and generate one document per language. Sharing options:** Add Gmail or Slack nodes to notify users once the document is generated. Add‑ons Notion Export:** Send the document summary directly into Notion using the Notion node. Slack Notification:** Notify your team with a link to the Google Doc using the Slack node. Google Sheets Logging:** Log video URLs, timestamps, and language used for auditing. n8n Forms Integration:** Allow users to submit video URLs and language via a hosted n8n form. Use Case Examples Repurposing Videos into Blogs:** Automatically convert YouTube podcasts into multilingual blog posts. Educational Notes:** Extract and translate lecture content into shareable study documents. International Marketing Teams:** Summarize and localize product explainer videos for different countries. Transcription Library:** Create a searchable database of translated transcripts from niche educational YouTube channels. Common Troubleshooting | Issue | Possible Cause | Solution | | ------------------------------- | ------------------------------------------ | ---------------------------------------------------------- | | Webhook not triggering | Incorrect webhook URL or POST format | Double-check payload and content-type (application/json) | | Transcription API fails | Invalid video ID or API key | Validate YouTube URL and Supadata API access | | Empty translation/summarization | Transcript was empty or prompt was weak | Ensure the video contains spoken content and refine prompt | | Google Doc not created | OAuth2 credentials not authorized properly | Reconnect Google Docs credentials in n8n | | Gemini LLM Chain fails | Model misconfigured or request malformed | Verify your model selection and payload structure | Need Help? Need help getting this set up or customizing it for your workflow? ✅ We can help you: Set up transcription and translation APIs Modify the summarization prompt Customize document layouts or automate sharing 👉 Contact WeblineIndia's automation experts !. An n8n automation workflow template by WeblineIndia.
- 5 nodes
- Automation
- AI
By Intuz
This n8n template from Intuz provides a complete and automated solution for instant team-wide financial visibility. It actively monitors QuickBooks and, upon detecting a new invoice, immediately sends a detailed alert to your chosen Slack channel. For customized reporting, the workflow can pull specific keywords or data like the customer name, invoice amount, and due date directly into the Slack message, creating a complete, real-time feed of your company's sales activity. Use Cases Sales Team Visibility:** Instantly notify the sales channel when an invoice is generated for a deal they closed. Finance & Ops Sync:** Keep the finance team aware of all billing activities as they happen in a dedicated channel. Account Management:** Alert account managers when invoices are sent to their clients, allowing for proactive follow-up. Executive Dashboard:** Create a high-level #billing-feed channel for leadership to monitor revenue-generating activities in real time. How it Works 1. Instant Webhook Trigger: The workflow begins when an invoice is created or updated in QuickBooks. A configured webhook in your Intuit Developer Portal sends a real-time notification to n8n, instantly activating the flow. 2. Fetch Full Invoice Details: The initial webhook payload only contains a basic event notification. This node uses the invoice ID from that payload to query the QuickBooks API and retrieve the full invoice details, such as the customer's name, due date, and domain. 3. Format Key Data: A simple but essential Code node takes the raw data from QuickBooks and cleans it up. It extracts only the most important fields (ID, Domain, Customer Name, Due Date) and organizes them for the next step. 4. Send Slack Notification: The final node crafts a human-readable message and posts it to your chosen Slack channel. The message is dynamically populated with the invoice data, providing a clear and concise update for the whole team. For example: Invoice having ID: 160 having the Domain: QBO for the customer Rondonuwu Fruit and Vegi which is due on 2025-09-07 has been generated successfully. Setup Instructions To get this workflow running, follow these configuration steps: 1. Credentials: QuickBooks: Connect your QuickBooks account credentials to n8n. Slack: Connect your Slack account using OAuth2 credentials. 2. QuickBooks Webhook Configuration: First, activate this n8n workflow. This will make the webhook URL live. Copy the Production URL from the QuickBooks Webhook node. Log in to your Intuit Developer Portal, navigate to the webhooks section for your application, and paste the URL. Ensure you subscribe to Invoice events (e.g., Create, Update, etc.). 3. Node Configuration: Get an invoice: No configuration needed; it will automatically use your QuickBooks credentials. Send a message (Slack): In the parameters, select the Slack Channel where you want the notifications to be posted. Support If you need help setting up this workflow or require a custom version tailored to your specific use case, please feel free to reach out to the template author: 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 Worflow Automation Click here- Get Started. An n8n automation workflow template by Intuz.
- 3 nodes
- 486 views
- Automation
By Marth - Business Automation
Automated Support Ticket & Customer Notification System Let's build this workflow to streamline your customer support. Here is a detailed, node-by-node explanation of how it works and how to set it up in n8n. How It Works This workflow transforms your support inbox into a structured ticket system. When a new email arrives at your support address, the system automatically creates a new ticket (e.g., a Trello card), sends an instant confirmation email to the customer, and notifies your support team. This ensures every customer inquiry is captured, organized, and confirmed, guaranteeing no request gets missed. Setup Steps 1. Gmail Trigger: Watch Support Inbox Node Type:** Gmail Trigger Credentials:** YOUR_GMAIL_CREDENTIAL Parameters:** Operation: Watch for New Mails Folder: Inbox (or a specific folder for support emails, like Support) To: your-support-email@example.com Explanation:** This node is the starting point. It connects to your support email address and listens for new messages. As soon as a new email arrives, it triggers the rest of the workflow. 2. Trello: Create New Support Ticket Node Type:** Trello Credentials:** YOUR_TRELLO_CREDENTIAL Parameters:** Operation: Create Card Board ID: YOUR_SUPPORT_BOARD_ID List ID: YOUR_INCOMING_LIST_ID (e.g., "New Tickets") Name: New Support Request from {{ $json.from }} Description: Subject: {{ $json.subject }} Body: {{ $json.body }} Explanation:** This node takes the details from the incoming email and creates a new card on your Trello board. This turns every email into an actionable, trackable ticket for your support team. 3. Gmail: Send Automatic Confirmation Node Type:** Gmail Credentials:** YOUR_GMAIL_CREDENTIAL Parameters:** Operation: Send To: ={{ $json.from }} Subject: Re: {{ $json.subject }} Body: Hi there, thanks for reaching out. We've received your request and have created a new ticket. Our team will get back to you shortly. Explanation:** This node sends a quick, professional, and automated email back to the customer. This provides immediate peace of mind for the customer and confirms that their inquiry was successfully received. 4. Slack: Notify Support Team (Optional) Node Type:** Slack Credentials:** YOUR_SLACK_CREDENTIAL Parameters:** Operation: Post Message Channel: YOUR_SUPPORT_CHANNEL_ID (e.g., #support-channel) Text: New Support Ticket! A new ticket from {{ $json.from }} has been created in Trello. Explanation:** This optional but recommended node sends a real-time notification to your support team on Slack, letting them know that a new ticket is waiting for their attention. Final Step: Activation After configuring the nodes and connecting all credentials, click "Save" at the top of the canvas. Click the "Active" toggle in the top-right corner. The workflow is now live! Note: You can easily swap out the Trello node with a Zendesk or Jira node, and the Slack node with a Telegram or Microsoft Teams node, depending on your team's tools. An n8n automation workflow template by Marth - Business Automation.
- 3 nodes
- Automation
By Marth - Business Automation
Website Lead Notification System Let's build this simple and high-value workflow. Here is a detailed, node-by-node explanation of how it works and how to set it up in n8n. How It Works This workflow acts as a bridge between your website's contact form and your sales team. It waits for a submission from your website via a Webhook. As soon as a new lead fills out the form, the workflow instantly captures their data and sends a formatted notification to your team's Slack channel. This ensures your team can respond to new leads in real time, without any delays. Setup Steps 1. Webhooks Trigger: Receive Website Form Submissions Node Type:** Webhook Trigger Parameters:** HTTP Method: POST Path: new-lead Explanation:** This node is the starting point. It creates a unique URL that you will use in your website's form submission settings. When a visitor submits your form, the data is sent to this URL as a POST request, triggering the workflow. 2. Slack: Notify Sales Team Node Type:** Slack Credentials:** YOUR_SLACK_CREDENTIAL Parameters:** Operation: Post Message Channel: YOUR_SALES_CHANNEL_ID (e.g., #sales-leads) Text: `New Website Lead! - Name: {{ $json.name }} Company: {{ $json.company }} Email: {{ $json.email }} Message: {{ $json.message }}` Explanation:** This node sends a formatted message to your designated Slack channel. The curly braces {{ }} contain n8n expressions that dynamically pull the data (name, company, email, etc.) from the website form submission. 3. Google Sheets: Archive Lead Data (Optional) Node Type:** Google Sheets Credentials:** YOUR_GOOGLE_SHEETS_CREDENTIAL Parameters:** Operation: Add Row Spreadsheet ID: YOUR_SPREADSHEET_ID Sheet Name: Leads Data: Name: ={{ $json.name }} Email: ={{ $json.email }} Date: ={{ $now }} Explanation:** This is an optional but recommended step. This node automatically adds a new row to a Google Sheet, creating a clean, organized archive of all your website leads. 4. Gmail: Send Automatic Confirmation Email (Optional) Node Type:** Gmail Credentials:** YOUR_GMAIL_CREDENTIAL Parameters:** Operation: Send To: ={{ $json.email }} Subject: Thanks for contacting us! Body: Hi {{ $json.name }}, thanks for reaching out. We've received your message and will get back to you shortly. Explanation:** This node provides a quick and professional automated response to the new lead, confirming that their message has been received. Final Step: Activation After configuring the nodes, click "Save" at the top of the canvas. Click the "Active" toggle in the top-right corner. The workflow is now live and will listen for new form submissions. Remember: You need to configure your website's form to send a POST request to the URL from your Webhook Trigger node. An n8n automation workflow template by Marth - Business Automation.
- 3 nodes
- Automation
By Wolf Bishop
A reliable, no-frills web scraper that extracts content directly from websites using their sitemaps. Perfect for content audits, migrations, and research when you need straightforward HTML extraction without external dependencies. How It Works This streamlined workflow takes a practical approach to web scraping by leveraging XML sitemaps and direct HTTP requests. Here's how it delivers consistent results: Direct Sitemap Processing: The workflow starts by fetching your target website's XML sitemap and parsing it to extract all available page URLs. This eliminates guesswork and ensures comprehensive coverage of the site's content structure. Robust HTTP Scraping: Each page is scraped using direct HTTP requests with realistic browser headers that mimic legitimate web traffic. The scraper includes comprehensive error handling and timeout protection to handle various website configurations gracefully. Intelligent Content Extraction: The workflow uses sophisticated JavaScript parsing to extract meaningful content from raw HTML. It automatically identifies page titles through multiple methods (title tags, Open Graph metadata, H1 headers) and converts HTML structure into readable text format. Framework Detection: Built-in detection identifies whether sites use WordPress, Divi themes, or heavy JavaScript frameworks. This helps explain content extraction quality and provides valuable insights about the site's technical architecture. Rich Metadata Collection: Each scraped page includes detailed metadata like word count, HTML size, response codes, and technical indicators. This data is formatted into comprehensive markdown files with YAML frontmatter for easy analysis and organization. Respectful Rate Limiting: The workflow includes a 3-second delay between page requests to respect server resources and avoid overwhelming target websites. The processing is sequential and controlled to maintain ethical scraping practices. Detailed Success Reporting: Every scraped page generates a report showing extraction success, potential issues (like JavaScript dependencies), and technical details about the site's structure and framework. Setup Steps Configure Google Drive Integration Connect your Google Drive account in the "Save to Google Drive" node Replace YOUR_GOOGLE_DRIVE_CREDENTIAL_ID with your actual Google Drive credential ID Create a dedicated folder for your scraped content in Google Drive Copy the folder ID from the Google Drive URL (the long string after /folders/) Replace YOUR_GOOGLE_DRIVE_FOLDER_ID_HERE with your actual folder ID in both the folderId field and cachedResultUrl Update YOUR_FOLDER_NAME_HERE with your folder's actual name Set Your Target Website In the "Set Sitemap URL" node, replace https://yourwebsitehere.com/page-sitemap.xml with your target website's sitemap URL Common sitemap locations include /sitemap.xml, /page-sitemap.xml, or /sitemap_index.xml Tip: Not sure where your sitemap is? Use a free online tool like https://seomator.com/sitemap-finder Verify the sitemap URL loads correctly in your browser before running the workflow Update Workflow IDs (Automatic) When you import this workflow, n8n will automatically generate new IDs for YOUR_WORKFLOW_ID_HERE, YOUR_VERSION_ID_HERE, YOUR_INSTANCE_ID_HERE, and YOUR_WEBHOOK_ID_HERE No manual changes needed for these placeholders Adjust Processing Limits (Optional) The "Limit URLs (Optional)" node is currently disabled for full site scraping Enable this node and set a smaller number (like 5-10) for initial testing For large websites, consider running in batches to manage processing time and storage Customize Rate Limiting (Optional) The "Wait Between Pages" node is set to 3 seconds by default Increase the delay for more respectful scraping of busy sites Decrease only if you have permission and the target site can handle faster requests Test Your Configuration Enable the "Limit URLs (Optional)" node and set it to 3-5 pages for testing Click "Test workflow" to verify the setup works correctly Check your Google Drive folder to confirm files are being created with proper content Review the generated markdown files to assess content extraction quality Run Full Extraction Disable the "Limit URLs (Optional)" node for complete site scraping Execute the workflow and monitor the execution log for any errors Large websites may take considerable time to process completely (plan for several hours for sites with hundreds of pages) Review Results Each generated file includes technical metadata to help you assess extraction quality Look for indicators like "Limited Content" warnings for JavaScript-heavy pages Files include word counts and framework detection to help you understand the site's structure Framework Compatibility: This scraper is specifically designed to work well with WordPress sites, Divi themes, and many JavaScript-heavy frameworks. The intelligent content extraction handles dynamic content effectively and provides detailed feedback about framework detection. While some single-page applications (SPAs) that render entirely through JavaScript may have limited content extraction, most modern websites including those built with popular CMS platforms will work excellently with this scraper. Important Notes: Always ensure you have permission to scrape your target website and respect their robots.txt guidelines. The workflow includes respectful delays and error handling, but monitor your usage to maintain ethical scraping practices.RetryClaude can make mistakes. Please double-check responses. An n8n automation workflow template by Wolf Bishop.
- 3 nodes
- Automation
By Oneclick AI Squad
This n8n workflow transforms uploaded health details or lab reports received via email into a customized diet plan using AI analysis, then sends the plan back to the user via email, optimizing nutrition based on individual health data. Why Use It This workflow automates the creation of personalized diet plans from health data, saving time for nutritionists, improving patient outcomes with AI-driven insights, and providing a convenient email delivery system for users. How to Import It Download the Workflow JSON: Obtain the workflow file from the n8n template or create it based on this document. Import into n8n: In your n8n instance, go to "Workflows," click the three dots, select "Import from File," and upload the JSON. Configure Credentials: Set up email (e.g., IMAP for receiving, SMTP for sending), AI model, and optional Google Sheets credentials in n8n. Run the Workflow: Test with a sample email containing health data and verify the diet plan delivery. System Architecture Data Input Pipeline**: Email Trigger: Initiates the workflow when a health report email is received. Extract Health Data: Parses uploaded health details or lab reports from the email. AI Analysis Flow**: Send to AI Model: Analyzes health data using an AI model. Generate Diet Plan: Creates a customized diet plan based on AI output. Delivery Flow**: Prepare Email Content: Formats the diet plan for email delivery. Send Diet Plan Email: Sends the plan to the user via SMTP. Update Log (Optional): Logs the process in a Google Sheet. Google Sheet Structure Columns**: timestamp: Date and time of the diet plan generation. user_email: User’s email address for receiving the plan. health_data: Extracted health metrics or lab report summary. condition: AI-identified health condition. diet_plan: Generated diet plan summary. sent_status: Status of email delivery (e.g., Sent, Failed). Customization Add SMS Alerts**: Integrate Twilio or WhatsApp for additional notifications. Enhance AI**: Train the AI model with more nutritional data for better plans. Include Recipes**: Add a node to suggest recipes based on the diet plan. Multilingual Support**: Adapt email content for different languages. Integration with Apps**: Connect to fitness apps (e.g., MyFitnessPal) for tracking. Requirements Email Service**: IMAP (e.g., Gmail) for receiving health data emails and SMTP for sending diet plans. AI Model**: Ollama or similar for health analysis and diet plan generation (requires API access). n8n Instance**: With email (IMAP/SMTP) and AI connectors configured. Internet Connection**: To access email and AI APIs. Optional Google Sheets Account**: For logging health data and diet plans. User Consent**: Ensure compliance with data privacy laws (e.g., HIPAA) for health data. Want a tailored workflow for your business? Our experts can craft it quickly Contact our team. An n8n automation workflow template by Oneclick AI Squad.
- 3 nodes
- Automation
- AI
By Oneclick AI Squad
This n8n workflow enables an AI-powered symptom checker where users input symptoms via a form or chat, analyzes them using an AI model, matches possible conditions, and suggests relevant doctors with contact details via WhatsApp or email, enhancing healthcare accessibility. Why Use It This workflow improves healthcare outreach by providing quick, AI-driven symptom analysis and doctor recommendations, reducing the burden on medical staff, empowering users with informed choices, and streamlining appointment scheduling. How to Import It Download the Workflow JSON: Obtain the workflow file from the n8n template or create it based on this document. Import into n8n: In your n8n instance, go to "Workflows," click the three dots, select "Import from File," and upload the JSON. Configure Credentials: Set up form/webhook, AI model, WhatsApp, email (e.g., SMTP), and optional doctor database API credentials in n8n. Run the Workflow: Test with a sample symptom input and verify responses. System Architecture Symptom Input Pipeline**: Form/Chat Trigger: Initiates the workflow when a user submits symptoms. Extract Symptom Data: Processes the input from the form or chat. AI Analysis Flow**: Send to AI Model: Analyzes symptoms using an AI model. Match Possible Conditions: Identifies potential health conditions. Doctor Suggestion Flow**: Retrieve Doctor Details: Fetches relevant doctor data from a Google Sheet or API. Prepare Suggestion Message: Formats the suggestion with doctor names and contacts. Send WhatsApp Suggestion: Delivers the suggestion via WhatsApp. Send Email Suggestion: Delivers the suggestion via email. Update Log: Logs the request and response in a Google Sheet. Google Sheet File Structure Columns**: timestamp: Date and time of the symptom submission. user_id: Unique identifier for the user (e.g., form ID or chat handle). symptoms: List of symptoms entered by the user. condition: AI-identified possible condition. doctor_name: Name of the suggested doctor. contact: Doctor’s contact (phone or email). sent_via: Channel used for delivery (e.g., WhatsApp, Email). Customization Ideas Add More Channels**: Integrate SMS or Slack for additional notifications. Enhance AI**: Train the AI model with more medical data for better accuracy. Include Appointment Booking**: Add a node to schedule appointments with suggested doctors. Multilingual Support**: Adapt responses for different languages. Severity Alerts**: Flag critical conditions for immediate medical attention. Requirements to Run This Workflow Google Sheets Account**: For logging symptom data and doctor details. AI Model**: Ollama or similar for symptom analysis (requires API access). Form/Chat Service**: Google Forms, WhatsApp webhook, or similar for user input. WhatsApp Business API**: For sending WhatsApp messages (requires token and phone number). Email Service**: Gmail, SMTP, or similar for email delivery. n8n Instance**: With Google Sheets, AI, WhatsApp, and email connectors configured. Internet Connection**: To access APIs and services. Want a tailored workflow for your business? Our experts can craft it quickly Contact our team. An n8n automation workflow template by Oneclick AI Squad.
- 5 nodes
- Automation
- AI
By WeblineIndia
Solar Energy Production Monitoring Alert Workflow This workflow automatically monitors solar energy production every 2 hours by fetching data from the Energidataservice API. If the energy output falls below a predefined threshold, it instantly notifies users via email. Otherwise, it logs the data into a Google Sheet and posts a daily summary to Slack. Who’s It For Renewable energy teams monitoring solar output. Facility managers and power plant supervisors. ESG compliance officers tracking sustainability metrics. Developers or analysts automating solar energy reporting. How It Works Trigger: The workflow starts every 2 hours using a Schedule Trigger. Data Fetch: An HTTP Request node fetches solar energy production data from the Energidataservice API. Processing: A Code node filters out entries with production below the minimum threshold. Decision Making: An If node checks whether any low-production entries are present. Alerts: If low-production is detected, an email is sent via the Gmail node. Logging: If all entries are valid, they are logged into a Google Sheet. Slack Summary: A Slack node posts the summary sheet data for end-of-day visibility. How to Set Up Schedule Trigger: Configure to run every 2 hours. HTTP Request Node: Method: GET URL: https://api.energidataservice.dk/dataset/YourDatasetHere Add necessary headers and params as required by the API. Code Node: Define logic to filter entries where solar_energy_production < required_threshold. If Node: Use items.length > 0 to check for low-production entries. Gmail Node: Auth with Gmail credentials. Customize recipient and message template. Google Sheets Node: Connect to a spreadsheet. Map appropriate columns. Slack Node: Use Slack OAuth2 credentials. Specify channel and message content. Requirements n8n Cloud or Self-hosted instance. Access to Energidataservice API. Gmail account (with n8n OAuth2 integration). Google Sheets account & sheet ID. Slack workspace and app with appropriate permissions. How to Customize Change Frequency:** Adjust the Schedule Trigger interval (e.g., every hour or 4x per day). Threshold Tuning:** Modify the value in the Code node to change the minimum acceptable solar production. Alert Routing:** Update Gmail recipients or replace Gmail with Microsoft Outlook/SendGrid. Sheet Format:** Add or remove columns in the Google Sheet based on extra metrics (e.g., wind or nuclear data). Slack Posting:** Customize Slack messages using Markdown for improved readability. Add‑ons Telegram Node:** Send alerts to a Telegram group instead of email. Discord Webhook:** Push updates to a Discord channel. n8n Webhook Trigger:** Extend it to receive external production update notifications. Integromat/Make or Zapier:** For multi-platform integration with CRMs or ticketing tools. Use Case Examples Utility Companies:** Automatically detect and act on solar underperformance to maintain grid stability. Solar Farm Operators:** Log clean production data for auditing and compliance reports. Sustainability Teams:** Track daily performance and anomalies without manual checks. Home Solar System Owners:** Get notified if solar generation drops below expected. Common Troubleshooting | Issue | Possible Cause | Solution | | -------------------------------------- | -------------------------------------- | ------------------------------------------------------------------- | | HTTP Request fails | API key missing or URL is incorrect | Check API endpoint, parameters, and authentication headers | | Gmail not sending alerts | Missing or invalid Gmail credentials | Re-authenticate Gmail OAuth2 in n8n credentials | | No data getting logged in Google Sheet | Incorrect mapping or sheet permissions | Ensure the sheet exists, columns match, and credentials are correct | | Slack node fails | Invalid token or missing channel ID | Reconnect Slack credentials and check permissions | | Code node returns empty | Filter logic may be too strict | Validate data format and relax the threshold condition | Need Help? Need help setting this up or customizing it for your own solar or energy monitoring use case? ✅ Set it up on your n8n Cloud or self-hosted instance ✅ Customize it for your own API or data source ✅ Modify alerts to suit your internal tools (Teams, Discord, SMS, etc.) 👉 Just reach out to our n8n automation team at WeblineIndia, we'll be happy to help. An n8n automation workflow template by WeblineIndia.
- 5 nodes
- Automation
By Tharwat Mohamed
Overview Turn WhatsApp chats into instant answers and real-time bookings—all in one n8n workflow. Your AI Agent leverages Gemini embeddings + Pinecone for on-the-fly knowledge retrieval, then logs reservations directly into Google Sheets. Features AI-powered Q&A: Natural-language responses driven by Gemini + Pinecone vector search Seamless Reservations: Book services via WhatsApp; entries auto-append to Google Sheets Auto-Embedding Sub-workflow: Drag-and-drop Google Drive docs get indexed in Pinecone 24-Hour Follow-Up: Automated template messages if no response within a day Personal Support Pledge: Hands-on help until your workflow runs flawlessly Requirements n8n account (self-hosted or n8n.cloud) Google Cloud project with Gemini & Drive APIs enabled Pinecone account (free tier works) Google Sheets account WhatsApp Business API credentials (e.g. Twilio, 360dialog) Setup Instructions Import Workflow Download the .json file from your Gumroad purchase In n8n Editor → Import → From File → select the JSON Add Credentials Google Service Account (Gemini & Drive APIs) Pinecone (API Key + Environment) Google Sheets OAuth2 WhatsApp Business API (HTTP credential or native) Configure Nodes AI Agent: select Gemini credentials; update system prompt with your business name & services Pinecone Loader: point “Google Drive” node to your docs folder Sheets Append: set Spreadsheet ID, sheet name “reservations”, map Timestamp, UserID, Service, Date, Time, Notes WhatsApp Trigger & Send: set webhook URL; choose approved template name Test End-to-End Activate the workflow → send a test WhatsApp message → verify AI reply + new row in your sheet Google Sheet Structure Column Description Timestamp Auto-generated when a user books UserID : Unique WhatsApp user identifier Service : Chosen service or product name Date : Booking date Time : Booking time slot Notes : Any extra information (e.g., special requests) Customization Add New Services: Edit the system prompt’s services list Change Follow-Up Window: Adjust the “24-hour window check” node logic Embed Different Docs: Point the Drive node at any folder of PDFs/TXT 📞 Personal Support Pledge: I’ll work with you (via WhatsApp or email, remote desktop ) until your workflow is running flawlessly—no extra fees, no “good luck” drop‑off. Just send a message via: Email: tharwat.elsayed2000@gmail.com WhatsApp: +20 106 180 3236. An n8n automation workflow template by Tharwat Mohamed.
- 12 nodes
- 235 views
- Automation
- AI
By Cristian Tala Sánchez
Automate Market Problem Discovery from Reddit with OpenAI Who’s it for This workflow is perfect for entrepreneurs, startup founders, product managers, researchers, and market analysts who want to automatically discover and analyze real market problems from online discussions. While this example focuses on identifying issues in the future of work and future of education, it can be fully adapted to detect any type of market pain point by changing the data sources and AI prompts. If you’re looking to automate market research, find customer pain points, or detect unmet needs in your industry, this template is for you. What it does This no-code n8n automation: Collects fresh discussions from Reddit (default: Teachers, Education, RemoteWork subreddits). Filters posts by engagement (more than 5 upvotes by default). Uses OpenAI GPT-4.1 to: Detect if a post describes a real market problem. Identify the underlying pain or unmet need. Suggest a practical, tech/AI-based solution. Score the problem’s Impact, Confidence, and Ease of prototyping (ICE framework). Saves results to Google Sheets for easy prioritization and action. This allows you to automate the detection of market opportunities without manually reading through hundreds of posts. How it works Schedule Trigger**: Runs the workflow at your preferred interval (daily, hourly, etc.). Reddit Nodes**: Pull posts from the targeted subreddits (you can replace them with any niche communities). Filter Node**: Keeps only posts with engagement above your threshold. OpenAI Node: Analyzes each post using a **User Prompt and System Prompt in English, returning structured JSON data. Google Sheets Node**: Stores all results with full scoring for later review and prioritization. Requirements Reddit OAuth2 API credentials. OpenAI API key. Google Sheets OAuth2 API credentials. A Google Sheet with these columns: SubReddit, Title, Content, Short Description, Detected Pain, Possible Solution, Impact, Confidence, Ease, URL, ICE Score How to customize Change the market focus**: Replace example subreddits with your own industry forums or communities. Adjust the filter criteria**: Modify the upvote threshold or other parameters. Edit the AI prompts**: Tailor them to detect specific types of problems (healthtech, fintech, sustainability, etc.). Integrate more sources**: Add Twitter, LinkedIn, or customer support logs for richer insights. 💡 With this automation, you can continuously monitor and capture market pain points, turning raw online discussions into actionable business opportunities. An n8n automation workflow template by Cristian Tala Sánchez.
- 3 nodes
- Automation
- AI
By Paul
HighLevel MCP Full CRM Automation With the HighLevel MCP Automation Workflow, you unlock the full potential of AI-driven CRM management inside n8n. This setup turns your HighLevel account into a fully orchestrated MCP-powered system, capable of executing contact management, opportunity tracking, task handling, and calendar scheduling automatically — all from a single intelligent trigger. Every action is performed through the MCP layer, ensuring seamless integration, instant execution, and real-time synchronization without manual effort. Whether you need to create a contact, update an opportunity, fetch available appointment slots, or close a task, the MCP workflow manages it end-to-end with precision. This is more than an automation — it’s a dedicated MCP agent for HighLevel that runs 24/7, keeping your CRM up-to-date, your pipeline organized, and your operations moving without delays. Harness the MCP framework to eliminate repetitive CRM work and maintain a perfectly optimized sales and operations flow. An n8n automation workflow template by Paul.
- 4 nodes
- Automation
- AI