by Sean Lon
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.
by JKingma
📄 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
by OwenLee
🎓📺 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>
by Yurie Ino
Employee Onboarding Automation with Multi-System Provisioning What this workflow does This workflow automates the end-to-end employee onboarding process by provisioning new hires across multiple internal systems and delivering a personalized welcome experience. Upon receiving new employee data via a webhook or form submission, it creates user accounts in Google Workspace, invites the employee to Slack, sets up a Notion onboarding page, generates an AI-powered welcome package, and notifies relevant stakeholders. All onboarding activities are logged for tracking and audit purposes. This template helps HR and People Operations teams reduce manual work, ensure consistency, and deliver a smooth onboarding experience from day one. How it works Employee data intake Triggered by a webhook or form submission. Collects employee details such as name, email, department, role, start date, and manager. Data preparation Generates a company email address. Assigns a unique onboarding ID. Standardizes employee information for downstream systems. Parallel account provisioning Creates a Google Workspace user account. Sends an invitation to the Slack workspace. Creates a dedicated Notion onboarding page. Executes these steps in parallel to minimize onboarding time. Provisioning result compilation Consolidates account creation statuses. Produces a single onboarding summary object. AI-powered welcome package Generates: A personalized welcome message A suggested first-week schedule Practical tips for success in the role Formats content for email delivery. Notifications & communication Sends a welcome email to the employee (if a personal email is provided). Notifies HR or People Ops via Slack. Logs onboarding details to Google Sheets. Webhook response Returns a structured JSON response confirming onboarding initiation. Setup requirements Before activating this workflow, ensure the following are configured: Enable the webhook endpoint and connect it to your form or HR system. Configure Google Workspace Admin API access. Set up Slack workspace permissions for user invitations. Define a parent Notion page for onboarding content. Prepare Google Sheets for onboarding logs. Customize email templates, departments, and org unit paths as needed. Required credentials This workflow requires the following credentials to be configured in n8n: Google API** (Google Workspace user provisioning) Slack** (workspace invitations and HR notifications) Notion** (onboarding page creation) OpenAI** (AI-generated welcome content) Gmail** (sending welcome emails) Google Sheets** (onboarding tracking and logs) Customization ideas Add role-based access provisioning (VPN, GitHub, Jira, etc.). Delay account creation until a specific start date. Generate localized onboarding content by region or language. Integrate with HRIS tools such as BambooHR or Workday. Add approval steps for managers or IT before provisioning. Who this is for HR & People Operations teams IT & Identity management teams Startups and scaling organizations Companies seeking consistent, automated onboarding This template provides a scalable, repeatable onboarding foundation that connects HR systems, IT provisioning, and AI-driven communication into a single automated workflow.
by Cheng Siong Chin
How It Works This workflow automates inventory management and customer engagement for e-commerce businesses and retail operations managing multiple product categories. It solves the critical challenge of maintaining optimal stock levels while personalizing customer communications across order fulfillment, product recommendations, and support interactions. The system processes webhook-triggered data across four parallel streams (orders, reviews, inventory, social media), applies AI-powered analysis for sentiment extraction, pricing optimization, promotion targeting, and demand forecasting, then distributes personalized communications through email campaigns and Slack/Microsoft Teams notifications. This eliminates manual inventory tracking, reduces stockouts, and delivers data-driven customer engagement. Setup Steps Configure webhook URLs for orders, reviews, inventory systems, and social media platforms Add AI model API credentials (OpenAI/Anthropic) for sentiment, pricing Connect CRM database for customer profile management and segmentation Set up email service (Gmail/SendGrid) with campaign templates for personalized communications Integrate Slack workspace or Microsoft Teams channels for internal inventory alerts Prerequisites Active e-commerce platform with webhook support, AI service API keys Use Cases Multi-channel retailers optimizing stock across locations, subscription box services Customization Adjust AI prompts for industry-specific sentiment rules, modify inventory thresholds for restocking alerts Benefits Reduces inventory management overhead by 70%, prevents stockouts through predictive forecasting
by Elay Guez
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
by Jitesh Dugar
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.
by Julian Kaiser
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
by Growth AI
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
by Jitesh Dugar
Transform chaotic employee departures into secure, insightful offboarding experiences - achieving zero security breaches, 100% equipment recovery, and actionable retention insights from every exit interview. What This Workflow Does Revolutionizes employee offboarding with AI-driven exit interview analysis and automated task orchestration: 📝 Exit Interview Capture - Jotform collects resignation details, ratings, feedback, and equipment inventory 🤖 AI Sentiment Analysis - Advanced AI analyzes exit interviews for retention insights, red flags, and patterns ⚠️ Red Flag Detection - Automatically identifies serious issues (harassment, discrimination, ethics) for immediate escalation 👤 Manager Intelligence - Flags management issues and provides coaching recommendations 🔐 Access Revocation - Schedules automatic system access removal on last working day 📦 Equipment Tracking - Generates personalized equipment return checklist for each employee 📚 Knowledge Transfer - Assesses knowledge transfer risk and creates handover plan 💰 Retention Analytics - Identifies preventable departures and competitive intelligence 📧 Automated Notifications - Sends checklists to employees, action items to managers, IT requests 📊 Boomerang Prediction - Calculates likelihood of rehire and maintains alumni relationships Key Features AI Exit Interview Analysis: GPT-4 provides 2+ analytical dimensions including sentiment, preventability, and red flags Preventability Scoring: AI calculates 0-100% score on whether departure was preventable Red Flag Escalation: Automatic detection of harassment, discrimination, ethics, or legal concerns Manager Performance Insights: Identifies management issues requiring coaching or intervention Sentiment Analysis: Analyzes tone, emotions, and overall sentiment from qualitative feedback Competitive Intelligence: Tracks where employees go and what competitors offer Knowledge Transfer Risk Assessment: Evaluates complexity and criticality of knowledge handover Boomerang Probability: Predicts likelihood (0-100%) of employee returning in future Department Trend Analysis: Identifies systemic issues in specific teams or departments Compensation Benchmarking: Flags compensation competitiveness issues Retention Recommendations: AI-generated actionable improvements prioritized by impact Equipment Tracking: Automatic inventory of laptops, phones, cards, and other company property Perfect For Growing Companies: 50-5,000 employees with monthly turnover requiring structured offboarding Tech Companies: Protecting IP and system access with departing engineers and developers Healthcare Organizations: Compliance-critical offboarding with HIPAA and patient data access Financial Services: Regulated industries requiring audit trails and secure access revocation Professional Services: Knowledge-intensive businesses where brain drain is costly Retail & Hospitality: High-turnover environments needing efficient, consistent offboarding Remote-First Companies: Distributed teams requiring coordinated equipment recovery What You'll Need Required Integrations Jotform - Exit interview and resignation form (free tier works) Create your form for free on Jotform using this link OpenAI API - GPT-4 for AI exit interview analysis (~$0.20-0.50 per exit interview) Gmail - Automated notifications to employees, managers, IT, and HR Google Sheets - Exit interview database and retention analytics Quick Start Import Template - Copy JSON and import into n8n Add OpenAI Credentials - Set up OpenAI API key (GPT-4 for best insights) Create Jotform Exit Interview - Build comprehensive form with these sections: Configure Gmail - Add Gmail OAuth2 credentials Setup Google Sheets: Create spreadsheet with "Exit_Interviews" sheet Replace YOUR_GOOGLE_SHEET_ID in workflow Columns will auto-populate on first submission Customization Options AI Prompt Refinement: Tailor analysis for your industry, company culture, and specific concerns Red Flag Categories: Customize what constitutes a red flag for your organization Equipment Types: Add specialized equipment (tools, uniforms, parking passes) Access Systems: Integrate with your specific IT systems for automated revocation Knowledge Transfer Templates: Create role-specific handover checklists Manager Notifications: Add more details based on department or seniority Exit Interview Questions: Add industry-specific or company-specific questions Retention Focus Areas: Adjust AI to focus on specific retention priorities Rehire Workflows: Add automatic alumni network invitations for boomerang candidates Severance Processing: Add nodes for severance agreement generation and tracking Reference Check Process: Include reference policy notifications Benefits COBRA: Automate COBRA benefits notification workflows Expected Results Zero security breaches from lingering access - automated revocation on last day 100% equipment recovery - automated tracking and follow-up 3x faster offboarding - 30 minutes vs 2 hours of manual coordination 85% actionable insights from exit interviews vs 20% with manual reviews 60% improvement in identifying preventable turnover 90% manager compliance with knowledge transfer (vs 40% manual) 50% reduction in repeat management issues through coaching identification 40% increase in boomerang rehires through positive offboarding experience Complete audit trail for legal compliance and investigations Department-level insights identifying systemic retention issues Use Cases Tech Startup (100 Employees, High Growth) Engineer resigns to join competitor. AI detects compensation issue (40% below market), flags manager micromanagement concerns, and identifies preventable departure (preventability: 85%). HR immediately initiates compensation review for engineering team, schedules manager coaching, and retains 3 other engineers considering leaving. Access to codebase revoked automatically on last day. Boomerang probability: 70% - maintains relationship for future recruiting. Healthcare System (500 Nurses) Nurse leaves citing burnout. AI identifies systemic staffing issues in ER department affecting 15% of departures. Flags potential HIPAA violation concern requiring investigation. Automatically revokes EHR access on final day. Equipment recovery (badge, pager, scrubs) tracked with 100% success. Exit insights lead to ER staffing model changes, reducing nurse turnover by 30%. Financial Services Firm Compliance officer departs. AI red flags potential ethics concern requiring immediate investigation. Legal team notified within minutes. Knowledge transfer flagged as "critical risk" due to regulatory expertise. Detailed 30-day handover plan auto-generated. All system access revoked immediately. Complete audit trail maintained for regulatory review. Investigation reveals process gap, not ethical issue, preventing regulatory exposure. Retail Chain (2,000 Employees) Store manager exits. AI aggregates insights across 50 recent retail departures, identifying district manager as common thread (manager rating consistently 2/5). Regional HR intervenes with district manager coaching. Equipment return (keys, registers codes, uniforms) automated via checklist. 95% equipment recovery vs previous 60%. Sentiment trends show seasonal staff prefer flexible scheduling - policy updated chain-wide. Remote Software Company Developer in different timezone resigns. Automated offboarding coordinates across 3 time zones: access revoked at EOD local time, equipment return label emailed internationally, knowledge transfer scheduled with overlap hours. AI detects "career growth" as preventable issue - company implements career ladder framework, reducing senior developer attrition by 45%. Pro Tips Timing Matters: Send Jotform link 1 week before last day for honest feedback (not on exit day) Anonymity Option: Consider anonymous feedback for more candid responses (separate form) Benchmark Scoring: After 50+ exits, calculate your company's average preventability score Manager Patterns: Track exits by manager to identify coaching needs early Department Trends: Monthly reviews of AI insights by department for systemic issues Compensation Data: Cross-reference "compensation issue" flags with market data Boomerang Program: Create formal alumni network for high-probability boomerang candidates Equipment Deposits: Consider requiring deposits for easier equipment recovery Exit Interview Training: Train managers on how to act on AI insights constructively Legal Review: Have legal team review red flag escalation categories quarterly Continuous Improvement: Use AI recommendations to create quarterly retention action plans Stay Interviews: Use exit interview insights to inform "stay interview" questions for current employees Learning Resources This workflow demonstrates advanced n8n automation patterns: AI Agents with complex structured output for multi-dimensional analysis, Sentiment analysis and natural language processing Conditional escalation based on severity and red flags Multi-stakeholder notifications with role-specific messaging Risk assessment algorithms for knowledge transfer and preventability Pattern recognition across qualitative feedback Equipment inventory management with dynamic list generation Compliance automation for access revocation scheduling Predictive analytics for boomerang probability Perfect for learning AI-powered HR automation and organizational analytics! 📊 Workflow Architecture 📝 Jotform Exit Interview Submission ↓ 🧾 Parse Offboarding Data ↓ 🤖 AI Exit Interview Analysis (GPT-4) │ ├─ Retention analysis (preventability scoring) │ ├─ Sentiment analysis (tone, emotions) │ ├─ Manager performance evaluation │ ├─ Department insights │ ├─ Compensation benchmarking │ ├─ Knowledge transfer risk assessment │ ├─ Competitor intelligence │ ├─ Red flag detection │ ├─ Boomerang probability │ └─ Action item generation ↓ 🔗 Extract AI Analysis (JSON) ↓ 🧩 Merge Exit Analysis with Data │ ├─ Calculate days until last day │ ├─ Build equipment checklist │ └─ Assess urgency levels ↓ ⚠️ Has Red Flags? ├─ TRUE → 🚨 Send Red Flag Alert (HR Director/Legal) │ ↓ └─ FALSE → 📧 Send Manager Action Items ↓ ✉️ Send Employee Checklist ↓ 🔐 Send IT Offboarding Request ↓ 📊 Log to Google Sheets Ready to transform employee offboarding? Import this template and turn departures into retention insights while maintaining security and professionalism. Every exit becomes a learning opportunity! 🚪✨ Questions or customization needs? The workflow includes detailed sticky notes explaining each AI analysis component and routing decision.
by WeblineIndia
Zendesk New Ticket → WooCommerce Order Matching, Tagging & Email Automation Automatically enrich Zendesk tickets with WooCommerce order details and reduce manual lookups. This workflow listens for new Zendesk tickets, fetches the ticket requester’s details, retrieves recent WooCommerce orders, matches them by customer email and updates the ticket with order information and relevant tags. If a matching order is marked as completed, it also sends a confirmation email to the customer. Quick Implementation Steps Connect Zendesk, WooCommerce and Gmail credentials in n8n. Import the workflow JSON and review node credentials. Adjust the WooCommerce order fetch limit if needed. Activate the workflow. That’s it — new tickets will now automatically include order context. What It Does This workflow bridges the gap between customer support and order management by linking Zendesk tickets with WooCommerce orders. When a new ticket is created, the workflow retrieves the requester’s profile to identify their email address, which is then used to find related orders in WooCommerce. Because direct email-based filtering is not available in the WooCommerce node, the workflow fetches the latest five orders and performs email matching internally within n8n. This ensures accurate matching while working around platform limitations. Once a matching order is found, the workflow extracts essential details such as order number, status, currency and purchased items. It updates the Zendesk ticket with a private internal note and applies clear order-status-based tags. If the order is marked as completed, the workflow also sends a confirmation email to the customer. Who’s It For Customer support teams using Zendesk and WooCommerce E-commerce businesses handling frequent order-related inquiries Support managers aiming to reduce manual order lookups Teams that want faster, more consistent ticket responses Requirements to Use This Workflow An active Zendesk account with API access A WooCommerce store with REST API credentials A Gmail account (OAuth2) for sending customer emails An active n8n instance Permission to update tickets and users in Zendesk How It Works & How To Set Up Workflow Logic Overview Trigger on New Ticket The workflow starts when a new Zendesk ticket is created with status new. Fetch Ticket Requester Details The requester’s user profile is retrieved to obtain their email address. Fetch Recent WooCommerce Orders The workflow retrieves the latest five orders from WooCommerce. Match Customer Email Each order’s billing email is compared with the Zendesk requester’s email. Only matching orders continue through the workflow. Generate Zendesk Tags Order status is evaluated and mapped to meaningful Zendesk tags. Prepare Ticket Update Payload Order details and tags are formatted for the Zendesk update. Update Zendesk Ticket A private internal note is added to the ticket, along with order-related tags. Check for Completed Orders If the order status is completed, the workflow proceeds to send an email. Send Confirmation Email The customer receives a confirmation email with their order details. Setup Instructions Update credentials in all Zendesk, WooCommerce and Gmail nodes. Review the WooCommerce order fetch limit (default: 5). Verify the email comparison logic in the IF node. Activate the workflow once testing is complete. How To Customize Nodes WooCommerce – Fetch Recent Orders** Increase or decrease the limit value to control how many recent orders are checked. Match Customer Email (IF Node)** Modify comparison logic (for example, make it case-insensitive). Generate Zendesk Tags (Code Node)** Add or change tags based on custom order statuses. Zendesk – Update Ticket** Customize the internal note format or add additional fields. Send Order Confirmation Email** Edit the email content or disable this node if emails are not required. Add-ons (Additional Features) SLA-based ticket prioritization Shipment tracking number enrichment Refund and cancellation detection Slack or Microsoft Teams notifications Extended reporting using Zendesk tags Use Case Examples Automatically attaching order details to “Where is my order?” tickets Speeding up refund or replacement requests Reducing agent time spent switching between Zendesk and WooCommerce Applying consistent order-status tags for analytics Sending proactive confirmation emails for completed orders There are many more possible use cases depending on how this workflow is extended or customized. Troubleshooting Guide | Issue | Possible Cause | Solution | |------|---------------|----------| | No order found | Customer used a different email | Ask the customer to confirm the checkout email | | Wrong order matched | Order not in recent fetch range | Increase the WooCommerce order fetch limit | | No email sent | Order status is not completed | Confirm order status or customize the IF condition | | Ticket not updated | Zendesk permission issue | Verify API credentials and scopes | | Tags missing | Code node not triggered | Check order status logic in the Code node | Need Help? If you need help setting up this workflow, customizing nodes or building additional automation, WeblineIndia is here to support you. Our team specializes in n8n workflow automation, Zendesk integrations and WooCommerce process optimization. Whether you want to extend this workflow or build a similar solution tailored to your business, feel free to reach out to WeblineIndia for expert assistance.
by 福壽一貴
Who is this for? This template is designed for B2B sales teams, recruiters, and business development professionals who want to identify sales opportunities by monitoring hiring signals from target companies. It's particularly useful for: Sales teams selling HR tech, recruitment software, or staffing services Consultancies offering technical talent or project-based work Any B2B company that uses "intent data" from job postings to time their outreach What this workflow does This workflow automates the entire process of monitoring job postings and converting hiring signals into actionable sales leads: Daily Job Scraping: Automatically scrapes job postings from Google Jobs, LinkedIn, and Indeed for your target companies using Apify actors Data Normalization: Standardizes job data from multiple sources into a unified format Keyword Filtering: Filters jobs based on your target keywords to identify relevant opportunities AI-Powered Analysis: Uses GPT-4o to analyze each qualified job posting and generate: Inferred pain points from the hiring signal Strategic sales approach angles Urgency scoring (1-10) Ready-to-send cold email drafts Slack Notifications: Sends real-time alerts with AI insights to your sales channel Weekly Reports: Generates comprehensive trend analysis reports every Monday with AI-powered insights Setup Google Sheets: Create a spreadsheet with 4 sheets: Target Companies (columns: Company Name, Target Keywords, My Solution) Raw Jobs (for all scraped jobs) Qualified Leads (for filtered opportunities) Weekly Reports (for trend analysis) Apify: Set up accounts and get Actor IDs for: Google Jobs Scraper LinkedIn Jobs Scraper Indeed Scraper Credentials: Connect your Google Sheets, Slack, Gmail, OpenAI, and Apify credentials Configuration: Update the placeholder values in the workflow for your specific IDs and channel names Requirements n8n instance (self-hosted or cloud) Apify account with credits OpenAI API key (GPT-4o access) Google Sheets access Slack workspace (optional, for notifications) Gmail account (optional, for email reports) Customization Adjust maxJobsPerSource and daysToCheck in the Configuration node Modify AI prompts to match your sales style and language preferences Add or remove job sources based on your needs Customize Slack message format and notification triggers