Workflow Templates

Description This n8n template demonstrates how to turn raw YouTube comments into research-backed content ideas complete with hooks and outlines. Use cases include: Quickly mining a competitor’s audience for video ideas. Generating hooks and outlines for your own channel’s comments. Validating content opportunities with live audience feedback. Good to know Apify is used to scrape YouTube comments (requires an API token). GPT-4.1-mini is used for both filtering and content generation. Tavily provides fresh research to ground the AI’s responses. All outputs are stored in Google Sheets, making it easy to manage and track ideas. How it works Trigger – Paste a YouTube URL into the chat trigger. Scrape Comments – Apify fetches all comments and metadata. Filter – GPT-4.1-mini decides if each comment could inspire a content idea. Store – Comments and “Yes/No” decisions are appended to Google Sheets. Research & Enrich – For “Yes” comments, Tavily provides context, and GPT generates a topic, hook, and outline. Update Sheet – The same row in Google Sheets is updated with enriched fields. Google Sheets Setup Your Google Sheet should include these columns (in this order): id | text | author | likes | isIdea | topic | research | hook | outline id** – unique identifier for each comment text** – the full YouTube comment author** – commenter’s name/handle likes** – number of likes on the comment isIdea** – “Yes” or “No” depending on GPT filter topic** – extracted video topic research** – 300–500 word background from Tavily hook** – engaging opening sentence for a video outline** – structured video outline Setup Steps Connect your Apify, OpenAI, Tavily, and Google Sheets credentials in n8n. Point the Google Sheets nodes to your own document and ensure the above headers exist. Replace sample API keys with your own stored in n8n Credentials. Time to set up: \~15–25 minutes for a first-time n8n user (less if you already have credentials handy). Customizing this workflow Filter logic** – Loosen the GPT filter to allow borderline ideas, or tighten it to only accept the best ones. Research depth** – Change Tavily’s search depth (e.g., depth: basic vs depth: advanced) to control how detailed the background research is. Notification channels* – Send new “Yes” ideas directly to *Slack* (#content-ideas), *Notion* (your content board), or *Email** (notify the content manager instantly). Alternative outputs** – Instead of hooks/outlines, generate: A script draft for YouTube Shorts. Blog post angles based on the same audience comments. A poll question for community engagement.

This n8n workflow monitors and alerts you about new construction projects in specified areas, helping you track competing builders and identify business opportunities. The system automatically searches multiple data sources and sends detailed email reports with upcoming projects. Good to know Email parsing accuracy depends on the consistency of request formats - use the provided template for best results. The workflow includes fallback mock data for demonstration when external APIs are unavailable. Government data sources may have rate limits - the workflow includes proper error handling. Results are filtered to show only upcoming/recent projects (within 3 months). How it works Email Trigger** - Detects new email requests with "Construction Alert Request" in the subject line Check Email Subject** - Validates that the email contains the correct trigger phrase Extract Location Info** - Parses the email body to extract area, city, state, and zip code information Search Government Data** - Queries government databases for public construction projects and permits Search Construction Sites** - Searches construction industry databases for private projects Process Construction Data** - Combines and filters results from both sources, removing duplicates Wait For Data** - Wait for Combines and filters results. Check If Projects Found** - Determines whether to send a results report or no-results notification Generate Email Report** - Creates a professional HTML email with project details and summaries Send Alert Email** - Delivers the construction project report to the requester Send No Results Email** - Notifies when no projects are found in the specified area The workflow also includes a Schedule Trigger that can run automatically on weekdays at 9 AM for regular monitoring. Email Format Examples Input Email Format To: alerts@yourcompany.com Subject: Construction Alert Request Area: Downtown Chicago City: Chicago State: IL Zip: 60601 Additional notes: Looking for commercial projects over $1M Alternative format: To: alerts@yourcompany.com Subject: Construction Alert Request Please search for construction projects in Miami, FL 33101 Focus on residential and mixed-use developments. Output Email Example Subject: 🏗️ Construction Alert: 8 Projects Found in Downtown Chicago 🏗️ Construction Project Alert Report Search Area: Downtown Chicago Report Generated: August 4, 2024, 2:30 PM 📊 Summary Total Projects Found: 8 Search Query: Downtown Chicago IL construction permits 🔍 Upcoming Construction Projects New Commercial Complex - Downtown Chicago 📍 Location: Downtown Chicago | 📅 Start Date: March 2024 | 🏢 Type: Mixed Development Description: Mixed-use commercial and residential development Source: Local Planning Department Office Building Construction - Chicago 📍 Location: Chicago, IL | 📅 Start Date: April 2024 | 🏢 Type: Commercial Description: 5-story office building with retail space Source: Building Permits [Additional projects...] 💡 Next Steps • Review each project for potential competition • Contact project owners for partnership opportunities • Monitor progress and timeline changes • Update your competitive analysis How to use Setup Instructions Import the workflow into your n8n instance Configure Email Credentials: Set up IMAP credentials for receiving emails Set up SMTP credentials for sending alerts Test the workflow with a sample email Set up scheduling (optional) for automated daily checks Sending Alert Requests Send an email to your configured address Use "Construction Alert Request" in the subject line Include location details in the email body Receive detailed project reports within minutes Requirements n8n instance** (cloud or self-hosted) Email account** with IMAP/SMTP access Internet connection** for API calls to construction databases Valid email addresses** for sending and receiving alerts API Integration Code Examples Government Data API Integration // Example API call to USA.gov jobs API const searchGovernmentProjects = async (location) => { const response = await fetch('https://api.usa.gov/jobs/search.json', { method: 'GET', headers: { 'Content-Type': 'application/json', }, params: { keyword: 'construction permit', location_name: location, size: 20 } }); return await response.json(); }; Construction Industry API Integration // Example API call to construction databases const searchConstructionProjects = async (area) => { const response = await fetch('https://www.construction.com/api/search', { method: 'GET', headers: { 'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36', 'Accept': 'application/json' }, params: { q: ${area} construction projects, type: 'projects', limit: 15 } }); return await response.json(); }; Email Processing Function // Extract location from email content const extractLocationInfo = (emailBody) => { const lines = emailBody.split('\n'); let area = '', city = '', state = '', zipcode = ''; for (const line of lines) { if (line.toLowerCase().includes('area:')) { area = line.split(':')[1]?.trim(); } if (line.toLowerCase().includes('city:')) { city = line.split(':')[1]?.trim(); } if (line.toLowerCase().includes('state:')) { state = line.split(':')[1]?.trim(); } if (line.toLowerCase().includes('zip:')) { zipcode = line.split(':')[1]?.trim(); } } return { area, city, state, zipcode }; }; Customizing this workflow Adding New Data Sources Add HTTP Request nodes for additional APIs Update the Process Construction Data node to handle new data formats Modify the search parameters based on API requirements Enhanced Email Parsing // Custom email parsing for different formats const parseEmailContent = (emailBody) => { // Add regex patterns for different email formats const patterns = { address: /(\d+\s+[\w\s]+,\s[\w\s]+,\s[A-Z]{2}\s*\d{5})/, coordinates: /(\d+\.\d+),\s*(-?\d+\.\d+)/, zipcode: /\b\d{5}(-\d{4})?\b/ }; // Extract using multiple patterns // Implementation details... }; Custom Alert Conditions Modify the Check If Projects Found node to filter by: Project value/budget Project type (residential, commercial, etc.) Distance from your location Timeline criteria Advanced Scheduling // Set up multiple schedule triggers for different areas const scheduleConfigs = [ { area: "Downtown", cron: "0 9 * * 1-5" }, // Weekdays 9 AM { area: "Suburbs", cron: "0 14 * * 1,3,5" }, // Mon, Wed, Fri 2 PM { area: "Industrial", cron: "0 8 * * 1" } // Monday 8 AM ]; Integration with CRM Systems Add HTTP Request nodes to automatically create leads in your CRM when high-value projects are found: // Example CRM integration const createCRMLead = async (project) => { await fetch('https://your-crm.com/api/leads', { method: 'POST', headers: { 'Authorization': 'Bearer YOUR_TOKEN', 'Content-Type': 'application/json' }, body: JSON.stringify({ name: project.title, location: project.location, value: project.estimatedValue, source: 'Construction Alert System' }) }); }; Troubleshooting No emails received**: Check IMAP credentials and email filters Empty results**: Verify API endpoints and add fallback data sources Failed email delivery**: Confirm SMTP settings and recipient addresses API rate limits**: Implement delays between requests and error handling

This n8n template demonstrates how to automate personalized cold email follow-ups using AI personalization and database tracking. Perfect for sales teams, recruiters, and agencies managing high-volume outreach. Use cases: Follow up with cold leads, re-engage trial users, nurture conference contacts, recruit candidates, or follow up with proposal recipients. PS: 1) This was created as a Follow Up workflow it was not meant for inital outreach. (However if you can customize it to include initial outreach then go ahead) 2)This workflow sends a maximum of 4 follow Ups How it works NocoDB fetches all leads and filters those needing follow-up today based on the "Next Follow up/Contact" date A switch node routes leads to the appropriate follow-up stage (1-4) based on which follow-ups have already been sent AI personalizes each email template by inserting the recipient's name while keeping the rest of the content intact Emails are sent via SMTP (or Gmail node), then the database updates to mark the follow-up as sent and schedule the next one The workflow runs daily at 10 AM to automatically process follow-ups without manual intervention Good to know Each AI personalization costs ~$0.001 with Groq (free tier available). See Groq pricing for details. Follow-up schedule: Day 3, 7, 12, 16 after initial contact (fully customizable) Leads marked "Not Interested" are automatically excluded from future follow-ups The workflow only processes leads with an "Initial Contact Date" set - this triggers the entire sequence (The initial Contact is done manually and updated manually) How to use The schedule trigger runs daily but can be replaced with manual trigger or webhook for immediate testing Customize the 4 email templates in the AI nodes to match your brand voice and offering Adjust follow-up intervals by modifying the "Update a row" nodes (currently +4 or +5 days between follow-ups) Import your lead list to NocoDB with minimum required fields: first_name, last_name, email, Initial Contact Date Requirements NocoDB account** - Free lead database (You can use any database-Google Sheets, Airtable etc. However ensure the essential details below are in the database) Groq API key** (or OpenAI/Ollama) - For AI personalization (Swap this for any LLM you like/have) SWITCH* the 'Send Email' nodes for the *Gmail** Node and set it up using OAuth

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

