Workflow Templates

Description This workflow helps you find and evaluate job opportunities automatically, without spending hours searching and comparing roles. It uses your resume to look for relevant jobs on LinkedIn, checks how well each role matches your profile, and organises everything neatly in Google Sheets so you can focus on applying to the best opportunities. How it works On a schedule, the workflow downloads your resume from Google Drive and analyses it to understand your skills and experience. Based on this, it creates LinkedIn job searches and pulls in recent job listings. Each job is then reviewed using AI to compare the job description with your resume, produce a match score, suggest resume improvements, and generate a tailored cover letter. All results are saved to Google Sheets, and you’re notified by email when the run finishes. How to use Make a copy of the Google Sheets template and keep it for your own job tracking. Upload your resume (PDF) to Google Drive. Connect your Google Drive, Google Sheets, Gmail, and AI credentials in n8n. Update the Config node with your preferences (remote work, Easy Apply, job limit). Paste your copied Google Sheet IDs into the workflow. Turn on the Schedule Trigger and activate the workflow. Requirements Google Drive account for storing your resume Google Sheets account for tracking results Gmail account for notifications AI model access (Google Gemini or similar) n8n (cloud or self-hosted) Customising this workflow You can easily adapt this workflow to suit your goals. Change the job limits, locations, or remote preferences in the Config node. Update the AI prompts to target different roles or industries, or extend the workflow to send results to tools like Notion, a CRM, or your own application tracker. Good to know This workflow is designed to help you screen and prepare for jobs, not to apply automatically. Match scores are a guide, not a guarantee, so it’s always worth reviewing roles manually. Also, since LinkedIn pages can change over time, you may occasionally need to update HTML selectors to keep things running smoothly.

This n8n workflow automates job discovery by scanning company career pages, extracting open positions using AI, filtering them by department, and sending real-time alerts via Slack and email. It is ideal for monitoring targeted job roles (such as Engineering) across multiple companies without manual checking. Use Cases Targeted Job Monitoring: Automatically track new job postings for a specific department or role. Faster Job Alerts: Receive instant Slack and email notifications when relevant positions are found. Multi-Company Career Tracking: Monitor multiple company career pages from a single Airtable base. Reduced Noise: Filter out irrelevant roles and avoid empty or misleading notifications. Good to Know The workflow runs on a schedule and processes career pages stored in Airtable. Jobs are processed in batches with a delay node to avoid rate limits or scraping issues. Google Gemini is used for intelligent job extraction and filtering, which may incur API costs. If no relevant jobs are found, the workflow safely returns “No matching positions found” to prevent false alerts. Some Gemini models may be geo-restricted depending on your region. How it Works Step 1: Job Source & Scheduling A Schedule Trigger starts the workflow and defines the job category to monitor (e.g., Engineering). Airtable is queried to fetch all company career page URLs. Step 2: Scraping & Extraction Each career page is scraped using Decodo. Google Gemini analyzes the raw page content and extracts job titles with application URLs while ignoring navigation and non-job content. Step 3: Data Cleaning & Structuring A JavaScript code node cleans the AI output, removes noise (e.g., “No open positions”), and converts results into structured job items. Step 4: AI-Based Filtering A second AI Agent compares extracted jobs against the target department and keeps only relevant roles. Step 5: Notifications Matching jobs are sent instantly to Slack and email. How to Use Airtable Credentials: Connect Airtable and store career page URLs in the table. Google Gemini Credentials: Add your Gemini API key for AI extraction and filtering. Slack Credentials: Select a user or channel to receive job alerts. Gmail Credentials: Configure Gmail to receive job notification emails. Schedule Setup: Adjust the trigger interval based on how often you want job checks. Activate Workflow: Enable the workflow to start automated job monitoring. Requirements n8n instance (self-hosted or cloud) Airtable base with company career page URLs Google Gemini API key Slack workspace Gmail account for email notifications

