Workflow Templates

Analyze YouTube videos for virality with an AI-powered report This workflow automates the discovery and analysis of potentially viral YouTube videos. It searches for recent, popular videos based on a keyword, calculates a unique "Algorithmic Lift Score" to measure virality, and uses an AI agent to generate an insightful summary report that is sent directly to your email. What it does This workflow identifies videos that are outperforming their channel's baseline, a key indicator of viral potential. It operates in several stages: Searches YouTube: It finds recent, top-performing videos based on your specified keyword and timeframe. Gathers Data: For each video found, it fetches detailed statistics for both the video (views, likes, comments) and its channel (subscriber count, total views). Calculates Virality Score: It calculates an "Algorithmic Lift Score" for each video. This custom metric prioritizes videos that achieve high view counts and engagement relative to their channel's subscriber base. Analyzes with AI: The top 5 videos, sorted by their virality score, are sent to an AI agent (pre-configured for OpenAI). The AI generates a concise summary highlighting trends, top performers, and other noteworthy patterns. Sends Email Report: The final AI-generated analysis is converted to HTML and emailed to you, providing a ready-to-read report on what's trending in your niche. Who it's for This workflow is perfect for: Content Creators** looking for trending topics and content ideas. Digital Marketers** conducting competitor analysis or market research. Social Media Managers** wanting to understand what content resonates on YouTube. Data Analysts** who need to automate the collection and analysis of YouTube trends. Requirements A Google API Key with the "YouTube Data API v3" enabled. An OpenAI API Key (or another compatible AI model credential). A connected Gmail account in n8n to send the final report. How to set up Configure the Setup Node: Click on the "Setup" node and fill in the values: query: The keyword you want to search for (e.g., "AI tools"). GoogleAPIkey: Your Google API key. daysback: How many days in the past to search for new videos. maxResult: The number of videos to analyze (e.g., 20). email: The email address where the report will be sent. Set AI Credentials: Click the "OpenAI Chat Model" node and add your OpenAI API key to the credentials. Set Gmail Credentials: Click the "Send_Report" node and connect your Gmail account to the credentials.

How it works: When a user submits a form with event details, the workflow sends this information to OpenAI's GPT-5 model, which generates a curated list of 18–32 songs tailored to the occasion and audience. The workflow then searches Spotify for each recommended song, creates a new playlist on the user's Spotify account, adds all the tracks, and sends the user an email with a direct link to listen. Key Features: AI-Powered Playlist Generation: Uses OpenAI's GPT-5 model to create contextually relevant song recommendations based on event type, audience, and personal preferences. Automated Spotify Integration: Searches Spotify's API for each song and automatically adds them to a new playlist on the user's account. One-Click Listening: Users receive an email with a direct Spotify link to listen, follow, and modify the playlist immediately after creation. Multi-Language Support: The AI responds in the same language as the user's input, making the workflow accessible globally. Email Confirmation: Users instantly receive an email notification confirming playlist creation with a shareable Spotify link. Step-by-step: Form Submission Trigger: User submits event details (occasion, guests, preferences, and email) through the web form. AI Playlist Generation: OpenAI's GPT-5 generates a curated list of 18–32 songs based on the provided event context. Spotify Integration: The workflow searches Spotify for each song, creates a new playlist, and adds all found tracks to the user's account. Email Notification: User receives an email with the playlist name and a direct Spotify link to listen immediately. API Keys Required OpenAI API Key: Required to access GPT-5 for generating playlist recommendations. Spotify Client ID & Secret: Required to authenticate with Spotify's API for searching, creating playlists, and adding tracks. SMTP Credentials: Required to send the confirmation email to the user (server, port, username, password, and sender email). Response Generation The AI model receives event details and generates a structured JSON response containing a playlist name, 18–32 song recommendations with artist credits, and HTML-formatted content for website integration, all in the user's language.