Initial Outreach Email Workflow This n8n template demonstrates how to automate personalized cold email outreach using AI and a lead database. It’s designed to contact unengaged leads, personalize messages at scale, and schedule follow-ups automatically. Use cases are many: Reach out to new leads, qualify prospects, start conversations, and set up consistent follow-up routines. Great for sales teams, recruiters, and agencies running cold outreach campaigns. Good to know Each AI personalization costs about $0.001 with Groq (free tier available; pricing may vary by provider). The workflow limits emails to 15 per day by default to protect your email reputation and reduce spam risk. The email template is fully customizable to match your brand tone and offer. Outreach timing and follow-up intervals are easy to adjust within the workflow. How it works NocoDB** fetches leads who haven’t been contacted yet (no “Initial Contact Date”). The Limit node ensures no more than 15 emails per run. AI personalizes** your chosen email template with lead name and company. Emails are sent via SMTP or Gmail node. Each contacted lead is updated in the database with today’s Initial Contact Date and a Next Follow-up Date (default 3 days later). The workflow runs on a daily schedule at 10:30 AM (configurable). How to use Set up a NocoDB/any database table with: first_name email Initial Contact Date Next Follow up/Contact organization_name (optional) Customize the email template inside the AI node. Adjust the daily limit and schedule to match your outreach capacity. Import leads into NocoDB and configure credentials for NocoDB, AI provider, and SMTP. Run the workflow manually for testing before going live.