How It Works This workflow automates quality event risk assessment through AI-powered multi-agent analysis with mandatory human oversight for critical decisions. Designed for quality managers, compliance officers, and risk analysts in manufacturing, healthcare, or service industries, it solves the challenge of consistent, transparent risk evaluation while maintaining human accountability. When quality events are detected, the system orchestrates specialized AI agents (traceability, risk assessment, and recall evaluation) to analyze different risk dimensions simultaneously. Results are synthesized, routed through human approval gates based on risk severity, and distributed via automated notifications. This ensures high-risk decisions receive proper scrutiny while low-risk events flow efficiently through automated channels. Setup Steps Configure NVIDIA NIM API credentials with Llama-3.1-70B-Instruct model access Set up routing logic thresholds Connect Gmail SMTP for executive alerts and Slack webhook for team notifications Configure human approval nodes with designated approver email addresses Customize AI agent prompts for industry-specific risk criteria Prerequisites NVIDIA NIM API key, Gmail account with app password Use Cases Manufacturing defect escalation, food safety incident management Customization Modify risk scoring thresholds, add industry-specific compliance agents Benefits Reduces risk assessment time by 75%, ensures consistent evaluation methodology

How it works This workflow runs on a schedule to monitor HubSpot deals with upcoming contract expiry dates. It filters deals that are 30, 60, or 90 days away from expiration and processes each one individually. Based on the remaining days, it sends personalized email reminders to contacts via Gmail. It also notifies account managers in Slack and creates follow-up tasks in ClickUp for tracking. Step-by-step Schedule and filter expiring deals** Schedule Trigger – Runs the workflow at defined intervals. Get all deals – Fetches deals and contract expiry data from HubSpot. Filter Deals – Calculates days left and keeps only 30, 60, or 90-day expiries. Process deals and fetch contacts** Loop Over Deals – Iterates through each filtered deal. Fetch Associated Contact With Deal – Retrieves linked contact IDs via API. Get Contact Details – Pulls contact email and basic info from HubSpot. Route and send reminder emails** Switch – Routes deals based on days left (30, 60, 90). 30 day mail – Sends urgent renewal reminder via Gmail. 60 day mail – Sends friendly renewal notification email. 90 day mail – Sends early awareness email. Merge – Combines all email paths into a single output. Notify team and create follow-ups** Nofity Account Manager – Sends Slack alert with deal and contact details. Create Follow-up Task – Creates a ClickUp task for renewal tracking. Why use this? Prevent missed renewals with automated tracking and alerts Improve customer retention through timely communication Reduce manual CRM monitoring and follow-ups Keep teams aligned with Slack notifications and task creation Scale contract management without increasing workload