How it works This workflow runs on scheduled weekly and monthly triggers to generate unified marketing performance reports. It processes multiple websites by collecting analytics data, paid ads performance, and CRM leads, then calculates KPIs and insights automatically. The workflow sends structured reports via email and stores historical data in Google Sheets. It ensures consistent reporting without manual effort. Step-by-step Step 1: Trigger & report type detection** Schedule Trigger2 – Triggers the workflow weekly at a predefined time. Schedule Trigger3 – Triggers the workflow monthly at a predefined time. check month and week1 – Identifies whether the run is weekly or monthly and sets flags. Set Websites and Campaings1 – Defines websites, GA4 property IDs, and mapped ad campaigns. Expand Websites1 – Expands the website array into individual website items. Attach Run Flags1 – Attaches weekly or monthly flags to each website record. Step 2: Website & ads data processing** Loop Websites1 – Iterates through each website independently. Get a report – Fetches website traffic and engagement metrics from analytics. Get many campaigns – Retrieves Google Ads campaign data. Fetch Meta Ads – Fetches Meta Ads performance data via API. Filter Google Ads By Website1 – Filters Google Ads campaigns by website. Filter Meta Ads By Website1 – Filters Meta Ads campaigns by website. Merge1 – Merges analytics, Google Ads, and Meta Ads datasets. Build Website Dataset1 – Builds a unified dataset per website. Calculate KPIs & Campaign Insights1 – Calculates spend, CTR, CPA, CPL, conversions, and performance insights. Append or update row in sheet2 – Stores website-level marketing metrics in Google Sheets. Step 2.1: Marketing report generation** Prepare Report Data2 – Combines all website datasets into a unified report object. Switch – Routes execution based on weekly or monthly report type. Send Weekly Marketing report2 – Sends the weekly marketing performance email. Send Monthly Marketing Report2 – Sends the monthly marketing performance email. Step 3: HubSpot lead analysis** Fetch1 – Fetches leads from HubSpot CRM. Filter Hubspot Leads – Filters leads based on weekly or monthly time range. Summarize Hubspot Leads – Aggregates lead status and lifecycle metrics. Prepare Report Data3 – Prepares CRM summary data for reporting. Step 3.1: CRM reporting & storage** Switch3 – Routes CRM reporting by report type. Send Weekly Marketing report3 – Sends the weekly CRM summary email. Send Monthly Marketing Report3 – Sends the monthly CRM summary email. Code in JavaScript1 – Transforms CRM data for storage. Append or update row in sheet3 – Stores CRM lead performance data in Google Sheets. Switch3 – Routes CRM reporting by report type. Send Weekly Marketing report3 – Sends the weekly CRM summary email. Send Monthly Marketing Report3 – Sends the monthly CRM summary email. Code in JavaScript1 – Transforms CRM data for storage. Append or update row in sheet3 – Stores CRM lead performance data in Google Sheets. Why use this? Automates complex weekly and monthly marketing reporting. Unifies website analytics, ad platforms, and CRM data in one flow. Delivers consistent KPI calculations and insights every run. Maintains historical performance logs in Google Sheets. Scales easily across multiple websites and campaigns.