🏠 SignSnapHome.com Open House Lead Management System Automatically capture, qualify, and follow up with open house visitors in real-time This comprehensive n8n workflow transforms your SignSnap Home open house sign-ins into a complete lead management system with instant notifications, intelligent lead scoring, and automated multi-channel follow-ups. View full blog writeup and YouTube video here: Open House n8n + SignSnapHome Automation 🎯 What This Workflow Does Transform every open house visitor into a managed lead with automated processing, scoring, and outreach—all without lifting a finger. Core Features 📸 Visual Lead Capture Automatically processes guest photos from sign-in Converts base64 images to proper binary format Displays guest photos as thumbnails in Discord notifications Supports JPEG, PNG, and other image formats 🎨 Smart Lead Scoring System 🔴 HOT Leads**: No agent + high rating (4-5 stars) → Immediate follow-up priority 🟠 WARM Leads**: Has agent but no buyer agreement → Potential opportunity 🟡 MEDIUM Leads**: Standard engagement level 🔵 COLD Leads**: Has agent with signed agreement OR low rating (1-2 stars) Color-coded Discord embeds for instant visual prioritization 📊 Rich Discord Notifications Beautiful embed cards with all guest information Guest photo thumbnail displayed inline Conditional fields (rating only shows if you have it enabled) Custom field support - ANY extra form fields automatically included Timestamp, contact info, property details Lead priority badge and color coding 📱 Intelligent SMS Follow-up (via Twilio) Sends personalized text message if phone number provided Different messaging for leads with/without agents Professional, warm tone that encourages response Simple "thank you for visiting" approach 📧 Professional Email Follow-up Beautiful HTML email template with gradient header Conditionally shows rating if available Different call-to-action based on agent status Branded footer with SignSnap Home mention Only sends if no phone number (SMS takes priority) Fallback to email if SMS not available ⚙️ Flexible Custom Field Support Automatically detects and processes ANY custom fields No workflow modification needed for new form fields Formats field names nicely (snake_case → Title Case) Displays all custom fields in Discord notification Perfect for additional questions like buyer agreements, prequalification status, etc. 📋 Workflow Structure Node Breakdown Webhook Trigger - Receives POST data from SignSnap Home Parse & Enrich Data - Extracts and processes all form data Separates standard vs custom fields Calculates lead priority score Formats timestamps and names Detects optional fields (like rating) Convert Image to Binary - Transforms base64 photo to n8n binary format Discord Notification - Sends rich embed with photo thumbnail Has Phone Number? - Conditional routing based on contact preference Send SMS (Twilio) - Priority follow-up via text message Has Email? - Fallback check if no phone provided Send Welcome Email - Professional HTML email follow-up ✨ Key Highlights Dynamic & Flexible No hardcoded fields** - automatically adapts to YOUR SignSnap form Works with default fields AND any custom fields you add Rating field is completely optional Handles missing data gracefully Smart Routing SMS-first approach (higher engagement rates) Automatic fallback to email if no phone Only sends what makes sense for each lead Professional Presentation Discord: Visual dashboard for your team SMS: Quick, personal outreach Email: Professional, branded communication Lead Intelligence Automatic qualification based on agent status Rating consideration (when available) Buyer agreement detection Priority-based follow-up suggestions 🔧 Setup Requirements Services Needed SignSnap Home Account - For open house sign-in app Discord Webhook - For team notifications Twilio Account - For SMS (optional but recommended) SMTP Email - For email follow-ups (optional) Configuration Steps Import this workflow into your n8n instance Set up Discord webhook: Create a webhook in your Discord channel Replace YOUR_WEBHOOK_ID/YOUR_WEBHOOK_TOKEN in the HTTP Request node Configure Twilio (if using SMS): Add Twilio credentials in n8n Set your Twilio phone number Configure Email (if using email): Add SMTP credentials in n8n Update the "from" email address Activate your workflow Copy the webhook URL from n8n Configure SignSnap Home: Go to your open house settings Add the n8n webhook URL as your automation endpoint Enable "Send on each submission" (not batch) 📝 Optional Features You Can Add Rating Field Add a "What did you rate the house?" field (1-5 scale) Workflow automatically detects and displays it Affects lead scoring (high ratings = hotter leads) Buyer Agreement Field Add "Do you have a signed buyer agreement?" field Helps identify truly available leads Factors into WARM vs COLD lead classification Any Custom Fields Add ANY additional questions to your form They'll automatically appear in Discord notifications No workflow changes needed! 🎨 Customization Ideas Modify Lead Scoring Edit the JavaScript in the "Parse & Enrich Data" node to adjust: Lead priority thresholds Color coding Scoring criteria Change Message Templates SMS message in "Send SMS (Twilio)" node Email HTML in "Send Welcome Email" node Discord embed structure in "Discord Notification" node Add More Automation Save to Google Sheets/Airtable Create tasks in your CRM Send to Slack instead of/in addition to Discord Add to email marketing list Trigger other workflows 💡 Use Cases Real Estate Agents**: Instant lead capture and follow-up Property Managers**: Track open house attendance Real Estate Teams**: Centralized lead dashboard Brokerages**: Multi-agent lead distribution Home Builders**: Model home visitor tracking 🚀 Why This Workflow Rocks ✅ Zero Manual Work - Completely automated from sign-in to follow-up ✅ Intelligent - Smart lead scoring and routing ✅ Flexible - Adapts to YOUR form fields ✅ Professional - Polished notifications and outreach ✅ Multi-Channel - Discord, SMS, and Email coverage ✅ Visual - See guest photos instantly ✅ Scalable - Handle unlimited open houses ✅ Customizable - Easy to modify for your needs 📊 What You Get Instant Visibility**: See every visitor as they sign in Lead Intelligence**: Know who's hot and who's not Fast Follow-up**: Reach out while interest is hot Team Coordination**: Everyone sees the same data Professional Image**: Automated, timely communication Time Savings**: Hours of manual work eliminated 🔗 Integration Details Webhook Endpoint: /signsnaphome-sign-in-trigger Method: POST Content-Type: application/json Expected Format: SignSnap Home standard output 📞 Support & Customization This workflow is designed to work out-of-the-box with SignSnap Home, but can be adapted for: Other open house sign-in apps Different notification platforms Custom CRM integrations Additional automation steps ⚡ Quick Start Summary Import workflow Add Discord webhook URL (Optional) Configure Twilio for SMS (Optional) Configure SMTP for email Activate workflow Copy webhook URL Add to SignSnap Home settings Start collecting leads! 🎯 Perfect For Solo agents wanting to professionalize their follow-up Teams needing centralized lead management Brokerages tracking multiple open houses Anyone using SignSnap Home for open house sign-ins Transform your open house visitors into qualified, followed-up leads automatically. Never miss an opportunity again! Tags: real-estate, lead-management, automation, discord, twilio, sms, email, webhook, signsnap, open-house, crm Difficulty: Intermediate Nodes Used: 8 External Services: SignSnap Home, Discord, Twilio (optional), SMTP (optional)