Automated Sales Rep Clone Outreach Video and Voice Note for B2B Outbound This workflow automatically transforms new leads from Google Sheets into hyper-personalized outreach videos, voice notes, and emails using AI research, scriptwriting, video cloning, and voice generation. Perfect for SDRs, founders, and agencies who want to scale outreach without sacrificing personalization. 🎥 Watch step by step build: https://www.youtube.com/watch?v=q9AAh9zRou4 What this template does Whenever a new row is added to your Google Sheets CRM, this workflow: Reads the new lead (Name, Email, Phone, Company, Industry, LinkedIn URL) Runs deep research on the person & company using Perplexity Generates a personalized 30-second outreach script Creates a cloned-face, AI-generated HeyGen video with the script Creates an ElevenLabs voice note using the same personalized insights Uploads the audio file to Google Drive Sends an email to yourself containing: Outreach subject line Email body Personalized video link Personalized voice note link (Optional) Sends a WhatsApp/SMS/MMS message via Twilio with the files or links This template builds a complete AI-powered outbound engine—research, video, voice note, and email—fully automated. Why this is useful Turns manual outbound into a hands-free, 360° AI workflow Personalized video outreach dramatically increases reply rates Consistent research quality for every lead SDRs save hours per day on manual prep Perfect for: Influencer agencies SaaS outbound teams Founders doing cold outreach Recruitment agencies Real estate & service businesses Requirements Before running this workflow, connect: Google Sheets OAuth (trigger + CRM sheet) Perplexity API Key OpenAI API Key (GPT-5.1, GPT-4.1-mini) OpenRouter API Key HeyGen API Key (for video avatar) ElevenLabs API Key (for voice note) Google Drive OAuth (for file upload) Twilio credentials (optional SMS/WhatsApp) ⚠️ All credentials must be added manually after importing. This ensures security and complies with n8n Template Guidelines. How it works (Node Breakdown) Google Sheets Trigger Watches your CRM sheet and fires whenever a new lead row is added. Code Node — Extract Latest Row Ensures only the newly added row continues through the workflow. Research Agent Powered by OpenAI + Perplexity Scrapes professional history, company insights, marketing gaps Identifies outreach opportunities & triggers Produces a structured research summary Scripting Agent Writes a natural, human-sounding 30-second outreach script tailored to that exact lead. HeyGen Video Generator Creates a personalized avatar video narrating the script (720×1280). ElevenLabs Voice Generation Generates a custom voice note version of the pitch. Google Drive Upload Saves the voice note file for sharing or sending via WhatsApp. Twilio Message (optional) Sends the voice note or video link via SMS/WhatsApp. Email Output Creates a fully structured JSON email including: Subject line Personalized body HeyGen video link Voice note link Delivered via Gmail node. Setup (Step-by-Step) Import the template into n8n Open Google Sheets Trigger → choose your CRM sheet Add all required credentials: Perplexity OpenAI OpenRouter HeyGen ElevenLabs Google Drive Gmail Twilio (optional) In HeyGen node, choose: Your avatar Your preferred voice ID In ElevenLabs node, set: Your preferred voice model Review the system prompts of: Research Agent Script Agent Email Agent Adjust for your brand tone if needed. Run once manually to test. Turn on the workflow—your AI outbound engine is live. Customization Ideas Swap HeyGen avatar to match your brand identity Add a Slack notification when each video is ready Save research & scripts into a Notion database Create a HubSpot contact for each lead Add duplicate detection logic Auto-post video to social channels for public outreach Troubleshooting Video stuck in “processing”? → Increase the Wait node duration (30–60 sec). Voice note too robotic? → Switch to a premium ElevenLabs voice. Research not specific enough? → Strengthen the system prompt with more constraints. Emails not arriving? → Ensure Gmail OAuth has send permission configured. API authentication errors? → Check credentials in each node (OpenAI, Perplexity, HeyGen, etc.).

