Workflow Templates

This workflow automatically checks a list of desired domain names for availability every 30 minutes. Using the Porkbun API and Google Sheets, it instantly sends detailed notifications via Gmail and Discord the moment a domain becomes available, so you can secure it before anyone else. Why Use This Workflow? Time Savings: Eliminates hours of manual domain checking each week. Set your list once and let the automation monitor your targets 24/7. Competitive Edge: Gain a critical speed advantage in acquiring high-value or expiring domains the second they become available. Scalability: Effortlessly monitor hundreds of domains simultaneously without any extra effort or performance degradation. Ideal For Domain Investors:** Automatically track and snipe valuable expiring domains for their portfolio without constant manual checks. Marketing Agencies & SEO Specialists:** Secure brandable domains for new clients or build out private blog networks by catching domains as soon as they drop. Startups & Entrepreneurs:** Monitor desired brand names without the daily hassle, ensuring they get the perfect domain the moment it's available. How It Works Trigger: A schedule trigger initiates the workflow every 30 minutes. Data Collection: It retrieves a list of domains to monitor from a designated Google Sheet, specifically targeting rows marked as "no" for availability. Processing: The workflow iterates through each domain one by one. Intelligence Layer: It makes an API call to Porkbun to check the current availability of the domain. An IF node then determines if the domain is available (avail == yes). Output & Delivery: If a domain is available, the workflow sends a rich HTML email via Gmail and a formatted message to a Discord channel, complete with pricing details and a direct registration link. Storage & Logging: The Google Sheet is automatically updated to mark the domain as "available," preventing redundant notifications on future runs. Setup Guide Prerequisites | Requirement | Type | Purpose | |-------------|------|---------| | n8n instance | Essential | Workflow execution platform | | Porkbun Account | Essential | API Access for domain checks | | Google Cloud Platform | Essential | Storing domain list (Sheets) & sending alerts (Gmail) | | Discord Server | Optional | Real-time channel notifications | Installation Steps Import the JSON file to your n8n instance. Create a Google Sheet with two columns: Domain (e.g., example.com) and isAvailable (e.g., no). Configure credentials: Porkbun: Log in to Porkbun, go to API Access, create a new key, and copy the API Key and Secret Key into the HTTP Request nodes. A "Validate API KEY" node is included for testing your credentials. Google Sheets/Gmail: Authenticate your Google account for the Google Sheets and Gmail nodes. Discord: Create a Discord Bot and add the credentials to the Discord node. Update environment-specific values: Get Domains from Sheet: Enter your Google Sheet ID and select the correct sheet name. Send Email Alert: Set your recipient's email address in the "To" field. Send Discord Notification: Select your desired Server and Channel ID. Test execution: Add a domain you know is available to your Google Sheet (with isAvailable set to "no"). Run the workflow manually to verify that all connections work and you receive notifications. Technical Details Core Nodes | Node | Purpose | Key Configuration | |------|---------|-------------------| | Schedule Trigger | Initiates the workflow on a recurring basis. | Set the desired interval (default: 30 minutes). | | Google Sheets | Reads the domain list and updates its status. | Sheet ID, Sheet Name, and column mapping. | | SplitInBatches | Processes each domain from the list individually. | Batch size is set to 1 to check domains sequentially. | | HTTP Request | Queries the Porkbun API for domain availability. | Porkbun API endpoint and credentials. | | IF | Routes the workflow based on the API response. | Checks if response.avail equals "yes". | | Gmail | Sends a detailed email alert for available domains. | Recipient email, subject, and HTML body. | | Discord | Sends a concise notification to a Discord channel. | Server ID, Channel ID, and message content. | | Wait | Prevents API rate-limiting. | Pauses for 10 seconds between checking domains. | Workflow Logic The workflow is triggered by a schedule, fetching a list of domains from a Google Sheet. It uses the SplitInBatches node to loop through each domain sequentially. For every domain, it calls the Porkbun API. An IF node checks the response; if available, it triggers notifications and updates the Google Sheet. A Wait node is crucial for respecting API rate limits, ensuring the workflow runs smoothly even with large domain lists. Customization Options Basic Adjustments: Check Frequency**: Modify the "Schedule Trigger" node to run more or less frequently. Notification Channels**: Remove the Gmail or Discord nodes, or add new ones like Slack or Telegram. Email Content**: Customize the HTML in the Gmail node to match your branding. Advanced Enhancements: Auto-Registration**: Extend the workflow to use Porkbun's domain registration API endpoint to automatically purchase the domain when it becomes available (use with caution). Advanced Filtering**: Add logic to only send notifications for domains with specific TLDs (.com, .io, etc.) or that are not marked as "premium." Tiered Notifications**: Set up different notification channels based on the perceived value of the domain, sending high-priority alerts via SMS for critical domains. Troubleshooting Common Issues: | Problem | Cause | Solution | |---------|-------|----------| | Workflow fails at HTTP Request node | Invalid Porkbun API credentials. | Use the separate "Validate API KEY" node to test your keys directly. Regenerate them if needed. | | No domains are processed | Google Sheets node configuration error or the sheet is empty. | Verify the Sheet ID is correct and that the isAvailable column contains "no" for the domains you want to check. | | Authentication errors | Google or Discord credentials have expired or lack permissions. | Re-authenticate the respective nodes in the n8n credentials panel. | Created by: Khaisa Studio Category: Monitoring Tags: Porkbun, Domain, Automation, Google Sheets, Notifications Need custom workflows? Contact us Connect with the creator: Portfolio • Workflows • LinkedIn • Medium • Threads

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.

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.