Description Automatically qualify and route new leads from a Google Sheet into your CRM with AI-powered scoring and instant sales notifications. Turn raw form submissions into prioritized opportunities—effortlessly. ⚡ What This Template Does Monitors a Google Sheet for new form submissions. 📄 Uses Azure OpenAI (GPT-4o-mini) to analyze lead details (value, stage, company) and generate action items. 🤖 Parses the AI response into clean JSON for structured processing. 🗂️ Saves qualified lead data and AI-generated action items into a Lead Status sheet for tracking. 💾 Categorizes leads into Hot, Warm, or Cold based on AI scoring. 🔥❄️ Creates/updates the contact in HighLevel CRM. 📇 Sends an email notification to the assigned sales rep with lead details and priority. 📧 Key Benefits Save time with automated lead qualification instead of manual checks. ⏱️ Ensure consistent Hot/Warm/Cold scoring across all leads. ✅ Centralize lead data in both Google Sheets and CRM for tracking. 📊 Keep sales teams aligned with instant notifications. 🚀 Fully no-code configurable and customizable for your business logic. 🧩 Features Google Sheets Trigger for new form rows. 📥 AI Agent with Azure OpenAI (GPT-4o-mini) for lead scoring. 🧠 JSON parsing node to clean AI output. ✂️ Lead logging to “Lead Status” sheet. 📊 Function node to categorize leads by score. 🎯 CRM sync with HighLevel to update/create contact records. 🔗 SMTP email notification to sales reps. ✉️ Requirements n8n instance (cloud or self-hosted). 🧰 Google Sheet with headers: Lead Name, Lead Email, Lead Contact No., Company Name, Opportunity Value, Stage of Lead; shared with n8n Google account. 📑 Azure OpenAI access with a GPT-4o-mini deployment. ☁️ HighLevel CRM account connected via OAuth. 📇 SMTP email account configured in n8n. 📧 Target Audience Sales teams handling inbound leads. 📈 Agencies managing multiple client pipelines. 🤝 Founders/startups wanting quick qualification and CRM sync. 🚀 Ops teams needing reliable reporting of lead qualification. 🗂️ Step-by-Step Setup Instructions (Concise) Create a Google Sheet with required headers; share with n8n account. 📋 Configure the Google Sheets Trigger with the sheet’s Document ID. 🔐 Connect your Azure OpenAI credentials and link to the AI Agent node. 🧠 Assign your HighLevel CRM account credentials. 📇 Set up SMTP credentials for the email send node. ✉️ Import the workflow, update node configs, and run a test submission. ▶️ Security Best Practices Share Google Sheets only with the n8n Google account (Editor). 🔒 Keep API keys and credentials encrypted in n8n, not hardcoded. 🛡️ Validate AI outputs before saving to CRM (via the parse node). ✅ Regularly back up your Lead Status sheet and CRM data. 📂

This n8n workflow automates your entire B2B outreach pipeline from lead discovery to personalized cold email delivery. Submit a form, let Apollo find and enrich your leads, review AI-generated emails in your sheet and send them all with one click. How it works Form Trigger** accepts Job Title, Location and Number of Leads to kick off the workflow Apollo** searches for matching people and enriches each lead with email, phone, LinkedIn URL and company data Duplicate check** runs automatically to skip any leads already in your sheet Leads are saved** to Google Sheet with outreach status set to Pending Manual Trigger** runs the email generation section using Groq LLM to write a personalized cold email per lead Generated emails** are saved to the sheet for review before sending Gmail** sends each email and updates the outreach status to Mail Sent How to use Run Trigger 1 — Form to scrape and enrich leads from Apollo Review leads in your Google Sheet Run Trigger 2 — Manual to generate and send cold emails Update the AI Cold Email Writer node with your company details before running Requirements Apollo** account with API Key Google Sheets** account Groq** account with API Key Gmail** account Customising this workflow Replace Groq with OpenAI or any other LLM for email generation Extend with a follow-up sequence to re-engage leads who did not reply

Who is this for This workflow is built for sales teams, agencies, and small businesses that receive inbound leads via WhatsApp and want to automate their first response, lead qualification, and CRM logging — without missing a single message. What this workflow does It listens for incoming WhatsApp messages, uses an AI agent to classify each message by intent (hot lead, warm lead, support, or needs qualification), sends a tailored auto-reply, logs every interaction to Google Sheets, and automatically books Google Calendar meetings with Meet links for qualified leads. How it works WhatsApp Trigger receives incoming messages and filters out bot/status messages to prevent loops. AI Agent (powered by Ollama or any connected LLM) classifies the message into one of four intent categories with confidence scoring. Smart Router directs each intent down a dedicated path. Hot & Warm Leads receive an instant reply, get logged to Google Sheets, have a Google Calendar meeting auto-booked, and receive the Meet link via WhatsApp. Support requests are logged and receive a ticket confirmation. Vague or incomplete messages trigger a smart follow-up question. Conversation memory ensures the AI re-classifies correctly when the user replies with more context. Setup steps Connect your WhatsApp Business API credentials (Meta Cloud API). Connect Google Sheets OAuth and set your spreadsheet ID in all three logging nodes. Connect Google Calendar OAuth and select your calendar in both booking nodes. Configure your LLM (Ollama endpoint, OpenAI, or any supported model). Update the BOT_NUMBERS array in the "Parse WhatsApp Message" node to match your WhatsApp Business phone number ID. Update the phoneNumberId in all WhatsApp Send nodes to your number. Send a test message and verify the full flow. Requirements WhatsApp Business API (Meta Cloud API) access Google Sheets and Google Calendar accounts with OAuth credentials An LLM endpoint (Ollama, OpenAI, or any n8n-supported model) n8n instance (cloud or self-hosted) How to customize Swap the AI model in the Ollama Chat Model node for OpenAI, Anthropic, or any supported LLM. Edit the auto-reply templates in each Reply code node to match your brand voice. Adjust meeting booking times (default: Hot = 2 hours out, Warm = 4 hours out). Add Slack or email notifications by branching from the Google Sheets logging nodes. Modify the AI classification prompt to add custom intent categories for your business.

