by Sandeep Patharkar | ai-solutions.agency
AI-Powered n8n Error Debugger & Notifier Automatically analyze any workflow failure with AI, get actionable solutions, and receive a detailed report directly in your inbox. Stop wasting time deciphering cryptic error messages and stack traces. This template turns your n8n instance into a self-diagnosing system. When any of your workflows fail, this error handler automatically triggers, sends the error data to an AI agent for a full analysis, and delivers a comprehensive, easy-to-read report to your email. It's like having a personal AI debugging assistant on call 24/7. | Services Used | Features | | :--- | :--- | | 🤖 OpenAI / LangChain | Provides deep, AI-driven root cause analysis of errors. | | 📧 Gmail | Delivers beautifully formatted and detailed HTML email notifications. | | 🚨 n8n Error Trigger | Acts as a global catch-all for any workflow failure in your instance. | | ✨ Data Formatting | Organizes raw error data and AI analysis for clear reporting. | How It Works ⚙️ 🚨 A Workflow Fails: When any workflow in your n8n instance encounters an error, this workflow is automatically triggered. 🧠 AI Analysis: The Error Trigger node passes the complete error context (message, stack trace, failing node, etc.) to a LangChain Agent. The agent is prompted to perform a deep analysis, identifying the root cause, potential solutions, impact, and urgency. ✨ Format Data: A Set node neatly organizes the original error details alongside the new, structured AI analysis into a single, clean data object. 📧 Send Detailed Report: The Gmail node uses this formatted data to construct a rich HTML email, presenting the error details and the AI's full analysis in a clear, actionable format, and sends it to your specified address. 🛠️ How to Set Up This workflow is designed to be set as your instance's default error handler. 🔑 Add Credentials: Add your OpenAI API key to the OpenAI Chat Model node. Add your Gmail OAuth2 credentials to the Send Gmail Notification node. ✏️ Configure Email: In the Send Gmail Notification node, change the To field from your-email@example.com to your own email address or a team distribution list. ⚙️ Set as Global Error Workflow: In your n8n instance, go to Settings > Workflow Default Settings. In the Error Workflow dropdown, select this workflow (AI-Powered n8n Error Debugger & Notifier). Save the changes. ▶️ Activate: Save and activate the workflow. It will now run automatically whenever another workflow fails. 💡 Customization Ideas Multi-Channel Alerts: Replace or add nodes to send notifications to **Slack, Discord, or Telegram for more immediate team visibility. Create an Error Dashboard: Add a **Google Sheets, Notion, or Baserow node after the Format Data node to log every error, creating a historical dashboard for tracking recurring issues. Severity-Based Routing: Add an **IF node to check the "Urgency Level" from the AI analysis. Route "Critical" errors to a PagerDuty or Twilio node to alert an on-call developer. Try Different Models: Swap the OpenAI Chat Model for an **Anthropic or Google Gemini node to compare analysis quality. 💬 Need Help or Want to Learn More? Join my Skool community for n8n + AI automation tutorials, live Q&A sessions, and exclusive workflows: 👉 https://www.skool.com/n8n-ai-automation-champions Template Author: Sandeep Patharkar Category: Utilities / DevOps Difficulty: Intermediate Estimated Setup Time: ⏱️ 10 minutes
by Rahul Joshi
Description Streamline your Net Promoter Score (NPS) survey process by automating survey delivery, response tracking, and structured data storage. This workflow integrates GoHighLevel, Gmail, and Notion to ensure every customer response is captured, categorized, and actionable. 💬📧📊 What This Template Does Trigger from GoHighLevel when a deal moves to "Completed." ⚡ Send NPS survey emails via Gmail to the customer automatically. ✉️ Capture responses through a Webhook and store them in structured format. 🔗 Process and categorize NPS responses (Promoter, Passive, Detractor). 🧮 Save results in Notion for centralized tracking and analysis. 📒 Send Slack notifications for quick visibility into customer satisfaction. 🔔 Key Benefits ✅ Automated NPS survey delivery and response tracking ✅ Centralized data storage for long-term insights ✅ Real-time team notifications for faster action ✅ Standardized response categorization ✅ Error handling ensures no response is lost Features GoHighLevel integration to trigger surveys at the right stage Gmail email automation with personalized survey links Webhook capture for dynamic NPS responses Notion database integration for structured data storage Slack alerts for quick feedback visibility Requirements n8n instance (cloud or self-hosted) GoHighLevel API credentials Gmail API credentials (OAuth2) Notion API integration token Slack API token (optional for notifications) Target Audience This workflow is ideal for Customer Success teams, SaaS businesses, agencies, and service providers who want to measure customer satisfaction at scale and act quickly on feedback. Step-by-Step Setup Instructions Configure GoHighLevel, Gmail, Notion, and Slack credentials in n8n. Set up a Notion database with fields for customer, score, category, and comments. Replace hardcoded values with environment variables ($env.GHL_API_KEY, $env.NOTION_DB_ID, etc.). Import the JSON into your n8n instance. Run once manually with test data to verify. Enable the workflow for automated execution. ✅
by WeblineIndia
iOS Environment Config Sync Wizard: .env to Xcode This workflow automatically detects changes to .env.staging files, compares them against iOS Xcode configuration files, creates pull requests to sync values, and invalidates Xcode build caches when needed. It ensures consistency between environment files and iOS project configs while automating the propagation of changes across the codebase and notifying the team via email. Quick Implementation Steps Import the workflow JSON into your n8n instance Set up credentials for GitHub and email Configure the webhook URL in your Git repository Customize configuration parameters in the "Set Configuration" node Activate the workflow What It Does The Environment Config Sync for iOS Xcode Projects workflow is designed to maintain consistency between environment configuration files and iOS project configuration files. When changes are made to .env.staging, the workflow automatically detects these changes, determines which iOS configuration files need to be updated, creates a new branch with those updates, and opens a pull request for review. The workflow analyzes the differences between the environment file and iOS configs, identifies which values need to be synchronized, and applies these changes to the appropriate files. It also checks if any of the changed values require cache invalidation and handles this automatically. Finally, it sends a detailed email notification to the iOS team with information about the sync operation. This automation reduces manual work, ensures consistency between configuration files, and helps prevent issues caused by mismatched environment settings across different parts of the iOS build system. Who's It For This workflow is ideal for: iOS development teams managing environment-specific configurations DevOps engineers responsible for maintaining Xcode project configuration consistency Mobile app developers working with multiple environment configurations Teams implementing CI/CD best practices for iOS applications Organizations using environment files to manage build-time configurations for Xcode projects Requirements n8n instance (self-hosted or cloud) GitHub repository with iOS project files Email service (SMTP) for sending notifications .env.staging file or similar environment configuration file iOS configuration files (Info.plist, Config.xcconfig, etc.) How It Works Webhook Trigger: The workflow starts when a push event occurs in the GitHub repository Configuration Setup: Sets up configurable parameters for file paths, branches, and notification settings File Change Detection: Checks if the .env.staging file was modified in the push Config Diff Analysis: Compares the .env.staging file with iOS Xcode configurations to identify differences Branch Creation: Creates a unique branch name and creates a new branch in the repository File Update Preparation: Prepares the updated content for each configuration file File Updates: Updates each configuration file in the new branch with the synced values PR Creation: Creates a pull request with all the configuration changes Cache Invalidation: Invalidates Xcode build cache if necessary based on changed keys Email Notification: Sends a detailed email notification about the completed sync operation How To Set Up Steps to Configure and Use 1\. Import the Workflow Import the provided JSON file into your n8n instance 2\. Set Up Credentials GitHub**: Create a new credential with a GitHub personal access token with repo scope Email**: Create a new credential with your SMTP server details for sending emails 3\. Configure GitHub Webhook Go to your GitHub repository settings Navigate to Webhooks and click "Add webhook" Set the Payload URL to the webhook URL from your n8n workflow Select "application/json" as the content type Choose "Let me select individual events" and select "Push events" Click "Add webhook" 4\. Configure Parameters Modify the parameters in the "Set Configuration" node to match your project structure: envFilePath**: Path to your environment file (default: ".env.staging") configFiles**: Array of iOS config files to update (default: \["Info.plist", "Config.xcconfig"\]) targetBranch**: Branch to create PRs against (default: "main") cacheInvalidationKeys**: Keys that trigger cache invalidation (default: \["API\_KEY", "BUNDLE\_VERSION", "ENVIRONMENT"\]) prLabels**: Labels to apply to created PRs (default: \["config-sync", "automated", "ios"\]) emailTo**: Email address for notifications (default: "ios-team@example.com") 5\. Configure Email Settings In the "Send Email Notification" node, update the "fromEmail" parameter to match your sending email address Ensure your SMTP credentials are properly configured in n8n 6\. Activate the Workflow Once all configurations are complete, activate the workflow Test by making a change to your .env.staging file and pushing it to the repository How To Customize Add More Config Files**: Update the configFiles parameter in the "Set Configuration" node to include additional iOS configuration files like .xcconfig files or project.pbxproj Modify Cache Invalidation Logic**: Update the cacheInvalidationKeys parameter to change which keys trigger cache invalidation Customize PR Content**: Edit the "Create PR" node to modify the PR title, body, or labels Change Email Notifications**: Update the "Send Email Notification" node to modify the email format, subject, or add additional recipients Implement Actual Cache Invalidation**: Modify the "Invalidate Cache" node to implement actual Xcode cache invalidation logic for your CI/CD system Add More Environment Files**: Extend the workflow to monitor additional environment files beyond .env.staging Add‑ons Multi-Environment Support: Extend the workflow to handle multiple environment files (.env.development, .env.production) with different target branches and configurations Configuration Validation: Add validation steps to ensure that environment values match expected formats or patterns before creating PRs Automated PR Merging: Add logic to automatically merge PRs if all checks pass and no conflicts are detected Configuration History Dashboard: Integrate with a database to track configuration changes over time and provide analytics Team Approval Workflow: Add approval steps that require team members to review and approve configuration changes before PRs are created Use Case Examples API Key Rotation: When security policies require rotating API keys, the workflow automatically updates all iOS configuration files with the new keys and invalidates the Xcode build cache to ensure the changes take effect immediately. Environment Promotion: When promoting configurations from staging to production, the workflow ensures that all iOS project files are consistently updated across the codebase, preventing deployment issues caused by mismatched configurations. Bundle Version Updates: When updating bundle versions in .env.staging for a new App Store release, the workflow automatically updates version strings in Info.plist files, ensuring version consistency for App Store submission. Feature Flag Management: When feature flags are added or modified in .env.staging, the workflow propagates these changes to Config.xcconfig files, ensuring that feature flags are consistently available throughout the iOS application. Multi-Target Projects: In projects with multiple iOS targets (e.g., app, extension, watchOS), the workflow can be extended to update configuration files across all targets when environment variables change, ensuring consistency throughout the application ecosystem. Troubleshooting Guide | Issue | Possible Cause | Solution | | --- | --- | --- | | Webhook not triggering | Webhook URL not configured correctly in GitHub | Verify the webhook URL is correctly copied and configured in your GitHub repository settings | | Changes not detected | .env.staging file path doesn't match configuration | Check the envFilePath parameter in the "Set Configuration" node and ensure it matches your file structure | | Branch creation fails | GitHub token doesn't have sufficient permissions | Ensure the GitHub personal access token has the "repo" scope and access to the target repository | | File updates fail | Config file paths don't exist in the repository | Verify the configFiles parameter in the "Set Configuration" node matches actual file paths in your repository | | PR creation fails | Target branch doesn't exist or insufficient permissions | Verify the targetBranch parameter matches an existing branch and the GitHub token has appropriate permissions | | Email notifications not sent | Email credentials not configured or incorrect | Verify your SMTP credentials are correctly configured in n8n and the email address in the "Send Email Notification" node is valid | | Cache invalidation not working | Cache invalidation logic not implemented for your CI/CD system | Modify the "Invalidate Cache" node to implement the appropriate Xcode cache invalidation mechanism for your CI/CD system | | PRs created with no changes | Diff logic not properly detecting differences | Review the "Perform Config Diff" node and ensure it correctly identifies differences between environment and iOS config files | | Workflow stops after file change detection | Workflow logic error in code nodes | Check the JavaScript code in the "Perform Config Diff" node for syntax errors or logic issues | Want to Customize ? Need help setting up or customizing this Environment Config Sync for iOS Xcode Projects workflow? The n8n experts at WeblineIndia can assist you with: Customizing the workflow to fit your specific iOS project structure Integrating with additional tools and services in your CI/CD pipeline Implementing advanced configuration validation and management Setting up multi-environment support and promotion workflows Training your team on iOS configuration management best practices
by Hassan
Overview This sophisticated n8n workflow transforms raw LinkedIn leads into personalized, high-converting connection requests using GPT-4O AI and PhantomBuster automation. The system processes LinkedIn profile data, generates authentic icebreakers, and automatically sends connection requests twice daily, creating a hands-off lead generation machine that maintains human authenticity while scaling outreach efforts. Key Benefits 🤖 AI-Powered Personalization Generate unique, human-like icebreakers for every LinkedIn connection request using GPT-4O, ensuring each outreach feels personal and authentic rather than automated. ⚡ Automated Workflow Execution Run your entire lead generation pipeline automatically twice daily (10 AM and 5 PM) USA Time with zero manual intervention required. 📊 Smart Data Management Seamlessly manage leads across multiple Google Sheets with automatic data cleanup, duplicate prevention, and organized lead tracking. 🎯 PhantomBuster Integration Leverage PhantomBuster's powerful LinkedIn automation to send connection requests at scale while maintaining platform compliance. 📈 Scalable Processing Process leads in optimized batches of 10 to maintain quality while scaling your outreach efforts effectively and remain within LinkedIn’s weekly connection request limits. 📧 Real-Time Monitoring Receive email notifications whenever connection requests are sent, keeping you informed of your campaign progress. 🔄 Continuous Operation Self-maintaining system that processes new leads, cleans up completed tasks, and prepares for the next cycle automatically. 💼 Professional Template System Uses proven icebreaker templates that follow the format: "Hey [name], loved seeing [personalized detail]. I'm also into [relevant connection], thought I'd connect." How It Works Phase 1: Lead Acquisition & Processing The workflow begins with scheduled triggers that activate twice daily. Upon activation, the system first cleans up previously processed leads from the source Google Sheet to prevent duplicates. It then retrieves fresh LinkedIn profile data including names, titles, company information, locations, and profile URLs. Phase 2: AI-Powered Personalization Engine Retrieved leads are processed in batches of 10 through a sophisticated GPT-4O integration. The AI analyzes each LinkedIn profile and generates personalized icebreakers following a proven template structure. The system is specifically programmed to paraphrase LinkedIn information rather than copy it directly, ensuring messages feel human-written rather than automated. Phase 3: Data Storage & Campaign Launch Processed leads with their AI-generated icebreakers are stored in a dedicated Google Sheet for tracking and analysis. The system then aggregates all processed data and triggers a PhantomBuster agent that executes the actual LinkedIn connection requests using the personalized messages. Phase 4: Cleanup & Notification After successful campaign launch, the system removes processed leads from the source sheet, sends email confirmation notifications, and prepares for the next scheduled execution cycle. Required Setup & Dependencies Core Integrations: Google Sheets API access with OAuth2 authentication OpenAI API key for GPT-4O access PhantomBuster account with API key and configured LinkedIn agent Gmail account for notifications Google Sheets Structure: Source Sheet: Contains raw LinkedIn data (firstName, lastName, title, companyName, location, etc.) Destination Sheet: Stores processed leads with icebreakers and tracking information PhantomBuster Configuration: LinkedIn connection request automation agent Proper agent ID configuration in the HTTP request node Valid API key with sufficient credits Business Use Cases Sales Development Representatives (SDRs) Automate personalized outreach to potential clients while maintaining the human touch that drives connection acceptance rates. Recruitment Agencies Scale candidate outreach with personalized messages that reference specific experience and skills from LinkedIn profiles. Business Development Generate partnerships and collaboration opportunities through targeted, personalized connection requests to industry leaders. Coaches & Consultants Build professional networks by connecting with potential clients using AI-generated icebreakers that reference their specific challenges and opportunities. Marketing Agencies Develop client relationships through personalized outreach that demonstrates understanding of their business and industry. Revenue Potential Direct Lead Generation: Process 20 leads daily (10 per execution × 2 runs) Average 25% connection acceptance rate = 5 new connections daily Convert 10% of connections to qualified leads = 15 qualified leads monthly Close 20% of qualified leads at $2,000 average deal size = $6,000 monthly revenue Agency Services: Offer as white-label service to clients at $500-1,500 monthly recurring revenue per client Manage 10-20 client accounts for $5,000-30,000 monthly recurring revenue SaaS Model: Package as LinkedIn automation SaaS with tiered pricing ($49-299/month) Target 100+ subscribers for $5,000-30,000 monthly recurring revenue Difficulty Level & Build Time Difficulty: Intermediate to Advanced Estimated Build Time: 4-6 hours Technical Requirements: Understanding of API integrations, Google Sheets operations, and basic workflow logic Setup Complexity: API key management and authentication setup Google Sheets structure creation and permission configuration PhantomBuster agent setup and testing AI prompt engineering for optimal icebreaker generation Detailed Setup Steps 1. Google Sheets Preparation Create two Google Sheets: Source Sheet:** Structure with columns for firstName, lastName, location, title, companyName, titleDescription, linkedInProfileUrl Destination Sheet:** Include all source columns plus id, photo_url, icebreaker, email_status fields 2. API Credentials Configuration OpenAI:** Generate API key with GPT-4O access Google Sheets:** Set up OAuth2 credentials in n8n PhantomBuster:** Create account, set up LinkedIn connection agent, obtain API key Gmail:** Configure OAuth2 for notification emails 3. PhantomBuster Agent Setup Create LinkedIn connection request automation agent Configure with proper message templates and targeting parameters Test agent functionality and note the agent ID for n8n configuration 4. Workflow Import & Configuration Import the provided n8n workflow JSON Update all credential references to match your configured accounts Modify Google Sheet IDs in all relevant nodes Update PhantomBuster agent ID and API key in HTTP request node 5. AI Prompt Optimization Review and customize the GPT-4O prompt for your specific use case Test icebreaker generation with sample data Adjust tone and style parameters as needed 6. Schedule Configuration Set appropriate trigger times based on your target timezone Consider LinkedIn usage patterns for optimal engagement 7. Testing & Validation Run workflow manually with test data Verify Google Sheets integration and data flow Test PhantomBuster integration with small batch Confirm email notifications are working Advanced Customization Options Enhanced AI Personalization Integrate additional data sources (company websites, news articles) for richer context Add industry-specific icebreaker templates Implement A/B testing for message variations CRM Integration Connect to Salesforce, HubSpot, or Pipedrive for seamless lead management Add lead scoring based on profile analysis Implement automated follow-up sequences Analytics & Reporting Add detailed tracking and analytics dashboard Implement conversion tracking from connection to closed deal Generate automated performance reports Multi-Platform Expansion Extend to Twitter/X and Instagram outreach Add email finder integration for multi-channel campaigns Implement unified contact management across platforms Advanced Filtering Add AI-powered lead qualification before outreach Implement company size, industry, and role-based filtering Add sentiment analysis for optimal timing This workflow represents a complete, production-ready solution that can immediately start generating leads and revenue while providing a foundation for advanced customization and scaling.
by Oneclick AI Squad
This enterprise-grade n8n workflow automates competitor monitoring on Instagram — from post fetching to AI-driven strategy alerts — using Claude AI, Instagram API, and multi-channel notifications. It tracks trends, analyzes performance, and delivers actionable insights via WhatsApp and email, keeping your team ahead with zero manual effort. Key Features Daily competitor scanning** from Google Sheets Post performance metrics** (engagement rate, trends) calculated automatically AI-powered insights* using *Claude 3.5 Sonnet** for content and engagement strategies Dual-channel alerts:** WhatsApp (Twilio) and email for instant delivery Audit logs** in Google Sheets for historical trends Scalable triggers:** Daily schedule or webhook for ad-hoc checks Workflow Process | Step | Node | Description | | ---- | ----------------------------------- | -------------------------------------------------------- | | 1 | Schedule Trigger | Runs daily at 10 AM or via webhook (/competitor-alert) | | 2 | Get Competitor List | Loads competitors from Competitors sheet | | 3 | Loop Over Competitors | Processes each competitor to avoid API limits | | 4 | Get Competitor Posts | Fetches last 10 posts via Instagram Graph API | | 5 | Calculate Performance Metrics | Computes avg engagement and trend using Code node | | 6 | Generate AI Insights (Claude AI)| Analyzes data for 3 strategic bullet-point insights | | 7 | Send Email Alert | Emails detailed report to team | | 8 | Send WhatsApp Alert (Twilio) | Sends concise alert via WhatsApp | | 9 | Log Alert | Records metrics and insights in AlertsLog sheet | | 10 | End Workflow | Terminates execution | Setup Instructions 1. Import Workflow Open n8n → Workflows → Import from Clipboard Paste the JSON workflow 2. Configure Credentials | Integration | Details | | ----------------- | -------------------------------------------------- | | Google Sheets | Service account with spreadsheet access | | Instagram API | Business access token for media fetching | | Claude AI | Anthropic API key for claude-3-5-sonnet-20241022 | | Twilio | Credentials for WhatsApp messaging | | SMTP/Email | SMTP or Gmail for email alerts | 3. Update Spreadsheet IDs Ensure your Google Sheets include: Competitors AlertsLog 4. Set Triggers Webhook:** /webhook/competitor-alert (for on-demand runs) Schedule:** Daily at 10:00 AM 5. Run a Test Use manual execution to confirm: Post fetching and metrics calculation AI insights generation WhatsApp/email delivery and sheet logging Google Sheets Structure Competitors | competitorName | competitorUserId | industryFocus | |----------------|------------------|---------------| | BrandX | 1234567890 | Fashion | AlertsLog | competitor | avgEngagement | trend | insights | timestamp | |---------------|----------------|--------|-----------------------------------|--------------------| | BrandX | 75.5 | Rising | - Bullet 1... | 2023-10-01T12:00:00Z | System Requirements | Requirement | Version/Access | | --------------------- | ---------------------------------------------- | | n8n | v1.50+ (AI and messaging integrations supported)| | Claude AI API | claude-3-5-sonnet-20241022 | | Instagram Graph API| Business account access token | | Twilio API | WhatsApp-enabled phone number | | Google Sheets API | https://www.googleapis.com/auth/spreadsheets | | SMTP | For email (e.g., Gmail OAuth) | Optional Enhancements Add visual charts (e.g., engagement trends via Google Charts) Integrate Slack for team-wide alerts Use advanced metrics like reach/impressions via Instagram Insights API Connect CRM (HubSpot) to tag competitors Enable multi-platform monitoring (e.g., TikTok) Add threshold-based alerts (e.g., only if engagement >20% increase) Export insights to Notion or Airtable for strategy docs Result: A single automated system that monitors competitors, uncovers trends, and arms your team with AI strategies — delivered via WhatsApp and email with zero manual work. Get in touch with us for custom n8n automation!
by Jitesh Dugar
Transform guest complaints into loyalty opportunities - achieving 60% reduction in negative reviews, 85% faster service recovery, and turning dissatisfied guests into brand advocates through AI-powered sentiment analysis and automated response workflows. What This Workflow Does Revolutionizes hotel guest experience management with AI-driven sentiment analysis and proactive service recovery: 📝 Real-Time Feedback Capture - Jotform collects guest feedback during their stay, not after checkout 🤖 AI Sentiment Analysis - GPT-4 analyzes feedback across sentiment, urgency, and reputation impact 🚨 Instant Escalation - Critical issues immediately alert managers via email and Slack 💝 Personalized Recovery Offers - AI generates custom compensation (upgrades, discounts, credits) 📧 Automated Guest Communication - Sends recovery offers to unhappy guests, thank-you notes to satisfied ones 🎫 PMS Integration - Creates tickets in your Property Management System with full context ⭐ Review Generation - Encourages happy guests to share experiences on Google, TripAdvisor, Booking.com 📊 Complete Analytics - Tracks all feedback with sentiment scores for trend analysis 🎯 Proactive Prevention - Resolves issues before guests post negative online reviews 💰 ROI Tracking - Measures service recovery effectiveness and guest satisfaction improvements Key Features AI Guest Experience Analyst: GPT-4 analyzes feedback across 10+ dimensions including sentiment scoring, urgency classification, and reputation impact assessment Intelligent Routing: Automatically escalates critical/high-urgency issues to hotel management within minutes Personalized Service Recovery: AI generates tailored compensation offers based on issue severity, guest emotional state, and long-term value potential Multi-Channel Alerts: Instant notifications via Gmail and Slack ensure no critical feedback is missed Sentiment Scoring: 0-100 numerical sentiment scores enable data-driven trend analysis Category Detection: AI identifies issue categories (cleanliness, staff, amenities, noise, etc.) Reputation Impact Assessment: Predicts likelihood of negative online review (low/medium/high) Recovery Action Suggestions: AI recommends specific steps to resolve each guest concern Positive Feedback Amplification: Automatically requests online reviews from satisfied guests with incentivized return offers Property Management Integration: Creates structured tickets with all AI insights for staff follow-up Complete Audit Trail: Google Sheets logging enables performance tracking and staff training insights Cost Optimization: AI balances recovery offer value against long-term guest lifetime value Perfect For Boutique Hotels: 20-100 rooms requiring personalized guest experience management Hotel Chains: Multi-property operations standardizing service recovery protocols Resorts: Large properties with multiple service areas (spa, dining, housekeeping, etc.) Business Hotels: Corporate-focused properties prioritizing fast issue resolution Vacation Rentals: Airbnb management companies handling guest communications at scale Hostels: Budget accommodations building reputation through responsive service Extended Stay Properties: Long-term guest relationships requiring proactive care Conference Centers: Event venues managing large groups and critical feedback What You'll Need Required Integrations Jotform - Guest feedback form (free tier works) Create your form for free on Jotform using this link OpenAI API - GPT-4 for AI sentiment analysis (~$0.10-0.30 per feedback) Gmail - Automated notifications to managers and guests Google Sheets - Feedback database and analytics dashboard Optional Integrations Slack - Real-time alerts to management team Property Management System - Automated ticket creation (via API) Quick Start Import Template - Copy JSON and import into n8n Add OpenAI Credentials - Set up OpenAI API key (GPT-4 recommended for best results) Create Jotform Guest Feedback Form: Guest Name (q3_guestName) Guest Email (q4_guestEmail) Room Number (q5_roomNumber) Stay Dates (q6_stayDates) Overall Rating 1-5 (q7_overallRating) Feedback Comments (q8_feedbackComments) Service Area (q9_serviceArea) Create your form for free on Jotform using this link Configure Gmail - Add Gmail OAuth2 credentials (same credential for all 3 Gmail nodes) Setup Google Sheets: Create spreadsheet with "Guest Feedback Analytics" sheet Replace YOUR_GOOGLE_SHEET_ID in workflow Columns: timestamp, submissionId, guestName, roomNumber, stayDates, overallRating, serviceArea, sentiment, sentimentScore, urgencyLevel, keyIssues, categories, reputationImpact, recoveryOfferSent, feedbackText Configure PMS Integration (Optional): Add your PMS API endpoint URL Set up HTTP authentication credentials Setup Slack Webhook (Optional): Create Slack incoming webhook Replace YOUR/SLACK/WEBHOOK in workflow Customize Email Addresses: Update hotel.manager@yourhotel.com Update guestrelations@yourhotel.com Update review site URLs in positive feedback email Test Workflow - Submit test feedback through Jotform Go Live - Share feedback form link with guests (QR codes in rooms, checkout emails, etc.) Customization Options Service Recovery Tiers: Adjust compensation levels based on issue severity and guest value Auto-Approval Thresholds: Set limits for automatic vs manager-approved recovery offers AI Prompt Tuning: Customize sentiment analysis criteria for your brand standards Multi-Language Support: Add translation nodes for international guests Guest Segmentation: VIP guests receive premium recovery offers Timing Rules: Different workflows for during-stay vs post-checkout feedback Review Platform Integration: Direct API connections to TripAdvisor, Google Reviews Staff Training Alerts: Route feedback to specific department managers Competitive Analysis: Track sentiment vs competitor properties Seasonal Adjustments: Higher compensation during peak season to retain bookings Loyalty Program Integration: Award points as part of service recovery Follow-Up Sequences: Automated check-ins after issue resolution Expected Results 60% reduction in negative online reviews - Proactive resolution before guests post publicly 85% faster service recovery - Automated workflows vs manual monitoring 40% increase in repeat bookings - Effective recovery turns complainers into loyalists 95% manager response rate - Instant alerts ensure nothing falls through cracks 3x increase in positive review requests - Automated outreach to satisfied guests 75% cost reduction in review management - Less time fighting bad reviews 90% guest satisfaction with recovery - Personalized, immediate responses 100% feedback tracking - Complete audit trail for quality improvement 50% improvement in staff training - Data-driven insights on recurring issues 30% reduction in compensation costs - AI optimizes offer value vs actual resolution Use Cases Luxury Resort (200 Rooms) Scenario: Guest in oceanview suite complains about noisy pool area disrupting afternoon nap. Rating: 2/5. Feedback submitted at 2:47 PM during stay. AI Analysis: Sentiment = negative (35/100), Urgency = high, Impact = high reputation risk. Key issue: noise disturbance. Category: amenities/environment. Automated Response: 2:48 PM: Hotel manager receives urgent email and Slack alert 2:49 PM: AI generates recovery offer: complimentary room upgrade to quiet wing + $100 spa credit + late checkout 2:52 PM: Manager reviews AI recommendation, approves via phone 3:00 PM: Guest receives personalized apology email with upgrade offer 3:15 PM: Guest accepts, moves to premium suite 3:45 PM: Manager personally visits guest with welcome amenity Next Day: Guest updates internal feedback to 5/5 Result: $200 recovery cost prevents $5,000+ in future lost bookings from negative review. Guest becomes repeat customer, books 3 more stays over next year. Business Hotel (80 Rooms) Scenario: Corporate traveler rates stay 5/5, praises front desk staff professionalism and fast WiFi. Checkout feedback at 7:23 AM. AI Analysis: Sentiment = positive (92/100), Urgency = low, Categories: staff excellence, amenities. Automated Response: 7:24 AM: Thank you email sent with review request links (Google, TripAdvisor) Email includes 15% discount code for next stay (WELCOME-BACK-2025) Review links customized with pre-filled star ratings 11:30 AM: Guest posts 5-star Google review mentioning staff by name Result: Positive review attracts 12 new corporate bookings over next quarter. Guest becomes regular weekly visitor. Zero manual effort required. Budget Hotel Chain (150 Locations) Scenario: Guest complains about unclean bathroom, slow check-in, and uncomfortable bed. Rating: 1/5. Multiple critical issues. AI Analysis: Sentiment = negative (15/100), Urgency = CRITICAL, Impact = very high reputation risk. Categories: cleanliness, operations, room quality. Automated Response: Instant email to hotel manager + regional director Slack alert to #operations-critical channel AI recommends: full refund + 2 free night voucher + immediate room change PMS ticket created for housekeeping inspection Guest receives apology within 10 minutes Manager calls guest personally within 20 minutes Room changed immediately, housekeeping staff retrained Result: Guest accepts recovery offer, doesn't post negative review. Systemic cleaning issue identified and corrected across all 150 locations, preventing 1,000+ potential complaints. Boutique B&B (12 Rooms) Scenario: Couple celebrating anniversary rates stay 4/5, mentions minor issue with breakfast timing but overall lovely experience. AI Analysis: Sentiment = positive (78/100), Urgency = low, Issue noted: breakfast service timing, Categories: dining, overall satisfaction. Automated Response: Thank you email with review requests AI suggests small gesture: complimentary breakfast on next visit Owner receives gentle notification about breakfast timing feedback (not urgent) Follow-up email includes personalized anniversary wishes Result: Couple posts glowing TripAdvisor review, becomes annual anniversary tradition. Breakfast timing adjusted based on feedback trend analysis. Personal touch strengthens brand loyalty. Resort During Peak Season Scenario: Family of 4 complains about overbooked pool area, long wait times at restaurant, stressed staff. Rating: 3/5. Peak season capacity issues. AI Analysis: Sentiment = neutral-negative (45/100), Urgency = medium, Categories: capacity management, staffing, amenities access. AI notes this is systemic, not individual service failure. Automated Response: Manager receives analysis highlighting capacity issues vs service quality AI recommends: restaurant priority reservations rest of stay + late checkout + $150 resort credit Recovery offer emphasizes "peak season challenges we're addressing" Guest receives empathetic communication acknowledging valid concerns Operations team receives alert about capacity strain for staffing adjustments Result: Family accepts offer, enjoys remaining days. Operations team adds staff for following weekend. Feedback trends identify need for reservation system improvements, implemented before next season. Pro Tips QR Code Distribution: Place QR codes linking to feedback form in every room, at checkout desk, and in common areas Timing Optimization: Send feedback requests on Day 2 of stay (not checkout) to enable real-time recovery Manager Training: Educate managers on interpreting AI sentiment scores and urgency classifications Recovery Budgets: Set department budgets for service recovery offers ($50-500 per incident) Review Monitoring: Cross-reference internal feedback with online reviews to measure prevention effectiveness Staff Recognition: Share positive feedback with staff members mentioned by name Trend Analysis: Weekly reviews of Google Sheets data to identify recurring issues Seasonal Patterns: Track sentiment scores across different seasons and events Competitor Benchmarking: Compare your sentiment scores to industry averages Follow-Up Surveys: Send 30-day post-stay surveys to guests who received service recovery Loyalty Integration: Higher-tier loyalty members receive premium recovery offers Language Customization: For international properties, adjust AI prompts for cultural norms Response Time Tracking: Monitor average time from feedback to resolution Cost-Benefit Analysis: Track recovery offer costs vs prevented negative review impact Success Metrics Dashboard: Create Google Data Studio dashboard from Sheets data Learning Resources This workflow demonstrates advanced automation: AI Agents with Multi-Dimensional Analysis: Sentiment scoring, urgency classification, impact assessment, and recovery recommendations Conditional Logic Routing: Different workflows for positive, negative, and critical feedback Real-Time Alerting: Multi-channel notifications (email + Slack) for urgent issues Dynamic Content Generation: AI creates personalized emails based on sentiment analysis API Integration Patterns: Property Management System ticket creation via HTTP requests Data Aggregation: Complete feedback logging for business intelligence and reporting Natural Language Processing: AI extracts key issues, categories, and emotional tone from free-text feedback Decision Support Systems: Provides managers with AI recommendations and key considerations Approval Workflows: Optional manager approval step for high-value recovery offers Guest Communication Templates: Professional, empathetic email templates for all scenarios Business Impact Metrics Review Management ROI: Compare cost of service recovery vs reputation management services (typically $500-2000/month) Guest Lifetime Value: Track repeat booking rates for guests who received service recovery vs those who didn't Online Reputation Score: Monitor aggregate rating improvements on Google, TripAdvisor, Booking.com Staff Efficiency: Calculate hours saved vs manual feedback monitoring and response Revenue Protection: Estimate revenue preserved by preventing negative reviews (avg negative review costs hotel $2,000-5,000 in lost bookings) Recovery Success Rate: Percentage of negative feedback resolved without resulting in online reviews Response Time: Average minutes from feedback submission to initial response First-Contact Resolution: Percentage of issues resolved without multiple interactions Training ROI: Reduction in recurring issues after staff training based on feedback trends Competitive Positioning: Sentiment score comparison vs competitor properties Ready to Transform Your Guest Experience? Import this template and turn guest feedback into your competitive advantage with AI-powered insights and automation! 🏨✨ Questions or customization? The workflow includes detailed sticky notes explaining each AI analysis component and decision logic. Template Compatibility ✅ n8n version 1.0+ ✅ Works with n8n Cloud and Self-Hosted ✅ No coding required for basic setup ✅ Fully customizable for advanced users
by tsushima ryuto
Event Participant Management and Automated Follow-up System This workflow automates the entire process of managing event participants, from registration and payment to sending reminders and follow-up communications. It's designed for event organizers who want to streamline their operations and ensure a smooth experience for attendees. Who is this for? This template is ideal for event organizers, community managers, and businesses that host workshops, webinars, conferences, or any event requiring participant registration and communication. How it works The workflow is divided into three main parts: Registration and Onboarding: When a new participant registers via a Typeform, their details are immediately added to a Google Sheet. Payment is processed via Stripe. Upon successful payment, a confirmation email is sent to the participant, and the event is added to their Google Calendar. The organizer receives a Slack notification about the new registration. Event Reminders: A daily scheduled trigger checks the Google Sheet for upcoming events. It calculates if an event is within the specified reminder period (e.g., 3 days before). If a reminder is needed, an email is automatically sent to the participant. Post-Event Follow-up: Another daily scheduled trigger checks for past events. It calculates if an event is due for a follow-up (e.g., 2 days after). A thank-you email, including a survey link, is sent to participants. The participant's status in the Google Sheet is updated to mark the follow-up as sent. How to set it up Typeform Registration Form: Replace <PLACEHOLDER_VALUE__Typeform Form ID> with your actual Typeform ID. Workflow Configuration: Fill in the placeholder values for Event Name, Event Date, Event Time, Event Location, Participation Fee Amount, and Slack Channel ID. Google Sheets: Replace <PLACEHOLDER_VALUE__Google Sheets Document ID> and <PLACEHOLDER_VALUE__Sheet Name (e.g., Participants)> with your Google Sheet details. Ensure your sheet has columns for "Name", "Email", "Phone", "Registration Date", "Event Name", "Event Date", "Payment Status", "Follow-up Sent", and "Follow-up Date". You will need to set up Google Sheets OAuth2 API credentials. Stripe (Process Payment): Replace <PLACEHOLDER_VALUE__Customer ID> and <PLACEHOLDER_VALUE__Source ID> with your Stripe customer and source IDs. You will need Stripe API credentials. Gmail (Send Confirmation Email, Send Reminder Email, Send Thank You & Survey): You will need to set up Gmail OAuth2 credentials. Google Calendar (Add to Calendar): You will need to set up Google Calendar OAuth2 API credentials. Slack (Notify Organizer): Replace <PLACEHOLDER_VALUE__Slack Channel ID> (if not already set in Workflow Configuration) and set up Slack OAuth2 API credentials. Survey URL (Send Thank You & Survey): Replace <PLACEHOLDER_VALUE__Survey URL> with the link to your post-event survey. Requirements Typeform account and a registration form. Google Sheet for participant management. Stripe account for payment processing. Gmail account for sending emails. Google Calendar for event scheduling. Slack account for organizer notifications. n8n credentials for Google Sheets, Stripe, Gmail, Google Calendar, and Slack. How to customize the workflow Reminder/Follow-up Timing:** Adjust the reminderDaysBefore and followupDaysAfter values in the "Workflow Configuration" node to change when reminder and follow-up emails are sent. Email Content:** Modify the HTML content in the "Send Confirmation Email", "Send Reminder Email", and "Send Thank You & Survey" nodes to match your branding and messaging. Payment Currency:** Change the currency in the "Process Payment" node if your event uses a different currency. Additional Data:** Extend the Google Sheets nodes to capture more participant information from Typeform if needed. Integration:** Easily integrate with other services by adding more nodes, for example, a CRM to add new participants as leads.
by Naveen Choudhary
Who's it for This workflow is perfect for digital marketing agencies, sales teams, and business development professionals who want to automate lead qualification, scoring, and personalized outreach. If you're tired of manually reviewing every form submission and crafting individual responses, this template will save you hours while improving response quality. What it does This AI-powered lead management system automatically processes JotForm submissions through a sophisticated 6-step pipeline: Captures leads from JotForm submissions in real-time Scores each lead using AI (GPT-4.1-nano) based on budget, company fit, and project clarity Logs all data to Google Sheets with AI scores, tiers (high/medium/low), and reasoning Enriches company information by fetching industry, employee count, tech stack, and location data Generates personalized emails that reference the lead's specific needs and company insights Sends tailored responses via Gmail with tier-appropriate calls-to-action High-tier leads get priority treatment with direct calendar links, medium-tier leads receive consultation offers, and low-tier leads are sent helpful resources—all automatically. How to set up Requirements JotForm account with a contact form (free tier works) OpenAI API key with GPT-4.1-nano access Google account for Sheets and Gmail Company enrichment API endpoint (see setup guide below) Setup steps Clone this workflow to your n8n instance Configure JotForm Trigger: Connect your JotForm account and select your contact form Add OpenAI credentials: Both AI nodes use the same OpenAI API key Set up Google Sheets: Create a new spreadsheet with columns: first_name, last_name, company, email, message, estimated_budget, ai_score, ai_tier, ai_reasoning Configure Gmail: Connect your Gmail account for sending responses Set up enrichment API: Deploy the company enrichment workflow (workflow #9960) and update the webhook URL in the "API: Company Enrichment Request" node Company Enrichment API Setup The enrichment API is a separate workflow that fetches company data. You can: Use the enrichment workflow template Deploy it to your n8n instance Update the webhook URL in the HTTP Request node to point to your deployed version How to customize Adjust AI scoring criteria: Modify the system prompt in "AI: Lead Scoring Analysis" to match your ideal customer profile and budget thresholds Customize email templates: Edit the system prompt in "AI: Generate Personalized Email" to match your brand voice and offerings Add more data points: Extend the Google Sheets schema to capture additional form fields or enrichment data Change email provider: Swap Gmail for Outlook, SendGrid, or any SMTP service Add notifications: Insert a Slack or Discord node after lead scoring to alert your team about high-tier leads instantly Implement lead routing: Add an IF node after scoring to route high-value leads to senior team members.
by Jitesh Dugar
🎫 Verified Press Pass Generator for Media Events Automate press credential verification and badge generation for journalists covering your events 📝 Description Streamline your event media management with this comprehensive press pass automation. When journalists apply for credentials, this workflow instantly validates their identity, verifies their media affiliation, generates professional digital badges with QR codes, and delivers everything via email—all within seconds. Perfect for conferences, product launches, trade shows, corporate events, and any occasion requiring verified media access. ✨ Key Features 🔐 Advanced Email Verification Real-time email validation using VerifiEmail API Checks RFC compliance, MX records, and domain reputation Detects disposable email addresses and spoofed domains Confirms journalist works for legitimate media organization 🎨 Professional Badge Design Auto-generates branded digital press passes Includes journalist photo, name, media outlet, and credentials Embedded QR code for contactless event entry Customizable colors, fonts, and event branding 400×600px portrait format optimized for mobile display 📧 Automated Communication Beautiful HTML email with embedded badge preview Download links for PNG and PDF versions Clear instructions for event check-in Professional event branding throughout 📊 Multi-Platform Logging Google Sheets backup with timestamp logs Slack notifications for organizer oversight Complete audit trail for compliance ⚡ Lightning Fast Processing Average execution time: 5-10 seconds Real-time webhook response with confirmation Scalable to hundreds of applications per hour Error handling with graceful fallbacks 🎯 Use Cases Event Types: Tech conferences and summits Product launch events Trade shows and exhibitions Political rallies and press conferences Sports events and tournaments Film festivals and premieres Corporate announcements Award ceremonies 🔧 What You Need Required Services: n8n (Cloud or Self-hosted) VerifiEmail API (Get API Key) - Email verification HTMLCSSToImage API (Get API Key) - Badge generation Gmail Account (OAuth) - Email delivery Slack Workspace - Team notifications Google Sheets - Backup logging 📋 How It Works Step-by-Step Process: 1. Application Submission Journalist fills out form on your event website (name, email, media outlet, photo, phone) 2. Data Validation Webhook receives application and checks for required fields (name, email, photo) 3. Email Verification VerifiEmail API validates email domain, checks MX records, and confirms media affiliation 4. Credential Generation Generates unique press ID (PRESS-XXX-timestamp) Creates QR code linking to verification portal Sets 30-day validity period 5. Badge Creation HTMLCSSToImage API renders professional badge with: Circular profile photo Name and media outlet Press ID in styled container Scannable QR code Event name and validity dates "VERIFIED" indicator 6. Distribution Sends HTML email with badge preview and download link Posts notification to Slack channel Backs up to Google Sheets Returns success response to webhook 7. Event Check-In Security scans QR code at event entrance, verifies credentials instantly 🚀 Setup Instructions Quick Start (15 minutes): 1. Import Workflow Download the JSON file In n8n: Click Workflows → Import from File Upload the JSON and open the workflow 2. Configure Webhook Activate the workflow Copy the webhook URL from the Webhook Trigger node Add this URL to your website form's action attribute 3. Add API Credentials VerifiEmail:** Create credential with API key from verifi.email dashboard HTMLCSSToImage:** Add User ID and API Key from htmlcsstoimg.com Gmail:** Connect via OAuth (click "Sign in with Google") Slack:** Connect via OAuth and select notification channel Google Sheets:** Connect via OAuth 4. Setup Google Sheets Create a new sheet named "Press Pass Logs" with these column headers: Timestamp | Press ID | Name | Email | Phone | Media Outlet | Email Domain | Verification Status | Event Name | Issued Date | Valid Until | Badge Image URL | QR Code URL | Verification URL | Photo URL | Execution Mode 5. Customize Badge Design Open the "HTML/CSS to Image" node Edit the HTML in html_content field Change gradient colors: Replace #667eea and #764ba2 with your brand colors Update event name default value Modify font sizes, spacing, or layout as needed 6. Update Email Content Open "Send Press Pass Email" node Customize email text, support contact info Update company/event branding Modify footer with your details 7. Configure Slack Channel Open "Notify Organizers (Slack)" node Select your preferred notification channel Customize notification message format 8. Test the Workflow Send a test POST request using Postman or cURL: curl -X POST https://your-n8n-url/webhook/press-application \ -H "Content-Type: application/json" \ -d '{ "name": "Jane Smith", "email": "jane@bbc.com", "media_outlet": "BBC News", "photo_url": "https://randomuser.me/api/portraits/women/50.jpg", "phone": "+44-1234567890", "event_name": "Tech Summit 2025" }' 9. Go Live Verify test execution completed successfully Check email received with badge Activate workflow for production use 🎨 Customization Options Badge Design: Colors:** Change gradient from purple (#667eea, #764ba2) to your brand colors Fonts:** Swap Google Font from Poppins to any available font Logo:** Add event logo in header section Size:** Adjust viewport_width and viewport_height for different dimensions Layout:** Modify HTML structure for custom badge designs Email Templates: Branding:** Update colors, fonts, and styling in HTML email Content:** Customize greeting, instructions, and footer Attachments:** Add PDF version or additional documents Language:** Translate all text to your language 🔒 Security & Privacy Data Protection: ✅ Email verification prevents fake submissions ✅ QR codes use unique, non-guessable IDs ✅ HTTPS webhook for encrypted transmission ✅ No sensitive data stored in workflow variables ✅ Audit trail for compliance requirements Best Practices: Use environment variables for API keys Enable webhook authentication (Basic Auth or API key) Implement rate limiting on webhook endpoint Regularly rotate API credentials Set up backup systems for critical data 🛠️ Troubleshooting Common Issues: Issue: "Webhook not receiving data" Solution: Ensure workflow is activated and webhook URL is correct in form action Issue: "Email verification fails for valid domains" Solution: Check VerifiEmail API credit balance and credential configuration Issue: "Badge image not generating" Solution: Verify HTMLCSSToImage API key is correct and has sufficient credits Issue: "Gmail not sending" Solution: Reconnect Gmail OAuth credential and check sending limits Issue: "QR code not loading in badge" Solution: Ensure QR code URL is properly encoded and publicly accessible 📈 Performance Metrics Average execution time:** 5-10 seconds Success rate:** 98%+ (with valid inputs) Concurrent capacity:** 50+ requests/minute API reliability:** 99.9% uptime (dependent on services) Badge generation:** <2 seconds Email delivery:** <3 seconds 🏷️ Tags event-management press-pass credential-verification badge-generation email-automation qr-code media-relations event-technology htmlcsstoimage verifi-email gmail slack google-sheets webhook automation workflow conference journalism press-credentials 📄 License This workflow template is provided as-is for use with n8n. Customize freely for your organization's needs.
by Itunu
📧 Automated Initial Outreach Emails with Safety Controls This n8n workflow sends personalized outreach emails automatically while enforcing strict safety rules such as email validation, spam checks, daily limits, and human-like delays. It is designed to help beginners send emails safely, consistently, and at scale without damaging sender reputation. What This Workflow Does On a daily schedule, this workflow: Pulls contacts from Google Sheets Cleans and validates email addresses Blocks spam, invalid, or risky emails Checks if an email was already sent Enforces daily sending limits (weekdays only) Adds random human-like delays Generates personalized subject lines and openings Sends emails via Gmail Updates Google Sheets with send status Who This Is For This workflow is useful if you: Send cold or semi-cold outreach emails Apply to jobs at scale with personalization Run sales, hiring, or networking campaigns Want safety controls to avoid spam flags Are learning n8n with a real-world workflow No advanced n8n knowledge is required. Required Services You will need: Google Sheets** (contact source + status tracking) Gmail** (sending emails) Google Drive** (for attachments like CVs) n8n** (self-hosted or cloud) Sheet Structure (Recommended) Contacts Sheet Required columns: EMAIL Name EMAIL VERIFIED EMAIL SMTP VERIFIED EMAIL SUGGESTION EMAIL TYPE SENT SENT DATE Email Status Columns Updated automatically by the workflow: SENT DATE SENT EMAIL TYPE Setup Instructions 1. Connect Google Sheets Update the Google Sheets nodes to point to your own spreadsheet Ensure column names match the workflow Sample Data for Sheets | EMAIL | Name | EMAIL VERIFIED | EMAIL SMTP VERIFIED | EMAIL SUGGESTION | EMAIL TYPE | SENT | DATE SENT | |--------------------------|-------------|----------------|---------------------|-------------------------|------------|------|-----------| | alex@company.com | Alex Morgan | REACHABLE | VALID | SAFE TO SEND | INITIAL | YES | 2025-01-12 | | info@startup.io | — | CATCH-ALL | UNKNOWN | SEND WITH CAUTION | INITIAL | NO | — | | sarah.lane@business.org | Sarah Lane | REACHABLE | VALID | SAFE TO SEND | INITIAL | YES | 2025-01-13 | | contact@agency.co | — | UNKNOWN | NOT VERIFIED | VERIFY BEFORE SENDING | INITIAL | NO | — | | michael@enterprise.net | Michael T. | REACHABLE | VALID | SAFE TO SEND | FOLLOW-UP | YES | 2025-01-14 | EMAIL is required for sending. SENT and DATE SENT are updated after a successful email send. EMAIL VERIFIED reflects high-level verification results. EMAIL SMTP VERIFIED indicates server-level validation when available. EMAIL SUGGESTION is generated by the workflow’s safety logic. SENT and DATE SENT are updated only after a successful send. Rows without a name are invalid for outreach. Additional rows can be added freely. 2. Connect Gmail Add your Gmail credentials Confirm daily sending limits match your account limits 3. (Optional) Connect Google Drive Used to attach files (e.g., Decks, CVs, Presentations,etc) 4. Review Safety Settings Daily email limit is enforced in code Weekends are automatically blocked Spam and invalid emails are skipped 5. Activate the Workflow Enable the workflow Emails will start sending automatically at the scheduled time Email Sample Safety Features Explained This workflow includes built-in protections: ✅ Email format validation ✅ Blocked domains and keywords ✅ Spam flag checks ✅ Duplicate send prevention ✅ Daily quota enforcement ✅ Weekend blocking ✅ Random delays between sends These safeguards help maintain a healthy sender reputation. Customization Ideas You can extend this workflow to: Add follow-up (retarget) emails Integrate email verification APIs Log sends into a database (NocoDB, Postgres, etc) Add Slack notifications Support multiple Gmail accounts Personalize content further with AI Important Notes Review Gmail sending limits before scaling Test with a small contact list first Do not remove safety checks unless you understand the risks License This workflow is shared for educational and practical use. You are free to modify and adapt it for your own projects. Author Built and shared by Itunu Ola n8n automation builder focused on safe, production-ready workflows.
by Sameed
Who’s it for This workflow is perfect for recruiters, HR professionals, and startup founders who receive job applications by email and want to automate the process of parsing, matching, and evaluating resumes. If you want to save time by having candidate data and AI scores automatically organized in Google Sheets, this workflow is for you. How it works Monitors a Gmail inbox for new emails with resume attachments (PDF) Extracts the job title from the email subject and matches it against open positions stored in Airtable Uploads the resume file to a designated Google Drive folder for storage Builds a prompt with all relevant context and sends it, along with the resume file, to Gemini AI for analysis Gemini scores the candidate, extracts their name and phone, and provides a one-sentence explanation All results—including candidate info, AI score, feedback, and a download link for the resume—are appended as new rows in Google Sheets How to set up Create accounts and APIs: You’ll need Google (Gmail, Drive, Sheets), Airtable, and Gemini API access. Prepare your Airtable base: Add your job descriptions (title, code, description, skills, etc.)—these are matched against incoming applications. Prepare your Google Sheet: Create a spreadsheet to store applicant data and scores. Connect credentials in n8n: Set up Gmail, Google Drive, Google Sheets, Airtable, and Gemini API credentials in n8n’s credential manager. Import this workflow: Use the workflow import feature in n8n and connect your credentials to each node. Test: Send a test application email with a PDF resume to your connected Gmail—watch the data appear in Google Sheets! Requirements Google account with access to Gmail, Drive, and Sheets Airtable account for job data Gemini API key (no hardcoded keys—use n8n environment variables or credentials) n8n instance (cloud or self-hosted) How to customize the workflow Job matching logic**: Edit the EmailMatcher node to fine-tune how subjects are matched to job titles. Scoring criteria**: Adjust the prompt in PromptBuilder to change what Gemini evaluates. Supported file types**: Modify the ReadyAttachment node to accept other resume formats if needed. Sheet columns**: Edit the Google Sheets node to map new data points or change the output format. Notifications**: Add Slack or email nodes to notify you when a strong candidate is found.
by David Olusola
⚠️ Crypto Price Threshold Alerts (Email/SMS/Telegram) 📌 Overview This workflow monitors Bitcoin (BTC) and Ethereum (ETH) prices in real-time using CoinGecko’s public API. It sends you an instant alert when a price crosses a custom threshold or when the 24-hour change moves beyond your defined % range. Perfect for traders who want automated price pings without constantly checking charts. ⚙️ How it works Schedule Trigger — runs every 10–15 minutes (configurable cron). HTTP Request (CoinGecko) — fetches live BTC/ETH prices + 24h % changes. Code Node — compares values against your target thresholds. IF Node — checks if any condition is true (cross up/down or big move). Notification Node — sends alert via Email, SMS (Twilio), or Telegram. Example Output: > “BTC broke $110,000 (+2.1% 24h)” 🛠 Setup Guide Set your thresholds in the Code node: BTC_UP / BTC_DOWN ETH_UP / ETH_DOWN MOVE_ABS (absolute % change to trigger) Choose delivery channel: Email Node → SMTP (Gmail, Outlook, etc.) Twilio Node → SMS alerts Telegram Node → DM or channel alerts Test Run: Execute once from the Code node. If thresholds are crossed, you’ll see a formatted alert payload. 🎛 Customization Adjust interval in the Schedule Trigger (default: every 15m). Add more cryptos by editing the CoinGecko API call. Use Slack or Discord instead of Email/Telegram for team alerts. Store last triggered state in Google Sheets/DB to avoid repeated pings. 👤 Author David Olusola For traning automation & 1:1 consulting: sales@daexai.com