Workflow Templates

🚀 AI Facebook Post Generator - Complete Setup Guide > Transform your content ideas into viral Facebook posts with AI-powered automation in just 30 minutes! 📋 Prerequisites Checklist What you'll need before we start: ✅ n8n instance (cloud or self-hosted) ✅ Facebook Business Page (not personal profile) ✅ Google account with Sheets & Gmail access ✅ Basic understanding of API credentials ⏱️ Estimated Setup Time: 30-45 minutes 🎯 Difficulty Level: Intermediate 💰 Cost: Free tier available for all services 🎨 What You'll Build By the end of this guide, you'll have: 📝 Smart Content Form - Web form that captures your ideas 🤖 AI Content Optimizer - Gemini AI that polishes your writing 🖼️ Auto Image Generator - Custom visuals created automatically 📊 Content Tracker - Google Sheets logging for analytics 📱 Facebook Publisher - Direct posting to your page 📧 Success Notifications - Email confirmations with post links 🔧 Step-by-Step Setup Step 1: 📘 Facebook Integration Setup 🔸 1.1 Create Your Facebook App Why this matters: This gives your workflow permission to post on your behalf. Navigate to Facebook Developers 🌐 Click "My Apps" → "Create App" Select "Business" as your app type App Name: AI-Content-Poster (or your preferred name) Hit "Create App" > 💡 Pro Tip: Choose a descriptive name - you'll see this in your Facebook activity logs 🔸 1.2 Configure App Settings In your app dashboard: "Add a Product" Find "Facebook Login" → "Set Up" Navigate to Settings → Basic App Domains: Add app.n8n.cloud (for n8n cloud users) Save changes ✅ 🔸 1.3 Generate Your Page Access Token This is the key that unlocks posting powers! 🔑 Go to Tools → Graph API Explorer Select your newly created app Click "Generate Access Token" Required Permissions: pages_manage_posts pages_read_engagement pages_show_list Select your target Facebook page Copy the token (starts with EAAG...) ⚠️ Critical Step - Make Token Long-Lived: In Graph API Explorer, make a GET request to: /oauth/access_token?grant_type=fb_exchange_token&client_id=YOUR_APP_ID&client_secret=YOUR_APP_SECRET&fb_exchange_token=YOUR_SHORT_TOKEN 🔸 1.4 Find Your Page ID Two methods to get your Page ID: Method 1 - Direct from Facebook: Visit your Facebook page Click "About" tab Scroll to find "Page ID" Method 2 - API Explorer: Use Graph API Explorer GET request to: /me/accounts Find your page in the response Step 2: 🔍 Google Services Setup 🔸 2.1 Enable Required APIs Setting up your Google Cloud foundation: Visit Google Cloud Console ☁️ Create new project or select existing "APIs & Services" → "Library" Enable these APIs: ✅ Google Sheets API ✅ Gmail API ✅ Google Drive API (optional) 🔸 2.2 Create Service Account This creates a "robot" account for automated access: "APIs & Services" → "Credentials" "Create Credentials" → "Service Account" Name: ai-facebook-automation "Create and Continue" Skip role assignment → "Continue" "Done" ✅ 🔸 2.3 Download Credentials File Click your service account email "Keys" tab → "Add Key" → "Create New Key" Choose "JSON" format Download and save securely 📁 > 🔒 Security Note: This file contains sensitive credentials. Store it safely! 🔸 2.4 Prepare Your Google Sheets Create your data tracking system: 📊 Sheet 1: Content Log Purpose:** Track all generated content Columns:** A: Date (Ngày) B: Short Content (Nội dung ngắn) C: Full Content (Nội dung đầy đủ) 📝 Sheet 2: Input Tracking Purpose:** Log form submissions Columns:** A: Date B: Time C: Content 🔗 Important: Share both sheets with your service account email (found in the JSON file) Step 3: 🤖 AI Services Configuration 🔸 3.1 Get Your Gemini API Key Power up your AI content generation: Head to Google AI Studio 🎨 Sign in with Google account "Create API Key" Copy the key (starts with AIza...) > 💰 Cost Info: Gemini offers generous free tier limits - perfect for getting started! Step 4: ⚙️ n8n Workflow Configuration 🔸 4.1 Import the Magic ✨ Copy the workflow JSON from the template In n8n: "Import from JSON" Paste the workflow code "Import" to load your new automation 🔸 4.2 Configure Your Credentials 🔑 Facebook Graph API Setup: Settings → Credentials → "Add Credential" Search: "Facebook Graph API" Access Token: Your Page Access Token from Step 1.3 Test connection → Save as: Facebook Page Access 🔍 Google Services Setup: "Add Credential" → "Google Service Account" Upload your JSON file from Step 2.3 Test connection → Save as: Google Services 🧠 Gemini AI Setup: "Add Credential" → "Google PaLM API" Enter your Gemini key from Step 3.1 Save as: Gemini AI 🔸 4.3 Customize Node Settings 📱 Update Facebook Configuration: In "Facebook Graph API" node: Replace "113732581629527" with your Page ID from Step 1.4 In "Facebook Upload Img" node: Replace "113732581629527" with your Page ID from Step 1.4 📊 Update Google Sheets: In "save content" node: Replace Document ID with your Content Log Sheet ID In "Append row in sheet" node: Replace Document ID with your Input Tracking Sheet ID > 💡 Finding Sheet ID: It's the long string in your Google Sheets URL after /spreadsheets/d/ 📧 Update Notification Email: In "Send a message" node: Replace xxx@gmail.com with your email address Configure Gmail credentials Step 5: 🧪 Testing & Validation 🔸 5.1 Component Testing 📊 Test Google Sheets Connection: Right-click "Append row in sheet" node "Execute Node" ✅ Verify test row appears in your sheet 🤖 Test Gemini AI: Right-click "Basic LLM Chain" node "Edit Input Data" → Add test content Execute → ✅ Verify AI response quality 🖼️ Test Image Generation: Right-click "HTTP Request" node Ensure valid prompt from previous step Execute → ✅ Check for base64 image data 📱 Test Facebook Upload: Run full workflow with test content ✅ Check your Facebook page for new post ✅ Verify image uploaded correctly 🔸 5.2 End-to-End Victory Test 🎉 "Execute Workflow" on trigger node Submit test content through the form Monitor each node execution 🎊 Celebrate your first AI-generated post! 🎯 Success Indicators Your setup is complete when you see: ✅ Form accepts and processes content ✅ AI generates optimized text + image prompt ✅ Custom image appears in Facebook post ✅ Content logged in Google Sheets ✅ Success email in your inbox ✅ Professional-looking post on your Facebook page 🚨 Troubleshooting Quick Fixes Facebook Issues Token Expired?** → Generate new long-lived token Permission Denied?** → Check page admin rights Invalid Page ID?** → Double-check Page ID format Google Sheets Problems 403 Forbidden?** → Share sheet with service account Sheet Not Found?** → Verify Sheet ID in URL Column Errors?** → Match exact column names AI Content Issues Empty Responses?** → Check Gemini API quotas Poor Quality?** → Adjust AI prompts JSON Errors?** → Validate parsing logic 🎨 Customization Ideas Make it uniquely yours: 🎨 Brand Voice: Adjust AI prompts for your tone ⏰ Scheduling: Add time delays for strategic posting 📈 Analytics: Connect performance tracking tools 🔄 Multi-Platform: Extend to Instagram, LinkedIn 👥 Team Features: Add approval workflows 🎉 You Did It! Congratulations! You've built an AI-powered content machine that will save you hours every week. What's Next? Test with different content types Monitor performance in Google Sheets Refine AI prompts for better results Share your success with the community! Need Help? 🤝 Join n8n Discord Visit Community Forum Check n8n Documentation Ready to revolutionize your content creation? Your AI assistant is waiting! 🚀