AI-Powered Lead Qualification & Enrichment Pipeline 🎯 Who is this for? This template is perfect for: Marketing Teams** looking to automatically qualify inbound leads from campaigns Sales Teams** wanting to prioritize high-value prospects instantly Agencies** offering lead qualification as a service to clients SaaS Companies** routing trial signups to appropriate nurture sequences B2B Service Providers** scoring and enriching leads from multiple sources 💡 What problem does it solve? Manual lead qualification is slow, inconsistent, and expensive. Sales teams waste hours on unqualified leads while hot prospects go cold. This workflow: Eliminates manual research** - Automatically enriches company data via LinkedIn Scores leads instantly** - AI analyzes 15+ data points to score 0-100 Routes intelligently** - Hot leads get instant alerts, warm leads enter nurture Personalizes outreach** - AI generates custom emails based on company context ⚡ What this workflow does 1. Lead Capture & Validation Captures leads via built-in n8n Form (embeddable on any website) Validates email format and detects business vs personal emails Normalizes data from various field naming conventions 2. Company Enrichment via Apify Uses Google Search to find company's LinkedIn profile Scrapes LinkedIn for industry, size, description, specialties, and more Gracefully skips enrichment for personal emails (Gmail, Yahoo, etc.) 3. AI Lead Qualification (GPT-4.1) Scores leads 0-100 based on buying signals Assigns tier: Hot (80+), Warm (60-79), Cold (40-59), Disqualified (<40) Identifies buyer persona (Decision Maker, Influencer, Champion, etc.) Generates personalized talking points and risk factors 4. Intelligent Routing & Actions Hot Leads**: Instant Slack alert + AI-generated personalized email + HubSpot contact Warm Leads**: Slack notification for nurture sequence Cold Leads**: Logged for future reference All Leads**: Recorded to Google Sheets with full qualification data 🔧 Setup Required Credentials | Service | Purpose | |---------|---------| | OpenAI | AI qualification & email generation | | Apify | Google Search + LinkedIn scraping | Optional Credentials | Service | Purpose | |---------|---------| | Slack | Lead alerts and notifications | | HubSpot | CRM contact creation | | Gmail | Sending personalized emails | | Google Sheets | Lead database logging | Apify Setup Create account at apify.com Get API token from Settings → Integrations Open the Apify HTTP nodes and replace YOUR_API_KEY with the API token obtained in the above step Apify Actors Used Google Search Scraper PPR** (Actor ID: G9PR1B1upfS0mRvp0) - ~$0.004/search LinkedIn Company Scraper PPR** (Actor ID: G9y3V8J1hXYJTf1Ho) - ~$0.02/company Total cost: ~$0.02-0.03 per enriched lead 📊 Lead Scoring Criteria | Score | Tier | What it means | |-------|------|---------------| | 80-100 | 🔥 Hot | Strong buying signals, budget confirmed, urgent timeline | | 60-79 | 🌡️ Warm | Good fit, some buying signals, needs nurturing | | 40-59 | ❄️ Cold | Potential fit but unclear intent | | 0-39 | ⛔ Disqualified | Poor fit, spam, or invalid | 🎨 Customization Modify Form Fields Edit the "Lead Capture Form" node to add/remove fields for your use case. Adjust AI Scoring Edit the system prompt in "AI Lead Qualification" to customize: Score thresholds for your industry Buyer persona definitions Custom qualification criteria Add Integrations Easily extend with: Pipedrive, Salesforce, or other CRMs Email sequences (Mailchimp, ActiveCampaign) SMS notifications (Twilio) Calendar booking (Calendly) 📈 Example Output { "qualification": { "score": 85, "tier": "Hot", "buyerPersona": "Decision Maker", "urgencyLevel": "High" }, "insights": { "keyInsights": [ "VP-level with direct budget authority", "Company in growth phase (51-200 employees)", "Industry aligned with our ICP" ], "talkingPoints": [ "Reference their sustainability focus", "Highlight ROI for mid-market companies" ] } } 🙋 Need Help? Check the sticky notes in the workflow for section-by-section guidance Ensure Apify credentials are properly configured Test with a business email (not Gmail/Yahoo) to see full enrichment Created by Agentical AI - AI Automation Agency specializing in workflow automation and AI solutions.

Contract Template Generator with E-Signature Integration What this workflow does This workflow automates the full contract lifecycle—from request intake to document generation and electronic signature completion. It receives contract requests via webhook, generates customized contract documents using AI, converts them into professionally formatted HTML, and sends them to an e-signature service for execution. The workflow pauses until signatures are completed, then records outcomes and notifies all parties accordingly. This template is designed to reduce legal and operational overhead while ensuring consistent, trackable, and scalable contract management. How it works Contract request intake Triggered by a webhook or external form. Validates required fields such as contract type and signatories. Generates a unique contract ID for tracking. Contract data preparation Normalizes contract metadata (dates, value, currency). Stores party and term information for downstream processing. Template routing Routes requests based on contract type (e.g., NDA, Service Agreement, Employment). Applies predefined base terms for each contract category. Falls back to a generic template if no specific type is matched. AI-powered contract generation An AI agent generates a complete contract in Markdown format. Suggests additional clauses and provides a brief risk assessment. Ensures a consistent contract structure across types. Document processing Converts Markdown into HTML for professional presentation. Prepares signer metadata, signing order, and deadlines. E-signature request Sends the document to an e-signature service (e.g., DocuSign, HelloSign). Emails all signatories with signing instructions. Uses a Wait node to pause execution until a signature webhook is received. Signature result handling Processes webhook callbacks for completed, pending, or expired signatures. Updates contract status accordingly. Completion & notifications Logs signed or expired contracts to Google Sheets. Sends confirmation, reminder, or expiration emails to all parties. Responds to the original webhook with a structured status message. Setup requirements Before activating this workflow, make sure to: Connect the contract request webhook to your intake form or system. Configure contract types and base terms as needed. Set up your e-signature provider webhook callback URL. Prepare Google Sheets for contract logging. Customize email me

