Workflow Templates

Automated Client Onboarding Workflow This n8n workflow automates the end-to-end client onboarding process: capturing client details, validating emails, assigning tiers, generating welcome packs, creating tasks, notifying teams, archiving records, and sending weekly reports. Who’s It For B2B SaaS companies** onboarding new customers Agencies** handling structured client setups Sales & customer success teams** needing automation Consulting firms** aiming for error-free onboarding ⚙️ How It Works Capture client details through a Webhook (connected to forms). Validate client’s email using Verifi Email. Log onboarding data into Google Sheets. Assign tier logic (Basic/Pro/Enterprise) via Function node. Create a Trello task card with onboarding steps. Generate a personalized Welcome Pack PDF with client details. Send Slack notification to internal team with client details. Download and attach PDF, then send personalized welcome email to the client. Archive structured onboarding data in Airtable. Weekly scheduled report: Collects Airtable onboarding data Processes weekly stats (plans, tiers, counts) Sends onboarding summary via email to the manager 🛠️ How to Set Up Webhook Setup Install & configure credentials: Verifi Email key Google Sheets OAuth2 Airtable OAuth2 Gmail OAuth2 Slack OAuth2 Trello API Optional: Customize the Welcome PDF template (HTML/CSS). Edit tier assignment logic inside the Assign Tier Logic node. Modify Slack & email templates to match your branding. Adjust schedule for weekly reports (default: Monday 9 AM IST). Test with sample payload: { "name": "Jane Doe", "email": "jane@acme.com", "company": "Acme Corp", "plan": "Pro" } 📋 Requirements Self-hosted or Cloud n8n Credentials: Verifi Email, Google Sheets, Airtable, Gmail, Slack, Trello Optional: API for company enrichment ⚠️ Note: The HTML/CSS to PDF node (used for report generation) has a limit of 10 free requests. For production usage, you’ll need an API plan. ⭐ Core Features Email Validation: Blocks fake/spam signups - **Tier Assignment: Auto-classifies clients into Basic/Pro/Enterprise Task Management**: Trello cards for onboarding checklist Welcome PDF Pack**: Branded, client-personalized PDF attachment Slack Notifications**: Real-time internal updates Airtable Archiving**: Permanent record-keeping Weekly Reports**: Automated onboarding summaries for managers 📈 Use Cases & Applications B2B SaaS**: Scale client onboarding without hiring more staff Agencies**: Deliver smooth onboarding experiences Sales Teams**: Reduce delays in CRM entry Customer Success**: Focus on relationship-building instead of admin ✅ Key Benefits Saves 5–6 hours of manual onboarding per client Ensures error-free onboarding with email validation Provides a professional, branded experience Improves collaboration with Slack + Trello integration Scales seamlessly as client volume grows 🔧 Customization Options Modify tier logic (e.g., budget, plan, company size) Customize Slack channel or Trello list for task routing Update PDF branding (logo, theme, styling) Add extra onboarding steps (e.g., Calendly call scheduling) Extend weekly reports (e.g., include ROI or CSM notes) ⚠️ Important Disclaimers For educational & automation purposes Ensure compliance with GDPR/CCPA before storing client data Always test workflow with dummy data before production Workflow Components Webhook Trigger** → Captures client form submissions Verifi Email** → Validates client email Google Sheets** → Logs onboarding entries Code Node** → Assigns tier & priority Trello** → Creates task card for CSM HTML/CSS to PDF** → Generates Welcome Pack PDF Slack** → Notifies team about new client Gmail** → Sends welcome email with PDF Airtable** → Archives full onboarding record Schedule Trigger* + *Report** → Weekly summary to management

🚀 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! 🚀

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.

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!

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.

📄 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

🎓📺 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>

