Browse 12,955 Workflows

By Sk developer

Automated Seo Website Traffic Checker with Google Sheets Logging (Seo) Description: This workflow uses the Website Traffic Checker Semrush API to analyze website traffic and performance. It collects data through a user-submitted website URL and stores the results in Google Sheets for easy access and reporting. Ideal for SEO analysis and data tracking. Node-by-Node Explanation: 1. On form submission Captures the website URL submitted by the user through a form. Triggers the workflow when a website URL is submitted via the form interface. 2. Check webTraffic Sends a request to the Website Traffic Checker Semrush API to gather traffic data for the submitted website. Uses the provided URL to fetch real-time traffic statistics using the Semrush API. 3. Re format output Extracts and reformats the raw traffic data from the API response. Cleans and structures the traffic data for easy readability and reporting. 4. Google Sheets Appends the formatted traffic data into a Google Sheet for storage and further analysis. Stores the data in a Google Sheets document for long-term tracking and analysis. Benefits of This Flow: Real-Time Data Collection:** Collects real-time website traffic data directly from the Website Traffic Checker Semrush API, ensuring up-to-date information is always available. Automation:** Automatically processes and formats the website traffic data into an easily accessible Google Sheet, saving time and effort. Customizable:** The workflow can be customized to track multiple websites, and the data can be filtered and expanded as per user needs. SEO Insights:** Get in-depth insights like bounce rate, pages per visit, and visits per user, essential for SEO optimization. Use Case: SEO Monitoring:** Track and analyze the traffic of competitor websites or your own website for SEO improvements. This is ideal for digital marketers, SEO professionals, and website owners. Automated Reporting:** Automatically generate traffic reports for various websites and save them in a Google Sheet for easy reference. No need to manually update data or perform complex calculations. Data-Driven Decisions:** By utilizing data from the Website Traffic Checker Semrush API, users can make informed decisions to improve website performance and user experience. An n8n automation workflow template by Sk developer.

By Yassin Zehar

Description This workflow sends a summary of your meeting minutes via Gmail, directly from the notes stored in your Google Sheet. Context Taking notes during meetings is important, but sharing them with the team can be time-consuming. This workflow makes it simple: just write down your meeting minutes in a Google Sheets, and n8n will automatically send them by email after each meeting. Who is this for? Perfect for anyone who: Uses Google Sheets to keep track of meeting notes. Wants to automatically share minutes with teammates or stakeholders. Values speed, productivity, and automation. Requirements Google account. Google Sheets (with your meeting minutes). You will need to setup the required columns first : Topic, Status, Owner, Next Step. Gmail. How it works ⏰ Trigger starts after a new row is added in your Google Sheet. 📑 The meeting minutes are retrieved from the sheet. 📨 Gmail automatically sends the minutes to the configured recipients. Steps 🗒️ Use the sticky notes in the n8n canvas to: Add your Google credentials (Sheets + Gmail). Define your sheet and recipient email addresses. Test the workflow to check if the minutes are sent. You’ll get this: An email containing your full meeting minutes, straight from your notes. Tutorial video Watch the Youtube Tutorial video About me : I’m Yassin a Project & Product Manager Scaling tech products with data-driven project management. 📬 Feel free to connect with me on Linkedin. An n8n automation workflow template by Yassin Zehar.

By Garri

Description This n8n workflow automates the process of retrieving images from a specific Google Drive folder, resizing them, and inserting them into a Google Docs document. It ensures images are processed in numeric order, automatically resized to fit the document, and uploaded in batches to prevent timeouts. This template is designed for content creators, documentation teams, and businesses who need to automatically insert images (e.g., product photos, reports, or scanned documents) into Google Docs with minimal manual effort. How it works Retrieves image files from a Google Drive folder. Filters and sorts files based on numeric order in the filename. Generates direct image URIs and resizes them automatically (width & height). Inserts the resized images into the target Google Docs document via API. Uses a batch loop to avoid timeouts and ensure all images are uploaded successfully. Requirements / Pre-conditions An n8n instance (self-hosted or cloud). Connected Google Drive credential in n8n. Connected Google Docs credential in n8n. A target Google Drive folder containing supported image files. A Google Docs document ready to receive the images. Supported formats: PNG, JPG, JPEG, GIF, WEBP. Error handling: If a file is not an image or exceeds Google Docs API limits, the workflow will skip it and continue processing the rest. Setup Steps Google Drive Credential Connect your Google Drive account in n8n to grant access to the folder containing the images. Google Docs Credential Connect your Google Docs account to allow image insertion into the document. Folder & File Filter In the Search File node, replace the placeholder {{YOUR_FOLDER_ID}} with your Google Drive folder ID. Google Docs Document ID In the Insert Image (HTTP Request) node, replace {{YOUR_DOCUMENT_ID}} with your target Google Docs document ID. (Make sure you rename this node to something descriptive, e.g., Insert Image to Google Doc.) Batch Loop The workflow includes a batch processing loop to prevent timeout errors when dealing with large sets of images. You can adjust the batch size if needed. Run the workflow Execute the workflow, and images will be automatically retrieved, resized, and inserted into the document. Customization Resize Dimensions: Adjust the width/height in the Image Resize node to fit your document’s style. Ordering Logic: Modify the sorting step if you want alphabetical or upload-date order instead of numeric order. Error Notifications: Add an email or Slack node to notify you when an image fails to insert. Image Placement: By default, images are appended. You can adjust the insert logic (e.g., after specific headings). An n8n automation workflow template by Garri.

By Sameed

Who’s it for This workflow is perfect for recruiters, HR professionals, and startup founders who receive job applications by email and want to automate the process of parsing, matching, and evaluating resumes. If you want to save time by having candidate data and AI scores automatically organized in Google Sheets, this workflow is for you. How it works Monitors a Gmail inbox for new emails with resume attachments (PDF) Extracts the job title from the email subject and matches it against open positions stored in Airtable Uploads the resume file to a designated Google Drive folder for storage Builds a prompt with all relevant context and sends it, along with the resume file, to Gemini AI for analysis Gemini scores the candidate, extracts their name and phone, and provides a one-sentence explanation All results—including candidate info, AI score, feedback, and a download link for the resume—are appended as new rows in Google Sheets How to set up Create accounts and APIs: You’ll need Google (Gmail, Drive, Sheets), Airtable, and Gemini API access. Prepare your Airtable base: Add your job descriptions (title, code, description, skills, etc.)—these are matched against incoming applications. Prepare your Google Sheet: Create a spreadsheet to store applicant data and scores. Connect credentials in n8n: Set up Gmail, Google Drive, Google Sheets, Airtable, and Gemini API credentials in n8n’s credential manager. Import this workflow: Use the workflow import feature in n8n and connect your credentials to each node. Test: Send a test application email with a PDF resume to your connected Gmail—watch the data appear in Google Sheets! Requirements Google account with access to Gmail, Drive, and Sheets Airtable account for job data Gemini API key (no hardcoded keys—use n8n environment variables or credentials) n8n instance (cloud or self-hosted) How to customize the workflow Job matching logic**: Edit the EmailMatcher node to fine-tune how subjects are matched to job titles. Scoring criteria**: Adjust the prompt in PromptBuilder to change what Gemini evaluates. Supported file types**: Modify the ReadyAttachment node to accept other resume formats if needed. Sheet columns**: Edit the Google Sheets node to map new data points or change the output format. Notifications**: Add Slack or email nodes to notify you when a strong candidate is found. An n8n automation workflow template by Sameed.

By Richard Uren

Create Products in Shopify from Airtable This workflow creates products in your Shopify store from Airtable. It also enables inventory tracking and sets the quantity of an inventory item at your store's default location. This is a great way to keep shopify in sync with Airtable if Airtable is your primary source of data, Only records with the 'sync' column set to true are sync'd. Setup Airtable Automations so that if any records are created or updated then this flag is set to true. Records are matched using the 'slug' column which Shopify calls a handle. Airtable Setup Notes The Airtable products table has the following columns title - free text description - free text company - free text type - free text status - ACTIVE, DRAFT or ARCHIVE slug - used in the product url, text with no spaces, can also use hyphen. price - sale price of the products compare_at_price - compare at price for products sku - unique code for each product stock_on_hand - quantity of this item available for purchase. sync - boolean, set to true to sync this record. Update GraphQL nodes with your Shopify store URL 1) Replace the URL in all GraphQL nodes with the URL for your Shopify store. 2) All GraphQL requests all use the Shopify 2025-04 GraphQL Admin API. An n8n automation workflow template by Richard Uren.

By Jimmy Gay

🔧 AI-Powered Auto-Maintenance System for n8n Transform your n8n instance management with this advanced automation system featuring artificial intelligence-driven workflow selection. This template provides comprehensive maintenance operations with smart filtering capabilities. ✨ Key Features 🤖 Artificial Intelligence Engine Multi-criteria scoring system for intelligent workflow selection Semantic analysis for business-critical pattern recognition Automated decision-making with configurable thresholds 🎯 Core Maintenance Operations Security Audits**: Automated vulnerability scanning with Google Sheets reporting Smart Pause/Resume**: Intelligent workflow suspension during maintenance windows AI Backup Creation**: Selective duplication of high-value workflows Intelligent Export**: Comprehensive system backups with metadata 🔐 Enterprise Security Token-based authentication with request validation Protected workflow safeguards (never modifies critical systems) Comprehensive error handling and logging ⚡ Automation & Scheduling Configurable maintenance schedules (daily, weekly, monthly) Webhook-driven operations for external integration Real-time monitoring and statistics 🎯 Perfect For DevOps Teams**: Streamline n8n maintenance operations Enterprise Users**: Manage large-scale workflow environments System Administrators**: Automated security and backup management Advanced Users**: Leverage AI for intelligent workflow management 🚀 Quick Setup Import the template Configure 4 credentials (n8n API, Google Sheets, Google Drive, Webhook Auth) Set your security token and Google Sheet ID Activate and enjoy automated maintenance! 🧠 AI Intelligence Highlights The system evaluates workflows using 6+ criteria including activity status, complexity, priority tags, business criticality, and recent updates. Workflows are automatically scored and selected based on intelligent thresholds. Selection Logic: Duplicate threshold: ≥3 points (smart backup selection) Export threshold: ≥5 points (comprehensive backup) System workflows always protected 📊 Includes 25+ configured nodes with emoji naming 4 detailed markdown documentation cards Pre-configured schedules and examples Comprehensive error handling Statistical reporting and monitoring Perfect for organizations looking to implement intelligent, automated n8n maintenance with minimal manual intervention. An n8n automation workflow template by Jimmy Gay.

By Vitorio Magalhães