Competitor Price Monitoring with AI-Powered Alerts What this workflow does This workflow automatically monitors competitor product prices on a scheduled basis, detects meaningful price changes, and delivers actionable alerts enriched with AI-powered competitive analysis. It compares current and historical price datasets, identifies increases, decreases, new products, and removals, and uses AI to assess market impact and recommend strategic actions. Alerts are intelligently routed to Slack or Email based on urgency, while all results are logged for auditing and trend analysis. This template is ideal for pricing teams, product managers, and competitive intelligence workflows that require timely, data-driven insights without manual monitoring. How it works Scheduled execution Runs on a configurable cron schedule (default: every 6 hours). Initializes a monitoring session with timestamps and tracking IDs. Price data collection Fetches current competitor pricing via HTTP APIs. Retrieves previous price snapshots from Google Sheets. Data normalization & comparison Normalizes current and historical data into a unified schema. Uses the Compare Datasets node to detect: New products Removed products Price increases or decreases Unchanged prices Change evaluation Calculates percentage price changes. Classifies severity: Urgent: ≥ 10% change Routine: 5–10% change No alert: < 5% or unchanged AI-powered analysis An AI agent evaluates competitive impact. Generates concise recommendations (match, hold, differentiate). Justifies urgency based on market implications. Smart alert routing Urgent changes are sent to Slack. Routine updates are sent via Email. All alerts and runs are logged in Google Sheets. Historical storage Updates price history for future comparisons. Maintains a complete monitoring audit trail. Setup requirements Before activating the workflow, configure the following: Replace the competitor price API endpoint with your own data source. Define product identifiers consistently (SKU, product ID, etc.). Configure Google Sheets documents and sheet names for: Price history Alert logs Monitoring logs Adjust alert thresholds or schedules as needed. Required credentials This workflow requires the following credentials to be set up in n8n: HTTP Header Auth** (for competitor price APIs) OpenAI** (for AI-based price analysis) Slack** (urgent alerts) Gmail** (routine email notifications) Google Sheets** (price history and logging) Customization ideas Add additional alert channels (Microsoft Teams, Discord, Webhooks). Extend AI analysis with competitor positioning or elasticity insights. Monitor multiple regions or currencies. Add dashboards using BI tools connected to Google Sheets. Trigger downstream pricing or promotion workflows automatically. Who this is for Pricing & revenue operations teams E-commerce and SaaS product managers Competitive intelligence analysts Growth and strategy teams needing real-time market awareness This template provides an end-to-end, scalable foundation for AI-assisted competitive price monitoring—turning raw price changes into actionable business decisions.