Customer Feedback Loop Analyzer (n8n Automated Workflow) This workflow automates the process of collecting customer feedback from forms and emails, analyzes it using AI, classifies it by category and sentiment, logs it into Google Sheets, and routes it to the right communication channels like Slack or email. It closes the feedback loop efficiently by ensuring every review is categorized, tracked, and acted upon. Who’s it for Product managers wanting structured customer insights Customer support teams needing fast issue routing Engineering teams who want to be alerted to bugs quickly Growth & UX teams tracking feature requests and usability feedback Any business managing customer feedback at scale How it works Form submission trigger captures reviews submitted via customer review forms. Gmail trigger listens for new feedback emails. Extract details (Code node) parses sender details and extracts the actual review text. AI node (LLM) summarizes the feedback, determines sentiment, and classifies it (Bug, Feature Request, UX Issue, Other). Google Gemini (optional) provides advanced classification/summarization. Google Sheets node logs all structured feedback for historical tracking. Switch node routes feedback into separate flows by category. Slack node instantly notifies the team of critical feedback (e.g., Bugs). Email node sends reports to relevant stakeholders (e.g., Feature Requests to product managers). How to set up Import the workflow JSON into your n8n instance. Connect credentials for: Gmail (for receiving/sending feedback) Google Sheets (for logging reviews) Slack (for real-time team alerts) Configure your Google Sheet (columns for Date, Reviewer, Sentiment, Category, Feedback). Adjust the AI node prompt to reflect your team’s preferred categories. Set Slack channels and email recipients for notifications. Activate workflow. Requirements n8n (cloud or self-hosted) Gmail API access (OAuth2 connected in n8n) Google Sheets API access Slack webhook or OAuth connection (Optional) Google Gemini or another LLM integration How to customize Modify the AI prompt to classify into different categories (e.g., “Support Issue”, “Billing Problem”). Extend the Google Sheet schema to include product version, tags, or priority scores. Add a translation step if feedback is multilingual. Replace Slack notifications with Teams/Discord if needed. Connect to Jira or Trello to auto-create tasks for certain categories. Add-ons Sentiment-based alerts**: Trigger Slack notifications only if sentiment is negative. Monthly report generator**: Compile all feedback into a PDF and email it automatically. CRM integration**: Sync categorized feedback into HubSpot or Salesforce. Auto-response emails**: Acknowledge receipt of customer feedback via Gmail. Use Case Examples SaaS product team routes all Bug feedback directly to engineering Slack channel. UX team receives only “UX Issue” categorized feedback for design improvements. Marketing team logs Feature Requests into Google Sheets for roadmap prioritization. Customer support automatically responds with a thank-you email for all submissions. Common Troubleshooting | Issue | Possible Cause | Solution | | ------------------------ | ----------------------------------------- | ----------------------------------------------------- | | Workflow doesn’t trigger | Gmail/Form node not authenticated | Reconnect Gmail / check webhook form integration | | No data extracted | Code node parsing wrong field | Update regex/parsing logic to match email format | | AI classification fails | Invalid LLM credentials or quota exceeded | Reconnect LLM node / check usage limits | | Feedback not logged | Wrong Google Sheet ID or missing sharing | Verify Sheet ID and grant access to connected account | | Slack messages not sent | Invalid webhook or channel not found | Reconfigure Slack node with valid channel/webhook | | Email reports fail | Gmail OAuth token expired | Refresh Gmail credentials in n8n | Need Help? Our n8n automation experts at WeblineIndia can help you: Fine-tune the AI prompts for better categorization accuracy Build custom dashboards from your Google Sheet data Add multilingual feedback handling Connect to your ticketing system (Jira, Trello, Asana) for seamless issue tracking

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 Feedback Automation with PDF Reports & Team Notifications Transform customer feedback into actionable insights automatically with AI analysis, professional PDF reports, personalized emails, and real-time team notifications. Table of Contents Overview Features Demo Prerequisites Quick Start Configuration Usage Troubleshooting License Overview AI-Powered Feedback Automation is a complete, production-ready n8n workflow that automatically processes customer feedback submissions with artificial intelligence, generates beautiful branded PDF reports, sends personalized email responses, logs data for analytics, and notifies your team in real-time. What Problem Does This Solve? Manual feedback processing is time-consuming and inconsistent. This workflow eliminates all manual work by: Automatically analyzing** sentiment and extracting key insights using OpenAI Generating professional** PDF reports with custom branding Sending personalized** thank-you emails to customers Logging everything** to Google Sheets for analytics and reporting Notifying your team** instantly via Slack with actionable summaries Perfect For Product Teams** - Collect and analyze user feedback systematically Educational Institutions** - Process student/parent feedback efficiently Customer Support** - Track customer satisfaction and sentiment trends E-commerce** - Manage product reviews and customer suggestions Healthcare** - Collect patient feedback and satisfaction scores Event Management** - Gather attendee feedback post-event Consulting Firms** - Streamline client feedback collection Features AI-Powered Analysis Sentiment Classification** - Automatically categorizes feedback as Positive, Neutral, or Negative Key Highlights Extraction** - Identifies the most important points from customer comments Actionable Recommendations** - AI generates specific suggestions based on feedback Executive Summaries** - Creates concise 2-3 sentence overviews of each submission Professional Report Generation Beautiful PDF Reports** - Branded, professional documents with custom styling Visual Elements** - Star ratings, color-coded sentiment badges, organized sections Responsive Design** - Mobile-friendly and print-optimized layouts 30-Day Hosting** - PDF reports automatically hosted with expiration dates Automated Email Communications Personalized Messages** - Thank-you emails customized with customer name and feedback PDF Attachments** - Direct download links to full feedback reports Sentiment Indicators** - Color-coded visual feedback summaries Professional Templates** - Modern, responsive email designs Data Logging & Analytics Google Sheets Integration** - Automatic logging of all feedback submissions Complete Audit Trail** - Tracks submission IDs, timestamps, and processing status Analytics Ready** - Structured data perfect for dashboards and trend analysis Historical Records** - Permanent storage of all feedback data Team Notifications Slack Integration** - Real-time alerts to team channels Rich Formatting** - Structured messages with highlights and action items Direct Links** - Quick access to full PDF reports from Slack Thread Discussions** - Enable team conversations around feedback Robust Error Handling Email Validation** - Automatically checks and handles invalid email addresses Fallback Mechanisms** - Continues workflow even if email sending fails Data Cleaning** - Sanitizes and normalizes all input data Graceful Degradation** - AI parsing failures handled with intelligent fallbacks Demo Workflow Overview User Submits Feedback ↓ Data Cleaning & Validation ↓ AI Sentiment Analysis (OpenAI) ↓ HTML Report Generation ↓ PDF Conversion ↓ Email Validation ─┬─ Valid → Send Email └─ Invalid → Skip ↓ Log to Google Sheets ↓ Notify Team (Slack) ↓ Webhook Response Sample Input { "name": "Sarah Johnson", "email": "sarah@example.com", "rating": 4, "comments": "Great product! Delivery was a bit slow but customer service was helpful.", "suggestions": "Improve shipping speed and tracking updates." } Sample Output ✅ AI Analysis: "Positive" sentiment with 3 key highlights ✅ PDF Report: Professional 2-page document with branding ✅ Email Sent: Personalized thank-you message delivered ✅ Data Logged: New row added to Google Sheet ✅ Team Notified: Slack message with summary posted ✅ Webhook Response: 200 OK with submission details Prerequisites Required Services & Accounts n8n Instance (v0.220.0 or higher) Self-hosted or n8n Cloud Installation Guide OpenAI Account API key with GPT-3.5-turbo or GPT-4 access Sign Up Google Account (Gmail + Google Sheets) OAuth2 setup for Gmail API OAuth2 setup for Google Sheets API Setup Guide Slack Workspace Admin access to create apps or OAuth Bot token with chat:write and channels:read scopes Create Slack App HTML to PDF API Service GET at: PDFMunk API key required VerifiEmail API GET at: VerfiEmail API key required Quick Start 1. Import Template Option A: Import via URL Copy the workflow JSON URL and paste in n8n: Settings → Import from URL → [Paste URL] Option B: Import via File Download workflow.json In n8n: Workflows → Import from File Select the downloaded JSON file Click "Import" 2. Configure Credentials (5 minutes) Navigate to: Settings → Credentials and add: ✅ OpenAI API - Add API key from OpenAI dashboard ✅ Gmail OAuth2 - Connect and authorize your Gmail account ✅ Google Sheets OAuth2 - Use same Google account ✅ Slack OAuth2 - Install app to workspace and authorize ✅ HTML to PDF API - Add API key from your PDF service ✅ VerifiEmail API - Add API key from VerifiEmail dashboard 3. Create Google Sheet (2 minutes) Create a new Google Sheet named "Feedback Log" with these column headers: Submission ID | Timestamp | Name | Email | Rating | Sentiment | Comments | Suggestions | AI Summary | PDF URL | PDF Available Until | Email Sent 4. Configure Workflow (3 minutes) Open the imported workflow Click "Log Feedback Data" node Select your "Feedback Log" spreadsheet Click "Notify Team" node Select your Slack channel (e.g., #feedback) 5. Test & Activate (5 minutes) Execute the "Webhook" node to get test URL Send test POST request (see test data below) Verify all nodes execute successfully Check email, Google Sheet, and Slack Click "Active" toggle to enable workflow Total Setup Time: ~15-20 minutes Configuration Webhook Configuration The workflow receives feedback via POST webhook: URL Format: https://your-n8n-domain.com/webhook/feedback-submission Expected Payload: { "name": "string (required)", "email": "string (optional, validated)", "rating": "integer 1-5 (required)", "comments": "string (optional)", "suggestions": "string (optional)" } Usage Testing the Workflow Using Postman/Insomnia: Create new POST request URL: https://your-n8n-domain.com/webhook/feedback-submission Headers: Content-Type: application/json Body (raw JSON): { "name": "Test User", "email": "your-email@example.com", "rating": 5, "comments": "This is a test feedback submission. Everything works great!", "suggestions": "Maybe add more features in the future." } Send request Expected response (200 OK): { "success": true, "message": "Thank you for your feedback! We've sent you a detailed report via email.", "data": { "submissionId": "FB-1234567890123-abc123xyz", "name": "Test User", "email": "your-email@example.com", "rating": "5", "sentiment": "Positive", "emailSent": "true", "reportUrl": "https://generated-pdf-url.com/report.pdf", "reportAvailableUntil": "2025-11-10" } } Using cURL: curl -X POST https://your-n8n-domain.com/webhook/feedback-submission \ -H "Content-Type: application/json" \ -d '{ "name": "Sarah Johnson", "email": "sarah@example.com", "rating": 4, "comments": "Great product! Delivery was a bit slow but customer service was helpful.", "suggestions": "Improve shipping speed and tracking updates." }' Monitoring & Maintenance Daily: Check Slack for new feedback notifications Review Google Sheet for any anomalies Weekly: Verify workflow execution success rate Check OpenAI API usage and costs Review sentiment trends in Google Sheet Monthly: Analyze feedback patterns and trends Update AI prompts if needed Check PDF service usage limits Review and optimize workflow performance Best Practices Rate Limiting Monitor for spam submissions Add rate limiting to webhook if needed Use n8n's built-in throttling Data Privacy Ensure GDPR/privacy compliance Add data retention policies Implement data deletion workflow Error Handling Set up error notifications Create error logging workflow Monitor execution failures Performance Keep Google Sheet under 50,000 rows Archive old data quarterly Use database for high volume (1000+/month) Troubleshooting Common Issues Issue 1: Webhook Not Receiving Data Symptoms: Webhook node shows no executions Forms submit but nothing happens Solutions: ✅ Verify workflow is Active (toggle at top right) ✅ Check webhook URL is correct in form ✅ Test webhook with Postman/cURL first ✅ Check n8n logs for errors: Settings → Log Streaming ✅ Verify firewall/network allows incoming webhooks Issue 2: OpenAI Node Fails Symptoms: Error: "API key invalid" Error: "Insufficient credits" Node times out Solutions: ✅ Verify API key is correct and active ✅ Check OpenAI account has sufficient credits ✅ Check API usage limits: platform.openai.com/usage ✅ Increase node timeout in workflow settings ✅ Try with shorter feedback text Issue 3: PDF Not Generating Symptoms: "PDF generation failed" error Empty PDF URL 404 when accessing PDF Solutions: ✅ Verify PDF API key is valid ✅ Check API service status ✅ Verify HTML content is valid (test in browser) ✅ Check API usage limits/quota ✅ Try alternative PDF service Issue 4: Email Not Sending Symptoms: Gmail node shows error Email doesn't arrive "Permission denied" error Solutions: ✅ Re-authenticate Gmail OAuth2 credential ✅ Check email address is valid ✅ Check spam/junk folder ✅ Verify Gmail API is enabled in Google Console ✅ Check daily sending limits not exceeded ✅ Test with different email address Issue 5: Google Sheets Not Updating Symptoms: No new rows added "Spreadsheet not found" error Permission errors Solutions: ✅ Verify spreadsheet ID is correct ✅ Check sheet name matches exactly (case-sensitive) ✅ Verify column headers match exactly ✅ Re-authenticate Google Sheets credential ✅ Check spreadsheet isn't protected/locked ✅ Verify spreadsheet isn't full (limit: 10M cells) Issue 6: Slack Not Posting Symptoms: Slack node fails Message doesn't appear in channel "Channel not found" error Solutions: ✅ Verify bot is invited to channel: /invite @BotName ✅ Check bot has chat:write permission ✅ Re-authenticate Slack credential ✅ Verify channel ID is correct ✅ Check Slack workspace isn't on free plan limits ✅ Test with different channel Debugging Tips Enable Debug Mode Settings → Executions → Save execution progress Watch each node execute step-by-step Check Execution Logs Click on failed node View "Input" and "Output" tabs Check error messages Test Nodes Individually Click "Execute Node" on each node Verify output before proceeding Use Browser Console Open Developer Tools (F12) Check for JavaScript errors Monitor network requests Enable Verbose Logging For self-hosted n8n N8N_LOG_LEVEL=debug npm start 📄 License This template is licensed under the MIT License - see the LICENSE file for details.

n8n Forum Job Aggregator - AI-Powered Email Digest Overview Automate your n8n community job board monitoring with this intelligent workflow that scrapes, analyzes, and delivers opportunities straight to your inbox. Perfect for freelancers, agencies, and developers looking to stay on top of n8n automation projects without manual checking. How It Works Scrapes the n8n community job board to find new postings from the last 7 days Extracts key metadata including job titles, descriptions, posting dates, and client details Analyzes each listing using OpenRouter AI to generate concise summaries of project requirements and client needs Delivers a professionally formatted email digest with all opportunities organized and ready for review Prerequisites OpenRouter API Key**: Sign up at OpenRouter.ai to access AI summarization capabilities SMTP Email Account**: Gmail, Outlook, or any SMTP-compatible email service Setup Steps Time estimate: 5-10 minutes Configure OpenRouter Credentials Add your OpenRouter API key in n8n credentials manager Recommended model: GPT-3.5-turbo or Claude for cost-effective summaries Set Up SMTP Email Configure sender email address Add recipient email(s) for digest delivery Test connection to ensure delivery Customize Date Range (Optional) Default: Last 7 days of job postings Adjust the date filter node to match your preferred frequency Test & Refine Run a test execution Review email formatting and AI summary quality Customize HTML template styling to match your preferences Customization Options Scheduling**: Set up cron triggers (daily, weekly, or custom intervals) Filtering**: Add keyword filters for specific technologies or project types AI Prompts**: Modify the summarization prompt to extract different insights Email Design**: Customize HTML/CSS styling in the email template node Example Use Cases Freelance Developers**: Never miss relevant n8n automation opportunities Agencies**: Monitor market demand and competitor activity Job Seekers**: Track n8n-related positions and consulting gigs Market Research**: Analyze trends in automation project requests Example Output Each email digest includes: Job title and posting date AI-generated summary (e.g., "Client needs workflow automation for Shopify order processing with Slack notifications") Direct link to original posting Organized by recency