📰 Reddit to Newsletter (Automated Curation with Open AI 4o Mini ) Turn the best posts from a subreddit into a ready-to-send HTML newsletter — no copy-pasting, no wasted time. This workflow fetches new posts, filters by topic of interest, analyzes comments, summarizes insights, and composes a clean HTML email delivered straight to your inbox with Gmail. 💡 What this workflow does ✅ Fetches posts from your chosen subreddit (default: r/microsaas, sorted by “new”) 🏆 Selects the Top 10 by upvotes, comments, and recency 🧭 Defines a topic of interest and runs a lightweight AI filter (true/false) without altering the original JSON 💬 Pulls and flattens comments into a clean, structured list 🧠 Summarizes each post + comments into main_post_summary, comment_insights, and key_learnings ✍️ Generates a newsletter in HTML (not Markdown) with headline, outline, sections per post, quotes, and “by the numbers” 📤 Sends the HTML email via Gmail with subject “Reddit Digest” (editable) 🛠 What you’ll need 🔑 Reddit OAuth2 connected in n8n 🔑 OpenAI API key (e.g., gpt-4o-mini) for filtering and summarization 🔑 Gmail OAuth2 to deliver the newsletter 🧵 A target subreddit and a clearly defined topic of interest 🧩 How it works (high-level) Manual Trigger → Get many posts (from subreddit) Select Top 10 (Code node, ranking by ups + comments + date) Set topic of interest → AI filter → String to JSON → If topic of interest Loop Over Items for each valid post Fetch post comments → Clean comments (Code) → Merge comments → Merge with post Summarize post + comments (AI) → Merge summaries → Create newsletter HTML Send Gmail message with the generated HTML ⚙️ Key fields to adjust Subreddit name* and “new” filter in *Get many posts Ranking logic* inside *Top 10 Code node Text inside Set topic of interest** Prompts* for *AI filter, Summarize, and Create newsletter (tone & structure) Recipient & subject line* in *Send Gmail message ✨ Use cases Weekly digest** of your niche community Podcast or newsletter prep** with community insights Monitoring specific themes** (e.g., “how to get first customers”) and delivering insights to a team or client 🧠 Tips & gotchas ⏱️ Reddit API limits: tune batch size and rate if the subreddit is very active 🧹 Robust JSON parsing: the String to JSON node handles clean, fenced, or escaped JSON; failures return error + raw for debugging 📨 Email client quirks: test long newsletters; some clients clip lengthy HTML 💸 AI cost: the two-step (summarization + HTML generation) improves quality but can be merged to reduce cost 🧭 Quick customization Change microsaas to your target subreddit Rewrite the topic of interest (e.g., “growth strategies”, “fundraising”, etc.) Adapt the newsletter outline prompt for a different tone/format Schedule with a Cron node for daily or weekly digests 📬 Contact & Feedback Need help tailoring this workflow to your stack? 📩 Luis.acosta@news2podcast.com 🐦 @guanchehacker If you’re building something more advanced with curation + AI (like turning the digest into a podcast or video), let’s connect — I may have the missing piece you need.

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