Description When a Zoom meeting ends, this workflow fires automatically — no manual action needed. It classifies every participant as On Time or Late, logs all attendance data to Google Sheets, and sends you one AI-written summary via Telegram. For every late joiner, a ClickUp follow-up task is created automatically so no one slips through the cracks. Built for team leads, trainers, and operations managers who run recurring Zoom meetings. What This Workflow Does Automatic attendance capture** — Receives the Zoom meeting.ended event via webhook and processes all participant data instantly, with zero manual input Late participant detection** — Classifies each attendee as Attended or Late based on a configurable join delay threshold (default: 5 minutes) 14-column Google Sheets log** — Saves every participant as one row including join time, leave time, time in meeting, join delay, and status AI-written Telegram summary** — GPT-4o-mini writes a professional attendance summary and sends it once per meeting directly to the host's Telegram Automated ClickUp follow-up tasks** — Creates one ClickUp task per late joiner with full meeting context, participant details, and a next-day due date Clean exit for on-time attendees** — Participants who joined on time bypass the task creation step with no noise or extra actions Setup Requirements Tools and accounts needed n8n instance (self-hosted or cloud) Zoom Marketplace account with a Webhook Only App configured Google account with Google Sheets access OpenAI account with API access (GPT-4o-mini) ClickUp account with API access Telegram Bot (via BotFather) Estimated Setup Time: 20–30 minutes Step-by-Step Setup Import the workflow — Open n8n, go to Workflows → Import from JSON, paste the workflow JSON, and verify all nodes are connected. Configure Zoom Webhook — In the 1. Webhook — Zoom Meeting Ended node, copy the webhook URL. Go to your Zoom Marketplace app, open your Webhook Only App, and paste the URL under the meeting.ended event subscription. Set your config values — Open 2. Set — Config Values and replace all six placeholders: YOUR_TELEGRAM_CHAT_ID — your Telegram chat ID (get it from @userinfobot) YOUR_GOOGLE_SHEET_ID — the ID from your Google Sheet URL (the long string between /d/ and /edit) Attendance Log — rename if your sheet tab has a different name YOUR HOST NAME — the name that appears in the Telegram summary 5 — change to your preferred late threshold in minutes YOUR_CLICKUP_LIST_ID — copy from your ClickUp list URL Connect Google Sheets — Open 4. Google Sheets — Log Participant Row and connect your Google Sheets OAuth2 credential. Authenticate via Google when prompted. Connect OpenAI — Open 7. OpenAI — GPT-4o-mini Model and connect your OpenAI API credential. Enter your API key from platform.openai.com. Connect ClickUp — Open 9. ClickUp — Create Late Participant Task and connect your ClickUp API credential. Enter your personal API token from ClickUp Settings → Apps. Connect Telegram — Open 12. Telegram — Send Meeting Summary and connect your Telegram Bot API credential. Enter the token from BotFather. Activate the workflow — Toggle the workflow to Active before running your next Zoom meeting. How It Works (Step by Step) Step 1 — Webhook: Zoom Meeting Ended When any Zoom meeting ends, Zoom sends a POST request to this webhook. This is the trigger that starts the entire workflow. No polling or manual action is needed — it fires the moment the meeting closes. Step 2 — Set: Config Values This step stores all six configuration values in one place — Telegram chat ID, Google Sheet ID, sheet tab name, host name, late threshold in minutes, and ClickUp list ID. You only set these once, and all downstream steps read from here automatically. Step 3 — Code: Extract and Classify Participants This step reads the full participant list from the Zoom payload. For each person, it calculates how many minutes after the meeting start they joined. If the delay exceeds the threshold, they are marked Late. Everyone else is marked Attended. This step outputs one item per participant — every step after this runs once per person. Step 4 — Google Sheets: Log Participant Row Every participant — regardless of status — is written as one row in your Google Sheet. The row includes 14 columns: meeting ID, topic, host email, date, start time, duration, participant name, email, join time, leave time, time in meeting, join delay in minutes, status, and the timestamp when the row was logged. Step 5 — IF: First Row Check This check gates the Telegram path. Only the first participant item passes through to the summary path (YES). All other participants go to the late-check path (NO). This prevents the host from receiving one Telegram message per attendee. Step 6 — AI Agent: Write Telegram Summary Using GPT-4o-mini, this step generates a concise, plain-text Telegram message for the host. The message covers the meeting topic, date, duration, participant counts, one observation about attendance quality, and one action suggestion. It is capped at 80 words and uses no markdown. Step 7 — OpenAI GPT-4o-mini Model This is the language model powering the AI Agent in Step 6. It runs with a max token limit of 200 and a temperature of 0.4 for consistent, professional output. Step 8 — Set: Prepare Telegram Fields Reads the AI-generated message and the Telegram chat ID, then packages them into a clean output ready to send. Step 9 — Telegram: Send Meeting Summary Sends the final AI-written message to the host's Telegram chat. This fires exactly once per meeting — not once per participant. Step 10 — IF: Is Participant Late? For every non-first participant, this check reads their status. If status equals Late (YES), they move to the ClickUp task step. If they joined on time (NO), they exit cleanly through the No Action step. Step 11 — ClickUp: Create Late Participant Task Creates one ClickUp task per late participant. The task name includes the participant's name and meeting topic. The task body includes full meeting context, participant details, join time, delay in minutes, time in meeting, and three pre-written action items. Due date is automatically set to the next day. Step 12 — Set: No Action Needed On-time participants exit here with a simple confirmation message. No task is created and no further action is taken. Key Features ✅ Zero-click attendance logging — The workflow fires automatically when Zoom ends; you never need to start it manually ✅ Configurable late threshold — Change one value in the config step to adjust what counts as late for your team ✅ One Telegram message per meeting — The first-row gate ensures the host gets one clean summary, not one message per attendee ✅ 14-column Google Sheets record — Every row is complete with time-in-meeting, join delay, and logged-at timestamp for easy reporting ✅ Pre-written ClickUp task body — Late participant tasks include context and three ready-to-act follow-up items out of the box ✅ Next-day due date on tasks — ClickUp tasks are automatically due 24 hours after the meeting ends ✅ GPT-4o-mini for cost efficiency — Telegram summaries use the lightweight model for fast, affordable generation Customisation Options Change the late threshold per meeting type — In 2. Set — Config Values, update lateThresholdMinutes to a higher value (e.g., 10) for longer or less structured meetings. Add email notification for late participants — After 9. ClickUp — Create Late Participant Task, connect a Gmail or SMTP node to automatically email the late participant a summary of what they missed. Log to multiple sheets by meeting topic — In 4. Google Sheets — Log Participant Row, use an expression to dynamically set the sheet tab name based on the meeting topic — one tab per recurring meeting type. Add a Slack notification alongside Telegram — Duplicate 12. Telegram — Send Meeting Summary and replace it with a Slack node to send the same summary to a team channel in addition to the host's personal Telegram. Increase task priority for participants who joined very late — In 9. ClickUp — Create Late Participant Task, add an IF check before the task node to set priority: 1 (urgent) if joinDelayMin exceeds 15 minutes. Filter out internal test accounts — Before 3. Code — Extract and Classify Participants, add a Code node that removes any participants matching test email domains so they don't pollute your sheet or trigger tasks. Troubleshooting Workflow not triggering when the meeting ends: Confirm the webhook URL from 1. Webhook — Zoom Meeting Ended is pasted correctly in your Zoom Marketplace app Verify the event subscription is set to meeting.ended specifically — not meeting.ended with a typo or a different event type Make sure the workflow is activated in n8n before the meeting starts Google Sheets rows not appearing: Check that the Sheet ID in 2. Set — Config Values is the correct ID from the sheet URL Confirm the sheet tab name matches exactly what is written in sheetName — it is case-sensitive Re-authenticate the Google Sheets OAuth2 credential if you recently changed Google account permissions Telegram message not sending: Verify the Telegram chat ID is correct — use @userinfobot in Telegram to retrieve it Confirm the Telegram Bot token in 12. Telegram — Send Meeting Summary is valid and has not been revoked via BotFather Make sure the bot has been added to the chat and has permission to send messages ClickUp tasks not being created: Check that the ClickUp list ID in 2. Set — Config Values is the correct list — not a space ID or folder ID Verify the ClickUp API credential is connected and the token has not expired If no participants are late in your test, the task node will not fire — use a threshold of 0 for initial testing AI summary is blank or returns an error: Confirm the OpenAI API key in 7. OpenAI — GPT-4o-mini Model is valid and has available credits Check that the credential is connected properly in n8n — reconnect and re-enter the key if needed Support Need help setting this up or want a custom version built for your team or agency? 📧 Email:info@isawow.com 🌐 Website:https://isawow.com