How it works This workflow automatically monitors competitor product prices stored in Google Sheets. It scrapes product pages, extracts pricing and offer data using AI, and compares it with historical values. Based on changes, it updates records and generates a market intelligence report. The workflow then emails the report and resets data for the next execution cycle. Step-by-step Step 1: Database sync** Schedule Trigger – Runs the workflow at a scheduled time. Get row(s) in sheet – Fetches competitor data and product URLs. Step 2: Scraping** Loop Over Items – Processes each competitor entry. HTTP Request3 – Retrieves raw HTML using ScraperAPI. Clean Content – Cleans and prepares text for AI processing. Step 3: Price extraction** AI Agent1 – Extracts product name, price, and offers. Groq Chat Model1 – Provides AI extraction capability. current Price and offer – Converts AI output into structured data. If2 – Checks if it's the first recorded entry. First time price and offer added – Stores initial values. If1 – Compares current vs previous price and offers. Updated current price and offer in sheet – Updates if changes detected. If No changes then update – Updates sheet even when no change is found. Step 4: Analysis** Get row(s) in sheet1 – Retrieves updated dataset. Data Aggregator – Builds structured market comparison data. AI Agent – Generates strategic insights and recommendations. Groq Chat Model – Powers the analysis output. Update row in sheet – Saves AI-generated summary in sheet. Step 5: Reporting** Edit Fields1 – Formats the report into HTML email layout. Send a message – Sends the final report via Gmail. Step 6: Reset** Get row(s) in sheet2 – Retrieves final processed data. Update row in sheet1 – Moves current data to history and clears fields. Why use this? Ensures all price scenarios (change or no change) are handled properly Keeps your Google Sheets always updated with accurate data Provides AI-powered competitive intelligence automatically Sends clean, formatted reports without manual effort Maintains structured historical tracking for better decision-making

Who is this for Entrepreneurs looking for verified technology to license. R&D Teams tracking aerospace innovation. Content Creators covering tech trends. How it works Fetch: Gets the latest patents from NASA's Tech Transfer API. Filter & Loop: Removes empty entries and processes each patent individually. Analyze: Translates the abstract (DeepL) and uses OpenAI to brainstorm practical business applications. Archive: Saves the details to Google Sheets. Notify: Compiles a summary and sends it to Slack. How to set up Prepare Google Sheet: Create a new sheet with these exact headers in Row 1: Date Title Abstract_Translated Business_Idea Link Edit Settings: Double-click the Edit Settings node to add your Google Sheet ID, Sheet Name, and Slack Channel ID. Credentials: Configure credentials for OpenAI, DeepL, Google Sheets, and Slack. Activate: Run a test execution, then switch the workflow to Active. Requirements OpenAI: API Key (gpt-4o or gpt-3.5-turbo) DeepL: API Key (Free or Pro) Google Sheets: OAuth2 credentials with Drive/Sheets scopes. Slack: Bot User OAuth Token with chat:write scope. How to customize Change the Prompt: Edit the Generate Business Ideas node to tailor ideas for a specific niche (e.g., "Applications for medical devices"). Adjust Schedule: Change the trigger in the Weekly Schedule node to run daily or monthly. Different Output: Swap Slack for Microsoft Teams or Email nodes if preferred.