This workflow contains community nodes that are only compatible with the self-hosted version of n8n. Overview Automate your email management with this n8n workflow that fetches, summarizes, and shares critical emails from your Gmail inbox. Designed for busy professionals, this workflow runs daily to extract important emails from the past 24 hours, summarizes key details (like credentials, OTPs, deadlines, and action items), converts the summary into a PDF, and sends it to your Discord channel for quick access. Key Features Scheduled Automation**: Triggers daily at 8 PM to process emails from the last 24 hours. Gmail Integration**: Retrieves emails labeled "INBOX" and "IMPORTANT" using secure OAuth2 authentication (no hardcoded API keys). Smart Email Parsing**: Extracts essential fields (subject, sender, and plain text) while cleaning up URLs, extra lines, and formatting for clarity. AI-Powered Summarization**: Uses OpenAI's GPT-4.1-mini to create concise plain text and markdown summaries, highlighting urgent actions with "[Action Required]". PDF Conversion**: Converts the markdown summary into a professional PDF using PDF.co API. Discord Notifications**: Shares the PDF via a Discord webhook for seamless team communication. Why Use This Workflow? Save time by automating email triage and focusing on what matters. Stay organized with clear, actionable summaries delivered to Discord. Securely handle sensitive data with proper credential management. Perfect for teams, freelancers, or anyone managing high email volumes. Setup Instructions Configure Gmail OAuth2 credentials for secure access. Set up PDF.co API and Discord webhook credentials. Customize the schedule or filters as needed. Activate and let the workflow handle your daily email summaries!