⚠️ 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

Verified Visitor Pass Generator Overview Transform your visitor management process with this fully automated, enterprise-grade workflow. The Verified Visitor Pass Generator eliminates manual data entry, prevents fake registrations through email verification, and creates professional branded visitor passes in under 30 seconds. What This Workflow Does This comprehensive automation handles the complete visitor onboarding lifecycle: Captures Visitor Data - Receives form submissions via webhook from Jotform, Typeform, or any custom form Verifies Email Authenticity - Uses VerifiEmail API to validate emails and block disposable/fake addresses Generates Unique IDs - Creates visitor IDs with timestamps for tracking and security Creates QR Codes - Generates scannable QR codes containing visitor information for fast check-in Designs Digital Passes - Produces professional, branded visitor badges with HTML/CSS to Image Sends Email Notifications - Delivers passes to visitors with visit details and instructions Alerts Security Team - Posts real-time notifications to Slack with visitor details Maintains Audit Trail - Logs all visitor data to Google Sheets for compliance and reporting Key Features ✅ Email Verification - Blocks fake registrations (95%+ accuracy) ✅ Branded Badges - Customizable design with logo, colors, and QR codes ✅ Instant Delivery - Visitors receive passes within 30 seconds ✅ Real-Time Alerts - Security team gets Slack notifications immediately ✅ Complete Audit Trail - All visitor data logged to Google Sheets ✅ Mobile-Friendly - Passes work on any smartphone ✅ QR Code Integration - Fast scanning for contactless check-in ✅ Professional Templates - HTML email templates included ✅ Error Handling - Invalid emails automatically rejected ✅ Zero Manual Work - 100% automated from submission to delivery Perfect For 🏢 Coworking spaces and shared offices 🏛️ Corporate offices and headquarters 🎪 Event venues and conference centers 🏥 Healthcare facilities 🏫 Educational institutions 🏭 Manufacturing facilities 🏨 Hotels and hospitality venues Business Impact Before Automation: ⏱️ 10-15 minutes per visitor (manual process) 📝 Manual data entry errors 🔒 No email verification 📊 No centralized tracking 💸 High labor costs After Automation: ⚡ 30 seconds per visitor ✅ Zero manual work 🔐 Email verification prevents fraud 📈 Complete analytics and reporting 💰 99% cost reduction Use Cases Scenario 1: Daily Office Visitors A coworking space receives 50 visitors daily. The workflow automatically verifies each visitor, generates professional passes, and maintains a searchable database for security compliance. Scenario 2: Event Registration A conference venue uses the workflow for event check-in. Attendees receive QR-coded passes that security scans for instant verification. Scenario 3: Contractor Management A corporate office tracks all contractor visits with automated logging, ensuring compliance with safety regulations and insurance requirements. Customization Options Easy Customizations: Change company logo and branding colors Modify email templates and messaging Adjust badge design and layout Add custom visitor fields Update location and contact information Advanced Customizations: Add SMS notifications (Twilio integration) Implement visitor pre-approval workflow Create recurring visitor fast-track Add NDA/terms acceptance step Integrate with access control systems Build visitor analytics dashboard What Users Love ⭐⭐⭐⭐⭐ "Reduced our visitor processing time from 10 minutes to 30 seconds. Game changer!" ⭐⭐⭐⭐⭐ "The email verification feature stopped all fake registrations. Security team loves it." ⭐⭐⭐⭐⭐ "Professional badges make our coworking space look enterprise-grade. Clients are impressed." 🔧 Required Integrations & Credentials 1. VerifiEmail API (Required) Setup:** Sign up at https://verifi.email and get API token 2. HTMLCSSToImage API (Required) Setup:** Sign up at https://htmlcsstoimg.com and get API credentials 3. Gmail OAuth2 or SMTP (Required) Setup:** Connect Gmail account via OAuth2 in n8n 4. Slack API (Required) Setup:** Create Slack app and get OAuth token 5. Google Sheets OAuth2 (Required) Setup:** Connect Google account and create spreadsheet 🎯 Quick Start Guide Step 1: Setup Credentials Create VerifiEmail account and get API token Setup HTMLCSSToImage API credentials Connect Gmail account via OAuth2 Create Slack app and get bot token Connect Google Sheets account Step 2: Configure Nodes Update company name in HTML badge template Replace logo in badge design (line 76 in HTML/CSS node) Update email template with your contact info Set Slack channel ID for notifications Create Google Sheets with proper column headers Step 3: Test Workflow Click "Execute Workflow" with test data Verify email is sent to test address Check Slack notification appears Confirm data logs to Google Sheets Scan QR code to verify it works Step 4: Activate Toggle workflow to "Active" Copy webhook URL to your form Submit first real visitor registration Monitor execution logs for issues 📈 Monitoring & Analytics Track these metrics in Google Sheets: Total visitors processed Email verification success rate Peak visitor hours/days Most common visit purposes Visitor company frequency Average processing time 📄 License This workflow is provided as-is for use in your n8n instance. Feel free to modify and adapt to your needs.