Overview This workflow automates weather forecast delivery by collecting city names, fetching 5-day forecasts from OpenWeatherMap, and generating professionally formatted HTML emails using GPT-4. The AI creates condition-based color-coded reports with safety precautions and sends them via Gmail. How It Works A form trigger collects up to three city names, which are geocoded via OpenWeatherMap API to retrieve coordinates and 5-day forecasts. JavaScript nodes process the raw weather data into daily summaries, calculating temperature ranges, precipitation levels, wind speeds, and dominant weather conditions. GPT-4 then generates professionally formatted HTML emails with condition-based color coding: The AI intelligently adds contextual safety warnings for heavy rain, extreme heat, high winds, and thunderstorms. A validation node ensures proper JSON formatting before Gmail sends the final briefing. Use Cases • Field ops & construction crew briefings • Travel planning and itinerary preparation • Outdoor event planning & coordination • Logistics and transportation route planning • Real estate property viewing scheduling • Sports and recreational activity planning Setup Requirements 1) OpenWeatherMap API credentials 2) OpenAI API key 3) Gmail OAuth2 authentication Need Help? Join the Discord or ask in the Forum! README file available at https://tinyurl.com/MulticityWeatherForecast

This workflow contains community nodes that are only compatible with the self-hosted version of n8n. Who is this for? Automation enthusiasts, content creators, or social media managers who post article-based threads to Bluesky and want to automate the process end-to-end. What problem is this solving? Manual content repackaging and posting can be repetitive and time-consuming. This workflow automates the process from capturing article URLs (via Telegram or RSS) to scraping content, transforming it into a styled thread, and posting on Bluesky platform. What this workflow does Listens on Telegram or fetches from RSS feeds (AI Trends, Machine Learning Mastery, Technology Review). Extracts content from URLs using JinaAI. Converts the article into a neat, scroll-stopping thread via LangChain + Gemini / OpenAI ChatGPT. Splits the thread into multiple posts. The first post is published with “Create a Post”, while subsequent posts are replies. Adds short delays between posting to avoid rate limits. Setup Add credentials for Telegram Bot API, JinaAI, Google Gemini, and Bluesky App Password. Add or customize RSS feeds if needed Test with a sample URL to validate posting sequence. How to customize Swap out RSS feeds or trigger sources. Modify prompt templates or thread formatting rules in the LangChain/Gemini node. Adjust wait times or content parsing logic. Replace Bluesky with another posting target if desired. Made by: Khaisa Studio Need customs workflows? Contact Me!

