by Punit
HubSpot Customer Onboarding Automation Overview Streamline your customer onboarding process with this intelligent automation that triggers when new contacts are created in HubSpot. The workflow automatically sends personalized welcome emails, schedules onboarding calls, and assigns customer success managers - ensuring every new customer receives immediate attention and proper support. What This Workflow Does Core Features Real-time Contact Detection**: Monitors HubSpot for new contact creation events via webhooks Intelligent Email Generation**: Uses AI to create personalized welcome emails based on contact information Automated Calendar Scheduling**: Finds available time slots and schedules onboarding calls with new contacts Smart CSM Assignment**: Automatically assigns contacts to appropriate customer success managers Multi-channel Communication**: Sends HTML-formatted emails with professional styling Calendar Integration**: Full Google Calendar management with attendee invitations Business Value Instant Response**: New customers receive immediate welcome communication Personalization at Scale**: Each email is uniquely crafted based on contact details and company information Process Consistency**: Ensures every new contact follows the same high-quality onboarding process Resource Optimization**: Automatically schedules meetings in available time slots Customer Experience**: Professional, timely communication builds trust from day one Prerequisites Required Accounts & Credentials HubSpot Account with Developer API access for webhooks HubSpot Pro/Enterprise for OAuth2 API access OpenAI API access for AI-powered email generation Google Calendar account for meeting scheduling Gmail account for email delivery Public-facing n8n instance or n8n Cloud for webhook reception Technical Requirements HubSpot webhook subscription capabilities Google Workspace or personal Google account OpenAI API with GPT-4o access n8n instance with LangChain nodes package installed Setup Instructions Step 1: HubSpot Developer Setup Create HubSpot Developer Account: Go to HubSpot Developer Portal Create or access your developer account Navigate to Apps section Create Webhook Subscription: In HubSpot Developer Portal: Apps > Create App Configure webhook subscription for contact.creation events Set webhook URL to your n8n webhook endpoint Note the App ID and Developer API key Add HubSpot Developer Credentials: In n8n: Settings > Credentials > "HubSpot Developer API" Enter Developer API key and App ID Step 2: HubSpot OAuth2 Configuration Create OAuth2 App: In HubSpot Developer Portal: Create OAuth2 app Add required scopes: contacts.read contacts.write crm.objects.owners.read Add HubSpot OAuth2 Credentials: In n8n: Settings > Credentials > "HubSpot OAuth2 API" Complete OAuth authorization flow Step 3: OpenAI Configuration Get OpenAI API Key: Visit OpenAI Platform Create API key with GPT-4o model access Add OpenAI Credentials: In n8n: Settings > Credentials > "OpenAI API" Enter your API key Step 4: Google Calendar Setup Enable Google Calendar API: Go to Google Cloud Console Enable Google Calendar API Create OAuth2 credentials Add Google Calendar Credentials: In n8n: Settings > Credentials > "Google Calendar OAuth2 API" Complete OAuth authorization flow Step 5: Gmail Configuration Enable Gmail API: In Google Cloud Console: Enable Gmail API Use same OAuth2 credentials as Calendar Add Gmail Credentials: In n8n: Settings > Credentials > "Gmail OAuth2" Complete OAuth authorization Step 6: Customize Company Information Update "Enter your company data here" Node: company_name: "Your Company Name" sender_name: "Your Name" sender_email: "your-email@company.com" company_activity: "Your company description" Important: The sender_email must match your HubSpot user email and Google account email Step 7: Configure Calendar Settings Update Calendar Agent Tool: Verify calendar ID matches your Google Calendar Ensure proper timezone settings Test calendar access permissions Configuration Details Webhook Event Handling The workflow processes HubSpot webhook events: Event Type**: contact.creation Data Processing**: Extracts contact ID and subscription type Validation**: Ensures event is contact creation before proceeding AI Email Generation System The email generation process uses: Model**: GPT-4o-mini for cost-effective, high-quality content Structured Output**: JSON format with subject and body fields Personalization Variables**: Contact name, email, company information Template Consistency**: Maintains professional tone and branding Calendar Management Features The calendar agent provides: Event Creation**: With and without attendees Event Retrieval**: Find available time slots Event Updates**: Modify existing appointments Event Deletion**: Remove canceled meetings Smart Scheduling**: Automatically finds next available slot Contact Assignment Logic The CSM assignment process: Owner Lookup**: Retrieves all HubSpot owners Sender Matching**: Finds owner matching the configured sender email Contact Assignment**: Updates contact record with owner ID Usage Instructions Automatic Operation Activate Workflow: Toggle workflow to "Active" status Webhook automatically registers with HubSpot Test with New Contact: Create test contact in HubSpot Monitor n8n execution log Verify email delivery and calendar event creation Monitor Performance: Check HubSpot webhook delivery logs Review email delivery success rates Validate calendar event creation Manual Testing Create Test Contact: Add new contact in HubSpot with complete information Ensure contact has valid email address Monitor workflow execution Validate Outputs: Email: Check recipient inbox for welcome email Calendar: Verify meeting invitation sent and accepted HubSpot: Confirm contact owner assignment Logs: Review n8n execution for any errors Expected Outputs Personalized Welcome Email AI-generated email featuring: Subject Line**: Customized based on company and contact information Personalized Greeting**: Uses contact's first name and relevant details Company Introduction**: Includes sender name, company name, and business description Meeting Notification**: Mentions upcoming scheduled onboarding call Professional Formatting**: HTML-styled for professional appearance Scheduled Onboarding Call Google Calendar event with: Title**: Descriptive meeting title including contact name Attendees**: New contact automatically invited Timing**: Next available 1-hour slot in sender's calendar Location**: Virtual meeting details (if configured) Description**: Meeting purpose and agenda HubSpot Contact Updates Automated contact management: Owner Assignment**: Contact assigned to appropriate CSM Activity Logging**: Webhook event recorded in contact timeline Data Enrichment**: Additional contact information if available Calendar Tool Responses Structured responses from calendar operations: Success Confirmations**: Meeting created successfully Error Handling**: Clear error messages for failed operations Event Details**: Complete information about created/modified events Troubleshooting Common Issues HubSpot Webhook Not Triggering Cause: Webhook subscription not properly configured or n8n endpoint not accessible Solutions: Verify n8n webhook URL is publicly accessible Check HubSpot webhook subscription settings Confirm webhook is active in HubSpot Developer Portal Test webhook delivery using HubSpot's testing tools Contact Information Not Retrieved Cause: Insufficient HubSpot API permissions or invalid contact ID Solutions: Verify HubSpot OAuth2 scopes include contact read permissions Check contact ID extraction from webhook payload Ensure contact exists and is accessible via API Test contact retrieval manually Email Generation Failed Cause: OpenAI API issues or insufficient token limits Solutions: Check OpenAI API key validity and usage limits Verify GPT-4o model access permissions Review prompt complexity and token requirements Test AI generation with simpler prompts Calendar Event Creation Failed Cause: Google Calendar permissions or invalid calendar ID Solutions: Verify Google Calendar OAuth2 permissions Check calendar ID configuration matches sender email Ensure calendar is accessible and not restricted Test calendar operations manually Gmail Delivery Problems Cause: Authentication issues or email formatting problems Solutions: Check Gmail OAuth2 token validity Verify sender email matches authenticated account Review HTML formatting for email compatibility Test email delivery with simple text format Performance Optimization High Contact Volume Implement rate limiting for API calls Add error retry mechanisms with exponential backoff Monitor token usage and API quotas Consider batch processing for multiple contacts Large Calendar Schedules Optimize calendar queries with specific date ranges Implement caching for frequently accessed calendar data Add timeout handling for slow calendar operations Consider pagination for large event lists Customization Examples Different CRM Systems Replace HubSpot with alternative CRMs: Salesforce**: Use Salesforce webhook and contact management Pipedrive**: Implement Pipedrive person creation triggers Zoho CRM**: Configure Zoho webhook subscriptions Airtable**: Use Airtable as simple CRM with webhooks Alternative Email Providers Replace Gmail with other email services: SendGrid**: Use SendGrid for transactional emails Mailgun**: Implement Mailgun email delivery Microsoft Outlook**: Use Outlook for business email AWS SES**: Configure Amazon Simple Email Service Enhanced Email Content Improve email personalization: Company Research**: Add web scraping for company information Industry-Specific Templates**: Different emails for different industries Multi-language Support**: Detect contact language and localize content Dynamic Content**: Include relevant resources based on contact properties Advanced Calendar Features Extend calendar functionality: Buffer Time**: Automatically add buffer between meetings Meeting Types**: Different durations for different contact types Timezone Handling**: Automatic timezone detection and conversion Recurring Meetings**: Schedule follow-up meetings automatically Workflow Branching Add conditional logic: Contact Source**: Different flows for different lead sources Company Size**: Tailored onboarding for enterprise vs SMB Geographic Routing**: Regional CSM assignment Product Interest**: Specialized onboarding based on product selection Security Considerations API Security Store all credentials securely in n8n credential system Use OAuth2 authentication where available Regularly rotate API keys and refresh tokens Monitor API usage for unauthorized access Data Privacy Ensure compliance with data protection regulations (GDPR, CCPA) Implement data retention policies for contact information Consider data encryption for sensitive customer data Document data flows for privacy audits Webhook Security Implement webhook signature verification where supported Use HTTPS endpoints for all webhook URLs Monitor webhook delivery logs for suspicious activity Consider IP whitelisting for webhook sources Integration Considerations HubSpot Best Practices Rate Limiting**: Respect HubSpot API rate limits Error Handling**: Implement proper error responses for webhooks Data Sync**: Ensure data consistency between systems Backup Procedures**: Regular backup of workflow configurations Email Deliverability Authentication**: Implement SPF, DKIM, and DMARC records Content Quality**: Avoid spam triggers in email content List Management**: Respect unsubscribe requests Monitoring**: Track email delivery and engagement metrics Business Process Integration Sales Handoff Lead Qualification**: Integrate with lead scoring systems Sales Notification**: Alert sales team of high-value prospects CRM Updates**: Sync onboarding status with sales pipeline Activity Tracking**: Log all onboarding activities in CRM Customer Success Workflows Milestone Tracking**: Monitor onboarding progress Health Scoring**: Assess customer engagement levels Escalation Procedures**: Flag at-risk customers for intervention Success Metrics**: Track onboarding completion rates Support and Maintenance Regular Maintenance Monitor webhook delivery success rates Review email open and response rates Update AI prompts based on feedback Audit calendar scheduling efficiency Performance Monitoring Track workflow execution times and success rates Monitor API usage and costs across all services Review customer feedback on onboarding experience Analyze conversion rates from onboarding to activation Updates and Improvements Stay updated with API changes from integrated services Test workflow compatibility with platform updates Implement customer feedback and feature requests Document all customizations for team reference Cost Optimization API Usage Management Monitor OpenAI token consumption patterns Optimize prompts for efficiency and effectiveness Track Google API usage for calendar and email operations Implement usage alerts and budgets Alternative Approaches Consider using local AI models for email generation Implement template-based emails for cost reduction Use free tiers where available and appropriate Regular cost-benefit analysis of integrated services License and Attribution This workflow template is provided under MIT license. Calendar agent implementation inspired by Nate Herk's YouTube channel. Attribution to original creators appreciated when sharing or modifying. Users are responsible for compliance with all integrated services' terms of service and data handling requirements. Support Contact For customizations, troubleshooting, or additional workflow development: Email**: punit@geekfleet.dev Creator Profile**: n8n Creator Profile Specializations**: n8n, Make, LangChain, and LangGraph workflow development
by Rahul Joshi
📊 Description Streamline your HR recruitment process with this intelligent automation that reads candidate emails and resumes, analyzes them using GPT-4, and automatically shortlists or rejects applicants based on skill and experience match. 📩🤖 The workflow updates your HR Google Sheet with detailed AI evaluations, notifies recruiters on Slack about high-scoring candidates, and sends personalized shortlist or rejection emails to applicants — all in one seamless flow. 🚀 What This Template Does 1️⃣ Trigger – Monitors the HR Gmail inbox for new job applications with attachments. 📬 2️⃣ Extracts Resume Data – Uploads attached resumes to Mistral OCR to extract text for analysis. 📄 3️⃣ Combines Inputs – Merges candidate email data and resume content for complete context. 🔗 4️⃣ AI Evaluation – GPT-4 analyzes the candidate’s qualifications against job requirements in a connected Google Sheet. 🧠 5️⃣ Scoring & Recommendation – Generates a structured JSON output with job fit summary, skill match, AI score, and recommendation (Shortlist or Reject). 📊 6️⃣ Record Update – Logs AI evaluation results in a Google Sheet for centralized tracking. 📋 7️⃣ Communication – Sends professional shortlist or rejection emails to applicants via Gmail. 💌 8️⃣ Team Alert – Notifies HR on Slack when a high-scoring candidate is detected. 🔔 Key Benefits ✅ Saves hours of manual resume screening and sorting ✅ Ensures consistent, unbiased candidate evaluation ✅ Provides detailed AI-driven insights for every applicant ✅ Automates communication and record-keeping ✅ Improves HR productivity and response speed Features Gmail trigger for new candidate emails Resume text extraction via Mistral OCR API GPT-4–powered resume and email evaluation Integration with Google Sheets for HR requirement mapping Slack notifications for shortlisted candidates Automated shortlist/rejection emails with custom templates Structured AI output for analytics and reporting Requirements Gmail OAuth2 credentials for inbox and email automation Google Sheets OAuth2 credentials with edit access OpenAI API key (GPT-4 or GPT-4o-mini) Slack Bot token with chat:write permissions Mistral AI OCR API key for resume text extraction Target Audience HR and recruitment teams managing large applicant volumes 🧑💼 Talent acquisition managers looking for AI-driven screening 🤖 Organizations standardizing hiring communication 💬 Agencies building automated candidate evaluation systems 📈 Step-by-Step Setup Instructions 1️⃣ Connect your Gmail account and configure the inbox trigger. 2️⃣ Add Mistral API credentials for resume OCR extraction. 3️⃣ Set up your Google Sheet with job role requirements and access credentials. 4️⃣ Add OpenAI credentials (GPT-4 or GPT-4o-mini) for AI evaluation. 5️⃣ Configure Slack credentials and HR channel ID for alerts. 6️⃣ Test with a sample application to ensure correct data mapping. 7️⃣ Activate the workflow to start automated recruitment processing. ✅
by WeblineIndia
iOS Environment Config Sync Wizard: .env to Xcode This workflow automatically detects changes to .env.staging files, compares them against iOS Xcode configuration files, creates pull requests to sync values, and invalidates Xcode build caches when needed. It ensures consistency between environment files and iOS project configs while automating the propagation of changes across the codebase and notifying the team via email. Quick Implementation Steps Import the workflow JSON into your n8n instance Set up credentials for GitHub and email Configure the webhook URL in your Git repository Customize configuration parameters in the "Set Configuration" node Activate the workflow What It Does The Environment Config Sync for iOS Xcode Projects workflow is designed to maintain consistency between environment configuration files and iOS project configuration files. When changes are made to .env.staging, the workflow automatically detects these changes, determines which iOS configuration files need to be updated, creates a new branch with those updates, and opens a pull request for review. The workflow analyzes the differences between the environment file and iOS configs, identifies which values need to be synchronized, and applies these changes to the appropriate files. It also checks if any of the changed values require cache invalidation and handles this automatically. Finally, it sends a detailed email notification to the iOS team with information about the sync operation. This automation reduces manual work, ensures consistency between configuration files, and helps prevent issues caused by mismatched environment settings across different parts of the iOS build system. Who's It For This workflow is ideal for: iOS development teams managing environment-specific configurations DevOps engineers responsible for maintaining Xcode project configuration consistency Mobile app developers working with multiple environment configurations Teams implementing CI/CD best practices for iOS applications Organizations using environment files to manage build-time configurations for Xcode projects Requirements n8n instance (self-hosted or cloud) GitHub repository with iOS project files Email service (SMTP) for sending notifications .env.staging file or similar environment configuration file iOS configuration files (Info.plist, Config.xcconfig, etc.) How It Works Webhook Trigger: The workflow starts when a push event occurs in the GitHub repository Configuration Setup: Sets up configurable parameters for file paths, branches, and notification settings File Change Detection: Checks if the .env.staging file was modified in the push Config Diff Analysis: Compares the .env.staging file with iOS Xcode configurations to identify differences Branch Creation: Creates a unique branch name and creates a new branch in the repository File Update Preparation: Prepares the updated content for each configuration file File Updates: Updates each configuration file in the new branch with the synced values PR Creation: Creates a pull request with all the configuration changes Cache Invalidation: Invalidates Xcode build cache if necessary based on changed keys Email Notification: Sends a detailed email notification about the completed sync operation How To Set Up Steps to Configure and Use 1\. Import the Workflow Import the provided JSON file into your n8n instance 2\. Set Up Credentials GitHub**: Create a new credential with a GitHub personal access token with repo scope Email**: Create a new credential with your SMTP server details for sending emails 3\. Configure GitHub Webhook Go to your GitHub repository settings Navigate to Webhooks and click "Add webhook" Set the Payload URL to the webhook URL from your n8n workflow Select "application/json" as the content type Choose "Let me select individual events" and select "Push events" Click "Add webhook" 4\. Configure Parameters Modify the parameters in the "Set Configuration" node to match your project structure: envFilePath**: Path to your environment file (default: ".env.staging") configFiles**: Array of iOS config files to update (default: \["Info.plist", "Config.xcconfig"\]) targetBranch**: Branch to create PRs against (default: "main") cacheInvalidationKeys**: Keys that trigger cache invalidation (default: \["API\_KEY", "BUNDLE\_VERSION", "ENVIRONMENT"\]) prLabels**: Labels to apply to created PRs (default: \["config-sync", "automated", "ios"\]) emailTo**: Email address for notifications (default: "ios-team@example.com") 5\. Configure Email Settings In the "Send Email Notification" node, update the "fromEmail" parameter to match your sending email address Ensure your SMTP credentials are properly configured in n8n 6\. Activate the Workflow Once all configurations are complete, activate the workflow Test by making a change to your .env.staging file and pushing it to the repository How To Customize Add More Config Files**: Update the configFiles parameter in the "Set Configuration" node to include additional iOS configuration files like .xcconfig files or project.pbxproj Modify Cache Invalidation Logic**: Update the cacheInvalidationKeys parameter to change which keys trigger cache invalidation Customize PR Content**: Edit the "Create PR" node to modify the PR title, body, or labels Change Email Notifications**: Update the "Send Email Notification" node to modify the email format, subject, or add additional recipients Implement Actual Cache Invalidation**: Modify the "Invalidate Cache" node to implement actual Xcode cache invalidation logic for your CI/CD system Add More Environment Files**: Extend the workflow to monitor additional environment files beyond .env.staging Add‑ons Multi-Environment Support: Extend the workflow to handle multiple environment files (.env.development, .env.production) with different target branches and configurations Configuration Validation: Add validation steps to ensure that environment values match expected formats or patterns before creating PRs Automated PR Merging: Add logic to automatically merge PRs if all checks pass and no conflicts are detected Configuration History Dashboard: Integrate with a database to track configuration changes over time and provide analytics Team Approval Workflow: Add approval steps that require team members to review and approve configuration changes before PRs are created Use Case Examples API Key Rotation: When security policies require rotating API keys, the workflow automatically updates all iOS configuration files with the new keys and invalidates the Xcode build cache to ensure the changes take effect immediately. Environment Promotion: When promoting configurations from staging to production, the workflow ensures that all iOS project files are consistently updated across the codebase, preventing deployment issues caused by mismatched configurations. Bundle Version Updates: When updating bundle versions in .env.staging for a new App Store release, the workflow automatically updates version strings in Info.plist files, ensuring version consistency for App Store submission. Feature Flag Management: When feature flags are added or modified in .env.staging, the workflow propagates these changes to Config.xcconfig files, ensuring that feature flags are consistently available throughout the iOS application. Multi-Target Projects: In projects with multiple iOS targets (e.g., app, extension, watchOS), the workflow can be extended to update configuration files across all targets when environment variables change, ensuring consistency throughout the application ecosystem. Troubleshooting Guide | Issue | Possible Cause | Solution | | --- | --- | --- | | Webhook not triggering | Webhook URL not configured correctly in GitHub | Verify the webhook URL is correctly copied and configured in your GitHub repository settings | | Changes not detected | .env.staging file path doesn't match configuration | Check the envFilePath parameter in the "Set Configuration" node and ensure it matches your file structure | | Branch creation fails | GitHub token doesn't have sufficient permissions | Ensure the GitHub personal access token has the "repo" scope and access to the target repository | | File updates fail | Config file paths don't exist in the repository | Verify the configFiles parameter in the "Set Configuration" node matches actual file paths in your repository | | PR creation fails | Target branch doesn't exist or insufficient permissions | Verify the targetBranch parameter matches an existing branch and the GitHub token has appropriate permissions | | Email notifications not sent | Email credentials not configured or incorrect | Verify your SMTP credentials are correctly configured in n8n and the email address in the "Send Email Notification" node is valid | | Cache invalidation not working | Cache invalidation logic not implemented for your CI/CD system | Modify the "Invalidate Cache" node to implement the appropriate Xcode cache invalidation mechanism for your CI/CD system | | PRs created with no changes | Diff logic not properly detecting differences | Review the "Perform Config Diff" node and ensure it correctly identifies differences between environment and iOS config files | | Workflow stops after file change detection | Workflow logic error in code nodes | Check the JavaScript code in the "Perform Config Diff" node for syntax errors or logic issues | Want to Customize ? Need help setting up or customizing this Environment Config Sync for iOS Xcode Projects workflow? The n8n experts at WeblineIndia can assist you with: Customizing the workflow to fit your specific iOS project structure Integrating with additional tools and services in your CI/CD pipeline Implementing advanced configuration validation and management Setting up multi-environment support and promotion workflows Training your team on iOS configuration management best practices
by Hassan
Overview This sophisticated n8n workflow transforms raw LinkedIn leads into personalized, high-converting connection requests using GPT-4O AI and PhantomBuster automation. The system processes LinkedIn profile data, generates authentic icebreakers, and automatically sends connection requests twice daily, creating a hands-off lead generation machine that maintains human authenticity while scaling outreach efforts. Key Benefits 🤖 AI-Powered Personalization Generate unique, human-like icebreakers for every LinkedIn connection request using GPT-4O, ensuring each outreach feels personal and authentic rather than automated. ⚡ Automated Workflow Execution Run your entire lead generation pipeline automatically twice daily (10 AM and 5 PM) USA Time with zero manual intervention required. 📊 Smart Data Management Seamlessly manage leads across multiple Google Sheets with automatic data cleanup, duplicate prevention, and organized lead tracking. 🎯 PhantomBuster Integration Leverage PhantomBuster's powerful LinkedIn automation to send connection requests at scale while maintaining platform compliance. 📈 Scalable Processing Process leads in optimized batches of 10 to maintain quality while scaling your outreach efforts effectively and remain within LinkedIn’s weekly connection request limits. 📧 Real-Time Monitoring Receive email notifications whenever connection requests are sent, keeping you informed of your campaign progress. 🔄 Continuous Operation Self-maintaining system that processes new leads, cleans up completed tasks, and prepares for the next cycle automatically. 💼 Professional Template System Uses proven icebreaker templates that follow the format: "Hey [name], loved seeing [personalized detail]. I'm also into [relevant connection], thought I'd connect." How It Works Phase 1: Lead Acquisition & Processing The workflow begins with scheduled triggers that activate twice daily. Upon activation, the system first cleans up previously processed leads from the source Google Sheet to prevent duplicates. It then retrieves fresh LinkedIn profile data including names, titles, company information, locations, and profile URLs. Phase 2: AI-Powered Personalization Engine Retrieved leads are processed in batches of 10 through a sophisticated GPT-4O integration. The AI analyzes each LinkedIn profile and generates personalized icebreakers following a proven template structure. The system is specifically programmed to paraphrase LinkedIn information rather than copy it directly, ensuring messages feel human-written rather than automated. Phase 3: Data Storage & Campaign Launch Processed leads with their AI-generated icebreakers are stored in a dedicated Google Sheet for tracking and analysis. The system then aggregates all processed data and triggers a PhantomBuster agent that executes the actual LinkedIn connection requests using the personalized messages. Phase 4: Cleanup & Notification After successful campaign launch, the system removes processed leads from the source sheet, sends email confirmation notifications, and prepares for the next scheduled execution cycle. Required Setup & Dependencies Core Integrations: Google Sheets API access with OAuth2 authentication OpenAI API key for GPT-4O access PhantomBuster account with API key and configured LinkedIn agent Gmail account for notifications Google Sheets Structure: Source Sheet: Contains raw LinkedIn data (firstName, lastName, title, companyName, location, etc.) Destination Sheet: Stores processed leads with icebreakers and tracking information PhantomBuster Configuration: LinkedIn connection request automation agent Proper agent ID configuration in the HTTP request node Valid API key with sufficient credits Business Use Cases Sales Development Representatives (SDRs) Automate personalized outreach to potential clients while maintaining the human touch that drives connection acceptance rates. Recruitment Agencies Scale candidate outreach with personalized messages that reference specific experience and skills from LinkedIn profiles. Business Development Generate partnerships and collaboration opportunities through targeted, personalized connection requests to industry leaders. Coaches & Consultants Build professional networks by connecting with potential clients using AI-generated icebreakers that reference their specific challenges and opportunities. Marketing Agencies Develop client relationships through personalized outreach that demonstrates understanding of their business and industry. Revenue Potential Direct Lead Generation: Process 20 leads daily (10 per execution × 2 runs) Average 25% connection acceptance rate = 5 new connections daily Convert 10% of connections to qualified leads = 15 qualified leads monthly Close 20% of qualified leads at $2,000 average deal size = $6,000 monthly revenue Agency Services: Offer as white-label service to clients at $500-1,500 monthly recurring revenue per client Manage 10-20 client accounts for $5,000-30,000 monthly recurring revenue SaaS Model: Package as LinkedIn automation SaaS with tiered pricing ($49-299/month) Target 100+ subscribers for $5,000-30,000 monthly recurring revenue Difficulty Level & Build Time Difficulty: Intermediate to Advanced Estimated Build Time: 4-6 hours Technical Requirements: Understanding of API integrations, Google Sheets operations, and basic workflow logic Setup Complexity: API key management and authentication setup Google Sheets structure creation and permission configuration PhantomBuster agent setup and testing AI prompt engineering for optimal icebreaker generation Detailed Setup Steps 1. Google Sheets Preparation Create two Google Sheets: Source Sheet:** Structure with columns for firstName, lastName, location, title, companyName, titleDescription, linkedInProfileUrl Destination Sheet:** Include all source columns plus id, photo_url, icebreaker, email_status fields 2. API Credentials Configuration OpenAI:** Generate API key with GPT-4O access Google Sheets:** Set up OAuth2 credentials in n8n PhantomBuster:** Create account, set up LinkedIn connection agent, obtain API key Gmail:** Configure OAuth2 for notification emails 3. PhantomBuster Agent Setup Create LinkedIn connection request automation agent Configure with proper message templates and targeting parameters Test agent functionality and note the agent ID for n8n configuration 4. Workflow Import & Configuration Import the provided n8n workflow JSON Update all credential references to match your configured accounts Modify Google Sheet IDs in all relevant nodes Update PhantomBuster agent ID and API key in HTTP request node 5. AI Prompt Optimization Review and customize the GPT-4O prompt for your specific use case Test icebreaker generation with sample data Adjust tone and style parameters as needed 6. Schedule Configuration Set appropriate trigger times based on your target timezone Consider LinkedIn usage patterns for optimal engagement 7. Testing & Validation Run workflow manually with test data Verify Google Sheets integration and data flow Test PhantomBuster integration with small batch Confirm email notifications are working Advanced Customization Options Enhanced AI Personalization Integrate additional data sources (company websites, news articles) for richer context Add industry-specific icebreaker templates Implement A/B testing for message variations CRM Integration Connect to Salesforce, HubSpot, or Pipedrive for seamless lead management Add lead scoring based on profile analysis Implement automated follow-up sequences Analytics & Reporting Add detailed tracking and analytics dashboard Implement conversion tracking from connection to closed deal Generate automated performance reports Multi-Platform Expansion Extend to Twitter/X and Instagram outreach Add email finder integration for multi-channel campaigns Implement unified contact management across platforms Advanced Filtering Add AI-powered lead qualification before outreach Implement company size, industry, and role-based filtering Add sentiment analysis for optimal timing This workflow represents a complete, production-ready solution that can immediately start generating leads and revenue while providing a foundation for advanced customization and scaling.
by Roshan Ramani
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
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 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.