This workflow contains community nodes that are only compatible with the self-hosted version of n8n. Stay ahead of market changes with this Automated Price Intelligence System! This workflow monitors e-commerce product prices 3x daily using advanced web scraping and AI analysis, tracking price changes, comparing against strategic thresholds, and sending intelligent alerts for competitive pricing opportunities. Perfect for e-commerce teams, retailers, and pricing strategists maintaining market competitiveness. What This Template Does Triggers 3x daily (9 AM, 3 PM, 9 PM) for continuous price monitoring. Configures global settings for products, thresholds, and alert recipients. Parses product targets and maps price thresholds by category (premium/default/budget). Uses Decodo scraper to extract real-time pricing data from e-commerce sites. Analyzes product pages with AI to extract structured price information. Logs all price data to Google Sheets for historical tracking and trend analysis. Evaluates prices against thresholds with AI-powered strategic recommendations. Classifies alerts as CRITICAL or STANDARD based on price drop severity. Sends targeted email alerts with strategic action recommendations. Key Benefits Continuous price monitoring across multiple e-commerce platforms AI-powered strategic recommendations for pricing decisions Historical price tracking for trend analysis and forecasting Multi-tier alert system for critical vs. standard price changes Automated competitive intelligence without manual monitoring Configurable thresholds for different product categories Features Triple-daily scheduling for comprehensive market coverage Multi-product monitoring with individual threshold configuration AI-powered price extraction and data structuring Real-time web scraping with Decodo integration Strategic alert classification (CRITICAL/STANDARD) Automated email notifications with actionable insights Google Sheets integration for data centralization Batch processing for efficient multi-product handling Quality assurance with auto-fixing output parsing Requirements Decodo API credentials for web scraping OpenAI API credentials for AI analysis Google Sheets OAuth2 credentials with edit access Gmail OAuth2 credentials for email alerts Environment variables for configuration settings Product URLs with internal tracking IDs Target Audience E-commerce and retail pricing teams Competitive intelligence analysts Pricing strategy and revenue optimization teams E-commerce marketing and sales teams Retail operations and category managers Digital agency e-commerce specialists Step-by-Step Setup Instructions Connect Decodo API credentials for reliable web scraping Set up OpenAI credentials for AI price analysis and strategy recommendations Configure Google Sheets for price history tracking and logging Add Gmail credentials for critical and standard alert notifications Define your product URLs with internal IDs and threshold types Set price thresholds for premium, default, and budget categories Configure alert recipients for different notification levels Test with sample product URLs to verify data extraction and alerting Activate for automated triple-daily price intelligence monitoring Pro Tip: Use coupon code "YARON" to get 23K requests for testing the workflow using the Decodo scraping platform This workflow ensures you never miss a pricing opportunity with automated monitoring, intelligent analysis, and strategic alerting!

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!