This workflow continuously monitors CVE databases, threat intelligence feeds, and public security advisories to surface emerging zero-day threats, correlates them against your registered infrastructure assets and software inventory, and uses Claude AI to score exploitability, assess business impact, and generate actionable remediation playbooks — all before attackers can operationalise the vulnerability. How it works Trigger — Hourly schedule or on-demand webhook for immediate threat scans Load Asset Inventory — Fetches registered infrastructure (IPs, hostnames, software, versions) from Airtable Scrape CVE Sources — Queries NVD API, CISA KEV, and GitHub Security Advisories in parallel Fetch Threat Feeds — Pulls OSINT feeds (AlienVault OTX, abuse.ch, Shodan) for active exploitation signals Normalise & Deduplicate — Merges all findings, deduplicates by CVE ID, enriches with CVSS scores Correlate with Assets — Matches CVEs to your specific software/version inventory AI Threat Assessment — Claude AI scores exploitability, blast radius, and urgency per matched threat Filter Critical Findings — Keeps only threats scoring above configurable risk threshold Route by Severity — Branches CRITICAL / HIGH / MEDIUM for different response paths Alert SOC via Slack — Immediate notification with threat summary and patch status Create Incident Tickets — Auto-opens Jira/ServiceNow issues for CRITICAL and HIGH threats Email Security Team — Detailed HTML threat brief with CVE details and remediation steps Update Threat Register — Appends findings to Google Sheets threat intelligence log Trigger Patch Workflow — Webhooks downstream patch management system for auto-remediation Return API Response — Structured JSON result for SIEM/SOAR integration Setup Steps Import workflow into n8n Configure credentials: Anthropic API — Claude AI for threat assessment NVD API Key — NIST National Vulnerability Database CISA KEV — Known Exploited Vulnerabilities catalogue (public) AlienVault OTX API — Open Threat Exchange pulses Shodan API — Internet exposure checks Airtable — Asset/software inventory Google Sheets OAuth — Threat intelligence log Slack OAuth — SOC alerts Jira API — Incident ticket creation SendGrid / SMTP — Security team email digests Register your asset inventory in Airtable (hostnames, IPs, software, versions) Set your risk score threshold (default: 65) in the filter node Set your Slack SOC channel IDs Configure downstream patch webhook URL Activate the workflow Sample Webhook Payload (On-Demand Scan) { "scanType": "targeted", "software": "Apache HTTP Server", "version": "2.4.51", "urgency": "high", "requestedBy": "soc-analyst@company.com" } Threat Sources Monitored NVD (NIST)** — Full CVE database with CVSS v3.1 scores CISA KEV** — Actively exploited vulnerabilities catalogue GitHub Security Advisories** — Open source dependency vulnerabilities AlienVault OTX** — Community threat intelligence pulses abuse.ch URLhaus** — Malware distribution and C2 URLs Shodan** — Internet-exposed asset enumeration EPSS** — Exploit Prediction Scoring System probabilities AI Assessment Dimensions CVSS Score** — Base, temporal, and environmental scoring EPSS Probability** — Likelihood of exploitation in the wild Asset Exposure** — Internal vs external facing, attack surface Patch Availability** — Vendor patch, workaround, or no fix status Active Exploitation** — CISA KEV / OTX confirmation Business Impact** — Confidentiality, integrity, availability impact Blast Radius** — Number of affected assets and systems Urgency Score** — Composite prioritisation score (0–100) Features Multi-source CVE aggregation with deduplication Asset correlation against software/version inventory EPSS-weighted AI exploitability scoring Automated CRITICAL/HIGH/MEDIUM severity routing Jira ticket creation with full CVE context Patch management webhook integration Full threat intelligence audit log SIEM/SOAR-ready JSON output Explore More Automation: Contact us to design AI-powered lead nurturing, content engagement, and multi-platform reply workflows tailored to your growth strategy.