💥 Automate Scrape Google Maps Business Leads (Email, Phone, Website) using Apify 🧠 AI-Powered Business Prospecting Workflow (Google Maps + Email Enrichment) Who is this for? This workflow is designed for entrepreneurs, sales teams, marketers, and agencies who want to automate lead discovery and build qualified business contact lists — without manual searching or copying data. It’s perfect for anyone seeking an AI-driven prospecting assistant that saves time, centralizes business data, and stays fully compliant with GDPR. What problem is this workflow solving? Manually searching for potential clients, copying their details, and qualifying them takes hours — and often leads to messy spreadsheets. This workflow automates the process by: Gathering publicly available business information from Google Maps Enriching that data with AI-powered summaries and contact insights Compiling it into a clean, ready-to-use Google Sheet database This means you can focus on closing deals, not collecting data. What this workflow does This automation identifies, analyzes, and organizes business opportunities in just a few steps: Telegram Trigger → Send a message specifying your business type, number of leads, and Google Maps URL. Apify Integration → Fetches business information from Google Maps (public data). Duplicate Removal → Ensures clean, non-redundant results. AI Summarization (GPT-4) → Generates concise business summaries for better understanding. Email Extraction (GPT-4) → Finds and extracts professional contact emails from company websites. Google Sheets Integration → Automatically stores results (name, category, location, phone, email, etc.) in a structured sheet. Telegram Notification → Confirms when all businesses are processed. All data is handled ethically and transparently — only from public sources and without any unsolicited contact. Setup Telegram Setup Create a Telegram bot via BotFather Copy the API token and paste it into the Telegram Trigger node credentials. Apify Setup Create an account on Apify Get your API token and connect it to the “Run Google Maps Scraper” node. Google Sheets Setup Connect your Google account under the “Google Maps Database” node. Specify the target spreadsheet and worksheet name. OpenAI Setup Add your OpenAI API key to the AI nodes (“Company Summary Info” and “Extract Business Email”). Test Send a Telegram message like: restaurants, 5, https://www.google.com/maps/search/restaurants+in+Paris How to customize this workflow to your needs Change search region or business type** by modifying the Telegram input message format. Adjust the number of leads** via the maxCrawledPlacesPerSearch parameter in Apify. Add filters or enrichments** (e.g., websites with social links, review counts, or opening hours). Customize AI summaries** by tweaking the prompt inside the “Company Summary Info” node. Integrate CRM tools** like HubSpot or Pipedrive by adding a connector after the Google Sheets node. ⚙️ Expected Outcome ✅ A clean, enriched, and ready-to-use Google Sheet of businesses with: Name, category, address, and city Phone number and website AI-generated business summary Extracted professional email (if available) ✅ Telegram confirmation once all businesses are processed ✅ Fully automated, scalable, and GDPR-compliant prospecting workflow 💡 This workflow provides a transparent, ethical way to streamline your B2B lead research while staying compliant with privacy and anti-spam regulations. 🎥 Watch This Tutorial 👋 Need help or want to customize this? 📩 Contact: LinkedIn 📺 YouTube: @DRFIRASS 🚀 Workshops: Mes Ateliers n8n 📄 Documentation: Notion Guide Need help customizing? Contact me for consulting and support : Linkedin / Youtube / 🚀 Mes Ateliers n8n

