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 Cheng Siong Chin
How It Works This workflow automates intellectual property (IP) monitoring, conflict detection, and governance reporting for IP counsel, legal operations teams, and compliance officers. It eliminates the manual effort of tracking IP lifecycle events, identifying conflicting registrations, and routing compliance actions across severity levels. IP alerts arrive via webhook and scheduled monitoring triggers. Both feeds are parsed and passed to the IP Monitoring Agent, backed by a monitoring model, shared memory, a Conflict Detection Agent (with knowledge base), an IP Lifecycle Tracking Agent, and an IP Tracking Sheet Tool. Structured outputs feed the IP Governance Agent, which coordinates a Governance Agent (with memory), a Licensing Compliance Agent, and a Documentation Generation Agent. Outputs are routed by severity: analytics data is formatted and exported to Google Sheets; conflicts are prepared, shared to Slack, and routed by severity level, critical conflicts trigger Gmail alerts while medium conflicts receive Slack notifications. Governance records, compliance reports, and governance decisions are stored and distributed in parallel. Setup Steps Import workflow; configure the External IP Alert Webhook and Schedule IP Monitoring trigger interval. Add AI model credentials to the IP Monitoring Agent Connect Slack credentials to the Share IP Conflicts and Notify Medium Conflicts nodes. Link Gmail credentials to the Email High Priority Conflicts and Send Compliance Report nodes. Link Google Sheets credentials; set sheet IDs for IP Analytics, Governance Decisions, and Compliance Report tabs. Configure the IP Knowledge Base tool with your IP registry or database source. Prerequisites OpenAI API key (or compatible LLM) Slack workspace with bot credentials Gmail account with OAuth credentials Google Sheets with IP analytics and governance tabs pre-created IP knowledge base or registry API access Use Cases IP counsel automating conflict detection across trademark and patent registrations Customisation Extend severity routing to include additional tiers such as low-risk advisory notifications Benefits Dual-trigger ingestion eliminates IP monitoring blind spots between scheduled and real-time events
by System Admin
Objective: Automatically categorize incoming emails based on existing Gmail labels or create a new label if none match. Tools: - Get message - Read all labels - Create label - Assign label to message...
by Harvex AI
AI Sales Analyst & Lead Router This n8n template handles the post-call process for your business. It uses the call recording to extract valuable data and handles the prospect based on their budget. Some use cases: Sales follow-ups, auto-qualifying leads based on budget, monetizing low-budget leads, and automatic data entry. How it works Ingestion: When a call recording is uploaded to a specific Google Drive folder, the workflow is triggered. Transcription: OpenAI's model transcribes the call recording. Analysis: The GPT-4o model analyzes the transcript and extracts crucial information. Lead classification: The extracted budget is checked against your defined threshold (e.g., $5,000). Hot leads (Budget > 5k): The workflow logs the data in Airtable (CRM), creates a high-priority task, and instantly alerts the team via a Slack channel. Warm leads (Budget < 5k): The workflow logs the data, creates a low-priority task, and emails the lead, offering a cheaper alternative. Logging: Every execution is logged in Airtable. How to use the workflow Configure Google Drive: Open the Trigger node and select the destination folder for the call recordings. Set your Threshold: Open the If node and set your desired budget (currently set to 5,000). Customize the email: Open the Gmail node in Phase 2B and modify the email according to your own preferences. Database mapping: Ensure that your Airtable base has the following columns: Client Name, Budget, Sentiment, Summary, Date, and Timeline. Test it out! Generate a sample audio file on ElevenLabs and upload it to your Google Drive folder. Requirements Google Drive** (For storing audio recordings) OpenAI API Key** (Access to OpenAI models) Airtable** (For CRM and System Logging) Trello** (For Task Management) Slack** (For Team Notifications) Gmail** (For sending automated emails)
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 Adem Tasin
🧩 Description A customized n8n workflow inspired by the Lead Generation Agent template. It automates B2B lead scraping via Apify, extracts contact emails with AI, sends cold emails via Gmail, and logs every interaction in Google Sheets with Telegram alerts for live monitoring. 🧠 How It Works This workflow automates the entire B2B lead generation and outreach process from data collection to email delivery. Once you enter your search keyword and location, the system scrapes business details using Apify, filters valid websites, and extracts email addresses with AI. Each lead is then enriched and logged in Google Sheets. The workflow automatically composes a personalized cold email based on your preferred tone (friendly, simple, or professional) and sends it through Gmail with short delays between each message to avoid spam filters. You’ll also receive Telegram notifications to monitor progress and any leads that fail to send. ⚙️ Setup Steps Clone the workflow into your n8n instance. Add your API credentials: Apify API Token OpenAI (or Gemini) API Key Google Sheets & Gmail account connections Telegram Bot Token + Chat ID (optional) Open the Form node or Manual Trigger, and set your search criteria (e.g., “marketing agencies in London”). Configure your Google Sheet — make sure the columns match the node mapping. Adjust the AI prompt in the OpenAI node if you want a different tone or style for your emails. Run the workflow manually to test one or two leads first. Once confirmed, activate scheduling or keep it manual for on-demand lead generation. 🚀 Try It Out! Experience how AI and automation can take over your lead generation workflow. Just enter a business type and location, and watch as the system finds potential clients, extracts contact details, crafts a personalized cold email, and sends it — all without manual effort. Perfect for freelancers, agencies, or anyone looking to automate their B2B outreach process.
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