How it works A prospect submits a form with their email and website URL The workflow fetches and cleans the website HTML, extracting key business signals An Analyst Agent reads the content and produces a structured JSON diagnostic (business type, offers, pain points, funnels, copy kit) A Writer Agent converts the diagnostic into a personalised email with 10 actionable improvements, written automatically in the lead's language A branded HTML email is assembled and sent via Gmail with numbered improvement cards, a booking CTA and a professional footer Set up steps Connect your OpenAI API credentials to both AI model nodes (~2 min) Connect your Gmail account to the Send Email node (~1 min) Open the Build Email HTML node and fill in the 6 constants at the top: your name, email, cal.com booking link, Instagram URL, LinkedIn URL and logo image URL (~3 min) Activate the workflow and share the form URL with your leads

📈 Automated Customer Rewards Platform: Jotform Integration This blueprint details a highly efficient, AI-powered workflow designed to automate customer reward fulfillment. Leveraging the accessible interface of Jotform, this system delivers superior reliability and exceptional processing speed. 📊 Reliability, Productivity, and Performance This workflow is engineered to maximize operational efficiency and maintain data integrity: Instant Fulfillment: Automation handles receipt scanning (OCR), AI calculation, logging, and notification in seconds, eliminating manual delays. Seamless Data Capture: Leverages the user-friendly Jotform interface for fast, reliable customer submission and file uploads. 🛠️ Quick Configuration Guide Jotform Webhook:* In your *JotForm* settings, paste the n8n *Jotform Trigger URL** into the Webhook Integration. Done. API Access:* Generate a *"Full Access"** JotForm API key and insert it into the required n8n nodes (Jotform Trigger and Fetch All Receipts). Credential Setup:** Plug in your necessary API keys (Gemini, OCR.Space) and update the Notion Database ID and internal email recipient. 🚀 How It Works (Practical Flow) Submission:* Customer submits their request via *Jotform**. Processing:** System extracts text from the receipt (OCR), the AI calculates the reward, and the If node verifies the total. Fulfillment:** Transaction logged, confirmation emails sent to both the customer and the internal team. If you need any help Get in Touch

AI appointment bot with Google Calendar, Gmail and Sheets 📌 Overview This workflow automates end-to-end appointment scheduling for your business using an AI-powered chatbot. Clients can book, reschedule, or cancel meetings through a simple chat interface — no manual coordination needed. Two independent flows run in parallel. The AI Chat Flow handles real-time client conversations using Groq LLaMA 4 Scout, managing calendar availability, event creation, updates, and Gmail confirmations automatically. The Daily Sync Flow runs every morning to refresh your Google Sheet with the day's appointments and email an admin summary report. All times are handled in IST (GMT+05:30) with full ISO 8601 formatting. ⚙️ How it works AI Chat Flow Client sends a message to the bot AI Agent collects name, email, purpose, date, time, and duration Checks Google Calendar for availability Creates, updates, or deletes calendar events based on request Sends Gmail confirmation or cancellation email to the attendee Daily Sync Flow Triggers every morning at 9:30 AM IST Clears previous rows from Google Sheets (keeps header) Fetches all of today's Google Calendar events Formats and inserts each event into the sheet Emails the admin a summary report with total meeting count and sheet link 🛠️ Setup steps Import this workflow into n8n Add a Google Calendar OAuth2 credential and set your calendar email Add a Gmail OAuth2 credential for the agent and admin report Add Google Sheets OAuth2 (for Clear node) and Service Account (for Insert node) Add your Groq API key for the LLaMA 4 Scout model Update your admin email, calendar email, and Google Sheet ID in the workflow Activate the workflow — both flows run independently 🚀 Features AI-powered scheduling Books, reschedules, and cancels appointments via chat Checks real-time calendar availability before confirming Suggests 3 alternative slots if the requested time is unavailable Sends automatic Gmail confirmations to attendees Maintains conversation memory across the session (last 50 messages) Daily reporting Auto-clears and refreshes the Google Sheet every morning Syncs all calendar events with full details (name, email, time, duration) Emails admin a daily count summary with a direct sheet link 📋 Requirements n8n (cloud or self-hosted) Google Calendar, Gmail, and Google Sheets access Groq API key (free tier supported) 🎯 Benefits Zero manual appointment coordination Clients self-serve via chat 24/7 Admin always has a fresh daily schedule in Google Sheets Automatic email confirmations build client trust IST timezone enforced consistently across all events 👨‍💻 Author BytezTech Pvt Ltd