AI Powered All Purpose Appointment System via JotForm What This Workflow Does This template automates the entire appointment request lifecycle using AI. When someone submits an appointment request through JotForm, the system automatically sends details for approval, generates personalized confirmation or rejection emails using OpenAI, and maintains records—all without manual intervention. 👉 Get JotForm here Whether you're running a clinic, consulting business, training center, or any service-based operation, this workflow eliminates repetitive email writing and ensures consistent, professional communication. It's fully customizable to work with any appointment form structure. Who's It For Service providers (consultants, trainers, coaches) Healthcare professionals Educational institutions Salon and wellness businesses Event coordinators Any business handling appointment requests at scale How It Works Form Submission – Appointment request arrives via JotForm Data Extraction – System pulls name, email, phone, date, time, and visit type Approval Request – Details are sent to Telegram for review and approval AI Email Generation – OpenAI creates personalized confirmation or rejection email based on approval status Smart Routing – If approved: records in Google Sheets and sends confirmation. If rejected: removes from system and sends reschedule notice Automated Follow-up – Requester receives professional email instantly Getting Started (Quick Setup) Step 1: Choose Your JotForm Select any existing appointment form or create a new one in JotForm The workflow works with any form structure Step 2: Map Your Form Fields Identify the field names in your JotForm (name, email, phone, appointment date, time, etc.) Update the "Parse: Extract Appointment Details" node with your exact field names This ensures the workflow reads data correctly from your specific form Step 3: Follow Full Setup Steps Connect JotForm – Copy the Form ID and API Key Configure Google Sheets – Create a sheet for appointment records and copy the spreadsheet ID Setup Telegram – Create a bot via BotFather for approval notifications Add OpenAI Credentials – Generate an API key at platform.openai.com Authorize Gmail – Enable Gmail API in Google Cloud Console Why This Is Customizable The workflow is built to be flexible from the start. Whether your form collects appointment type, service category, special requests, or any other field, you can easily map those fields into the flow. Just identify what data your form collects and tell the workflow where to find it. Requirements JotForm account with an appointment form Google Sheets for record keeping Telegram account and bot (for approvals) OpenAI API key (paid account recommended) Gmail account for sending emails n8n instance (self-hosted or cloud) How to Customize Change Approval Channel** – Replace Telegram with Slack, Discord, or email by swapping the notification node Modify Email Templates** – Edit the AI prompt in "Generate: Appointment Response Email" to match your tone and branding Add More Fields** – Update the Set node to capture additional information from your JotForm like appointment type, service category, or special requests Adjust Routing Logic** – Modify the conditional node to add approval stages or auto-confirm certain appointment types Connect CRM** – Add steps to automatically create contacts in HubSpot, Pipedrive, or Salesforce Enable Reminders** – Use Gmail or SMS nodes to send appointment reminders 24 hours before scheduled time Extend Data Collection** – Map any custom fields from your JotForm by updating the extraction node to include them