How it works: This workflow fetches sent campaign data from Brevo on a schedule, calculates key metrics (open rate, click rate, bounce rate), and stores results in Google Sheets. It then filters to a rolling 7-day window, runs an AI analysis to generate an executive summary with performance highlights and recommendations, and delivers a structured HTML report by email to stakeholders. Step-by-step: Data collection Schedule Trigger – Fires the workflow on your chosen day and time. HTTP Request (Brevo) – Fetches sent campaign data via the Brevo API. Transform Data – Calculates open rate, click rate, and bounce rate per campaign. Write to Google Sheets – Appends processed results to the historical database. Data preparation Read from Google Sheets – Retrieves the latest stored campaign records. Filter to 7-day window – Narrows data to the last 7 days for trend analysis. Aggregate Results – Summarises campaign performance across the window. AI analysis AI Summary Engine – Evaluates trends and generates an executive summary. LLM (Groq or alternative) – Provides the AI model for analysis. Format AI Output – Structures the summary for use in the report. Report delivery Build HTML Report – Compiles metrics, highlights, and recommendations into a styled email. Send via Gmail – Delivers the final report to stakeholder recipients. Why use this? Automates the full reporting lifecycle from data pull to inbox delivery. Surfaces top-performing campaigns and list health issues without manual review. Keeps a growing historical database for long-term trend tracking. Easily adjustable reporting window, thresholds, and notification channels. Works with any AI provider — swap Groq for any compatible LLM.