🎓📺 Watching top YouTubers is now a mainstream way to learn, but watching dozens—or even hundreds—of videos isn’t realistic. This workflow gives learners a fast way to grasp an entire creator’s catalog at a glance. 📄🔗 Demo Google Sheet: click me 🧠🔍 YouTube Channel Research & Summarization Workflow 👥 Who’s it for 📚 Learners and educators who want a fast overview of a creator’s entire catalog. 🧩 Research, SEO, and content ops teams building an intelligence layer on top of YouTube channels. ⚙️ How it works 📝 Collects parameters via a Form Trigger. 🕷️ Launches an Apify YouTube Scraper, polls for completion, and fetches the final dataset. 💾 Saves the raw JSON to Google Drive, reloads it, and processes records in batches. 🗣️ Auto-selects English subtitles when available, extracts core metadata, and feeds transcript + metadata to an AI Summarization Agent. 📧 Sends a Gmail completion notification when done. 🛠️ How to set up 🔑 Connect credentials (once) 🗂️ Google Drive 📊 Google Sheets (OAuth enabled) ✉️ Gmail 🧠 DeepSeek API (or alternative LLM); Apify API (YouTube scraper actor) 📝 Configure the form 🔗 Youtuber_MainPage_URL (e.g., https://www.youtube.com/@n8n-io) 🔢 Total_number_video (tip: use the channel’s current total to crawl all) 🏷️ Storing_Name (used for the Drive filename & the Sheet tab) 🔑 Apify_API (Apify provides $5 free credit per month, which can crawl ~1,000 YouTube videos → https://console.apify.com/) 📧 Email 📁 Point Sheets & Drive 🔗 Create a Google Sheet and link it to all Google Sheets–related nodes. 💽 Select a Drive folder to save raw CSV backups (optional). 🎛️ How to customize the workflow 🈯 Subtitle logic:** Extend the language selector Select_Subtitle_Language to choose English, Mandarin, or another language. 🔔 Notifications:** Customize the Gmail subject/body, or add Slack/Teams alerts on success/failure with basic run stats. 📬 Need help? Contact me <owenlzyxg@gmail.com>

📄 PDF-to-Order Automation for Magento2 (Adobe commerce / open source) Description This n8n template demonstrates how to automatically process PDF purchase orders received via email and convert them into sales orders in Adobe Commerce (Magento 2) using Company Credit as the payment method. This is especially useful for B2B companies receiving structured orders from clients by email. Use cases include: Automating incoming B2B orders Reducing manual entry for sales teams Ensuring fast order creation in Adobe Commerce Reliable error handling and customer validation Good to know This workflow is tailored for Adobe Commerce, using the Company Credit payment method. It requires that the customer already has an account in Adobe Commerce and is authorized to use Company Credit. The same flow can be easily adapted for other payment methods (e.g. Purchase Order, Bank Transfer). No third-party services are required aside from n8n and access to Adobe Commerce with API credentials. How it works Trigger → Monitors an email inbox for incoming emails with PDF attachments. Extract PDF → Downloads the attached PDF and parses order data (e.g. SKU, quantity, customer reference). Validate Customer → Checks if the sender matches an existing customer in Adobe Commerce and verifies Company Credit eligibility. Create Order → Generates a new order in Magento using the extracted product data and Company Credit. Handle Errors → Logs issues and can notify a designated channel (email, Slack, etc.) if something goes wrong. Optional Enhancements → Add logging to Airtable, send confirmations to customers, or attach parsed order data to CRM entries. How to use A manual trigger is included as an example, but you can replace it with an IMAP Email Trigger, Gmail Trigger, or Webhook, depending on your setup. Customize the PDF parser node to fit your specific document layout and field structure. Configure Adobe Commerce API credentials in the HTTP nodes (or use environment variables). Optionally connect error steps to Slack, Email, or dashboards for monitoring. Requirements ✅ n8n instance (self-hosted or cloud) ✅ Adobe Commerce (Magento 2) instance with API access and Company Credit enabled ✅ Structured PDF templates used by your customers (Optional) Slack/Email/Airtable for notifications and logs Customising this workflow This workflow can be adapted for: Other payment methods (e.g. Purchase Orders, Online Payment) Magento open source ready. Just use your own payment method Alternate order sources (e.g. uploading PDFs via a portal instead of email) Parsing other document formats (e.g. CSV, Excel) Direct integration into ERP systems

Automated project status tracking with Airtable and Motion Who's it for Project managers, team leads, and agencies who need to automatically monitor project completion status across multiple clients and send notifications when specific milestones are reached. What it does This workflow automatically tracks project progress by connecting Airtable project databases with Motion task management. It monitors specific tasks within active projects and triggers email notifications when key milestones are completed. The system is designed to handle multiple projects simultaneously and can be customized for various notification triggers. How it works The workflow follows a structured monitoring process: Data Retrieval: Fetches project information from Airtable (project names and Motion workspace IDs) Motion Integration: Connects to Motion API using HTTP requests to retrieve project details Project Filtering: Identifies only active projects with "Todo" status containing "SEO" in the name Task Monitoring: Checks for specific completed tasks (e.g., "Intégrer les articles de blog") Conditional Notifications: Sends email alerts only when target tasks are marked as "Completed" Database Updates: Updates Airtable with last notification timestamps Requirements Airtable account with project database Motion account with API access Gmail account for email notifications HTTP request authentication for Motion API How to set up Step 1: Configure your Airtable database Ensure your Airtable contains the following fields: Project names: Names of projects to monitor Motion Workspace ID: Workspace identifiers for Motion API calls Status - Calendrier éditorial: Project status field (set to "Actif" for active projects) Last sent - Calendrier éditorial: Timestamp tracking for notification frequency Email addresses: Client and team member contact information Step 2: Set up API credentials Configure the following authentication in n8n: Airtable Personal Access Token: For database access Motion API: HTTP header authentication for Motion integration Gmail OAuth2: For email notification sending Step 3: Configure Motion API integration Base URL: Uses Motion API v1 endpoints Project retrieval: Fetches projects using workspace ID parameter Task monitoring: Searches for specific task names and completion status Custom filtering: Targets projects with "SEO" in name and "Todo" status Step 4: Customize scheduling Default schedule: Runs daily between 10th-31st of each month at 8 AM Cron expression: 0 8 10-31 * * (modify as needed) Frequency options: Can be adjusted for weekly, daily, or custom intervals Step 5: Set up email notifications Configure Gmail settings: Recipients: Project managers, clients, and collaborators Subject line: Dynamic formatting with project name and month Message template: HTML-formatted email with professional signature Sender name: Customizable organization name How to customize the workflow Single project, multiple tasks monitoring To adapt for monitoring one project with several different tasks: Modify the filter conditions to target your specific project Add multiple HTTP requests for different task names Create conditional branches for each task type Set up different notification templates per task Multi-project customization Database fields: Add custom fields in Airtable for different project types Filtering logic: Modify conditions to match your project categorization Motion workspace: Support multiple workspaces per client Notification rules: Set different notification frequencies per project Alternative notification methods Replace or complement Gmail with: Slack notifications: Send updates to team channels Discord integration: Alert development teams SMS notifications: Urgent milestone alerts Webhook integrations: Connect to custom internal systems Teams notifications: Enterprise communication Task monitoring variations Multiple task types: Monitor different milestones (design, development, testing) Task dependencies: Check completion of prerequisite tasks Progress tracking: Monitor task progress percentages Deadline monitoring: Alert on approaching deadlines Conditional logic features Smart filtering system Active project detection: Only processes projects marked as "Actif" Date-based filtering: Prevents duplicate notifications using timestamp comparison Status verification: Confirms task completion before sending notifications Project type filtering: Targets specific project categories (SEO projects in this example) Notification frequency control Monthly notifications: Prevents spam by tracking last sent dates Conditional execution: Only sends emails when tasks are actually completed Database updates: Automatically records notification timestamps Loop management: Processes multiple projects sequentially Results interpretation Automated monitoring outcomes Project status tracking: Real-time monitoring of active projects Milestone notifications: Immediate alerts when key tasks complete Database synchronization: Automatic updates of notification records Team coordination: Ensures all stakeholders are informed of progress Email notification content Each notification includes: Project identification: Clear project name and context Completion confirmation: Specific task that was completed Calendar reference: Links to editorial calendars or project resources Professional formatting: Branded email template with company signature Action items: Clear next steps for recipients Use cases Agency project management Client deliverable tracking: Monitor when content is ready for client review Milestone notifications: Alert teams when phases complete Quality assurance: Ensure all deliverables meet completion criteria Client communication: Automated updates on project progress Editorial workflow management Content publication: Track when articles are integrated into websites Editorial calendar: Monitor content creation and publication schedules Team coordination: Notify writers, editors, and publishers of status changes Client approval: Alert clients when content is ready for review Development project tracking Feature completion: Monitor when development milestones are reached Testing phases: Track QA completion and deployment readiness Client delivery: Automate notifications for UAT and launch phases Team synchronization: Keep all stakeholders informed of progress Workflow limitations Motion API dependency: Requires stable Motion API access and proper authentication Single task monitoring: Currently tracks one specific task type per execution Email-only notifications: Default setup uses Gmail (easily expandable) Monthly frequency: Designed for monthly notifications (customizable) Project naming dependency: Filters based on specific naming conventions Manual configuration: Requires setup for each new project type or workspace

Geopolitics Breaking News Alert System Workflow Name: Geopolitics Breaking News Alert System Author: Devjothi Dutta Category: Productivity, News & Media, AI/Machine Learning Complexity: Medium Setup Time: 45-60 minutes 📖 Description An intelligent geopolitical monitoring system that filters 200+ daily news articles down to only the critical breaking news that matters to you. This workflow uses smart keyword filtering and AI-powered scoring to eliminate noise, reduce AI costs, and deliver only high-priority geopolitical alerts to Telegram. The Problem: Traditional news monitoring is overwhelming - hundreds of articles per hour, 95% irrelevant to your region of interest, no urgency prioritization, and critical breaking news gets buried in noise. The Solution: This workflow combines dual-layer filtering (primary + secondary keywords) with AI scoring to distinguish actual breaking news from general news coverage. By filtering first and scoring second, you reduce AI API costs by 80-90% while ensuring you never miss critical geopolitical developments. Switch between monitoring India, China, Middle East, Russia-Ukraine, or any region by simply changing a configuration file. Perfect for government analysts, corporate security teams, investment research firms, news organizations, or anyone who needs to stay informed about geopolitical developments without information overload. 👥 Who's it for For Government & Defense Analysts: Monitor specific regions for military actions, diplomatic developments, and security threats Filter by mission-critical keywords to eliminate irrelevant news AI scoring identifies genuine breaking news vs routine coverage Reduce analyst workload by 90% through intelligent automation For Corporate Security & Risk Teams: Track geopolitical risks affecting global supply chains and operations Custom keyword filters for industry-specific concerns (e.g., "semiconductor", "tariff", "sanctions") Real-time alerts for events impacting business continuity Cost-efficient monitoring with minimal AI API usage For Investment Research Firms: Monitor emerging market geopolitical risks affecting portfolio companies AI scoring differentiates market-moving events from background noise Configurable alert thresholds based on investment strategy (conservative vs aggressive) Track multiple regions simultaneously with different configs For News Organizations & Journalists: Monitor breaking geopolitical developments for editorial coverage Filter by urgency to prioritize assignment desk resources Aggregate multiple international news sources in one place Extend alerts to newsroom Slack channels or email ✨ Key Features 🎯 Smart Dual-Layer Filtering - Primary keywords ensure regional relevance, secondary keywords filter by event type (military, diplomatic, economic) 🤖 AI-Powered Urgency Scoring - GPT-4o-mini scores articles 1-10 based on geopolitical urgency, distinguishing breaking news from routine coverage 💰 Cost-Efficient Design - Filter first, score second approach reduces AI API calls by 80-90% (only ~5 articles analyzed out of 200) 🌍 Multi-Region Support - Monitor India, China, Middle East, Russia-Ukraine, or any region by switching config files 📰 Multi-Source RSS Aggregation - Combines 6 international news sources (NYT, BBC, Al Jazeera, SCMP, regional feeds) 🔄 Duplicate Detection - Persistent storage prevents re-analyzing same articles across multiple executions 📊 Consolidated Alerts - Single Telegram message with all breaking news, grouped by urgency score ⏰ Flexible Scheduling - Configure trigger interval per your needs (15min for active conflicts, 3hr for routine monitoring) 💾 Config-Driven Architecture - All filters, keywords, and scoring rules in Google Drive JSON file 🔒 Production Ready - Tested end-to-end with real-world India and China configurations 📈 Scalable Design - Run multiple regional configs in parallel, extend to Slack/WhatsApp/Email delivery 🛠️ Requirements Required Services: n8n (version 1.0+) - Workflow automation platform Free tier: n8n cloud or self-hosted Docker Required feature: Data Tables (for duplicate tracking) OpenAI API (GPT-4o-mini) - AI scoring engine Cost: ~$0.10/day for 30min intervals Free tier: $5 credit for new accounts Telegram Bot - Alert delivery Free: Create via @BotFather on Telegram Get chat ID via @userinfobot Google Drive - Config file storage Free: Any Google account Used for publicly shared JSON config files Required Credentials: OpenAI API Key** - Get from platform.openai.com (GPT-4o-mini access) Telegram Bot Token** - Create bot via @BotFather, get token n8n Data Table** - Built-in n8n feature (no external credential) Optional: Slack Webhook URL (for extending alerts to Slack) SMTP credentials (for email alerts) Twilio account (for WhatsApp/SMS alerts) 📦 What's Included This workflow package includes: Complete n8n workflow JSON (ready to import) Complete setup guide - Detailed configuration with Data Table setup, troubleshooting Technical architecture documentation Use cases and customization guide 4 pre-built regional configs (India, China, Middle East, Russia-Ukraine) 🚀 Quick Start Full setup takes 45-60 minutes. For detailed step-by-step instructions, see SETUP_GUIDE.md Overview Create n8n Data Table (analyzed_articles with 2 columns) Upload config to Google Drive (choose region, share publicly, get file ID) Import workflow (22 nodes ready to configure) Configure nodes: Update Google Drive config URL with your file ID Update 6 RSS Feed URLs for your region Link 3 Data Table nodes to analyzed_articles table Add credentials (OpenAI API, Telegram Bot) Set schedule (15min-daily based on monitoring needs) Test workflow (verify filtering, scoring, alerts work) Activate (workflow runs automatically on schedule) Quick Start Result: ✅ 200+ articles processed → 5-7 filtered → 3-5 scored → 1-3 alerts sent ✅ Telegram receives consolidated breaking news message ✅ Workflow runs every 30min (or your chosen interval) ✅ Total monthly cost: $3-5 (OpenAI API only) Need help? See detailed SETUP_GUIDE.md for complete instructions with screenshots and troubleshooting. 📊 Workflow Stats Nodes:** 22 Complexity:** Medium Execution Time:** ~30-60 seconds per run Monthly Cost:** $3-5 (OpenAI API usage only) Maintenance:** Minimal (update RSS feeds if sources change) Scalability:** Handles 200+ articles per execution, easily scales to 10+ RSS feeds 🎨 Customization Options Add more regions:** Create new config JSON files for North Korea, Taiwan, Africa, Latin America, etc. Multi-channel alerts:** Extend to Slack, WhatsApp, Email, Discord, Microsoft Teams, SMS Severity-based routing:** Send critical alerts (score 9-10) via SMS, others to Telegram Custom scoring models:** Switch between GPT-4o-mini, GPT-4o, Claude based on config Exclude keywords:** Add "exclude_keywords" array to filter out sports, entertainment, weather Alert digest mode:** Aggregate alerts into daily/weekly summary emails instead of real-time Dashboard integration:** Connect to Grafana or Metabase for visual trend analysis Webhook triggers:** Use workflow output to trigger other n8n workflows or external systems Custom RSS feeds:** Add industry-specific or regional news sources Adjust alert threshold:** Change from score >= 6 to higher/lower based on notification preferences 🔧 How it Works Schedule Trigger (Configurable): Workflow runs at your configured interval (15min, 30min, 1hr, 3hr, daily, etc.) Trigger frequency depends on use case: active conflicts need more frequent monitoring Config Loading: HTTP Request node fetches JSON config from Google Drive Config contains: keywords, scoring rules, AI role, alert threshold, Telegram chat ID RSS Aggregation: 6 RSS Feed nodes fetch articles from international news sources Merge node combines all feeds (~200 articles per execution) RSS Cleanup node strips HTML and normalizes to 5 fields (60-75% size reduction) Smart Filtering (Cost Optimization Layer 1): Dynamic Filter checks PRIMARY keywords (geographic/entity: "india", "modi", "delhi") Also checks SECONDARY keywords (event type: "military", "conflict", "trade deal") Both conditions required: Article must mention at least one primary AND one secondary Result: 200 articles reduced to ~5-7 relevant articles (95% reduction) Why this matters: Eliminates noise BEFORE expensive AI scoring Duplicate Detection (Cost Optimization Layer 2): Queries Data Table for previously analyzed article links Filters out articles already scored in last 7 days Result: 5-7 filtered articles reduced to 3-5 new articles Why this matters: Prevents redundant AI API calls (saves 80% on repeat articles) Dynamic AI Prompt Generation: Code node builds system prompt from config.ai_role and config.scoring_criteria Instructs AI: "You are a geopolitical analyst for [REGION]. Score articles 1-10..." Includes scoring rubric: 9-10 = Military Action, 7-8 = Trade/Economic, etc. AI Urgency Scoring (Breaking News Detection): Breaking News Analyzer (GPT-4o-mini) evaluates geopolitical urgency Scores 1-10: Distinguishes genuine breaking news from routine coverage Returns: score, category, reasoning, should_alert (true/false based on threshold) Cost: $0.002 per article (only 3-5 articles scored per execution) Alert Decision: IF node checks: should_alert === true (score >= config.alert_threshold) Only high-priority alerts proceed to Telegram Articles below threshold are logged but not sent Alert Aggregation: Consolidates multiple breaking news alerts into single Telegram message Groups by urgency score with color-coded emojis (🔴 9-10, 🟠 7-8, 🟡 6-7) Includes: score, category, title, link for each alert Telegram Delivery: Sends consolidated alert to configured Telegram chat Uses HTML formatting for bold text and clickable links Chat ID dynamically loaded from config (different regions → different chats) 💡 Pro Tips Start with Higher Threshold:** Begin with alert_threshold = 7 to avoid alert fatigue, lower to 6 after tuning keywords Regional RSS Matters:** Use region-specific news sources for better coverage (e.g., Times of India for India, not just BBC/NYT) Test Keywords First:** Run workflow manually with "Test Workflow" to verify keyword filtering before activating schedule Monitor AI Costs:** Check OpenAI usage dashboard after first week to confirm ~$0.10/day cost estimate Tune Secondary Keywords:** Add domain-specific terms to secondary keywords (e.g., "semiconductor" for tech supply chain monitoring) Use Separate Configs for Critical Regions:** Clone workflow for high-priority regions instead of switching configs manually Schedule Based on Time Zones:** Align execution intervals with business hours in monitored region (e.g., 9AM-6PM IST for India) Clear Duplicates for Testing:** Manually clear analyzed_articles Data Table when testing new configs for fresh results Backup Working Configs:** Export and version control config files before making major keyword changes Consider Alert Fatigue:** Score 9-10 events are rare (0-1 per day), score 6-8 events are common (2-5 per day) - set threshold accordingly 🔗 Related Workflows Multi-Region Geopolitics Dashboard** - Combine multiple regional configs into single monitoring dashboard Geopolitical Risk Scoring for Portfolios** - Integrate with stock portfolio data to assess investment risk Automated Geopolitical Intelligence Reports** - Generate daily/weekly PDF reports from breaking news data Conflict Escalation Tracker** - Track score trends over time to detect escalating tensions Supply Chain Risk Alerting** - Focus on trade/sanctions news affecting global supply chains 📧 Support & Feedback For questions, issues, or feature requests: GitHub:** n8n-geopolitics-breaking-news-alert Repository n8n Community Forum:** Tag @devdutta Email:** devjothi@gmail.com 📄 License MIT License - Free to use, modify, and distribute ⭐ If you find this workflow useful, please share your feedback and star the workflow!

Sycorda AI Lead Qualification & Meeting Booking System This workflow creates a sophisticated AI-powered sales assistant that automatically qualifies website visitors, schedules meetings, and manages the entire lead-to-booking pipeline without human intervention. The system acts as "Hassan," a friendly sales representative who engages prospects through natural conversation and converts interest into booked appointments with remarkable efficiency. Benefits: Complete Sales Automation - Engages website visitors 24/7, qualifies leads through intelligent conversation, and books meetings automatically without any manual oversight AI-Powered Lead Qualification - Uses advanced conversational AI with SPIN Selling and Challenger Sale methodologies to identify high-value prospects and overcome objections naturally Smart Calendar Integration - Automatically checks availability, prevents double-bookings, and sends professional confirmation emails with meeting details Intelligent Data Management - Tracks all interactions, prevents duplicate outreach, and maintains comprehensive conversation summaries for follow-up optimization Scalable Conversion System - Processes unlimited website visitors simultaneously while maintaining personalized, human-like interactions for maximum conversion rates Revenue-Focused Approach - Specifically designed to identify prospects interested in AI automation services and guide them toward high-value consulting calls How It Works: Website Visitor Engagement: Captures incoming chat messages from website visitors in real-time Initiates conversations using a trained AI persona that feels authentically human Gradually qualifies interest in AI automation services through strategic questioning Intelligent Lead Processing: Collects essential contact information (name, email, company) within first few exchanges Cross-references visitor history to provide personalized follow-up experiences Updates comprehensive database with conversation summaries and lead scoring Advanced Qualification System: Uses proven sales methodologies (SPIN, Challenger) to overcome objections naturally Identifies pain points, budget indicators, and timeline requirements through conversation Accesses company knowledge base to answer specific questions about services and pricing Automated Meeting Booking: Seamlessly transitions qualified prospects to calendar booking when interest is confirmed Checks real-time calendar availability to prevent conflicts and optimize scheduling Creates calendar events with proper attendee management and meeting details Professional Follow-Up Automation: Sends branded confirmation emails with meeting links and company information Maintains conversation context across multiple touchpoints for consistency Provides detailed handoff information to sales team for optimal meeting preparation Required Database Setup: Before running this workflow, create a Google Sheets database with these exact column headers: Essential Columns: Name** - Prospect's full name (collected during qualification) Email** - Primary email address (used for matching and updates) Summary** - Detailed conversation summary with key insights Date** - Timestamp of interaction for tracking and follow-up Setup Instructions: Create a new Google Sheet with these column headers in the first row Name the sheet "Web Chat Bot Convo Summary" Connect your Google Sheets OAuth credentials in n8n Update the document ID in the workflow nodes The merge logic uses the Email column to prevent duplicate entries and update existing records with new conversation data. Business Use Cases: Service-Based Businesses - Automatically qualify and book high-value consultation calls without hiring additional sales staff Digital Agencies - Scale lead generation for AI automation services while maintaining personalized prospect experiences Consultants & Coaches - Convert website traffic into booked discovery calls with intelligent qualification and objection handling B2B SaaS Companies - Identify enterprise prospects and schedule product demos through natural conversation flow Revenue Potential: This system can generate $10,000-$50,000+ monthly by converting website visitors into qualified meetings. A single automated booking for AI automation services typically ranges from $3,000-$15,000 in project value, making the ROI calculation extremely attractive. Conversion Metrics: Typically converts 15-25% of engaged website visitors into qualified meetings Saves 20+ hours weekly of manual lead qualification and follow-up Eliminates scheduling back-and-forth and missed appointment opportunities Difficulty Level: Advanced Estimated Build Time: 3-4 hours Monthly Operating Cost: ~$50-100 (AI API usage + integrations) Set Up Steps: Configure AI Services: Add OpenAI API credentials for conversational AI and Claude Sonnet for specialized tasks Set up appropriate rate limiting and cost controls for sustainable operation Customize the AI persona and conversation flow for your specific business Database Configuration: Create Google Sheets database with provided column structure Connect Google Sheets OAuth credentials for seamless data management Configure the merge logic for duplicate prevention and record updates Calendar Integration Setup: Connect Google Calendar OAuth with proper permissions for event creation Configure calendar checking logic to prevent double-bookings Set up meeting link generation and attendee management Email Automation: Connect Gmail OAuth for sending confirmation emails Customize the branded email template with your company information Test email delivery and formatting across different clients Conversation Optimization: Customize AI prompts for your specific industry and service offerings Adjust qualification questions to identify your ideal customer profile Set up objection handling responses that align with your sales methodology Advanced Configuration: Configure memory management for consistent multi-session conversations Set up proper error handling and fallback responses Implement conversation logging and analytics for optimization Testing & Launch: Test the complete flow with sample conversations and edge cases Verify calendar integration, email delivery, and data logging Deploy with monitoring to track performance and optimize conversion rates Advanced Customization: Multi-Language Support** - Adapt conversations for international prospects Industry-Specific Qualification** - Customize questioning for different market segments Integration Expansion** - Connect to CRM systems, Slack notifications, or other business tools Advanced Analytics** - Track conversion funnels, conversation quality, and ROI metrics A/B Testing Framework** - Test different conversation approaches and optimize for higher conversion This system transforms your website from a passive information source into an active sales machine that works around the clock to generate qualified meetings and drive revenue growth.

WhatsApp AI Personal Assistant - n8n Workflow Instructions Who's it for This workflow is designed for business professionals, entrepreneurs, and individuals who want to transform their WhatsApp into a powerful AI-powered personal assistant. Perfect for users who need to manage emails, calendar events, document searches, and various productivity tasks through a single messaging interface. What it does This comprehensive n8n workflow creates an intelligent WhatsApp bot that can process multiple message types (text, voice, images, PDF documents) and execute complex tasks using integrated tools including Gmail, Google Calendar, Google Drive, Airtable, Discord, and internet search capabilities. The assistant maintains conversation context and can handle sophisticated requests through natural language processing. How it works Phase 1: Message Reception and Classification The workflow begins when a message is received through the WhatsApp Trigger. A Switch node automatically classifies the incoming message type (text, audio, image, or document) and routes it to the appropriate processing pathway. Phase 2: Content Processing by Format Text Messages: Direct extraction and formatting for AI processing Voice Messages: Retrieves audio URL from WhatsApp API Downloads audio file with authenticated requests Transcribes speech to text using OpenAI Whisper Formats transcribed content for AI agent Images: Downloads image from WhatsApp API Analyzes visual content using GPT-4O-mini vision model Generates detailed French descriptions covering composition, objects, people, and atmosphere Combines user requests with AI analysis PDF Documents: Validates file format (rejects non-PDF files) Downloads and extracts text content Processes document text for AI analysis Phase 3: AI Assistant Processing The processed content is handled by a Claude Sonnet 4-powered agent with access to: SerpAPI** for internet searches Airtable database** for email contact management Gmail integration** for email operations Google Calendar** for event scheduling and management Google Drive** for document searches Discord messaging** for notifications Calculator** for mathematical operations PostgreSQL chat memory** for conversation context Phase 4: Response Delivery The system intelligently determines response format: For voice inputs: Converts AI response to speech using OpenAI TTS For other inputs: Sends text responses directly Handles technical requirements like MIME type compatibility for WhatsApp Requirements API Credentials Required: WhatsApp Business API** (Trigger and messaging) OpenAI API** (GPT-4O-mini, Whisper, TTS) Anthropic API** (Claude Sonnet 4) Google APIs** (Gmail, Calendar, Drive OAuth2) Airtable API** (Database operations) Discord Bot API** (Messaging) SerpAPI** (Internet search) PostgreSQL Database** (Conversation memory) Self-hosted n8n Instance This workflow requires a self-hosted n8n installation as it uses community nodes and advanced integrations not available in n8n Cloud. How to set up 1. Prerequisites Setup Deploy n8n on a server with public access Obtain WhatsApp Business API credentials Create developer accounts for all required services Set up a PostgreSQL database for conversation memory 2. Credential Configuration Configure the following credentials in n8n: WhatsApp API credentials for both trigger and messaging nodes OpenAI API key with access to GPT-4O-mini, Whisper, and TTS Anthropic API key for Claude Sonnet 4 Google OAuth2 credentials for Gmail, Calendar, and Drive Airtable Personal Access Token Discord Bot token SerpAPI key PostgreSQL database connection 3. WhatsApp Configuration Configure webhook URLs in WhatsApp Business API settings Set up phone number verification Configure message templates if required 4. Tool Configuration Airtable**: Set up email database with 'Nom' and 'Mails' columns Google Calendar**: Configure calendar access permissions Google Drive**: Set up appropriate folder permissions Discord**: Configure bot permissions and channel access 5. Testing and Validation Test each message type (text, audio, image, PDF) Verify all tool integrations work correctly Test conversation memory persistence Validate response delivery in both text and audio formats How to customize the workflow Modify AI Assistant Personality Edit the system message in the "Agent personnel" node to customize the assistant's behavior, tone, and capabilities according to your needs. Add New Tools Integrate additional n8n tool nodes to extend functionality: CRM systems (Salesforce, HubSpot) Project management tools (Notion, Trello) File storage services (Dropbox, OneDrive) Communication platforms (Slack, Microsoft Teams) Customize Content Processing Modify image analysis prompts for specific use cases Add document format support beyond PDF Implement content filtering or moderation Add language detection and multi-language support Enhance Memory and Context Implement user-specific memory sessions Add conversation summaries for long interactions Create user preference storage Implement conversation analytics Response Customization Add multimedia response capabilities Implement response templates for common queries Add typing indicators or read receipts Create custom response formatting Security Enhancements Implement user authentication Add rate limiting for API calls Create audit logs for sensitive operations Implement data encryption for stored conversations Performance Optimization Add caching for frequently accessed data Implement queue management for high-volume usage Add error handling and retry mechanisms Create monitoring and alerting systems Important Notes This workflow processes sensitive data; ensure proper security measures are in place Monitor API usage limits across all integrated services Regularly backup conversation memory data Test thoroughly before deploying to production Consider implementing user access controls for business environments Keep all API credentials secure and rotate them regularly Troubleshooting Audio Issues**: Verify MIME type handling in the "Fix mimeType for Audio" node WhatsApp Delivery**: Check webhook configurations and phone number verification Tool Failures**: Validate all API credentials and permissions Memory Issues**: Monitor PostgreSQL database performance and storage Response Delays**: Optimize tool timeout settings and add proper error handling

AI-Powered HR Candidate Evaluation Agent with LinkedIn Data Enrichment in CSV/XLSX Format 🎯 Overview Transform your manual hiring process into an intelligent evaluation system that saves 15-20 minutes per candidate! This workflow automates the entire candidate assessment pipeline - from CSV/XLSX upload to AI-powered scoring with LinkedIn insights. When you upload a candidate list, this workflow automatically: 📊 Converts your file into a formatted Google Sheet with RTL support 🔍 Researches each candidate's recent LinkedIn posts via Apify 🤖 Evaluates candidates using GPT-4.1 with context-aware scoring (0-100) 💬 Generates professional Hebrew explanations for each score 📈 Auto-sorts by score and applies professional formatting ⚠️ Sends error alerts to keep everything running smoothly Cost per candidate: ~$0.05 | Time saved: 15-20 minutes each 👥 Who's it for? HR teams drowning in candidate applications Recruitment agencies needing consistent evaluation criteria Hiring managers seeking data-driven candidate insights Companies looking to scale their team Anyone tired of manual spreadsheet juggling ⚡ How it works Form submission triggers with CSV/XLSX upload Google Drive stores the file and creates a new Sheet Data extraction processes the file content AI Agent loops through each candidate: Fetches up to 3 recent LinkedIn posts via Apify Analyzes qualifications against job requirements Generates evaluation score and Hebrew explanation Sheet formatting applies filters, sorting, and styling Error handling notifies admin of any issues 🛠️ Setup Instructions Time to deploy: 15 minutes Requirements: Google account (Drive + Sheets access) OpenAI API key (GPT-4.1 access) Apify API key (for LinkedIn scraping) Gmail account (for error notifications) Step-by-step: Import this template into your n8n instance Configure Google credentials: Connect Google Drive OAuth2 Connect Google Sheets OAuth2 Add OpenAI API key to the GPT-4.1 node Set up Apify credentials for LinkedIn scraping Configure Gmail for error alerts (update email in "Send a message" node) Update folder IDs in Google Drive nodes to your folders Test with a sample CSV containing 2-3 candidates Activate and share the form URL with your team! 📋 Input File Format Your CSV/XLSX should include these columns (Hebrew): שם פרטי (First name) שם משפחה (Last name) חשבון לינקדאין (LinkedIn URL) Your custom evaluation questions 🎨 Customization Options Easy tweaks: Scoring criteria**: Modify the AI agent's system message Language**: Switch from Hebrew to any language Scoring rubric**: Adjust the 50/25/15/10 weighting LinkedIn posts**: Change from 3 posts to more/fewer Sheet styling**: Customize colors and formatting Advanced modifications: Add integration with your ATS (Greenhouse, Lever, etc.) Connect to Slack for real-time notifications Add multiple evaluation agents for different roles Implement multi-language support Add candidate email automation 💡 Pro Tips Better LinkedIn data**: Ensure candidates provide complete LinkedIn URLs (not just usernames) Consistent scoring**: Run batches of similar roles together for normalized scoring Cost optimization**: Adjust Apify settings to fetch only essential data Scale smartly**: Process in batches of min 10-20 for optimal performance ⚠️ Important Notes LinkedIn scraping respects Apify's rate limits Scores are relative within each batch - don't compare across different job roles The workflow handles both CSV and XLSX formats automatically Error notifications help you catch issues before they cascade 📊 Expected Results After implementation, expect: Data-driven evaluation across candidates Professional explanation for hiring decisions Happy recruiters who can focus on human connection Built with ❤️ by Elay Guez

AI-Powered Product-Qualified Lead (PQL) Scoring & Sales Routing One-Line Description Automatically score product usage signals from Amplitude cohorts and route hot leads to sales with enriched context. Detailed Description What it does: This workflow transforms behavioral data into sales-ready leads by instantly detecting when users hit your PQL threshold, enriching their profile with company intelligence, and using AI to score their conversion potential. Hot leads are routed directly to sales with personalized conversation starters, while warm and cold leads enter appropriate nurture sequences. Who it's for: Product-led growth (PLG) teams** bridging the gap between product adoption and sales conversion Sales development teams** needing real-time alerts on high-intent users with actionable context Revenue operations professionals** optimizing lead handoff processes between product and sales Key Features: Real-time PQL detection** - Triggers instantly when users enter Amplitude behavior cohorts, eliminating manual lead review Multi-source enrichment** - Combines product usage data with company intelligence from People Data Labs and AI-powered research AI-driven scoring** - Evaluates usage intensity, ICP fit, intent signals, and timing to produce 0-10 lead scores with breakdown reasoning Smart routing logic** - Automatically categorizes leads as hot (8-10), warm (5-7), or cold (0-4) for appropriate follow-up workflows Sales enablement context** - Provides conversation starters, key insights, red flags, and handoff recommendations tailored to each lead Customizable criteria** - References external Google Doc for PQL rules, allowing non-technical teams to update scoring logic How it works: Trigger: Amplitude fires webhook when user enters predefined PQL cohort based on product usage patterns Enrichment: Pulls company data from People Data Labs and conducts AI research on company stage, tech sophistication, and budget indicators AI Scoring: Agent evaluates combined usage + enrichment data against ICP criteria stored in Google Docs, producing structured scoring output Routing: High-scoring leads (hot) generate formatted Slack alerts for immediate sales outreach; warm/cold leads could trigger email sequences (not shown in this template) Setup Requirements Prerequisites: Amplitude account** with cohort webhook capability (Growth plan or higher) People Data Labs API key** for company/person enrichment (paid credits required) Perplexity API** for AI-powered company research Anthropic Claude API** for PQL scoring logic Google Gemini API** for Slack message formatting Slack workspace** with OAuth app configured for posting messages Google Docs** containing your PQL criteria and ICP definition (publicly readable or authenticated access) Estimated Setup Time: 45-60 minutes including API credential configuration, Amplitude cohort definition, and PQL criteria document creation Installation Notes Amplitude cohort setup**: Define your PQL cohort using behavioral criteria (e.g., "Users who viewed 5+ pages AND invited team members in last 7 days"). Configure webhook to fire on cohort entry. PQL criteria document**: Create a Google Doc outlining your scoring components (usage intensity factors, ICP requirements, intent signals). Update the Google Docs Tool node with your document URL. Free email filtering**: The workflow includes logic to flag free email domains (Gmail, Yahoo, etc.) which you may want to route differently Testing tip**: Use Amplitude's "Test Webhook" feature to send sample payloads before going live Customization Options Replace People Data Labs** with Clearbit, Apollo, or other enrichment providers by swapping the HTTP Request node Add CRM integration** to automatically create opportunities or update lead scores in Salesforce/HubSpot Extend routing paths** by adding branches for warm/cold leads (e.g., trigger email sequences via Customer.io, Braze) Adjust scoring weights** by modifying the AI agent prompt or criteria document without touching workflow logic Multi-channel alerts** by duplicating output nodes to send to email, SMS, or CRM tasks in addition to Slack Category Sales Tags amplitude pql product-qualified-leads sales-automation lead-scoring enrichment people-data-labs slack-notifications ai-scoring revenue-operations Use Case Examples SaaS PLG companies**: Automatically escalate free trial users who hit usage milestones (API calls, integrations connected, team invites sent) to sales for upgrade conversations Developer tools**: Identify enterprise-ready accounts based on team size growth, deployment patterns, and GitHub integration usage, routing to enterprise sales team B2B marketplaces**: Surface buyers showing high-intent behavior (multiple searches, saved items, pricing page views) to account executives with company context for proactive outreach

Description Automate customer feedback analysis and action planning by integrating Monday.com, Azure OpenAI, Jira, Google Sheets, and Outlook. This workflow classifies customer feedback with AI, calculates business impact, creates Jira tasks for high-priority issues, and sends weekly performance summaries — turning raw feedback into actionable insights. 💬📈🤖 What This Template Does Step 1: Triggers automatically every Monday at 9:00 AM to fetch new customer feedback from Monday.com. ⏰ Step 2: Normalizes and structures data into consistent fields (title, account, ARR, NPS, etc.). 🧩 Step 3: Uses Azure OpenAI GPT-4 to classify sentiment and identify feedback themes (e.g., “UI Design,” “App Crash”). 🧠 Step 4: Calculates a business impact score based on ARR, NPS delta, and sentiment weightings. ⚙️ Step 5: Creates Jira tasks for high-impact feedback items for product or engineering follow-up. 🎫 Step 6: Logs all feedback and impact scores into Google Sheets for analytics dashboards. 📊 Step 7: Generates a professional HTML report summarizing metrics, wins, and risks, then emails it via Outlook. 📧 Step 8: Sends automated error-alert emails if any node fails during execution. 🚨 Key Benefits ✅ Converts qualitative feedback into measurable business intelligence ✅ Identifies critical customer issues automatically using AI ✅ Reduces manual effort in triaging and prioritizing feedback ✅ Creates real-time visibility for product and CX teams ✅ Provides weekly executive summaries and performance insights Features Weekly scheduled trigger (every Monday 9 AM) Monday.com data fetching and field normalization Azure OpenAI GPT-4-based sentiment and theme detection Impact scoring combining ARR + NPS + sentiment weighting Jira issue creation with context-rich descriptions Google Sheets logging for dashboards and historical records Outlook HTML email reports for leadership visibility Automated Gmail error-notification system Requirements Monday.com API credentials with board access Azure OpenAI GPT-4 API credentials Jira Software Cloud API credentials Google Sheets OAuth2 credentials with edit permissions Microsoft Outlook OAuth2 credentials for email delivery Gmail OAuth2 credentials for error alerting Target Audience Product and CX teams analyzing customer sentiment SaaS businesses tracking post-implementation feedback Customer-success and support operations teams Product managers prioritizing improvements based on impact Leadership teams monitoring customer health and satisfaction Step-by-Step Setup Instructions 1️⃣ Connect Monday.com API and update your boardId and groupId. 2️⃣ Configure Azure OpenAI GPT-4 credentials for the AI classifier. 3️⃣ Set Jira project ID and issue type for ticket creation. 4️⃣ Link Google Sheets and replace YOUR_SHEET_ID. 5️⃣ Connect Outlook OAuth2 and add recipient email for reports. 6️⃣ Configure Gmail OAuth2 for error alerts. 7️⃣ Adjust the cron expression (0 9 * * 1) to fit your timezone. 8️⃣ Test the workflow end-to-end with sample data. 9️⃣ Enable automation for seamless weekly feedback intelligence. ✅

Team Wellness - AI Burnout Detector Agent devex github 🎯 Demo sample report github action code alternative How it works 🎯 Overview A comprehensive n8n workflow that analyzes developer workload patterns from GitHub repositories to detect potential software engineering team burnout risks and provide actionable team wellness recommendations. This workflow automatically monitors team activity patterns, analyzes them using AI, and provides professional wellness reports with actionable recommendations which will automate GitHub issue creation and do email notifications for critical alerts. ✨ Features Automated Data Collection**: Fetches commits, pull requests, and workflow data from GitHub Pattern Analysis**: Identifies late-night work, weekend activity, and workload distribution AI-Powered Analysis**: Uses Groq's LLM for professional burnout risk assessment Automated Actions**: Creates GitHub issues and sends email alerts based on criticality Professional Guardrails**: Ensures objective, evidence-based analysis with privacy protection Scheduled Monitoring**: Weekly automated wellness checks 🏗️ Architecture 1. Data Collection Layer GitHub Commits API**: Fetches commit history and timing data GitHub Pull Requests API**: Analyzes collaboration patterns GitHub Workflows API**: Monitors CI/CD pipeline health 2. Pattern Analysis Engine Work Pattern Signals**: Late-night commits, weekend activity Developer Activity**: Individual contribution analysis Workflow Health**: Pipeline success/failure rates Collaboration Metrics**: PR review patterns and merge frequency 3. AI Analysis Layer Professional Guardrails**: Objective, evidence-based assessments Risk Assessment**: Burnout risk classification (Low/Medium/High) Health Scoring**: Team wellness score (0-100) Recommendation Engine**: Actionable suggestions for improvement 📊 Sample Output 📊 Team Health Report 📝 Summary Overall, the team is maintaining a healthy delivery pace, but there are emerging signs of workload imbalance due to increased after-hours activity. 🔢 Health Score Value:** 68 / 100 Confidence:** 87% Limitations:** Based solely on commit and PR activity; meeting load and non-code tasks not captured. 🔍 Observed Patterns ⏰ After-hours activity 29% of commits occurred between 10pm–1am (baseline: 12%). Confidence: 0.90 ⚠️ Systemic Risks Sustained after-hours work may indicate creeping burnout risk. Evidence: 3 consecutive weeks of elevated late-night commits. Confidence: 0.85 ✅ Recommendations 📌 Facilitate a team discussion on workload distribution and sprint commitments. (Priority: Medium) 🔔 Introduce automated nudges discouraging late-night commits. (Priority: Low) 🛠️ Rotate PR review responsibilities or adopt lightweight review guidelines. (Priority: High) 🚀 Quick Start Prerequisites n8n instance (cloud or self-hosted) GitHub repository with API access Groq API key Gmail account (optional, for email notifications) Setup Instructions Import Workflow Import the workflow JSON file into your n8n instance Configure Credentials GitHub API: Create a personal access token with repo access Groq API: Get your API key from Groq Console Gmail OAuth2: Set up OAuth2 credentials for email notifications Update Configuration { "repoowner": "your-github-username", "reponame": "your-repository-name", "period": 7, "emailreport": "your-email@company.com" } Test Workflow Run the workflow manually to verify all connections Check that data is being fetched correctly Verify AI analysis is working Schedule Automation Enable the schedule trigger for weekly reports Set up monitoring for critical alerts 🔧 Configuration Configuration Node Settings repoowner: GitHub username or organization reponame: Repository name period: Analysis period in days (default: 7) emailreport: Email address for critical alerts AI Model Settings Model**: openai/gpt-oss-120b (Groq) Temperature**: 0.3 (for consistent analysis) Max Tokens**: 2000 Safety Settings**: Professional content filtering 📈 Metrics Analyzed Repository-Level Metrics Total commits count Pull requests opened/closed Workflow runs and success rate Failed workflow percentage Work Pattern Signals Late-night commits (10PM-6AM) Weekend commits (Saturday-Sunday) Work intensity patterns Collaboration bottlenecks Developer-Level Activity Individual commit counts Late-night activity per developer Weekend activity per developer Workload distribution fairness 🛡️ Privacy & Ethics Professional Guardrails Never makes personal judgments about individual developers Only analyzes observable patterns in code activity data Always provides evidence-based reasoning for assessments Never suggests disciplinary actions or performance reviews Focuses on systemic issues and team-level recommendations Respects privacy and confidentiality of team members Data Protection No personal information is stored or transmitted Analysis is based solely on public repository data and public data All recommendations are constructive and team-focused Confidence scores indicate analysis reliability There is added redaction prompt. Note that LLM is not deterministic and usually, you will need to refine your own prompt to enhance difference level of criticality of privacy you need censored or displayed. In some cases ,you will need the engineer account names to help identify f2f conversation. 🔄 Workflow Nodes Core Nodes Schedule Trigger: Weekly automation (configurable) Config: Repository and email configuration Github Get Commits: Fetches commit history Github Get Workflows: Retrieves workflow runs Get Prs: Pulls pull request data Analyze Patterns Developer: JavaScript pattern analysis AI Agent: Groq-powered analysis with guardrails Update Github Issue: Creates wellness tracking issues Send a message in Gmail: Email notifications Data Flow Schedule Trigger → Config → Github APIs → Pattern Analysis → AI Agent → Actions 🚨 Alert Levels (Optional and Prompt configurable) Critical Alerts (Health Score < 90) GitHub Issue**: Automatic issue creation with detailed analysis Email Notification**: Immediate alert to team leads Slack Integration**: Critical team notifications Warning Alerts (Health Score 90-95) GitHub Issue**: Tracking issue for monitoring Slack Notification**: Team awareness message Normal Reports (Health Score > 95) Weekly Report**: Comprehensive team health summary Slack Summary**: Positive reinforcement message 🔧 Troubleshooting Common Issues GitHub API Rate Limits Solution: Use authenticated requests, implement rate limiting Check: API token permissions and repository access AI Analysis Failures Solution: Verify Groq API key, check model availability Check: Input data format and prompt structure Email Notifications Not Sending Solution: Verify Gmail OAuth2 setup, check email permissions Check: SMTP settings and authentication Workflow Execution Errors Solution: Check node connections, verify data flow Check: Error logs and execution history 🤝 Contributing Development Setup Fork the repository link above demo part Create a feature branch Make your changes Test thoroughly Submit a pull request Testing Test with different repository types Verify AI analysis accuracy Check alert threshold sensitivity Validate email and GitHub integrations 📄 License This project is licensed under the MIT License 🙏 Acknowledgments Groq**: For providing the AI analysis capabilities GitHub**: For the comprehensive API ecosystem n8n**: For the powerful workflow automation platform Community**: For feedback and contributions 📞 Support Getting Help Issues**: Create a GitHub issue for bugs or feature requests Discussions**: Use GitHub Discussions for questions Documentation**: Check the comprehensive setup guides Contact Email**:aiix.space.noreply@gmail.com LinkedIn**: SeanLon ⚠️ Important: This tool is designed for team wellness monitoring and should be used responsibly. Always respect team privacy and use the insights constructively to improve team health and productivity.