Overview This workflow automatically enriches Brazilian company data by fetching comprehensive CNPJ information from the MinhaReceita.org API and updating your Google Sheets spreadsheet. Perfect for data analysts, sales teams, and anyone working with Brazilian business databases who needs to enrich company information at scale. What it does Reads CNPJ numbers** from your Google Sheets spreadsheet Fetches complete company data** from Brazil's Federal Revenue database via MinhaReceita.org API Updates your spreadsheet** with comprehensive business information including address, tax status, partners, and more Sends Telegram notifications** when the process is complete Processes data in batches** to handle large datasets efficiently Key Features ✅ Free API - No authentication required, completely free to use ✅ Comprehensive Data - 47+ fields of official Brazilian company information ✅ Batch Processing - Handles up to 100 CNPJs per batch automatically ✅ Smart Filtering - Only processes CNPJs that don't already have data ✅ Real-time Updates - Updates your spreadsheet as data is retrieved ✅ Progress Notifications - Get notified via Telegram when complete Setup Requirements Google Sheets Structure Your spreadsheet must contain at minimum: cnpj** column with Brazilian CNPJ numbers (numbers only, no formatting) razao_social** column (used to identify records without data) Credentials Needed Google Sheets OAuth2** credentials configured in n8n Telegram Bot** credentials for notifications (optional but recommended) Available Data Fields The workflow can populate your spreadsheet with any or all of these official fields from Brazil's Federal Revenue: 🏢 Company Information cnpj, razao_social, nome_fantasia, capital_social porte, codigo_porte, natureza_juridica, codigo_natureza_juridica 📍 Address & Location uf, municipio, codigo_municipio, codigo_municipio_ibge bairro, logradouro, descricao_tipo_de_logradouro numero, complemento, cep pais, codigo_pais, nome_cidade_no_exterior 📞 Contact Information email, ddd_telefone_1, ddd_telefone_2, ddd_fax 💼 Business Classification cnae_fiscal, cnae_fiscal_descricao, cnaes_secundarios regime_tributario, qualificacao_do_responsavel 📋 Registration Status situacao_cadastral, descricao_situacao_cadastral motivo_situacao_cadastral, descricao_motivo_situacao_cadastral situacao_especial, identificador_matriz_filial, descricao_identificador_matriz_filial ente_federativo_responsavel 📅 Important Dates data_inicio_atividade, data_situacao_cadastral, data_situacao_especial 🏛️ Tax Regime Information opcao_pelo_mei, data_opcao_pelo_mei, data_exclusao_do_mei opcao_pelo_simples, data_opcao_pelo_simples, data_exclusao_do_simples 👥 Partners & Shareholders qsa (Complete structured data of company partners and shareholders) How to Use Prepare your spreadsheet with CNPJ numbers in the cnpj column Configure your Telegram ID in the Settings node for notifications Set up Google Sheets credentials in n8n Add the desired data columns to your spreadsheet (any combination from the list above) Run the workflow - it will automatically process all CNPJs without existing data Performance & Limitations API Limits**: None - completely free API from MinhaReceita.org Data Accuracy**: Official data from Brazil's Federal Revenue Service Batch Size**: Configurable (default: 100 records per batch) Use Cases Lead Enrichment**: Enhance prospect databases with complete company information Market Research**: Gather comprehensive data about Brazilian companies Compliance & Due Diligence**: Verify company registration status and details Sales Intelligence**: Access contact information and company classification data Data Cleaning**: Standardize and complete existing company databases Prerequisites N8N instance with Google Sheets integration Google Sheets document with CNPJ data Basic understanding of Brazilian CNPJ format (14-digit company registration number) Telegram bot token (optional, for notifications) Important Notes CNPJs must be active and registered with Brazil's Federal Revenue Service The workflow only processes CNPJs where razao_social is empty (avoiding duplicates) All data comes from official government sources via MinhaReceita.org No rate limiting needed - the API is designed for bulk requests Supports both matriz (headquarters) and filial (branch) identification. An n8n automation workflow template by Vitorio Magalhães.

By inderjeet Bhambra

AI Security Pipeline - Prompt Injection Defense System using GPT-4O Protect your AI workflows from prompt injection attacks, XSS attempts, and malicious content with this multi-layer security sanitization system. > Important: The n8n workflow template uploader did not allow me to upload the complete system prompt for the Input Validation & Pattern Detection. Copy the complete System Prompt from here What it does This workflow acts as a security shield for AI-powered automations, preventing indirect prompt injection and other threats. It processes content through a multi-layered defense pipeline that detects malicious patterns, sanitizes markdown, validates URLs, and provides comprehensive security assessments. How it works Receives content via webhook endpoint Detects threats including prompt injections, XSS attempts, and data URI attacks Sanitizes markdown by removing HTML, dangerous protocols, and suspicious links Validates URLs blocking suspicious IP addresses, domains, and URL shorteners Returns security report with risk assessment and sanitized content Setup Import and activate the workflow Use the generated webhook URL: /webhook/security-sanitize Send POST requests with JSON: {"content": "your_text", "source": "identifier"} Use cases Secure AI chatbots and LLM integrations Process user-generated content before AI processing Protect RAG systems from data poisoning Sanitize external webhook payloads Ensure compliance with security standards Perfect for any organization using AI that needs to prevent prompt manipulation, data exfiltration, and injection attacks while maintaining audit trails for compliance. An n8n automation workflow template by inderjeet Bhambra.

By Robert Breen

This n8n workflow template creates an efficient data analysis system that uses Google Gemini AI to interpret user questions about spreadsheet data and processes them through a specialized sub-workflow for optimized token usage and faster responses. What This Workflow Does Smart Query Parsing**: Uses Gemini AI to understand natural language questions about your data Efficient Processing**: Routes calculations through a dedicated sub-workflow to minimize token consumption Structured Output**: Automatically identifies the column, aggregation type, and grouping levels from user queries Multiple Aggregation Types**: Supports sum, average, count, count distinct, min, and max operations Flexible Grouping**: Can aggregate data by single or multiple dimensions Token Optimization**: Processes large datasets without overwhelming AI context limits Tools Used Google Gemini Chat Model** - Natural language query understanding and response formatting Google Sheets Tool** - Data access and column metadata extraction Execute Workflow** - Sub-workflow processing for data calculations Structured Output Parser** - Converts AI responses to actionable parameters Memory Buffer Window** - Basic conversation context management Switch Node** - Routes to appropriate aggregation method Summarize Nodes** - Performs various data aggregations 📋 MAIN WORKFLOW - Query Parser What This Workflow Does The main workflow receives natural language questions from users and converts them into structured parameters that the sub-workflow can process. It uses Google Gemini AI to understand the intent and extract the necessary information. Prerequisites for Main Workflow Google Cloud Platform account with Gemini API access Google account with access to Google Sheets n8n instance (cloud or self-hosted) Main Workflow Setup Instructions 1. Import the Main Workflow Copy the main workflow JSON provided In your n8n instance, go to Workflows → Import from JSON Paste the JSON and click Import Save with name: "Gemini Data Query Parser" 2. Set Up Google Gemini Connection Go to Google AI Studio Sign in with your Google account Go to Get API Key section Create a new API key or use an existing one Copy the API key Configure in n8n: Click on Google Gemini Chat Model node Click Create New Credential Select Google PaLM API Paste your API key Save the credential 3. Set Up Google Sheets Connection for Main Workflow Go to Google Cloud Console Create a new project or select existing one Enable the Google Sheets API Create OAuth 2.0 Client ID credentials In n8n, click on Get Column Info node Create Google Sheets OAuth2 API credential Complete OAuth flow 4. Configure Your Data Source Option A: Use Sample Data The workflow is pre-configured for: Sample Marketing Data Make a copy to your Google Drive Option B: Use Your Own Sheet Update Get Column Info node with your Sheet ID Ensure you have a "Columns" sheet for metadata Update sheet references as needed 5. Set Up Workflow Trigger Configure how you want to trigger this workflow (webhook, manual, etc.) The workflow will output structured JSON for the sub-workflow ⚙️ SUB-WORKFLOW - Data Processor What This Workflow Does The sub-workflow receives structured parameters from the main workflow and performs the actual data calculations. It handles fetching data, routing to appropriate aggregation methods, and formatting results. Sub-Workflow Setup Instructions 1. Import the Sub-Workflow Create a new workflow in n8n Copy the sub-workflow JSON (embedded in the Execute Workflow node) Import as a separate workflow Save with name: "Data Processing Sub-Workflow" 2. Configure Google Sheets Connection for Sub-Workflow Apply the same Google Sheets OAuth2 credential you created for the main workflow Update the Get Data node with your Sheet ID Ensure it points to your data sheet (e.g., "Data" sheet) 3. Configure Google Gemini for Output Formatting Apply the same Gemini API credential to the Google Gemini Chat Model1 node This handles final result formatting 4. Link Workflows Together In the main workflow, find the Execute Workflow - Summarize Data node Update the workflow reference to point to your sub-workflow Ensure the sub-workflow is set to accept execution from other workflows Sub-Workflow Components When Executed by Another Workflow**: Trigger that receives parameters Get Data**: Fetches all data from Google Sheets Type of Aggregation**: Switch node that routes based on aggregation type Multiple Summarize Nodes**: Handle different aggregation types (sum, avg, count, etc.) Bring All Data Together**: Combines results from different aggregation paths Write into Table Output**: Formats final results using Gemini AI Example Usage Once both workflows are set up, you can ask questions like: Overall Metrics: "Show total Spend ($)" "Show total Clicks" "Show average Conversions" Single Dimension: "Show total Spend ($) by Channel" "Show total Clicks by Campaign" Two Dimensions: "Show total Spend ($) by Channel and Campaign" "Show average Clicks by Channel and Campaign" Data Flow Between Workflows Main Workflow: User question → Gemini AI → Structured JSON output Sub-Workflow: Receives JSON → Fetches data → Performs calculations → Returns formatted table Contact Information For support, customization, or questions about this template: Email**: robert@ynteractive.com LinkedIn**: Robert Breen Need help implementing these workflows, want to remove limitations, or require custom modifications? Reach out for professional n8n automation services and AI integration support. An n8n automation workflow template by Robert Breen.

By Luis Hernandez

Overview This n8n workflow provides an automated notification system that monitors tickets in GLPI (Gestionnaire Libre de Parc Informatique) and sends proactive alerts through Microsoft Teams when tickets are approaching their expiration dates. Key Features 🕘 Automated Scheduling Daily execution scheduled at 9:00 AM Continuous monitoring without manual intervention Customizable scheduling configuration 🎯 Intelligent Deadline Detection Automatic identification of tickets expiring within the next 2 days Configurable date-based filtering criteria Efficient processing of multiple simultaneous tickets 👥 Targeted Notifications Personalized alerts sent to specific technicians via Microsoft Teams Automatic assignment based on ticket assignee Structured messages with key ticket information 🔧 Complete GLPI Integration Secure connection through GLPI REST API Authentication with application tokens Automatic session management (initiation and closure) Technical Functionalities Data Processing Extraction: Automatic queries to GLPI database Filtering: Ticket separation by assigned technician Transformation: Data formatting for readable notifications Conditional Flow Automatic evaluation of responsible technician Intelligent notification routing Handling of cases without specific assignment Session Management Automatic session initiation with GLPI Secure session token maintenance Controlled session closure upon completion Ticket Information Included Each alert contains: Ticket Title: Clear problem description Ticket ID: Unique identifier for tracking Time Remaining: Days/hours until expiration System Requirements Infrastructure GLPI server with REST API enabled Running n8n instance Microsoft Teams account with API permissions Required Credentials GLPI user with application administrator privileges Valid GLPI application token OAuth2 credentials for Microsoft Teams GLPI User ID Identification For complete workflow configuration, it's necessary to identify the correct IDs of technical users for proper notification assignment. User IDs can be obtained by accessing user management in GLPI and observing the ID directly in the browser URL when selecting a specific user. Path: Administration > Users > [Select User] When clicking on the desired user, you can see the user ID directly in the browser URL (e.g., id=7 for Support Technician 1, id=8 for Support Technician 2). Configuration Environment Variables json{ "glpi_url": "https://your-glpi-server.com", "app_token": "your-application-token-here" } Available Customization Alert Period**: Modifiable from 2 days to any desired range Execution Schedule**: Configurable according to operational needs Recipients**: Adaptable to specific team structure Operational Benefits For Support Teams Reduction of expired tickets Improved response times Proactive workload management For Organizations Higher SLA compliance Increased customer satisfaction Optimized technical support resources Ideal Use Cases IT Service Centers**: Incident and request management Technical Support Teams**: Critical case tracking Organizations with Strict SLAs**: Service agreement compliance IT Departments**: Internal ticket monitoring Scalability This workflow is designed to: Handle high ticket volumes Adapt to teams of different sizes Integrate with multiple communication channels Expand with additional functionalities Installation and Deployment Import the JSON workflow into n8n Configure GLPI and Microsoft Teams credentials Update configuration variables Activate the scheduled trigger Perform functionality tests This workflow represents a robust and scalable solution for proactive ticket management in enterprise environments, significantly improving operational efficiency and service commitment compliance. An n8n automation workflow template by Luis Hernandez.