This is a fully working n8n workflow that sends prescriptions to patients via email and WhatsApp when a doctor enters prescription data into a Google Sheet. 📋 Google Sheets Structure Main Sheet: Required columns: prescription_id (unique ID) patient_name patient_email patient_phone doctor_name prescription_date prescription_details dosage_instructions followup_date (optional) prescription_status (set to "new" for new prescriptions) Log Sheet: This will be auto-created with columns for tracking sent notifications. 🔧 Required Credentials Setup Google Sheets OAuth2 API: Connect your Google account SMTP Credentials: For email sending (Gmail, Outlook, etc.) WhatsApp API: Meta Business WhatsApp API credentials ⚙️ Configuration Steps Replace YOUR_GOOGLE_SHEET_ID with your actual Google Sheet ID Replace YOUR_WHATSAPP_PHONE_NUMBER_ID with your WhatsApp Business phone number ID Update the email sender address in the "Send Email" node Set up your credentials in n8n 🌟 Features Included Automated Trigger**: Monitors Google Sheet for new prescriptions Smart Filtering**: Only processes prescriptions with status "new" Rich Email Format**: Professional HTML email with prescription details WhatsApp Integration**: Sends formatted prescription text Comprehensive Logging**: Tracks all sent notifications Status Updates**: Marks prescriptions as "sent" after processing Error Handling**: Logs success/failure status for both channels 📱 Sample Data Format Add rows to your sheet like this: prescription_id: RX001 patient_name: John Doe patient_email: john@email.com patient_phone: +1234567890 doctor_name: Dr. Smith prescription_date: 2025-01-15 prescription_details: Amoxicillin 500mg capsules dosage_instructions: Take 1 capsule 3 times daily with food followup_date: 2025-01-22 prescription_status: new

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

Email Automation Workflow Template This n8n template demonstrates how to automate email classification, labeling, draft generation, and logging using Gmail, OpenAI, and Google Sheets. Use cases include customer support management, sales inquiry handling, and keeping track of incoming emails efficiently in a structured way. Good to know Gmail OAuth2 credentials are required for sending, labeling, and drafting emails. OpenAI credentials are needed for generating draft responses. Google Sheets must have Logs and Errors sheets with the correct columns (Original Email, Decision, Output Email for Logs; Node with Error, Error Message, Time, Execution ID, Workflow ID for Errors). The workflow is designed to handle multiple emails simultaneously and continues even if a node fails. How it works The workflow is triggered by new emails in Gmail. Emails are classified into categories: Support, Sales, Complaints, Information, or Other. Based on the classification: Support and Sales emails → Draft response generated with OpenAI and labeled in Gmail. Complaints, Information, and Other → Emails labeled accordingly. All processed emails and generated outputs are logged in Google Sheets (Logs). Any workflow errors are captured in the Errors sheet for debugging. How to use Test with a sample email to confirm classification, draft generation, labeling, and logging work correctly. Update Google Sheets nodes with your document ID and sheet names. Requirements Gmail account with OAuth2 credentials OpenAI account for draft generation Google Sheets account for logging Customizing this workflow Add new email categories or refine existing ones. Adjust draft responses or templates for Support/Sales. Integrate with other apps or systems for more advanced automation (e.g., CRM updates, notifications).