How it Works This workflow automatically monitors competitor affiliate programs twice daily using Bright Data's web scraping API to extract commission rates, cookie durations, average order values, and payout terms from competitor websites. The AI analysis engine scores each competitor (0-100 points) by comparing their commission rates, cookie windows, earnings per click (EPC), and affiliate-friendliness against your program, then categorizes them as Critical (70+), High (45-69), Medium (25-44), or Low (0-24) threat levels. Critical and high-threat competitors trigger immediate Slack alerts with detailed head-to-head comparisons and strategic recommendations, while lower threats route to monitoring channels. All competitors are logged to Google Sheets for tracking and historical analysis. The system generates personalized email reports—urgent action plans with 24-48 hour deadlines for critical threats, or standard intelligence updates for routine monitoring. The entire process takes minutes from scraping to strategic alert, eliminating manual competitive research and ensuring you never lose affiliates to better-positioned competitor programs. Who is this for? Affiliate program managers monitoring competitor programs who need automated intelligence E-commerce brands in competitive verticals who can't afford to lose top affiliates Affiliate networks managing multiple merchants needing competitive benchmarking Performance marketing teams responding to commission rate wars in their industry Setup Steps Setup time: Approx. 20-30 minutes (Bright Data setup, API configuration, spreadsheet creation) Requirements: Bright Data account with web scraping API access Google account with a competitor tracking spreadsheet Slack workspace SMTP email provider (Gmail, SendGrid, etc.) Sign up for Bright Data and get your API credentials and dataset ID. Create a Google Sheets with two tabs: "Competitor Analysis" and "Historical Log" with appropriate column headers. Set up these nodes: Schedule Competitor Check: Pre-configured for twice daily (adjust timing if needed). Scrape Competitor Sites: Add Bright Data credentials, dataset ID, and competitor URLs. AI Offer Analysis: Review scoring thresholds (commission, cookies, AOV, EPC). Route by Threat Level: Automatically splits by 70-point critical and 45-point high thresholds. Google Sheets Nodes: Connect spreadsheet and map data fields. Slack Alerts: Configure channels for critical alerts and routine monitoring. Email Reports: Set up SMTP and recipient addresses. Credentials must be entered into their respective nodes for successful execution. Customization Guidance Scoring Weights:** Adjust point values for commission (35), cookies (25), cost efficiency (25), volume (15) based on your priorities. Threat Thresholds:** Modify 70-point critical and 45-point high thresholds for your risk tolerance. Benchmark Values:** Update commission gap thresholds (5%+ = critical, 2%+ = warning) and cookie duration benchmarks (30+ days = critical). Competitor URLs:** Add or remove competitor websites to monitor in the HTTP Request node. Alert Routing:** Create tier-based channels or route to Microsoft Teams, Discord, or SMS via Twilio. Scraping Frequency:** Change from twice-daily to hourly for competitive markets or weekly for stable industries. Additional Networks:** Duplicate workflow for different affiliate networks (CJ, ShareASale, Impact, Rakuten). Once configured, this workflow will continuously monitor competitive threats and alert you before top affiliates switch to better-paying programs, protecting your affiliate revenue from competitive pressure. Built by Daniel Shashko Connect on LinkedIn