By Budi SJ

YouTube Comment Sentiment & Keyword Extractor Template Google Sheets: Click here to open This workflow automatically retrieves comments from YouTube videos listed in Google Sheets, analyzes sentiment and keywords using an LLM, stores the results, then generates an aggregate summary and sends a report to Telegram. ✨ Key Features Automated Scheduling** – Runs the process at regular intervals. Google Sheets Integration** – Fetches a list of videos and stores analysis results directly in Google Sheets. YouTube Comment Retrieval** – Retrieves top-level comments (up to 100 per video; can be extended with pagination). Comment Parsing** – Flattens the API response into one item per comment. AI Sentiment & Keyword Analysis** – Powered by an LLM model to extract: Sentiment (positive, neutral, negative) Sentiment score (-1 to 1) Keywords (cleaned from stopwords, emojis, hashtags) Language (ISO 639-1, 2-letter code) Data Normalization** – Ensures LLM output is consistent and safe to write to the sheet. Telegram Reporting** – Sends a concise report for each video directly to a Telegram chat. 🔐 Required Credentials Google Sheets OAuth2 API** – Read & write access to the spreadsheet. YouTube Data API Key** – To fetch comments via commentThreads. OpenRouter API Key** – To access the LLM model. Telegram Bot API** – To send reports via a Telegram bot. 🎁 Benefits End-to-End Automation** – From comment retrieval to reporting, no manual steps required. No Duplication** – Each comment is uniquely tracked by comment_id. Data Transparency** – Raw and analyzed data stored neatly in Google Sheets. Actionable Insights** – Sentiment and keyword summaries ready for content strategy decisions. Scalable** – Can be extended for pagination, reply comment analysis, or additional metrics. Cross-Platform** – Direct Telegram integration for easy monitoring on any device. An n8n automation workflow template by Budi SJ.

By Daniel Rosehill

Voice Note Context Extraction Pipeline with AI Agent & Vector Storage This n8n template demonstrates how to automatically extract and store contextual information from voice notes using AI agents and vector databases for future retrieval. How it works Webhook trigger** receives voice note data including title, transcript, and timestamp from external services (example here: voicenotes.com) Field extraction** isolates the key data fields (title, transcript, timestamp) for processing AI Context Agent** processes the transcript to extract meaningful context while: Correcting speech-to-text errors Converting first-person references to third-person facts Filtering out casual conversation and focusing on significant information Output formatting** structures the extracted context with timestamps for embedding File conversion** prepares the context data for vector storage Vector embedding** uses OpenAI embeddings to create searchable representations Milvus storage** stores the embedded context for future retrieval in RAG applications How to use Configure the webhook endpoint to receive data from your voice note service Set up credentials for OpenRouter (LLM), OpenAI (embeddings), and Milvus (vector storage) Customize the AI agent's system prompt to match your context extraction needs The workflow automatically processes incoming voice notes and stores extracted context Requirements OpenRouter account for LLM access OpenAI API key for embeddings Milvus vector database (cloud or self-hosted) Voice note service with webhook capabilities (e.g., Voicenotes.com) Customizing this workflow Modify the context extraction prompt** to focus on specific types of information (preferences, facts, relationships) Add filtering logic** to process only voice notes with specific tags or keywords Integrate with other storage** systems like Pinecone, Weaviate, or local vector databases Connect to RAG systems** to use the stored context for enhanced AI conversations Add notification nodes** to confirm successful context extraction and storage Use cases Personal AI assistant** that remembers your preferences and context from voice notes Knowledge management** system for capturing insights from recorded thoughts Content creation** pipeline that extracts key themes from voice recordings Research assistant** that builds context from interview transcripts or meeting notes. An n8n automation workflow template by Daniel Rosehill.

By Automate With Marc

💬 GPT-5 Slack Impersonation Agent with RAG – Auto-Respond to Messages Using Live Project Docs Let AI handle your Slack conversations — and always have the right answer. This n8n workflow transforms GPT-5 into your on-brand Slack assistant, capable of responding as you in real-time while referencing a Google Docs RAG (Retrieval-Augmented Generation) document for accurate project updates. Watch step-by-step build like these on: https://www.youtube.com/@automatewithmarc Here’s how it works: Listens for Slack mentions or messages — triggered instantly when someone talks to you. Understands the conversation context using GPT-5 and conversation memory. Retrieves the latest project updates from your linked Google Doc via RAG. Responds in Slack as you — maintaining your tone, style, and workplace personality. Key Features & Benefits: 🧠 RAG-powered accuracy – Always pulls the latest info from your project docs. 🤖 GPT-5 natural conversation – Replies feel human, friendly, and context-aware. ⚡ Instant responses – No more message backlog or missed updates. 🎯 Impersonation mode – Sends replies under your Slack name for seamless collaboration. 🔄 Continuous conversation memory – Keeps track of what was said before. Ideal Use Cases: Acting as a stand-in during busy periods so no message goes unanswered. Project managers who want instant, document-backed answers. Customer support or client-facing roles needing quick, accurate replies. Included Integrations: Slack Trigger & Send Message – Listen and reply in real-time. GPT-5 Agent – Craft context-aware, on-brand responses. Google Docs Tool – Pull live data from your RAG document. Conversation Memory – Maintain context across messages. 💡 Pro Tip: Customize the system prompt to mimic your exact tone and integrate with multiple docs for broader knowledge coverage. An n8n automation workflow template by Automate With Marc.

By AI/ML API | D1m7asis