How It Works Automates daily real estate market opportunity analysis by aggregating MLS listings, public property records, demographic information, and macroeconomic indicators, applying GPT-4 for investment evaluation, assessing investment thresholds, and notifying investors of high-potential properties. Simultaneously collects MLS data, public records, demographic profiles, and economic metrics, consolidates the datasets, applies GPT-4 to perform comprehensive investment analysis including ROI projections and risk assessment, calculates key financial metrics via an investment calculator, validates opportunities against predefined thresholds, and sends alerts to acquisition teams and investors through email and Slack. Designed for real estate investors and property acquisition firms seeking automated, data-driven investment insights. Setup Steps Connect MLS data provider, public records database, and demographic data source APIs. Configure OpenAI GPT-4 API for investment analysis and opportunity scoring. Set up investment calculator integration and ROI calculation parameters. Connect Gmail and Slack for team notifications; define investment thresholds. Prerequisites MLS data access; public records database; demographic data provider; macroeconomic data source Use Cases Real estate investment firms automating deal sourcing across markets; Customization Adjust investment analysis criteria and thresholds Benefits Identifies investment opportunities automatically

How It Works Automates financial risk evaluation by intelligently consolidating information from five critical sources: financial, operational, legal, insurance, and regulatory systems. Hourly triggers enable continuous, AI-driven risk assessment using the OpenRouter Chat Model, producing dynamic risk scores while simultaneously identifying emerging compliance gaps and potential exposure areas. High-risk findings automatically initiate corrective actions, trigger secondary investigations, and send real-time alerts through Slack notifications as well as investor email updates. Designed for financial institutions, compliance teams, risk managers, and investment firms, it provides continuous, scalable, and fully data-driven monitoring of risk across complex regulatory and operational environments. Setup Steps Configure hourly/daily schedule trigger. Authenticate all five data APIs. Set OpenRouter credentials. Configure Slack webhook. Set Gmail for email distribution. Define risk thresholds and compliance rules. Prerequisites OpenRouter API key, five data source APIs, Slack access, Gmail account, investor contacts Use Cases Banking risk audits, insurance compliance monitoring, portfolio risk tracking Customization Swap AI models, modify data sources, adjust thresholds Benefits 90% faster risk assessment, eliminates manual aggregation