How it Works This workflow automatically monitors your Gmail support inbox every minute for new unread messages, instantly sending each email to OpenAI for intelligent analysis. The AI engine evaluates sentiment (Positive/Neutral/Negative/Critical), urgency level (Low/Medium/High/Critical), and categorizes requests into Technical, Billing, Feature Request, Bug Report, or General Inquiry, while extracting key issues and generating professional response templates. The system calculates a priority score (0-110 points) by combining urgency weight (25 points per level) with sentiment impact (10 points per level), automatically flagging any Critical urgency or Critical sentiment tickets for immediate attention. Critical issues trigger instant Slack alerts with full context, suggested responses, and 30-minute SLA reminders, while routine tickets route to monitoring channels for standard processing. Every ticket is logged to Airtable with complete analysis data and thread tracking, then simultaneously posted to a Google Sheets analytics dashboard for real-time metrics. A secondary AI pass generates strategic insights including trend identification, risk assessment, and actionable recommendations for the support team, storing these insights back in Airtable linked to the original ticket. The entire process takes seconds from email arrival to team notification, eliminating manual triage and ensuring critical customer issues receive immediate attention while building a searchable knowledge base of support patterns. Who is this for? Customer support teams drowning in high email volumes needing automated prioritization SaaS companies tracking support metrics and response times for customer satisfaction Startups with lean support teams requiring intelligent ticket routing and escalation E-commerce businesses managing technical support, returns, and billing inquiries simultaneously Support managers needing data-driven insights into customer pain points and support trends Setup Steps Setup time: Approx. 20-30 minutes (OpenAI API, Gmail connection, database setup) Requirements: Gmail account with support email access OpenAI API account with API key Airtable account with workspace access Google Sheets for analytics dashboard Slack workspace with incoming webhooks Sign up for OpenAI and obtain your API key for the AI analysis nodes. Create an Airtable base with two tables: "tblSupportTickets" (main records) and "tblInsights" (AI insights) with matching column names. Create a Google Sheet with columns for Date, Time, Customer, Email, Subject, Sentiment, Urgency, Category, Priority, Critical, Status. Set up these nodes: Monitor Support Emails: Connect Gmail account, configure to check INBOX label for unread messages. AI Analysis Engine: Add OpenAI credentials and API key, system prompt pre-configured. Parse & Enrich Data: JavaScript code automatically extracts and scores data (no changes needed). Route by Urgency: Configure routing rules to split critical vs. routine tickets. Slack Alert Nodes: Set up webhook URLs for critical alerts channel and routine monitoring channel. Log to Airtable Database: Connect Airtable, select base and table, map all data fields. Update Analytics Dashboard: Connect Google Sheets and select target sheet/range. Generate Insights & Store AI Insights: OpenAI credentials already set, Airtable connection for storage. Replace placeholder IDs: Airtable base ID (appXXXXXXXXXXXXXX), table names, Google Sheet document ID (1XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX). Credentials must be entered into their respective nodes for successful execution. Customization Guidance Priority Scoring Formula:** Adjust urgency multiplier (currently 25) and sentiment weight (currently 10) in the Code node to match your SLA requirements. Urgency Thresholds:** Modify critical routing logic—currently any "Critical" urgency or sentiment triggers immediate alerts. AI Analysis Temperature:** Lower OpenAI temperature (0.1-0.2) for more consistent categorization, or raise (0.4-0.5) for nuanced sentiment detection. Polling Frequency:** Change Gmail trigger from every minute to every 5/15/30 minutes based on support volume and urgency needs. Email Filters:** Add sender whitelist/blacklist, specific label filters, or date ranges to focus on particular customer segments. Category Customization:** Modify AI system prompt to add industry-specific categories like "Compliance," "Integration," "Onboarding," etc. Multi-Language Support:** Add language detection and translation steps before AI analysis for international support teams. Auto-Response:** Insert Gmail send node after AI analysis to automatically send suggested responses for low-priority inquiries. Escalation Rules:** Add additional routing for VIP customers, enterprise accounts, or tickets mentioning "cancel/refund." Dashboard Enhancements:** Connect to Data Studio, Tableau, or Power BI for advanced support analytics and team performance tracking. Once configured, this workflow transforms your support inbox into an intelligent triage system that never misses critical issues, provides instant team visibility, and builds actionable customer insights—all while your team focuses on solving problems instead of sorting emails. Built by Daniel Shashko Connect on LinkedIn