This workflow contains community nodes that are only compatible with the self-hosted version of n8n. 🌅 Daily AI Inspiration (n8n + AI/ML API + Telegram) This n8n workflow sends a short, original AI‑generated quote and a matching cinematic image to your Telegram chat every morning. It auto‑captures your chat ID from the first message you send to the bot, then runs on a daily schedule. 🚀 Key Features Zero‑Friction Delivery — Just send any message once; the chat ID is saved for daily drops. AI Quote Writer — GPT‑4o crafts concise, uplifting quotes (no author, no quotes). Cinematic Visuals — flux-pro turns each quote into a mood‑rich illustration. Hands‑Off Scheduling — Runs at a set time every day via Schedule Trigger. Telegram Ready — Sends the image + caption directly to your chat. 🛠 Setup Guide Create AI/ML API Credentials Get your API key in AI/ML API. In n8n → Credentials, add AI/ML API (Bearer token, Base URL https://api.aimlapi.com/v1). Create Telegram Credentials In Telegram, open @BotFather → /newbot → save the bot token. In n8n → Credentials → Telegram API, paste the token. Capture Chat ID Start the workflow, message your bot once (Telegram Trigger will store the chat ID automatically). Schedule & Test Set your preferred time in Schedule Trigger (e.g., 07:30). Execute once to confirm delivery, then enable the workflow. 💡 How It Works Trigger — Runs daily via Schedule Trigger (or manually after first chat message to capture chat ID). Quote Generation — AI/ML API (GPT‑4o) produces a short, original, uplifting line. Image Creation — AI/ML API (flux-pro) renders a cinematic image inspired by the quote. Telegram Delivery — Sends the image to your chat with the quote as the caption (🌅 prefix). Optional: tweak image size (1024×1024 by default), add logging (Google Sheets), or extend with moderation, model switching, or multi‑chat routing. An n8n automation workflow template by AI/ML API | D1m7asis.

By Davide Boizza

This workflow contains community nodes that are only compatible with the self-hosted version of n8n. This workflow automates the entire process of generating short AI videos using Google Veo3 Fast, enhancing them with SEO-optimized titles, and uploading them directly to TikTok via Postiz, all triggered from a central Google Sheet. This setup ensures a seamless pipeline from video creation to TikTok upload, with minimal manual intervention. Benefits Full automation** from prompt input to social media publishing. Cheaper video generation** using Veo3 Fast vs traditional AI video tools. Centralized management** through Google Sheets – no coding required for end users. SEO-enhanced titles** with GPT-4o to boost engagement. Scheduled or manual triggering**, perfect for batch operations. No manual uploads** – integration with Postiz means content is published hands-free. How It Works This workflow automates the process of generating AI videos using Google Veo3 Fast, saving them to Google Drive, and uploading them to TikTok via Postiz. Here’s how it functions: Trigger: The workflow can be started manually or scheduled (e.g., every 5 minutes) to check for new video requests in a Google Sheet. Video Generation: The workflow retrieves a video prompt and duration from the Google Sheet. It sends the prompt to Google Veo3 Fast via the Fal.ai API to generate the video. The system periodically checks the video generation status until it’s completed. Post-Processing: Once the video is ready, it is downloaded and uploaded to Google Drive. A YouTube-optimized title is generated using GPT-4o Mini based on the video prompt. TikTok Upload: The video is uploaded to Postiz, a social media scheduling tool. Postiz then publishes the video to the connected TikTok account with the generated title. Tracking: The Google Sheet is updated with the video URL for record-keeping. Set Up Steps To configure this workflow, follow these steps: Prepare the Google Sheet: Create a Google Sheet with columns: PROMPT: Description of the video. DURATION: Length of the video. VIDEO: (Leave empty, auto-filled by the workflow). Obtain API Keys: Sign up at Fal.ai to get an API key for Google Veo3 Fast. Replace YOURAPIKEY in the "Create Video" node’s HTTP header (Authorization: Key YOURAPIKEY). Configure Postiz for TikTok: Create a Postiz account (free trial available). Connect your TikTok account in Postiz and note the Channel ID. Replace XXX in the "TikTok" node with your TikTok Channel ID. Set the Postiz API key in the "Upload Video to Postiz" node. Set Up Google Drive & Sheets Access: Ensure the workflow has OAuth access to: Google Sheets (to read/write video data). Google Drive (to store generated videos). Schedule or Run Manually: The workflow can be triggered manually or scheduled (e.g., every 5 minutes) to process new video requests. Note: This workflow requires self-hosted n8n due to community node dependencies. Need help customizing? Contact me for consulting and support or add me on Linkedin. An n8n automation workflow template by Davide Boizza.

By Jay Emp0

This workflow automatically backs up all public Postgres tables into a GitHub repository as CSV files every 24 hours. It ensures your database snapshots are always up to date updating existing files if data changes, or creating new backups for new tables. How it works: Schedule Trigger – Runs daily to start the backup process. GitHub Integration – Lists existing files in the target repo to avoid duplicates. Postgres Query – Fetches all table names from the public schema. Data Extraction – Selects all rows from each table. Convert to CSV – Saves table data as CSV files. Conditional Upload – If the table already exists in GitHub → Update the file. If new → Upload a new file. Postgres Tables Preview GitHub Backup Preview Use case: Perfect for developers, analysts, or data engineers who want daily automated backups of Postgres data without manual exports keeping both history and version control in GitHub. Requirements: Postgres credentials with read access. GitHub repository (OAuth2 connected in n8n). An n8n automation workflow template by Jay Emp0.

By David Olusola

Overview: Automated WordPress Post Archiving This workflow is designed to maintain your blog's health and SEO by automatically moving old, published posts into a "draft" or "archive" state. This prevents outdated or low-traffic content from negatively impacting your site's performance and allows you to easily review and update them later. How It Works Quarterly Trigger: The workflow is set to run automatically on a recurring schedule, specifically on the 1st day of every 3rd month (quarterly). This ensures that your content is regularly audited without any manual intervention. Find Old Posts: The workflow connects to your WordPress site and fetches all published posts that are older than a specified time frame (in this case, 12 months). It uses the WordPress API's filtering capabilities to efficiently find the right content. Check if Posts Found: An If node checks if the previous step found any posts. This prevents the workflow from running further steps if there's nothing to archive. If no posts are found, the workflow ends and logs this. Archive Post: If posts are found, the workflow proceeds to update each one. It changes the post's status from publish to draft and automatically adds tags like archived and old-content for easy identification within your WordPress dashboard. Send Notification: After the archiving process is complete, the workflow sends an email notification to the administrator. This provides a summary of the activity, letting you know that the task has been completed. Setup Steps Configure WordPress Credentials: In both the Find Old Posts and Archive Post nodes, you need to add your WordPress credentials. This typically involves entering your site URL and creating an application password in your WordPress admin dashboard for secure API access. Set Up Email Credentials: In the Send Notification node, add your email service credentials (like SMTP or a Gmail account) to enable the workflow to send you the completion notification. Adjust the Archiving Period: In the Find Old Posts node, the current expression is {{ $now.minus({ months: 12 }).toISO() }} which archives posts older than 12 months. You can change the number of months to fit your content strategy (e.g., 24 for two years). Customize Tags: In the Archive Post node, you can customize the tags to better suit your needs. You can change or add new tags that will be applied to the archived posts. Activate the Workflow: Once all credentials and settings are configured, make sure to activate the workflow to set the quarterly schedule in motion. An n8n automation workflow template by David Olusola.

By David Olusola

Overview: GitHub to WordPress Tutorial Generator This workflow automates the process of creating technical tutorials for your blog. It runs on a weekly schedule, automatically identifies trending GitHub repositories, uses an AI to generate a detailed tutorial for each one, and then saves the content as a draft post on your WordPress site. Finally, it sends you an email notification so you can review and publish the new content. This is an excellent way to keep your blog fresh with relevant, trending topics without manual effort. How It Works Weekly Trigger: The workflow is set to activate every Monday at 10 AM, starting the entire process. Get Trending Repositories: The workflow makes an HTTP request to the GitHub API to find the most popular repositories. Split Items: The Split node processes the list of repositories from the GitHub API, handling each one as a separate item. This ensures that a unique tutorial is created for every trending repository. AI Tutorial Generation: The AI Tutorial Generator node, powered by the Google Gemini Chat Model, takes the information for each repository and, following a detailed prompt, creates a comprehensive tutorial. The prompt instructs the AI to include an introduction, prerequisites, code examples, best practices, and more. Format Content: A Code node then processes the AI's output. It extracts the title and content, ensuring the data is correctly formatted for the next steps. It's a key step to handle potential variations in the AI's output. Create WordPress Post: The WordPress node takes the formatted tutorial content and creates a new post on your blog, automatically setting the title, tags, and categories. It's saved as a draft, allowing you to review and edit it before publishing. Send Notification: Once the post is created, the Email node sends a notification to your email address, letting you know a new tutorial is ready for your review. Setup Steps Configure WordPress Credentials: In the Create Tutorial Post node, add your WordPress credentials. This includes your site URL, username, and application password. Set Up Email Credentials: In the Notify Admin node, add your email service credentials (e.g., SMTP, Gmail) to enable sending email notifications. Configure GitHub API Access: Manual Mapping: Run the Get Trending Repos node once to get sample data. In the Split Repository Items node, manually map the data by setting the "Field to Split Out" to json.items. This tells the workflow to process each repository in the API response. Optional: For higher API limits, you can create a GitHub Personal Access Token and configure the Get Trending Repos node to use it. Review AI Prompt: Go to the AI Tutorial Generator node and read the system message. You can adjust the prompt to change the style, length, or content of the tutorials the AI generates. An n8n automation workflow template by David Olusola.

By Omer Fayyaz

Who's it for This template is perfect for business owners, developers, and marketers who want to add a professional, branded AI chatbot to their website. Whether you're running an e-commerce site, a SaaS platform, or a corporate website, this template gives you a fully customizable chat widget that integrates seamlessly with your brand. How it works The template creates a webhook endpoint that receives chat messages and processes them through an AI agent powered by DeepSeek. The workflow includes: Webhook endpoint** that accepts POST requests from your website AI Agent** that processes user messages and maintains conversation context Memory buffer** that remembers conversation history for each user session Response formatting** that sends AI replies back to your chat widget The chat widget itself is a vanilla JavaScript component that you embed on your website. It features: Customizable colors, branding, and positioning Light/dark theme support Mobile-responsive design Local conversation history Session management with expiration WordPress plugin integration How to set up Import the workflow into your n8n instance Configure your DeepSeek API credentials in the DeepSeek Chat Model node Activate the workflow to generate your webhook URL Copy the webhook URL from the Webhook node Embed the chat widget on your website using the provided JavaScript files Requirements n8n instance** (self-hosted or cloud) DeepSeek API account** and API key Website** where you want to embed the chatbot Basic HTML/JavaScript knowledge** for customization How to customize the workflow AI Agent Configuration Modify the AI Agent prompt to change how the bot responds Adjust the memory buffer settings for conversation context Change the AI model parameters for different response styles Webhook Customization Add authentication headers if needed Modify the response format to match your requirements Add additional processing nodes before the AI Agent Chat Widget Styling Change brandColor and accentColor to match your brand Customize the bot name, avatar, and welcome message Adjust positioning and launcher style Enable dark mode or HTML responses as needed Advanced Features Add user authentication integration Implement rate limiting Connect to your CRM or support system Add analytics and tracking Template Features ✅ No hardcoded API keys - uses n8n credential system ✅ Sticky notes included - explains the entire workflow ✅ Professional branding - fully customizable appearance ✅ WordPress ready - includes plugin and shortcode support ✅ Mobile responsive - works on all devices ✅ Session management - remembers conversations per user Use Cases Customer Support**: Provide instant AI-powered assistance Lead Generation**: Engage visitors and collect contact information Product Guidance**: Help customers find the right products/services FAQ Automation**: Answer common questions automatically Booking Assistant**: Help with appointments and reservations E-commerce Support**: Guide customers through purchases Technical Details The workflow uses the LangChain AI Agent with DeepSeek as the language model and includes a Memory Buffer for conversation context. The webhook response format is optimized for the chat widget. Live Demo Try it online: Live Demo Experience the chatbox widget in action with a working n8n webhook integration. The demo showcases all features including light/dark themes, HTML responses, and session management. Note: This template includes a complete JavaScript chat widget and WordPress plugin, making it ready for immediate use on any website. The workflow is designed to be production-ready with proper error handling and security considerations. An n8n automation workflow template by Omer Fayyaz.

By Patrik Schick

How it works Every day at 6:00 AM, the workflow pulls all events from your Google Calendar scheduled for that day. It extracts each event’s ID, title, and start time, aggregates them into one list, and converts them into a text string. This text is passed to an AI-powered Information Extractor (using Claude 3.5 Sonnet) to format the events into a clear daily summary. Finally, the summary is sent as a Telegram message to your chosen chat ID, giving you a ready-to-read daily to-do list. How to use Connect your Google Calendar account to the Get many events node. Set the correct calendar in the calendar field. Link your Telegram account and set your chatId in the Send a text message node. Adjust the Schedule Trigger node if you want a different reminder time. Activate the workflow — it will run daily and send your event summary to Telegram automatically. Customising this workflow Reminder time: Change triggerAtHour in the Schedule Trigger node for morning, evening, or multiple reminders per day. Calendar source: Switch to another Google Calendar or add multiple Get many events nodes for different calendars. Message style: Edit the Information Extractor system prompt to change language, formatting, or level of detail in your summary. Delivery channel: Replace or add another messaging node (e.g., Email, Slack, WhatsApp) if you want your to-do list in different apps. Event filtering: Add a filter before aggregation to include only certain event types or keywords (e.g., “Meeting”, “Deadline”). An n8n automation workflow template by Patrik Schick.

By Marko Korhonen

This workflow contains community nodes that are only compatible with the self-hosted version of n8n. How it works It creates a nested folder in your OneDrive's My Files You could be creating folders like: Foobar Foobar/Barfur Foobar/Barfur/Furbar Workflow checks if any of the folders in the path exists and created only the ones that don't exist. The usual case it to use it in your other workflows and execute it as Sub-workflow. Requirements n8n-nodes-datastore Community node Microsoft Drive account credential. An n8n automation workflow template by Marko Korhonen.

By Sidd

This workflow has 2 Broad Steps Step 1 - Vector store creation with set of ipl rules using Google Gemini Embedding. This will we used to drive RAG for model grouding Step 2 - Connecting the vector store with google gemini API model and enabling a chat interface to drive the chat bot Step 1 Load the reference material (run once via the Manual Trigger) 1.1 Manual Trigger → HTTP Request downloads the IPL “Match Playing Conditions” PDF. 1.2 Default Data Loader extracts text from the PDF. **Type of data is binary 1.3 Recursive Character Text Splitter breaks the text into overlapping chunks. **This step ensures that the data chunks that are created in vector store have some overlap and hence less chance of hallucination **Chunk size and chunk overlap are 2 variables to manage this 1.4 Embeddings Google Gemini (1) converts each chunk to a vector. **Connect the model with google gemini model. You will need your own api key for this **Make note of the embedding model also since the same embedding model has to be selected in Step 2 1.5 Simple Vector Store 1 inserts those vectors into an in-memory store under key **Make note of the vector store name since it is same vector store you will have to use in Step 2 Note: Google gemini API key credential needed ##Using Vector store nodes provided by n8n is the best way to get started to test out the workflow before you switch to more enterprise grade vector store nodes Step 2 2.1 Chat Trigger to initiate n8n native chat interface 2.2 Simple Memory keeps the last 20 chat turns for context. This value can be edited within the node 2.3 Simple Vector Store (retrieve-as-tool mode) receives the user’s query embedding, finds the top-10 most relevant chunks stored in step 1, and supplies them as tool output. This will drive RAG **The name of vector store should match from Step 1, the embedding rule should match step 1 2.4 Google Gemini Chat Model is the language model that is used as the llm model 2.5 AI Agent orchestrates everything: ** Uses the system prompt (“You are a cricket expert… If info is missing, say ‘Sorry I don’t know’”). to prompt the model ** Has access to the memory (2.2) and the RAG tool (2.3). ** Generates the final response with Google Gemini, strictly limited to the retrieved IPL cricket rules data. Note: Google gemini API key credential needed ##Using simple memory store nodes provided by n8n is the best way to get started to test out the workflow before you switch to more enterprise grade vector store nodes. An n8n automation workflow template by Sidd.

By Vitorio Magalhães

Who’s it for This template is designed for individuals who want to gain full control over their personal finances without the hassle of manual tracking. Ideal for freelancers, small business owners, or anyone who wants a simple, automated way to monitor income and expenses. How it works / What it does Using n8n, Telegram, and Google Sheets, this workflow allows you to log, edit, and query your financial transactions through simple Telegram messages. The AI interprets your input—whether text or audio—and automatically categorizes your income and expenses. Responses are delivered fully formatted in Telegram HTML, giving you clean, readable summaries and insights. Features include: Add, edit, and delete transactions automatically Query totals and category-specific expenses, e.g., “How much did I spend on food this month?” Generate financial summaries and monthly reports Automatic ID assignment and date handling How to set up Deploy this workflow on your self-hosted n8n instance. Connect your Telegram Bot and Google Sheets account. Configure the Google Gemini AI node for message interpretation. Update sheet headers and categories if needed. Start sending messages to your Telegram bot to track expenses instantly. How to Set Up the Google Sheet To use this workflow, you’ll need a Google Sheet with the following structure: | Column Name | Description | | ------------------- | ----------------------------------------------- | | id | Unique sequential identifier (auto-incremented) | | type | "income" or "expense" | | value | Monetary value (format: 1234.56) | | category | Classification of the transaction | | payment\_method | Payment method used (e.g., card, cash, PIX) | | description | Details about the transaction | | date | Transaction date (format: yyyy-MM-dd) | Make sure the column headers match exactly as shown above, and leave the rows empty for the bot to fill automatically. Requirements n8n (self-hosted or cloud instance) Telegram Bot API Google Sheets Google Gemini AI or equivalent AI node. An n8n automation workflow template by Vitorio Magalhães.

By Paul

✉️ AI-Powered 3-Step B2B Pipeline — Lead Gen → Cold Outreach → AI Drafted Email Management Automate your outbound workflow from prospecting to AI-generated reply drafts in Gmail — all fully integrated with your database. Ideal for SDRs, founders, and growth agencies who want speed, personalization, and control without losing human review. 📌 Example: From a verified lead list to a qualified opportunity — fully tracked, classified, and pre-drafted with this automation. 🚀 What This Workflow Does Step 1 — Lead Generation Import leads from Apollo. Enrich and verify emails. Store results in Supabase/Postgres, Step 2 — Cold Outreach Send 3 step personalized sequences via Mailgun/SendGrid. Track delivery, opens, replies, and bounces directly in your DB. Step 3 — Email Management (AI Drafts) Process only incoming Gmail messages from contacts in your DB. Generate personalized reply drafts, label threads, update lead status, and alert your team via Slack/Telegram. 🔗 Integrated Services Database:** Supabase/Postgres Outbound Email:** Mailgun / SendGrid Inbound Email & Drafts:** Gmail (OAuth2) AI Models:** OpenAI / Anthropic (JSON mode for classification + drafting) Alerts:** Slack / Telegram (optional) 💼 What You Get Detailed setup guide Fully connected 3-step pipeline in n8n Ready-to-use database schema Pre-built AI prompts for intent classification and professional replies 📥 Perfect For SDR teams doing targeted outbound Agencies managing multiple client campaigns Founders building scalable outbound systems Sales ops needing a no-risk, review-first reply process 💡 Why You’ll Love It This isn’t just another outreach template — it’s a full sales engine. From verified leads to AI-drafted replies, every action is logged, tracked, and controlled for maximum conversions without sacrificing oversight. An n8n automation workflow template by Paul.

By Annie To

This workflow automatically processes customer support requests from emails and web forms, uses AI to classify and either auto-resolve simple issues or intelligently route complex ones to the right team members with proper JIRA tickets and SLA tracking. Key Benefits Multi-channel support (email + web forms) Smart routing to qualified agents based on expertise Consistent ticket creation with full context in JIRA Perfect For Support teams handling 50+ requests/day SaaS companies with tiered customer support Organizations wanting to scale support without hiring Teams needing consistent ticket classification Requirements Microsoft Outlook (email monitoring) OpenAI API (AI classification) JIRA Cloud (ticket management) n8n instance with AI nodes. An n8n automation workflow template by Annie To.

By Robert Breen

This n8n workflow template automatically pulls marketing data from Google Sheets, calculates key performance metrics, and sends beautifully formatted HTML email reports. Perfect for marketing teams, agencies, or businesses that need regular performance reporting without manual data processing. What This Workflow Does This automated workflow: Retrieves marketing campaign data from Google Sheets Calculates 5 key performance metrics (customers, campaigns, clicks, conversions, spend) Merges all statistics into a single data object Sends a professional HTML email report with modern styling Can be run manually or scheduled for regular reporting The workflow processes data including Customer ID, Campaign names, Clicks, Conversions, and Spend amounts to generate comprehensive performance summaries. Tools & Services Used N8N** - Workflow automation platform Google Sheets** - Marketing data source and storage Microsoft Outlook** - Email delivery system HTML/CSS** - Professional report formatting Step-by-Step Implementation Step 1: Set Up Your Google Sheets Data Source Copy the Sample Data Template: Access the template: Marketing Performance Data Template Click "File" → "Make a copy" to create your own version Rename it (e.g., "My Marketing Performance Data") Set Up Your Data Structure: Your Google Sheet should have a "Data" tab with these columns: Customer ID** - Unique identifier for each customer Campaign** - Name of the marketing campaign Clicks** - Number of clicks generated Conversions** - Number of conversions achieved Spend ($)** - Amount spent on the campaign Configure Google Sheets API Access: Go to Google Cloud Console Create a project or select existing one Enable "Google Sheets API" Create OAuth2 credentials or use service account Share your sheet with the service account email (if using service account) Step 2: Import and Configure the N8N Workflow Import the Workflow: Copy the workflow JSON from the template In your N8N instance, go to Workflows → Import from JSON Paste the JSON and import the workflow Step 3: Configure Each Node Node 1: "When clicking 'Execute workflow'" (Manual Trigger) Purpose**: Starts the workflow manually for testing Configuration**: No setup required Note**: You can replace this with a Schedule Trigger for automated reports Node 2: "Get Google Sheets Data" Purpose**: Retrieves all marketing data from your Google Sheet Setup Required**: Click on the node Set up Google Sheets OAuth2 credentials: Click "Create New Credential" Follow OAuth2 setup process Authorize access to your Google account Select your spreadsheet from the dropdown Choose the "Data" sheet Test the connection to ensure data loads Node 3-7: Data Analysis Nodes "Count Unique Customers" Purpose**: Counts how many unique customers were reached Configuration**: Pre-configured to count unique "Customer ID" values No setup required** "Count Unique Campaigns" Purpose**: Counts total number of campaigns run Configuration**: Pre-configured to count unique "Campaign" values No setup required** "Sum Total Clicks" Purpose**: Adds up all clicks across campaigns Configuration**: Pre-configured to sum "Clicks" column No setup required** "Sum Total Conversions" Purpose**: Totals all conversions achieved Configuration**: Pre-configured to sum "Conversions" column No setup required** "Sum Total Spend" Purpose**: Calculates total marketing spend Configuration**: Pre-configured to sum "Spend ($)" column No setup required** Node 8: "Merge" Purpose**: Combines all calculated metrics into one data object Configuration**: Pre-configured to merge by position No setup required** Node 9: "Send Email Report" (Microsoft Outlook) Purpose**: Sends the formatted HTML email report Setup Required**: Click on the node Set up Microsoft Outlook OAuth2 credentials: Click "Create New Credential" Follow OAuth2 setup for your Microsoft account Grant necessary email permissions Configure Email Settings: To Recipients: Change from "rbreen@ynteractive.com" to your recipient email(s) Subject: Modify "Daily Marketing Performance" as needed Body Content: Pre-configured with professional HTML template Email Template Features: Modern glassmorphic design Responsive layout for mobile devices Animated gradient accents Hover effects on metric cards Professional typography For professional setup, customization, or troubleshooting of this workflow, contact: Robert - Ynteractive Solutions Email**: robert@ynteractive.com Website**: www.ynteractive.com LinkedIn**: linkedin.com/in/robert-breen-29429625/ Specializing in AI-powered workflow automation, business process optimization, and custom integration solutions. An n8n automation workflow template by Robert Breen.

By Robert Breen

This n8n workflow template automatically monitors your Google Sheets for new entries and uses AI to generate detailed descriptions for each topic. Perfect for content creators, researchers, project managers, or anyone who needs automatic content generation based on simple topic inputs. What This Workflow Does This automated workflow: Monitors a Google Sheet for new rows added to the "data" tab Takes the topic from each new row Uses OpenAI GPT to generate a detailed description of that topic Updates the same row with the AI-generated description Logs all activity in a separate "actions" tab for tracking The workflow runs every minute, checking for new entries and processing them automatically. Tools & Services Used N8N** - Workflow automation platform OpenAI API** - AI-powered description generation (GPT-4.1-mini) Google Sheets** - Data input, storage, and activity logging Google Sheets Trigger** - Real-time monitoring for new rows Prerequisites Before implementing this workflow, you'll need: N8N Instance - Self-hosted or cloud version OpenAI API Account - For AI description generation Google Account - For Google Sheets integration Google Sheets API Access - For both reading and writing to sheets Step-by-Step Setup Instructions Step 1: Set Up OpenAI API Access Visit OpenAI's API platform Create an account or log in Navigate to API Keys section Generate a new API key Copy and securely store your API key Step 2: Set Up Your Google Sheets Option 1: Use Our Pre-Made Template (Recommended) Copy our template: AI Description Generator Template Click "File" → "Make a copy" to create your own version Rename it as desired (e.g., "My AI Content Generator") Note your new sheet's URL - you'll need this for the workflow Option 2: Create From Scratch Go to Google Sheets Create a new spreadsheet Set up the main "data" tab: Rename "Sheet1" to "data" Set up column headers in row 1: A1: topic B1: description Create an "actions" tab: Add a new sheet and name it "actions" Set up column headers: A1: Update Copy your sheet's URL Step 3: Configure Google API Access Enable Google Sheets API Go to Google Cloud Console Create a new project or select existing one Enable "Google Sheets API" Enable "Google Drive API" Create Service Account (for N8N) In Google Cloud Console, go to "IAM & Admin" → "Service Accounts" Create a new service account Download the JSON credentials file Share your Google Sheet with the service account email address Step 4: Import and Configure the N8N Workflow Import the Workflow Copy the workflow JSON from the template In your N8N instance, go to Workflows → Import from JSON Paste the JSON and import Configure OpenAI Credentials Click on the "OpenAI Chat Model" node Set up credentials using your OpenAI API key Test the connection to ensure it works Configure Google Sheets Integration For the Trigger Node: Click on "Row added - Google Sheet" node Set up Google Sheets Trigger OAuth2 credentials Select your spreadsheet from the dropdown Choose the "data" sheet Set polling to "Every Minute" (already configured) For the Update Node: Click on "Update row in sheet" node Use the same Google Sheets credentials Select your spreadsheet and "data" sheet Verify column mapping (topic → topic, description → AI output) For the Actions Log Node: Click on "Append row in sheet" node Use the same Google Sheets credentials Select your spreadsheet and "actions" sheet Step 5: Customize the AI Description Generator The workflow uses a simple prompt that can be customized: Click on the "Description Writer" node Modify the system message to change the AI behavior: write a description of the topic. output like this. { "description": "description" } Need Help with Implementation? For professional setup, customization, or troubleshooting of this workflow, contact: Robert - Ynteractive Solutions Email**: robert@ynteractive.com Website**: www.ynteractive.com LinkedIn**: linkedin.com/in/robert-breen-29429625/ Specializing in AI-powered workflow automation, business process optimization, and custom integration solutions. An n8n automation workflow template by Robert Breen.

By Annie To

Google Drive Folder Duplicator This n8n workflow creates a complete recursive copy of any Google Drive folder, preserving the entire folder structure, all files, and sharing permissions. What It Does Duplicates folders with unlimited nested subfolders Copies all files maintaining original names and metadata Preserves sharing permissions (users, groups, domains) Creates identical folder hierarchy in target location How It Works Initialize: Sets source/target folders and creates main destination folder Recursive Processing: Scans each folder level, splits files from subfolders File Handling: Copies files and applies original permissions Folder Handling: Creates subfolders and applies original permissions Self-Recursion: Calls itself for each subfolder to process unlimited nested levels Key Features Unlimited Depth: Handles any number of nested folder levels Permission Preservation: Maintains exact sharing settings Requirements Google Drive OAuth2 credentials with drive access. An n8n automation workflow template by Annie To.

By Matheus Pedrosa

Workflow Overview This workflow provides a complete, automated post-purchase solution triggered by a successful payment webhook from Abacate Pay. (For international users, think of Abacate Pay as 'the Brazilian Stripe' – a popular and robust payment gateway in Brazil). When a successful payment is registered, this workflow instantly sends a beautiful, responsive HTML confirmation email to the customer and posts a detailed notification to a designated Slack channel. The key feature is its ability to dynamically reward first-time buyers. The workflow checks the customer's purchase history, and if it's their first order, it automatically generates a 10% discount coupon for their next purchase and includes it in the welcome email. Key Features: Webhook Trigger:** Securely listens for successful payment events from Abacate Pay. First-Time Buyer Detection:** Queries past orders to identify new customers. Automatic Coupon Generation:** Creates a unique, single-use discount coupon for new buyers. Dynamic Content:** The email and Slack messages automatically include the coupon details, but only for first-time buyers. Responsive HTML Email:** Sends a professional and mobile-friendly order confirmation. Rich Slack Notifications:** Uses Block Kit for well-formatted, actionable alerts for your team. Centralized Configuration:** A single Configs node makes it easy to manage static variables like company name and tokens. Setup Instructions: Webhook Node: Copy the webhook URL and paste it into your Abacate Pay dashboard for the "payment successful" event (e.g., billing.paid). Configs Node: Open this Set node and fill in your company's information (companyName, companySite, companyEmail) and the token used to validate the webhook requests. HTTP Request Nodes (GetOrders, CreateCustomCoupon): In both nodes, go to the "Authentication" or "Header" section and replace the placeholder Bearer Token with your actual Abacate Pay API key. Send Email Node: Select your email credentials from the dropdown or configure a new account (e.g., SMTP, Gmail). Slack Node: Select your Slack credentials and choose the channel where you want to receive notifications. Activate the Workflow: Save and activate the workflow. It's now ready to process incoming orders! Required Credentials: Abacate Pay API Credentials Email Credentials (e.g., SMTP, SendGrid, Gmail) Slack API Credentials. An n8n automation workflow template by Matheus Pedrosa.

By Giovanni Beggiato

How it works: Detects new unread Gmail messages Extracts sender name for personalized replies Classifies the email into one of four categories Applies the correct Gmail label and either sends an auto-reply, creates a draft, or logs the contact in Google Sheets Setup steps: Takes about 5–10 minutes to connect accounts and set labels Connect Gmail, OpenAI, and optional Google Sheets in n8n Add label IDs, Google Sheet ID, sheet name, and phone number in Set – Config Create four Gmail labels for the categories Keep full setup instructions in the sticky notes inside the workflow. An n8n automation workflow template by Giovanni Beggiato.

By David Olusola

WordPress Daily News Digest Generator Overview: This automation automatically fetches trending tech news every morning, uses AI to create engaging blog posts from each article, and publishes them directly to your WordPress site. What it does: Fetches top 10 US technology news stories every day at 8 AM via NewsAPI Splits articles into individual items for processing Processes each article through a loop system AI creates expanded, engaging blog posts (600-800 words) from each news article Parses AI response to extract clean titles and content Publishes individual blog posts to WordPress automatically Setup Required: NewsAPI Configuration Get free API key from newsapi.org (1,000 requests/day free) Replace YOUR_API_KEY in the HTTP Request URL with your actual key Customize country/category parameters in URL if needed WordPress Connection Configure WordPress credentials in the "Publish to WordPress" node Enter your WordPress site URL, username, and password/app password AI Configuration Set up Google Gemini API credentials Connect the Gemini model to the "AI News Summarizer" node Customization Options Publishing Schedule: Modify schedule trigger (default: daily 8 AM) News Sources: Change country, category, or pageSize in NewsAPI URL Content Style: Adjust AI system message for different writing tones Post Status: Change from "publish" to "draft" for manual review Testing Run workflow manually to test all connections Verify news articles are fetched correctly Check that blog posts appear properly on your WordPress site Features: Automatic daily content creation AI-generated unique titles and expanded content Loop processing for multiple articles per day Duplicate content filtering (removes incomplete articles) SEO-optimized blog post formatting Automatic tagging and categorization Customization: Change news categories (technology, business, science, etc.) Adjust posting frequency (hourly, twice daily, etc.) Modify AI prompts for different writing styles Add custom categories and tags Change article limits (currently 5 articles max) Need Help? For n8n coaching or one-on-one consultation. An n8n automation workflow template by David Olusola.

By David Olusola

WordPress Weekly Newsletter Generator Overview: This automation automatically converts your latest WordPress posts into beautifully formatted email newsletters using AI, then sends them to your subscriber list every Friday. What it does: Fetches your latest WordPress posts from the past week every Friday at 10 AM Filters posts to ensure there's content to include AI creates an engaging newsletter with compelling subject line and HTML content Parses the AI response to extract subject and content Sends formatted HTML email newsletter to your subscriber list Setup Required: WordPress Connection Configure WordPress credentials in the "Fetch Recent Posts" node Enter your WordPress site URL, username, and password/app password Email SMTP Setup Set up SMTP credentials (Gmail, SendGrid, Mailgun, etc.) in the "Send Newsletter" node Replace newsletter@yoursite.com with your actual sender email Replace subscriber emails in "To Email" field with your actual subscriber list Configure reply-to address for professional appearance AI Configuration Set up Google Gemini API credentials Connect the Gemini model to the "AI Newsletter Creator" node Customization Options Newsletter Schedule: Modify schedule trigger (default: Friday 10 AM) Post Count: Adjust number of posts to include (default: 5 from past week) Content Style: Modify AI system message for different newsletter tones Email Design: Customize HTML template and styling in AI prompt Testing Run workflow manually to test all connections Send test newsletter to yourself first Verify HTML formatting appears correctly in email clients Features: Automatic weekly scheduling AI-generated compelling subject lines HTML email formatting with proper structure Post filtering to avoid empty newsletters Professional email headers and reply-to setup Batch processing of multiple recent posts Customization: Change newsletter frequency (daily, bi-weekly, monthly) Adjust AI prompts for different writing styles Modify email template design Add custom intro/outro messages Include featured images from posts Need Help? For n8n coaching or one-on-one consultation. An n8n automation workflow template by David Olusola.

By David Olusola

This workflow contains community nodes that are only compatible with the self-hosted version of n8n. WordPress to Blotato Social Publisher Overview: This automation monitors your WordPress site for new posts and automatically creates platform-specific social media content using AI, then posts to Twitter, LinkedIn, and Facebook via Blotato. What it does: Monitors WordPress site for new posts every 30 minutes Filters posts published in the last hour to avoid duplicates Processes each new post individually AI generates optimized content for each social platform (Twitter, LinkedIn, Facebook) Extracts platform-specific content from AI response Publishes to all three social media platforms via Blotato API Setup Required: WordPress Connection Configure WordPress credentials in the "Check New Posts" node Enter your WordPress site URL, username, and password/app password Blotato Social Media API Setup Get your Blotato API key from your Blotato account Configure API credentials in the Blotato connection node Map each platform (Twitter, LinkedIn, Facebook) to the correct Blotato channel AI Configuration Set up Google Gemini API credentials Connect the Gemini model to the "AI Social Content Creator" node Customization Options Posting Frequency: Modify schedule trigger (default: every 30 minutes) Content Tone: Adjust AI system message for different writing styles Post Filtering: Change time window in WordPress node (default: last hour) Platform Selection: Remove any social media platforms you don’t want to use Testing Run workflow manually to test connections Verify posts appear correctly on all platforms Monitor for API rate limit issues Features: Platform-optimized content (hashtags, character limits, professional tone) Duplicate prevention system Batch processing for multiple posts Featured image support Customizable posting frequency Customization: Change monitoring frequency Adjust AI prompts for different tones Add/remove social platforms Modify hashtag strategies Need Help? For n8n coaching or one-on-one consultation. An n8n automation workflow template by David Olusola.

By Cai Yongji

GitHub Trending to Supabase (Daily, Weekly, Monthly) Who is this for? This workflow is for developers, researchers, founders, and data analysts who want a historical dataset of GitHub Trending repositories without manual scraping. It’s ideal for building dashboards, newsletters, or trend analytics on top of a clean Supabase table. What problem is this workflow solving? Checking GitHub Trending by hand (daily/weekly/monthly) is repetitive and error-prone. This workflow automates collection, parsing, and storage so you can reliably track changes over time and query them from Supabase. What this workflow does Scrapes GitHub Trending across Daily, Weekly, and Monthly timeframes using FireCrawl. Extracts per-project fields: name, url, description, language, stars. Adds a type dimension (daily / weekly / monthly) to each row. Inserts structured results into a Supabase table for long-term storage. Setup Ensure you have an n8n instance (Cloud or self-hosted). Create credentials: FireCrawl API credential (no hardcoded keys in nodes). Supabase credential (URL + Service Role / Insert-capable key). Prepare a Supabase table (example): CREATE TABLE public.githubtrending ( id bigint GENERATED ALWAYS AS IDENTITY NOT NULL, created_at timestamp with time zone NOT NULL DEFAULT now(), data_date date DEFAULT now(), url text, project_id text, project_desc text, code_language text, stars bigint DEFAULT '0'::bigint, type text, CONSTRAINT githubtrending_pkey PRIMARY KEY (id) ); Import this workflow JSON into n8n. Run once to validate, then schedule (e.g., daily at 08:00). An n8n automation workflow template by Cai Yongji.

By Jimmy Gay

Automate your B2B prospecting by finding local businesses and sending AI-personalized outreach emails to qualified contacts. What This Workflow Does This workflow acts as a powerful AI Sales Assistant, automating your entire B2B lead generation process for local businesses. It saves you countless hours of manual research and outreach by intelligently finding prospects, enriching their data, and drafting personalized emails tailored to their specific business. Stop prospecting manually and start scaling your outreach efforts effectively. How It Works The process is designed to be both smart and efficient: Find Businesses: It starts by searching for local businesses based on your criteria (e.g., "engineering in London"). Qualify & Enrich: It filters out businesses without a website. For the valid ones, it scrapes the website's title and description to understand what they do. Identify Contacts: Using Hunter.io, it finds professional email contacts associated with the company and verifies their validity to ensure high-quality leads. Generate AI-Personalized Emails: For each valid contact, it uses OpenAI to write a unique, short, and professional outreach email. The AI uses the scraped website information to create a personalized hook, showing you've done your research. Send & Organize: The final email is sent automatically via your Gmail account. If a business has no website, a follow-up task is created in your Google Tasks for manual review. Key Benefits Save Time: Automate a time-consuming prospecting process from start to finish. Increase Reply Rates: Engage prospects with personalized emails, not generic templates. Scale Your Outreach: Generate and contact dozens of qualified leads effortlessly. Stay Organized: Never lose a lead, thanks to the integrated task management for manual follow-ups. An n8n automation workflow template by Jimmy Gay.

By Luis Hernandez

Custom Interface for GLPI with n8n Transform your GLPI system's user experience with a modern, optimized web interface that simplifies technical support ticket creation. How it works Unified entry portal: Users access an intuitive web form where they select between "Request" or "Incident" Custom data collection: Specific forms adapt fields based on ticket type, requesting only relevant information Automatic processing: The system automatically maps categories and priorities, creates tickets in GLPI via REST API File management: Allows document attachments that are automatically linked to the created ticket Confirmation and tracking: Provides the generated ticket ID for future follow-up Key benefits ✅ More user-friendly interface than native GLPI interface ✅ Adaptive forms based on request type ✅ Error reduction through automatic validations ✅ Mobile-optimized user experience ✅ Seamless integration with existing GLPI Setup steps ⏱️ Estimated time: 15-20 minutes Prerequisites GLPI server with REST API enabled User with application administrator privileges Application token generated in GLPI Basic configuration Connection variables: Update GLPI server URL and application token in the "Configuration Variables" node Authentication credentials: Configure HTTP Basic Auth credentials for GLPI connection Category IDs: Identify and map ITIL category IDs in the processing nodes Form customization: Adapt fields, options, and categories according to organizational needs Activation Activate the workflow and obtain web form URLs Share the portal link with end users Perform ticket creation tests Ideal use cases Companies looking to improve GLPI user experience Organizations needing more intuitive support forms IT teams wanting to reduce miscategorized tickets Companies requiring mobile-friendly support interfaces Technologies used n8n (orchestration and web forms) GLPI REST API HTTP Basic Authentication Automatic session management. An n8n automation workflow template by Luis Hernandez.

By Peliqan

How it works This template is an end-to-end demo of an in-house AI agent that can answer a wide range of questions by retrieving information from the Uniconta ERP system. For example users can ask questions related to products, stock, accounting or any other type of information contained in Uniconta. Peliqan.io is used as a "cache" of all Uniconta data. Peliqan uses one-click ELT to sync all data from Uniconta to the built-in data warehouse, allowing for fast & accurate queries. The AI agent uses Text-to-SQL to answer questions. Text-to-SQL is performed via the Peliqan node, added as a tool to the AI Agent. The question of the user - in natural language - is converted to an SQL query by the AI Agent. The query is executed by Peliqan.io on the source Uniconta data and the result is interpreted by the AI Agent. Preconditions You signed up for a Peliqan.io free trial account You have a Uniconta ERP system Set up steps Sign up for a free trial on peliqan.io Add Uniconta as a connection in Peliqan (using an API key from Uniconta) Copy your Peliqan API key (in Peliqan go to Settings > API key) and use it in n8n to add a Peliqan connection Select your data warehouse in the Peliqan node "Execute an SQL query via Peliqan" in the drop-down field "Data warehouse name or id" Optional: run the template script in Peliqan that outputs your specific Uniconta datamodel (tables & columns). Copy your datamodel and paste it in the System Message of the AI Agent (replace the standard Uniconta model already present in this workflow) Visit peliqan.io/n8n for more information. Need help ? Contact Peliqan at support@peliqan.io Disclaimer: This template contains a community node and therefore only works for n8n self-hosted users. An n8n automation workflow template by Peliqan.

By Will Carlson

What it does: Collects cybersecurity news from trusted RSS feeds and uses OpenAI’s Retrieval-Augmented Generation (RAG) capabilities with Pinecone to filter for content that is directly relevant to your organization’s tech stack. “Relevant” means the AI looks for news items that mention your specific tools, vendors, frameworks, cloud platforms, programming languages, operating systems, or security solutions — as described in your .txt scope documents. By training on these documents, the system understands the environment you operate in and can prioritize news that could affect your security posture, compliance, or operational stability. Once filtered, summaries of the most important items are sent to your work email every day. How it works Pulls in news from multiple cybersecurity-focused RSS feeds:** The workflow automatically collects articles from trusted, high-signal security news sources. These feeds cover threat intelligence, vulnerability disclosures, vendor advisories, and industry updates. Filters articles for recency and direct connection to your documented tech stack:** Using the publish date, it removes stale or outdated content. Then, leveraging your .txt scope documents stored in Pinecone, it checks each article for references to your technologies, vendors, platforms, or security tools. Uses OpenAI to generate and review concise summaries:** For each relevant article, OpenAI creates a short, clear summary of the key points. The AI also evaluates whether the article provides actionable or critical information before passing it through. Trains on your scope using Pinecone Vector Store (free) for context-aware filtering:** Your scope documents are embedded into a vector store so the AI can “remember” your environment. This context ensures the filtering process understands indirect or non-obvious connections to your tech stack. Aggregates and sends only the most critical items to your work email:** The system compiles the highest-priority news items into one daily digest, so you can review key developments without wading through irrelevant stories. What you need to do: Setup your OpenAI and Pinecone credentials in the workflow Create and configure a Pinecone index (dimension 1536 recommended) Pinecone is free to setup. Setup Pinecone with a single free index. Use a namespace like: scope. Make sure the embedding model is the same for all of your Pinecone references. Submit .txt scope documents listing your technologies, vendors, platforms, frameworks, and security products. .txt does not need to be structured. Add as much detail as possible. Update AI prompts to accurately describe your company’s environment and priorities. An n8n automation workflow template by Will Carlson.

By Oneclick AI Squad

This n8n workflow automatically fetches top technology news from Google News, summarizes it using AI, and sends a daily email with key updates. Users get a concise overview of important tech developments every morning. Good to know: Focuses specifically on technology news. Summarizes multiple sources into one concise email. Ensures consistent and easy-to-read formatting. Handles updates from different websites reliably. How it works Trigger: Schedule Daily Tech News Runs automatically every morning at 8 AM. Fetch Google Tech News Retrieves the latest tech news from Google News. Extract Tech News Articles Parses the HTML to extract headlines, source, and timestamps. Format Tech News Data Prepares structured data ready for AI analysis. Check If News Found If no news is found, sends an error alert email. Otherwise, continues to AI summarization. AI Tech News Analyzer Uses an AI model to summarize and highlight key trends. Send Tech News Email Sends a formatted daily email with summarized tech news. Send Error Alert (optional) Sends an alert email if no news can be found. Email Examples Output Email Example: Subject: 🌐 Daily Tech News Summary - August 14, 2025 📌 Top Technology Headlines Today: AI-powered tools are revolutionizing cloud computing. (Source: TechCrunch) Startup funding in India sees record growth. (Source: Economic Times) New smartphone launches include innovative camera features. (Source: The Verge) Cybersecurity threats increase amid remote work trends. (Source: Wired) 🗓️ Summary Date: August 14, 2025 How to use Setup Instructions: Import workflow into your n8n instance. Configure SMTP credentials for sending emails. Set the schedule to run daily at your preferred time. Test the workflow to ensure news is fetched and the email is sent correctly. Requirements: n8n instance (cloud or self-hosted). Email account with SMTP access. Reliable internet connection. Access to Google News. Troubleshooting: No news found:** Check internet connection and Google News accessibility. Email not sent:** Verify SMTP credentials. AI summarization errors:** Check model credentials and API usage. An n8n automation workflow template by Oneclick AI Squad.

By Ariyanto Catur Pamungkas

Filter incoming emails via IMAP, extract & clean the body into plain text, normalize (title/slug/snippet/date/from/url), check for duplicates in Postgres, store as a row in a Notion database, then send a Telegram notification. Perfect for building a knowledge base or inbox triage automation without duplicate noise. Key Features IMAP polling (Only UNSEEN). Extract & clean HTML → plain text. Normalization: title, snippet, bodyText, slug, messageId, sentAt, fromAddress, sourceUrl. Deduplication via Postgres (SELECT EXISTS). Create page in Notion database (property mapping). Telegram success notification. Tags: email, imap, notion, postgres, deduplication, telegram, automation, knowledge-base Prerequisites IMAP access (Gmail/Outlook/Custom). Gmail: enable IMAP + App Password if using 2FA. Notion Integration Token & Database ID (database must be shared with the integration). PostgreSQL accessible from n8n. (Optional) Telegram Bot Token & Chat ID. An n8n automation workflow template by Ariyanto Catur Pamungkas.

By Allan Vaccarizi

📺 Full walkthrough video: https://youtu.be/x3PDYon4qKk ⚠️ Self-hosted only — This template uses a community node (Firecrawl) and cannot run on n8n Cloud. Who it's for This workflow is for content teams, SEO specialists, and developers who need to batch-scrape web pages and store their content as clean Markdown files — without manually copying and reformatting text from each URL. How it works A chat message triggers the workflow. The URL in the chat input points to a Google Sheet containing the list of URLs to scrape. All rows are read from the sheet, then filtered to keep only rows with a non-empty URL and no existing scraping status. Valid URLs are processed in configurable batches using a loop node. Each URL is scraped with Firecrawl, which extracts the full web page content. A code node cleans the raw Markdown: it removes links, standalone URLs, navigation labels, and excess whitespace. The cleaned Markdown file is saved to a specified Google Drive folder. The corresponding row in Google Sheets is updated with an "OK" status to prevent re-scraping on future runs. How to set up [ ] Connect your Google Sheets OAuth2 credential and configure the sheet containing the URLs [ ] Connect your Firecrawl API credential for web scraping [ ] Connect your Google Drive OAuth2 credential and set the destination folder ID [ ] Ensure the Google Sheet has a URL column and a Scraped column [ ] (Optional) Adjust the batch size in the loop node to control throughput Requirements Google Sheets account Google Drive account Firecrawl API key (community node — self-hosted n8n only) How to customize Replace the chat trigger with a Schedule Trigger for fully automated periodic scraping. Modify the Transform Scraped Content code node to enrich the Markdown (e.g. add metadata headers, extract specific sections). Add a Slack or email notification step after the loop completes to report how many URLs were successfully scraped. An n8n automation workflow template by Allan Vaccarizi.

By Allan Vaccarizi

📺 Full walkthrough video: https://youtu.be/-xqjoUvbXbs Who it's for This workflow is for agencies or freelancers — such as Growth AI — who manage client projects in Motion and want to automatically notify customers when a project task has been completed, without any manual follow-up. How it works A schedule trigger fires daily between the 10th and 31st of each month at 8 AM. Active customer records are retrieved from an n8n Data Table and filtered to include only rows where the last notification was sent before the current month. Eligible rows are processed in batches of 10 in a loop. For each customer, the Motion API is queried to fetch their workspace projects, filtered for those in a "Todo" state. The workflow then queries the Motion API again to check whether the associated task is marked as completed. If the task is completed, a notification email is sent to the customer via Gmail. The Data Table row is updated with the current timestamp, and the loop continues. How to set up [ ] Configure the Schedule Trigger with your desired run interval [ ] Connect the Data Table nodes to your n8n data table containing customer records [ ] Add your Motion API key as an HTTP Header Auth credential (X-API-Key) [ ] Connect your Gmail OAuth2 credential to the Send Email node [ ] Customize the email subject and body in the Send Email to Customer node [ ] Adjust the Filter Todo Projects node to match your Motion project and status naming Requirements Motion account with API access Gmail account with OAuth2 credentials n8n Data Table with customer records (ClientName, MotionID, ClientMail, Active, LastSent) How to customize Replace the Gmail node with Outlook, SendGrid, or another email provider to match your stack. Adjust the Filter Eligible Rows logic to change the notification frequency (e.g., weekly instead of monthly). Extend the email template in Send Email to Customer to include task details, project names, or a link to a client portal. An n8n automation workflow template by Allan Vaccarizi.

By Allan Vaccarizi

📺 Full walkthrough video: https://youtu.be/Z_l_T22px3U Who it's for This workflow is for developers and AI builders who want to deploy a context-aware chat assistant powered by a private knowledge base. It suits teams that need persistent conversation memory and retrieval-augmented generation (RAG) on their own infrastructure. How it works The Chat Trigger listens for incoming user messages and forwards them to the AI Agent. The AI Agent (Claude Sonnet 4) orchestrates the response generation. Postgres Chat Memory stores and retrieves the conversation history, enabling multi-turn dialogue. The Supabase Vector Store is queried as a tool to retrieve relevant documents from the knowledge base. OpenAI Embeddings convert the user query into vectors used for the Supabase similarity search. Claude synthesizes context from memory and retrieved documents to produce a final response. How to set up [ ] Add your Anthropic API key to the Claude Sonnet 4 Model node [ ] Add your OpenAI API key to the Generate OpenAI Embeddings node [ ] Configure your Supabase project URL, API key, and target table name [ ] Configure the Postgres Chat Memory node with your PostgreSQL database credentials [ ] Optionally set authentication on the Chat Trigger node Requirements Anthropic account (Claude Sonnet 4) OpenAI account (text-embedding model) Supabase project with a vector-enabled table PostgreSQL database for session memory How to customize Swap Claude for OpenAI GPT-4 or another LLM supported by n8n Replace Supabase Vector Store with Pinecone, Qdrant, or another vector database Use a unique session key per user to support isolated multi-user conversations. An n8n automation workflow template by Allan Vaccarizi.

By Adnan Azhar

Template Overview This n8n workflow provides an intelligent, timezone-aware AI voice calling system for e-commerce businesses to automatically confirm customer orders via phone calls. The system uses VAPI (Voice AI Platform) to make natural, conversational calls while respecting customer time zones and business hours. 🎯 Use Case Perfect for e-commerce businesses that want to: Automatically confirm high-value or important orders via phone Reduce order cancellations and disputes Provide personalized customer service at scale Maintain human-like interactions while automating the process Respect customer time zones and calling hours ✨ Key Features Timezone Intelligence Automatically detects customer timezone from shipping address or phone number Only calls during appropriate business hours (10 AM - 3 PM local time, weekdays) Schedules calls for appropriate times when outside calling hours Uses timezone-aware greetings (Good morning/afternoon/evening) AI-Powered Conversations Natural, context-aware conversations using VAPI Personalized greetings with customer names and local time awareness Intelligent confirmation detection from call transcripts Handles customer concerns and change requests gracefully Smart Call Management Automatic retry logic with attempt tracking Call quality assessment and cost tracking Detailed transcript analysis and sentiment detection Follow-up alerts for calls requiring human intervention Comprehensive Tracking Complete call history and analytics in Airtable Real-time status updates throughout the process Detailed reporting on confirmation rates and call quality Cost tracking and ROI analysis 🏗️ Workflow Architecture Main Flow (Order Confirmation) Order Webhook - Receives order data from e-commerce platform Data Validation - Validates required fields (phone, status) Timezone Detection - Determines customer timezone and calling eligibility Call Routing - Either initiates immediate call or schedules for later VAPI Integration - Makes the actual AI voice call Status Tracking - Updates database with call results Scheduled Flow (Retry System) Runs every 15 minutes to check for scheduled calls Respects retry limits and calling hours Automatically processes queued confirmations Webhook Handler (Results Processing) Receives VAPI call completion webhooks Analyzes call transcripts for confirmation status Sends follow-up alerts or confirmation emails Updates final order status 🔧 Prerequisites & Setup Required Services VAPI Account - For AI voice calling functionality Airtable Base - For order tracking and analytics SMTP Server - For email notifications n8n Instance - Self-hosted or cloud. An n8n automation workflow template by Adnan Azhar.

By Allan Vaccarizi

📺 Full walkthrough video: https://youtu.be/yjeKYfZP0kU > ⚠️ Self-hosted only — This template uses a community node (@mendable/n8n-nodes-firecrawl) and cannot run on n8n Cloud. Who it's for This workflow is for SEO consultants, web agencies, and technical teams who need to quickly audit or document a website's URL structure and export it into a clean, hierarchical spreadsheet. How it works A chat message is received containing the target website URL. Firecrawl maps the website via its sitemap and retrieves all available URLs. An IF node checks whether the Firecrawl response was successful; if not, the workflow stops with an error. On success, a Google Drive template file is copied to serve as the destination spreadsheet. A custom JavaScript node parses the crawled URLs, groups them by domain/subdomain, and structures them into a hierarchical table (up to 6 depth levels: Niv 0 to Niv 5) with HYPERLINK formulas. The structured rows are appended to the copied Google Sheet. How to set up [ ] Connect your Firecrawl credentials with a valid API key [ ] Set the Google Drive template file ID to copy for each run [ ] Connect your Google Sheets credentials and verify the target sheet name (FR) [ ] Review the Organize URLs into Table Format code node if you need to adjust the depth logic or output columns Requirements Self-hosted n8n instance Firecrawl account and API key Google Drive and Google Sheets OAuth2 credentials How to customize Modify the JavaScript code node to add URL filtering, deduplication, or category tagging before writing to the sheet. Extend the sheet schema beyond 5 depth levels if your website has a deeper URL hierarchy. Replace the chat trigger with a form or webhook to allow non-technical users to submit URLs for crawling. An n8n automation workflow template by Allan Vaccarizi.

By Evoort Solutions

📈 YouTube Trend Finder Workflow using n8n & RapidAPI Description: Easily discover trending YouTube videos by country and language using this automated n8n workflow. The flow leverages the YouTube Trend Finder API and logs insights to Google Sheets — ideal for content creators, marketers, and researchers. 🔗 Node-by-Node Explanation | Node Name | Type | Description | |-----------------------------|--------------------|-----------------------------------------------------------------------------| | 1. On form submission | Form Trigger | Captures user input for country and language through a web form. | | 2. Trend Finder API Request | HTTP Request | Sends a request to YouTube Trend Finder API with the form data. | | 3. Re format output | Code | Extracts and reshapes API response data like title, link, and tags. | | 4. Google Sheets | Google Sheets | Appends the trending video data into a structured spreadsheet. | 🎯 Use Cases 🔍 Content Research: Find top-trending videos in any region or language for idea inspiration. 📈 Marketing Intelligence: Track video trends to tailor your video marketing strategy. 📰 Trend Monitoring: Journalists and analysts can quickly surface viral video topics. ✅ Benefits of this Workflow No Coding Required:** Easy-to-use form interface for non-technical users. Real-Time Trends:* Instantly access trending YouTube content with the *YouTube Trend Finder API**. Automated Logging:** Stores data directly in Google Sheets for future analysis or sharing. Customizable:** Easily modify for more inputs like video category, max results, or add filters. Create your free n8n account and set up the workflow in just a few minutes using the link below: 👉 Start Automating with n8n Save time, stay consistent, and grow your LinkedIn presence effortlessly!. An n8n automation workflow template by Evoort Solutions.

By Oriol Seguí

Autonomous YouTube - Blog Builder / SEO Autopublisher (Sheets, ChatGPT, Apify, Pexels, WordPress) – Multilanguage 100% autonomous workflow that transforms YouTube videos into unique, high-quality, SEO-optimized blog articles and automatically publishes them to WordPress. No human intervention required: it uses YouTube as the main source for fresh, original content ideas, manages a keyword bank in Google Sheets, finds relevant videos via Apify, transcribes, writes, formats, selects a featured image via Pexels, generates SEO metadata, and publishes. When all keywords are used, it will automatically generate new ones (avoiding duplicates) to keep producing content without interruptions. Estimated cost per post (including ChatGPT + Apify (free 5$ new user)) → \$0.01 – \$0.03 depending on video length. Includes: Access to APIs with 7-day free trials** (Apify, Pexels, etc.). Step-by-step documentation** to get each API key. Basic setup support** to get you started. Who it’s for Agencies and creators looking to scale blogging from video content. SEO teams needing automation with quality control. Technical bloggers who want hands-off publishing with tracking. SEO SEO teams needing automation with quality control (modifiable from the options node like including h1, hierarchy among other SEO options). The title and description of the page (SEO) is based on the language in which the blog was created Allows you to add keywords How it works (phase summary) Part 1 – Keyword initialization Manual or scheduled trigger. Checks if the Google Sheet is empty; if so, generates 10 keywords based on a seed idea and saves them. Part 2 – Keyword management & blog settings Includes an “options” node to configure global blog language and formatting rules (H1, headings, bold, intro, conclusion, etc.). Selects a keyword with false status (unused), marks it true with a usage date, and if none are left, generates new ones while avoiding duplicates. Part 3 – Video search & duplicate filtering Searches YouTube via Apify using the keyword, retrieves \~30 results, excludes Shorts, and selects 2 videos based on title/description/hashtags. Checks for duplicates; if found, retries up to 5 times with variations. If still duplicated, discards the keyword and selects another. Error Handling & Continuity Includes fallbacks and failure alerts in every critical node to ensure the workflow keeps running even if a step fails. Part 4 – Article creation Transcribes the video (cost included in \$0.01–\$0.03). ChatGPT writes a formal blog post in the language set in the “options” node. A second ChatGPT step applies the formatting rules (structure, H1/H2…, intro/conclusion). Ensures SEO compliance. Converts Markdown → HTML and publishes to WordPress (more info results screenshots). Part 5 – Image & final publishing Searches Pexels API for images using the post keyword. ChatGPT chooses the most suitable image; it’s downloaded and attached to the post. Generates an SEO title and meta description based on the content. Sends an email confirmation with the published URL (with the chosen language, more info screenshots). Requirements OpenAI / ChatGPT** (or compatible provider for transcription and writing). Google Sheets** (keyword storage and usage tracking). Apify** (YouTube search (free 5$ new user)). Pexels API** (image sourcing (free api)). WordPress REST API** (user with permissions to create posts/media). Costs & limits (important) Cost per post:* *\$0.01 – \$0.03** (ChatGPT + Apify included (free 5$ new user)). Rate limits**: respect YouTube/Apify, Pexels, and OpenAI limits. Thoroughly Tested for Reliability and Performance This workflow has been carefully tested in multiple scenarios to ensure optimal functionality, stability, and accuracy. Various edge cases and potential failure points were simulated, and fallback mechanisms were implemented to handle unexpected situations. The result is a robust and reliable automation you can run confidently in production environments. The workflow is multi-language and it has been tested to create blogs in (Russian, Spanish, English, German and French) all the results were verified and good Screenshots Is it really autonomous? Blog example (Eng) – P1 Blog example (Eng) – P2 Blog example (IT) Email received More info and photos: oriolrotllant3@gmail.com. An n8n automation workflow template by Oriol Seguí.

By SIENNA

Automated FTP/SFTP to MinIO Object Backup with Scheduling $\mapsto$ Can work with FTP/SFTP Servers like your Wordpress Website ! What this workflow does ? This workflow performs automated, periodic backups of files from a FTP or SFTP server directory to a MinIO S3 bucket running locally or on a dedicated container/VM/server. It can also work if the MinIO bucket is running on a remote cloud provider's infrastructure; you just need to change the URL and keys. Who's this intended for ? Storage administrators, cloud architects, or DevOps who need a simple and scalable solution for retrieving data from a remote FTP or SFTP Server. This can also be practical for Wordpress Devs that need to backup data from a server hosting a Wordpress Website. In that case, you'll just need to specify the folder that you want to backup (could be one from wordpress/uploads or even the root one) How it works This workflow uses commands to list and download files from a specific directory on a FTP-SFTP Server, then send them to MinIO using their version of the S3 API. The source directory can be a specific one or the entire server (the root directory) Requirements None, just a source folder/directory on a FTP/SFTP Server and a destination bucket on MinIO. You'll also need to get MinIO running. You're using Proxmox VE ? Create a MinIO LXC Container : https://community-scripts.github.io/ProxmoxVE/scripts?id=minio Need a Backup from another Cloud Storage Provider ? Need automated backup from another Cloud Storage Provider ? $\mapsto$ Check out our templates, we've done it with AWS, Azure, and GCP, and we even have a version for FTP/SFTP servers! $\odot$ These workflow can be integrated to bigger ones and modified to best suit your needs ! You can, for example, replace the MinIO node to another S3 Bucket from another Cloud Storage Provider (Backblaze, Wasabi, Scaleway, OVH, ...). An n8n automation workflow template by SIENNA.