Gmail and Slack integration

This n8n workflow acts as an AI-powered Inbox Assistant that automatically summarizes and classifies Gmail emails, prioritizes important messages, and sends a daily digest to Slack. It’s ideal for startup founders and small teams juggling investor intros, customer leads, and support queries — all from a busy Gmail inbox. Each email is processed using ChatGPT to generate a concise summary, classify the message (e.g., Support, Investor, Spam), and determine its urgency. High and medium priority messages are forwarded to Slack instantly. Lower priority emails are logged to Google Sheets for review. A daily 7 PM digest summarizes the day’s most important messages. 💡 Use Cases Preventing missed investor or lead emails Lightweight CRM alternative using Google Sheets Slack summaries of critical Gmail activity 🔧 How It Works Gmail node fetches new messages ChatGPT summarizes and extracts urgency + type High/medium urgency → sent to Slack + labeled in Gmail Low urgency → logged in Google Sheets Cron node triggers a daily 7 PM Slack summary ✅ Requirements OpenAI API Key (GPT-4 or GPT-4o recommended) Gmail access with read and label permission Slack Bot Token or Webhook URL Google Sheets integration (optional) 🛠 Customization Ideas Replace Slack with Telegram or WhatsApp Route investor leads to Airtable or Notion Add multi-language support in ChatGPT prompt Create weekly summaries via email

📘 Description This workflow enables on-demand social lead discovery using a chat-based interface. When a user submits a lead discovery query, the workflow searches Twitter and Instagram for posts where people are actively asking for tools, recommendations, or help solving real problems. An AI agent filters out spam and promotions, extracts only genuine buying-intent posts, and classifies each lead as Low, Medium, or High intent. Qualified leads are converted into two outputs: a human-readable Slack summary for quick review and a structured, CRM-ready Notion record for tracking and follow-ups. Short-term conversation memory is maintained to improve relevance across follow-up queries. Built-in error handling ensures failures are reported immediately. ⚠️ Deployment Disclaimer This template can only be used on self-hosted n8n installations. It relies on external MCP tools and custom AI orchestration not supported on n8n Cloud. ⚙️ What This Workflow Does (Step-by-Step) 💬 Receive User Lead Discovery Query (Chat Trigger) Accepts a natural-language lead discovery request from a user. 🧠 Maintain Short-Term Conversation Context Keeps recent query context to improve follow-up accuracy. 🔎 Discover Buying-Intent Leads from Social Platforms (AI) Searches Twitter and Instagram for posts indicating real buying or problem-solving intent and extracts structured lead data. 🌐 External Social Search & Enrichment (MCP Tool) Fetches relevant social posts from external platforms. 🧠 AI Lead Qualification Classifies intent (Low / Medium / High), summarizes the problem, and filters noise. 🧩 Generate Slack & Notion Lead Insight Summary (AI) Creates a concise Slack summary and a clean, structured Notion record. 📣 Send Lead Discovery Summary to Slack Delivers a skimmable summary for immediate team visibility. 🗂 Store Lead Discovery Insight in Notion CRM Logs search query, themes, and overall intent for tracking. 🚨 Error Handler → Email Alert Sends an alert if the workflow fails at any step. 🧩 Prerequisites • Self-hosted n8n instance • Azure OpenAI API credentials • MCP bearer authentication for social search • Slack API credentials • Notion API credentials 🛠 Setup Instructions Deploy the workflow on a self-hosted n8n instance Connect Azure OpenAI, MCP, Slack, and Notion credentials Enable the chat trigger Test with a sample lead discovery query 🛠 Customization Tips • Adjust intent classification rules in the AI prompt • Modify output fields to match your CRM schema • Extend discovery to additional platforms via MCP tools 💡 Key Benefits ✔ On-demand social lead discovery via chat ✔ Filters only real buying-intent signals ✔ Produces Slack-ready summaries and CRM-ready records ✔ Maintains context across follow-up queries ✔ Eliminates manual social media scanning 👥 Perfect For Sales teams Growth teams Founders Agencies sourcing leads from social platforms

📘 Description This workflow automates market-driven content ideation by continuously discovering real user pain points from public discussions and converting them into execution-ready content ideas. It is designed for growth and content teams who want ideas grounded in actual customer language, frustrations, and unmet needs—rather than assumptions or generic brainstorming. On a scheduled basis, the workflow scans public search and social platforms for conversations related to a defined niche and keyword set. An AI discovery agent extracts recurring pain points, common complaints, and the exact phrasing users use when describing their problems. These raw market signals are then transformed by a second AI agent into pain-driven content ideas, each mapped to a platform, format, hook, core pain point, resonance logic, and CTA. All generated ideas are normalized, stored in a central Google Sheets content database, converted into execution tasks in ClickUp, and summarized in Slack for immediate team visibility. Built-in error handling ensures failures are reported instantly. ⚠️ Deployment Disclaimer This workflow is intended for self-hosted n8n instances only. It relies on MCP-based social intelligence tools and advanced AI agent orchestration not supported on n8n Cloud. ⚙️ What This Workflow Does (Step-by-Step) ⏰ Scheduled Market Discovery Trigger Runs automatically on a defined schedule. 🧾 Inject Niche and Keyword Parameters Defines the research scope for discovery. 🔎 Extract Raw User Pain Points (AI) Scans public discussions to capture real frustrations, questions, and language—no solutions, no opinions. 📡 Public Search & Social Intelligence (MCP) Fetches relevant public conversations for analysis. 🧠 Generate Pain-Driven Content Ideas (AI) Converts raw pain points into platform-ready content ideas with hooks, formats, and CTAs. 🧹 Normalize & Parse AI Output Cleans and standardizes content ideas for downstream systems. 📊 Store Content Ideas in Google Sheets Appends ideas to a centralized content database. 🗂 Create Content Tasks in ClickUp Automatically creates execution-ready tasks for the content team. 📣 Aggregate & Summarize Ideas Generates a concise Slack summary highlighting volume, platforms, and strongest hooks. 🚨 Workflow Error Handler → Email Alert Sends immediate error notifications if any step fails. 🧩 Prerequisites • Self-hosted n8n instance • OpenAI API credentials • MCP (Xpoz) public search & social intelligence credentials • Google Sheets API access • ClickUp API credentials • Slack API access 💡 Key Benefits ✔ Content ideas grounded in real user pain ✔ Eliminates manual research and brainstorming ✔ Produces creator-ready, platform-specific ideas ✔ Centralized storage and task creation ✔ Clear Slack visibility for growth teams ✔ Reliable error monitoring 👥 Perfect For Content strategists Growth marketers B2B SaaS teams Automation and n8n-focused creators Marketing operations teams

Hourly Email Summary: This agent scans your inbox every 4 hour and summarizes new emails into a clean, actionable Slack message. Powered by GPT-4, it classifies emails by Urgency (High, Medium, Low) and Intent (Awaiting Reply, To Respond, Comment, Notification, Marketing). No more inbox FOMO — just what you need to act fast. Main Use Cases: • Stay on top of important threads without refreshing your inbox constantly • Prioritize tasks and replies based on urgency and context • Catch missed follow-ups by surfacing emails that need a response • Filter out noise like marketing emails or low-priority notifications • Enable async decision-making by keeping the team updated on critical emails via Slack • Reduce cognitive load by letting AI handle sorting and triaging ⸻ ✅ Steps to Use Connect Your Accounts: Add your Gmail, Slack, Google Sheets, and OpenAI credentials inside n8n. Create Gmail Labels (Required): Go to your Gmail settings and create labels matching the following format: AI Agent/To Respond, AI Agent/Awaiting Reply, AI Agent/Notification, AI Agent/Marketing, etc. These are used by the workflow to auto-tag emails based on intent. Create a Google Sheet with 2 Tabs • Name the sheet something like “N8N - Emails”. • Add two sheets/tabs inside: • Sheet1 → stores all processed emails • Sheet2 → stores only the latest batch for digest view • In both sheets, add these columns (first row): From | Summary | Intent | Category | TimeStamp | Urgency Import the Workflow: Upload or paste the .json file into your n8n instance. Make sure each node is linked to your active credentials. Configure Slack Channel: In the Slack node, select the channel where you want urgent alerts and digest summaries to be posted. Adjust Schedule (Optional): Default: runs every hour. You can tweak this to suit your preference (e.g., every 30 min or 2 hours). Run a Test: Execute manually once to check: • Emails are getting processed • Labels are added correctly in Gmail • Slack notifications are triggered • Data is logged in Google Sheets Turn It On • Once everything looks good, activate the workflow. • Your inbox will now be triaged in real-time — sorted, labeled, summarized. Step-by-Step Breakdown: ⏰ Schedule Trigger: Runs every hour to kick off the workflow automatically. 📩 Fetch Emails & Labels • Pulls all Gmail messages received in the last 4 hours. • Also fetches Gmail labels to use for tagging messages based on intent. 🤖 Analyze with GPT-4 • Each email is analyzed using GPT-4. • Output includes: • Summary • Urgency: High, Medium, Low • Intent: To Respond, Awaiting Reply, Marketing, Notification, etc. • Category: Customer, Investor, Spam, etc. Classify and Label • Emails are tagged with the right intent label inside Gmail. 5.🚨 Slack Alerts for High Urgency • If an email is marked High Urgency, it sends an alert to a designated Slack channel with all key details. 📊 Google Sheets Logging • All emails are logged to two Google Sheets: • Sheet1: All messages, for long-term record. • Sheet2: Temporary sheet to collect latest batch for digest. ⏳ Wait + Digest Preparation • After logging, the workflow waits 30 seconds. • It then fetches recent entries from Sheet2, filters out older messages, and groups them by Medium and Low urgency. 📬 Slack Digest Summary • A clean digest is posted on Slack showing only the Medium and Low urgency messages from the past hour — helping you catch up without inbox overload. Uses a System Prompt to define its role as an AI Chief of Staff. Uses a User Prompt that instructs GPT-4 to analyze each email and return a structured JSON with the following: • summary – One-line summary of the email • urgency – High / Medium / Low • category – Investor, Customer, Support, Spam, Other • Intent – One of: • To Respond: Needs your reply • Awaiting Reply: You’re waiting for a response • Notification: Auto-updates from tools or services • Meeting Update: Calendar or schedule changes • Marketing: Promotional or cold emails • FYI: Informational emails that don’t need action The output is clean JSON with built-in guardrails to avoid hallucinations or irrelevant content. Only real message data is used for summaries and classification. Sections with no relevant data are omitted to keep it concise. 🧩 What’s Next This agent already cuts through inbox noise and gives you clarity — but there’s more you can build on top: 💡 Suggestions to Improve: • Train on your past threads to make prioritization even smarter • Allow custom rules per sender or domain (e.g. always mark investor emails as High) • Add emoji tags or reactions in Slack to quickly mark emails as done or follow-up • Support voice summary via Slack audio snippet or Loom integration 🚀 Next Features You Could Add: • Reply-from-Slack: One-click smart reply suggestions that can be sent right from Slack • Cross-inbox support: Add Outlook or multiple Gmail accounts • Weekend Digest: A weekly email or Slack drop with trends (top senders, most flagged categories) • Daily Timeline View: Generate a Notion page that logs the day’s most critical communication

Who is this for? Teams using Gmail and Slack who want to streamline email handling. Customer support, sales, and operations teams that want emails sorted by topic and priority automatically. Anyone tired of manually triaging customer emails. What does it solve? Stops important messages from slipping through the cracks. Automatically identifies the nature and urgency of incoming emails. Routes emails to the right Slack channel with a clear, AI-generated summary. How it works The workflow watches for unread emails in your Gmail inbox. It fetches the full email content and passes it to OpenAI for classification. The AI returns structured JSON with the email’s category, priority, summary, and sender. Based on the AI result, it assigns a label and Slack channel. A message is sent to the right Slack channel with the details. How to setup? Connect credentials: Gmail (OAuth2) Slack (OAuth2) OpenAI (API Key) Adjust email polling: Open the Gmail Trigger node and set how frequently it should check for new emails. Verify routing settings: In the “Routing Map” node, update Slack channel IDs for each category if needed. Customize AI behavior (optional): Tweak the AI Agent prompt to better match your internal categorization rules. How to customize this workflow to your needs Add more categories:** Update the AI prompt and the schema in the “Structured Output Parser.” Change Slack formatting:** Modify the message text in the Slack node to include links, emojis, or mentions. Use different routing logic:** Expand the Routing Map to assign based on keywords, domains, or even sentiment. Add escalation workflows:** Trigger follow-up actions for high-priority or complaint emails.

Stop spending hours manually pulling paid ads data. This workflow connects to Databox via MCP, auto-discovers every connected paid platform, fetches 6 key metrics, and delivers a consolidated weekly report to Slack and email - every Monday at 9 AM, completely hands-free. Who's it for Performance marketers** managing campaigns across multiple platforms Marketing managers** who need a weekly cross-platform overview Agencies** automating paid ads reporting for clients How it works Schedule Trigger fires every Monday at 9 AM AI Agent connects to Databox via MCP and discovers all connected paid platforms (Google Ads, Facebook Ads, LinkedIn Ads, TikTok Ads, and 6 more) Fetches Spend, Clicks, CPC, CTR, Impressions, and Conversions for this week and last week Calculates week-over-week changes and formats two outputs - a Slack summary and a color-coded HTML email Delivers both simultaneously Requirements Databox account** with at least one paid ads platform connected (free plan works) OpenAI API key (or Anthropic) Slack account Gmail account How to set up Click Databox MCP Tool - set Authentication to OAuth2 and authorize Add your OpenAI API key to the Chat Model node Connect Slack and update the channel ID in the Send to Slack node Connect Gmail and set the recipient address in the Send Email node Activate - your first report arrives next Monday

📘 Description This workflow automates end-to-end pre-surgery checklist reminders and confirmation tracking for healthcare operations teams. It ensures patients receive timely preparation instructions, can confirm completion with a single click, and allows staff to monitor confirmation status in real time—without manual coordination. Every day at 9:00 AM, the workflow fetches surgery events from Google Calendar, extracts patient details from event descriptions, and generates a unique confirmation link for each patient. An AI assistant then creates a personalized, patient-friendly pre-op checklist email (subject + styled HTML body) that includes surgery details and a confirmation button. When a patient clicks the confirmation link, a webhook captures the confirmation, updates Google Sheets as the source of truth, and records the timestamp. A separate periodic scheduler scans the sheet for patients who have not confirmed within the expected window. If confirmation is missing, the assigned nurse or owner is alerted in Slack with full patient and surgery context for immediate follow-up. This creates a closed-loop system: reminder → confirmation capture → tracking → escalation. ⚙️ What This Workflow Does (Step-by-Step) ▶️ Daily 9:00 AM Trigger Starts the pre-op reminder cycle automatically each morning. 📅 Fetch Today’s Surgery Events (Google Calendar) Pulls calendar events and filters only surgery-related entries. 🧾 Extract Patient Details from Event Description Parses patient name, email, phone, ID, procedure, and surgery time. 🔗 Generate Unique Confirmation Link Creates a secure confirmUrl per patient with tracking parameters. ✉️ AI Email Generation (Subject + HTML Body) Uses Azure OpenAI (gpt-4o) to generate a calm, professional checklist email with: Surgery details Basic preparation checklist Green confirmation button linked to confirmUrl 📤 Send Pre-Op Reminder via Gmail Delivers the styled HTML email directly to the patient. ✅ Confirmation Webhook (GET /confirm) Captures patient clicks, parses query parameters, and marks the checklist as confirmed. 🧾 Upsert Confirmation Status (Google Sheets) Stores and updates patient confirmation records as the operational source of truth. ⏳ Periodic Confirmation Check Runs on a schedule to scan all patient rows for missing confirmations. 🚨 Slack Alert for Missing Confirmations Notifies the nurse or owner with full patient context when confirmation is not received in time. 🧩 Prerequisites • Google Calendar OAuth2 • Gmail OAuth2 • Azure OpenAI (gpt-4o) credentials • Google Sheets OAuth2 • Slack API credentials • Publicly accessible webhook URL for confirmation tracking 💡 Key Benefits ✔ Automated pre-op reminders at a fixed daily time ✔ Personalized AI-generated patient emails ✔ One-click confirmation tracking ✔ Google Sheets audit trail for operations ✔ Proactive Slack alerts for missing confirmations ✔ Reduced manual follow-ups and missed preparations 👥 Perfect For Hospitals and surgical centers Clinic operations teams Care coordinators Day-surgery facilities Healthcare admin automation systems

📘 Description This workflow automates the entire process of taking a raw user-submitted script, rewriting it into a polished HeyGen-ready narration, generating a full avatar video, handling all processing checks, retrieving the final MP4, uploading it to Google Drive, and notifying the user through email and Slack. It turns an unstructured script into a complete, ready-to-share video package without any manual intervention. The system rewrites scripts into structured sections (intro → narration sections → closing), ensures the final narration fits HeyGen’s free-tier limits, submits the script to HeyGen’s video API, initiates a polling loop until the video is fully rendered, downloads the finished file, uploads it to Drive with metadata, and generates clean notification messages containing the file links. Errors at any point trigger automated Slack alerts for debugging. This workflow replaces manual rewriting, video rendering, download/upload, and team communication—providing a fully-managed script-to-video pipeline. ⚙️ What This Workflow Does (Step-by-Step) 🟢 Receive Script Request via Webhook Captures the raw script payload submitted by the user. 🧹 Parse Incoming Script Payload Converts stringified JSON body into structured data for processing. ✍️ Rewrite & Structure Video Script Using AI Transforms the raw script into: • Video title • Intro • Multiple sections (title + narration) • Closing • Combined full_script optimized for HeyGen’s ~300–350 word limit Ensures natural, human narration with smooth transitions. 🧠 Script Writing Memory + LLM Engine Maintains writing consistency and uses GPT-4.1-mini to generate polished narration. 🧪 Validate Structured Script Output Enforces strict JSON schema for titles, sections, closing, and full_script. 🎞️ Submit Video Generation Request to HeyGen Sends structured script to HeyGen API with avatar, voice, and background settings for 1280×720 export. ⏳ Wait Before Polling Loop Initial delay before the first status check. 📡 Check HeyGen Video Status Queries the HeyGen API to check progress of the video generation. ⏳ Wait Before Rechecking Adds timed spacing between repeated polls. 🔍 Evaluate Video Completion If status = completed → proceed If still processing → loop back to polling sequence 📥 Download Generated HeyGen Video Retrieves the completed MP4 using the returned video_url. ☁️ Upload Video to Google Drive Uploads the MP4 to a specific Google Drive folder, returning: • File name • View link • Download link • Timestamp • Size metadata 📣 Generate Completion Notifications Using AI Creates two outputs: • A friendly short email summary • A concise Slack message Both containing the Google Drive file link. 🧠 Notification Memory + LLM Engine Maintains tone and ensures consistent messaging across channels. 🧪 Validate Notification Output JSON Ensures email_subject, email_body, and slack_message follow schema. 💬 Send Video Ready Slack Notification Posts the final Slack message containing file details and Drive link. 📧 Send Video Ready Email Notification Emails the summary and file link to the designated recipient. 🚨 Error Handler Trigger → Slack Alert Any workflow failure sends a detailed diagnostic alert with node name, message, and timestamp. 🧩 Prerequisites • HeyGen API key • Google Drive OAuth connection • Slack API credentials • Gmail OAuth connection • Valid webhook endpoint to receive scripts 💡 Key Benefits ✔ Converts raw script → structured HeyGen-ready narration automatically ✔ Produces full HD avatar video with zero manual steps ✔ Polls HeyGen until the video is fully rendered ✔ Securely uploads final MP4 to Google Drive ✔ Auto-generates polished email + Slack notifications ✔ Ensures narrative consistency using memory context ✔ Provides real-time error alerts via Slack 👥 Perfect For HR teams automating onboarding videos Marketing teams producing quick avatar explainers Training content creators Founders creating rapid how-to or announcement videos Anyone needing instant script-to-video automation

📘 Description: This workflow automates sales contact follow-ups and engagement tracking by integrating HighLevel CRM, Gmail, Slack, and Google Sheets. It fetches all contacts from HighLevel, filters inactive contacts, sends personalized follow-up emails, checks for responses, and notifies the sales team accordingly. It eliminates manual follow-up tracking, ensures timely outreach, and provides real-time notifications — helping sales teams maintain engagement, respond promptly, and improve lead conversion. ⚙️ What This Workflow Does (Step-by-Step) 🟢 Manual Trigger – Starts the automation manually Action: Initiates the workflow for immediate follow-up execution or testing. 📦 Fetch Contacts from HighLevel CRM Action: Retrieves all contacts from HighLevel, including names, emails, and metadata for full visibility. 🔍 Validate Deal Fetch Success (IF Node) Action: Verifies that fetched contacts contain valid IDs. ✅ True Path: Continues to filter inactive contacts. ❌ False Path: Logs invalid or missing contacts to Google Sheets for auditing and troubleshooting. 🧹 Filter Contacts with No Response Action: Selects contacts who have not replied in the last 24 hours, ensuring follow-ups target only inactive leads. 📊 Get Most Recent Contact Action: Retrieves the latest contact based on last updated time and calculates hours since last interaction. 📧 Send Follow-Up Email to Contact Action: Sends a personalized email to the contact, asking for confirmation or questions and including dynamic details like name and last interaction time. ⏳ Wait for 24 Hours Before Next Action Action: Pauses the workflow for 24 hours to allow contacts sufficient time to respond. 📨 Retrieve Email Thread for Response Action: Fetches the most recent Gmail thread using the thread ID to check if the contact has replied. ✅ Check If Contact Responded with “Yes” (IF Node) Action: Evaluates if the response contains the word “yes”. ✅ True Path: Triggers Slack notification for positive response. ❌ False Path: Triggers Slack notification for no response. 💬 Notify Sales Team in Slack if Response Received Action: Sends a Slack message notifying the team of a positive reply, including contact details and response snippet. ⚠️ Notify Sales Team in Slack if No Response Action: Sends a Slack message notifying the team that the contact hasn’t replied, including contact info, follow-up timestamp, and waiting status. 🚨 Log Fetch or Validation Errors (Error Handling) Action: Records any fetch or validation errors in Google Sheets for easy review and troubleshooting. 🧩 Prerequisites HighLevel CRM API OAuth credentials Gmail OAuth2 credentials for sending and fetching emails Google Sheets document for error logging Slack API credentials for notifications 💡 Key Benefits ✅ Fully automated follow-up workflow for sales contacts ✅ Timely notifications for positive and inactive responses ✅ Personalized emails to contacts ✅ Transparent tracking and logging of errors ✅ Seamless integration across HighLevel, Gmail, Slack, and Google Sheets 👥 Perfect For Sales teams managing multiple leads Marketing teams ensuring lead engagement Startups scaling outreach efforts Organizations using HighLevel CRM + Gmail + Slack for sales follow-ups

Revolutionize your recruitment process with intelligent AI-driven candidate screening that evaluates resumes, scores applicants, and automatically routes them based on fit - saving 10-15 hours per week on initial screening. 🎯 What This Workflow Does Transforms your hiring pipeline from manual resume review to intelligent automation: 📝 Captures Applications - Jotform intake with resume upload 🤖 AI Resume Analysis - OpenAI parses skills, experience, education, and red flags 🎯 Intelligent Scoring - Evaluates candidates against job requirements with structured scoring (0-100) 🚦 Smart Routing - Automatically routes based on AI recommendation: Strong Yes (85-100): Instant Slack alert → Interview invitation Maybe/Yes (60-84): Manager review → Approval workflow No (<60): Polite rejection email 📊 Analytics Tracking - All data logged to Google Sheets for hiring insights ✨ Key Features AI Resume Parsing**: Extracts structured data from any resume format Intelligent Scoring System**: Multi-dimensional evaluation (skills match, experience quality, cultural fit) Structured Output**: Consistent JSON schema ensures reliable data for decision-making Automated Communication**: Personalized emails for every candidate outcome Human-in-the-Loop**: Manager approval for borderline candidates Comprehensive Analytics**: Track conversion rates, average scores, and hiring metrics Customizable Job Requirements**: Easy prompt editing to match any role 💼 Perfect For Startups & Scale-ups**: Processing 50+ applications per week HR Teams**: Wanting to reduce time-to-hire by 40-60% Technical Recruiters**: Screening engineering, product, or design roles Growing Companies**: Scaling hiring without scaling headcount 🔧 What You'll Need Required Integrations Jotform** - Application intake form (free tier works) Create your form for free on Jotform using this link OpenAI API** - GPT-4o-mini for cost-effective AI analysis (~$0.15 per candidate) Gmail** - Automated candidate communication Google Sheets** - Hiring database and analytics Optional Integrations Slack** - Instant alerts for hot candidates Linear/Asana** - Task creation for interview scheduling Calendar APIs** - Automated interview booking 🚀 Quick Start Import Template - Copy JSON and import into n8n Create Jotform - Use provided field structure (name, email, resume upload, etc.) Add API Keys - OpenAI, Jotform, Gmail, Google Sheets Customize Job Requirements - Edit AI screening prompt with your role details Personalize Emails - Update templates with your company branding Test & Deploy - Submit test application and verify all nodes 🎨 Customization Options Adjust Scoring Thresholds**: Change routing logic based on your needs Multiple Positions**: Clone workflow for different roles with unique requirements Add Technical Assessments**: Integrate HackerRank, CodeSignal, or custom tests Interview Scheduling**: Connect Calendly or Google Calendar for auto-booking ATS Integration**: Push data to Lever, Greenhouse, or BambooHR Diversity Tracking**: Add demographic fields and analytics Reference Checking**: Automate reference request emails 📈 Expected Results 90% reduction** in manual resume review time 24-hour response time** to all candidates Zero missed applications** - every candidate gets feedback Data-driven hiring** - track what works with comprehensive analytics Better candidate experience** - fast, professional communication Consistent evaluation** - eliminate unconscious bias with structured AI scoring 🏆 Use Cases Technology Companies Screen 100+ engineering applications per week, identify top 10% instantly, schedule interviews same-day. Agencies & Consultancies Evaluate consultant candidates across multiple skill dimensions, route to appropriate practice areas. High-Volume Hiring Process retail, customer service, or sales applications at scale with consistent quality. Remote-First Teams Evaluate global candidates 24/7, respond instantly regardless of timezone. 💡 Pro Tips Train Your AI**: After 50+ applications, refine prompts based on false positives/negatives A/B Test Thresholds**: Experiment with score cutoffs to optimize for your needs Build Talent Pipeline**: Keep "maybe" candidates in CRM for future roles Track Source Effectiveness**: Add UTM parameters to measure which job boards deliver best candidates Continuous Improvement**: Weekly review of AI assessments to calibrate accuracy 🎓 Learning Resources This workflow demonstrates: AI Agents with structured output Multi-stage conditional routing Human-in-the-loop automation Binary data processing (resume files) Email automation with HTML templates Real-time notifications Analytics and data logging Perfect for learning advanced n8n automation patterns! Ready to transform your hiring process? Import this template and start screening candidates intelligently in under 30 minutes. Questions or customization needs? The workflow includes detailed sticky notes explaining each section.

HR Date Management Automation - Complete Setup Guide 🎯 How It Works This n8n workflow transforms your HR department from reactive to proactive by automatically monitoring 5 critical employee timelines and generating smart alerts before deadlines hit. Core Components Data Input → Employee information (hire dates, contracts, certifications) Date Analysis Engine → Calculates days until critical events Smart Categorization → Sorts employees by urgency level Reminder Scheduler → Creates proactive notifications Multi-Format Export → Sends alerts to your preferred systems Business Value Prevents compliance violations** ($5K-50K+ in fines) Reduces HR workload** (15-20 hours/month saved) Improves employee experience** (no missed reviews/renewals) Provides management visibility** (dashboard reporting) 🚀 Quick Start Test Import the Workflow Download the Javascript_Hr.json file Open n8n and click “Import from file” Select the downloaded JSON file Click “Import” Test with Sample Data Click the “Execute Workflow” button Review the sample output in each node Check the final export data format What you’ll see: 5 sample employees with different scenarios Calculated days until contract/certification expiry Priority levels (high/medium/low) Scheduled reminders with recipient emails Export data in multiple formats 🔧 Real-World Integration Setup Option 1: Google Sheets Integration (Most Popular) Step 1: Prepare Your Employee Data Create a Google Sheet with these columns: | Employee ID | Name | Email | Department | Hire Date | Contract End | Certification Expiry | Last Review | Probation End | Vacation Days | Status | Sample data format: | 1 | John Smith | [email protected] | IT | 2024-01-15 | 2025-12-31 | 2025-03-20 | 2024-06-15 | 2024-07-15 | 20 | active | Step 2: Replace Sample Data Generator Delete the “Sample Data Generator” node Add “Google Sheets” node Connect to your Google account Configure these settings: Operation**: Read Document**: Your employee spreadsheet Sheet**: Employee data sheet Range**: A1:K100 (adjust for your data size) Options**: ✅ RAW data, ✅ Header row Step 3: Map Your Data Add a “Set” node after Google Sheets to standardize field names: // Map your sheet columns to workflow format { "id": "{{ $json['Employee ID'] }}", "name": "{{ $json['Name'] }}", "email": "{{ $json['Email'] }}", "department": "{{ $json['Department'] }}", "hiredOn": "{{ $json['Hire Date'] }}", "contractEndDate": "{{ $json['Contract End'] }}", "certificationExpiry": "{{ $json['Certification Expiry'] }}", "lastReviewDate": "{{ $json['Last Review'] }}", "probationEndDate": "{{ $json['Probation End'] }}", "vacationDays": "{{ $json['Vacation Days'] }}", "status": "{{ $json['Status'] }}" } Option 2: HRIS Integration (BambooHR Example) Step 1: BambooHR API Setup Get your BambooHR API key from Settings > API Keys Note your company subdomain (e.g., yourcompany.bamboohr.com) Step 2: Replace Sample Data Generator Delete the “Sample Data Generator” node Add “HTTP Request” node Configure these settings: Method**: GET URL**: https://api.bamboohr.com/api/gateway.php/[SUBDOMAIN]/v1/employees/directory Authentication**: Basic Auth Username**: Your API key Password**: x (leave as ‘x’) Headers**: Accept: application/json Step 3: Transform BambooHR Data Add a “Code” node to transform the API response: // Transform BambooHR response to workflow format const employees = []; for (const employee of $input.all()) { const emp = employee.json; employees.push({ id: emp.id, name: ${emp.firstName} ${emp.lastName}, email: emp.workEmail, department: emp.department, hiredOn: emp.hireDate, contractEndDate: emp.terminationDate || "2025-12-31", // Default if not set certificationExpiry: emp.customCertDate || "2025-12-31", lastReviewDate: emp.customReviewDate || null, probationEndDate: emp.customProbationDate || null, vacationDays: emp.paidTimeOff || 20, status: emp.employeeStatus || "active" }); } return employees.map(emp => ({ json: emp })); Option 3: CSV File Upload Step 1: Prepare CSV File Create a CSV with the same structure as the Google Sheets format. Step 2: Use CSV Parser Replace “Sample Data Generator” with “Read Binary File” node Add “CSV Parser” node Configure settings: Include Headers**: Yes Delimiter**: Comma Skip Empty Lines**: Yes 📧 Output Integration Setup Email Notifications Step 1: Add Email Node Add “Email” node after “Reminder Scheduler” Connect to your email provider (Gmail/Outlook) Step 2: Configure Email Templates // Dynamic email content based on reminder type const reminder = $json; const emailTemplates = { contract_renewal: { subject: 🚨 Contract Renewal Required - ${reminder.employeeName}, body: ` Hi HR Team, ${reminder.employeeName}'s contract expires on ${reminder.dueDate}. Days remaining: ${Math.ceil((new Date(reminder.dueDate) - new Date()) / (10006060*24))} Please initiate renewal process immediately. Best regards, HR Automation System ` }, certification_renewal: { subject: 📜 Certification Renewal Reminder - ${reminder.employeeName}, body: ` Hi ${reminder.employeeName}, Your certification expires on ${reminder.dueDate}. Please renew your certification to maintain compliance. Contact HR if you need assistance. Best regards, HR Team ` } }; const template = emailTemplates[reminder.type]; return { to: reminder.recipientEmail, subject: template.subject, body: template.body }; Slack Integration Step 1: Add Slack Node Add “Slack” node after “Advanced Date Filters” Connect to your Slack workspace Step 2: Configure Channel Alerts // Send summary to #hr-alerts channel const summary = $json.summary; const message = ` 🏢 Daily HR Report 👥 Total Employees: ${summary.totalEmployees} 🆕 New Hires: ${summary.newHires} ⚠️ High Priority Actions: ${summary.highPriority} 📋 Contracts Expiring: ${summary.contractsExpiring} 🎓 Certifications Expiring: ${summary.certificationsExpiring} Generated: ${new Date().toLocaleDateString()} `; return { channel: '#hr-alerts', text: message }; Google Calendar Integration Step 1: Add Calendar Node Add “Google Calendar” node after “Reminder Scheduler” Connect to your Google account Step 2: Create Calendar Events // Create calendar events for upcoming deadlines const reminder = $json; const eventTitles = { contract_renewal: Contract Renewal - ${reminder.employeeName}, certification_renewal: Certification Renewal - ${reminder.employeeName}, performance_review: Performance Review - ${reminder.employeeName}, probation_review: Probation Review - ${reminder.employeeName} }; return { calendarId: '[email protected]', summary: eventTitles[reminder.type], description: reminder.message, start: { dateTime: reminder.dueDate, timeZone: 'America/New_York' }, end: { dateTime: reminder.dueDate, timeZone: 'America/New_York' }, attendees: [ { email: '[email protected]' }, { email: reminder.recipientEmail } ] }; 🎯 Scheduling & Automation Daily Monitoring Setup Step 1: Add Cron Trigger Replace “Manual Trigger” with “Cron” node Set schedule: 0 9 * * 1-5 (9 AM, Monday-Friday) Configure timezone to your business hours Step 2: Error Handling Add “Error Trigger” node Connect to email notification for failures Set up retry logic for failed integrations Weekly Reports Step 1: Create Weekly Summary Add separate “Cron” trigger for weekly reports Set schedule: 0 9 * * 1 (9 AM every Monday) Modify the filtering logic to show weekly trends 🔍 Customization Options Adjust Alert Timings In the “Date Analysis & Categorization” node: // Modify these values to change alert timing const isContractExpiringSoon = daysUntilContractEnd <= 90; // Change from 90 days const isCertificationExpiringSoon = daysUntilCertificationExpiry <= 60; // Change from 60 days const needsReview = daysSinceLastReview >= 365; // Change from 365 days Add Custom Employee Categories // Add new categories in the analysis node const isContractor = employee.employeeType === 'contractor'; const isRemoteWorker = employee.location === 'remote'; const isHighRisk = employee.performanceRating === 'needs_improvement'; Custom Date Formats Modify the “Date Formatting & Export” node to add your preferred formats: // Add custom date format const formatters = { custom: (date) => { const options = { year: 'numeric', month: 'long', day: 'numeric', weekday: 'long' }; return date.toLocaleDateString('en-US', options); } }; 🎚️ Testing & Validation Step 1: Data Validation Test with 2-3 sample employees first Verify all dates are parsing correctly Check that calculations match manual calculations Step 2: Alert Testing Create test scenarios with dates 30/60/90 days out Verify emails are sent to correct recipients Test Slack notifications in a test channel Step 3: Performance Testing Test with your full employee dataset Monitor execution time (should be under 30 seconds) Check for memory usage with large datasets 🆘 Troubleshooting Guide Common Issues Date Parsing Errors // Add date validation in the analysis node const parseDate = (dateStr) => { const date = new Date(dateStr); if (isNaN(date.getTime())) { console.error(Invalid date: ${dateStr}); return null; } return date; }; Missing Data Fields // Add data validation const validateEmployee = (employee) => { const required = ['name', 'email', 'hiredOn']; const missing = required.filter(field => !employee[field]); if (missing.length > 0) { console.error(Missing required fields for ${employee.name}: ${missing.join(', ')}); return false; } return true; }; API Rate Limits Add “Wait” nodes between API calls Implement retry logic with exponential backoff Cache API responses when possible 🚀 Advanced Features Multi-Company Support // Add company filtering in the analysis node const processEmployeesByCompany = (employees, companyId) => { return employees.filter(emp => emp.companyId === companyId); }; Custom Notification Rules // Advanced notification logic const shouldNotify = (employee, eventType) => { const rules = { contract_renewal: employee.department !== 'intern', certification_renewal: employee.role === 'certified_professional', performance_review: employee.status === 'active' }; return rules[eventType] || false; }; Integration with Time Tracking // Connect to time tracking APIs const calculateWorkingDays = (startDate, endDate) => { // Implementation for working days calculation // Excluding weekends and holidays }; This workflow transforms your HR department from reactive to proactive, preventing costly compliance issues while improving employee experience. The modular design allows you to start simple and add complexity as needed.

📘 Description This workflow is an AI-powered roto matte generation and first-pass compositing pipeline designed for VFX production. It transforms structured roto requests into multiple high-precision matte passes using AI, performs automated quality evaluation, generates production-ready Nuke scripts, and delivers fully organized assets and review tasks to the team—bridging the gap between manual rotoscoping and scalable AI-assisted matte generation. ⚙️ Step-by-Step Flow The workflow begins with a Google Sheets trigger that continuously monitors for new roto requests, acting as the intake layer for structured production data such as plate image URLs, subject descriptions, shot codes, subject type, and complexity. Once a new entry is detected, the system moves into a validation and extraction stage, where input fields are normalized, defaults are assigned, and essential attributes like sequence codes, frame ranges, QC thresholds, and project metadata are structured for downstream processing. The pipeline then performs prompt engineering and expands the request into four specialized roto passes: an alpha matte pass for clean silhouette extraction, an edge detail pass for fine hair and motion blur accuracy, a foreground isolation pass for compositing-ready subject separation, and a motion tracking reference pass enriched with tracking markers and velocity overlays. Each variation includes detailed instructions aligned with shot context and technical constraints to ensure precise AI-driven outputs. At the core of the workflow, an image-to-video generation layer constructs structured API requests and submits each variation as an independent job to the Seedance AI model, always using the plate image as a reference for accurate subject extraction. A polling mechanism continuously monitors each job at fixed intervals, ensuring that processing proceeds only after successful completion. Once rendering is complete, a metadata and automated QC layer evaluates each pass by assigning a quality score based on resolution and predefined thresholds, classifying outputs as either AI-approved or requiring manual intervention. A decision routing layer then determines the next stage—approved passes continue through the pipeline, while failed outputs trigger immediate Slack alerts for senior artist review and manual roto assignment. For approved outputs, the system generates a fully production-ready Nuke roto template, automatically configuring nodes for plate input, AI matte extraction, alpha application, edge refinement, and artist-level roto adjustments, along with structured EXR output paths and naming conventions. The pipeline then proceeds to asset handling, where generated videos are downloaded and distributed via email to requesters, while simultaneously creating Jira review tasks to ensure pipeline tracking and accountability. An aggregation layer consolidates all roto passes into a unified structured summary, combining QC results, video links, task references, and technical metadata. Finally, a team notification system delivers a comprehensive summary to the roto team via Telegram, including per-pass QC status, preview links, task tracking, output paths, and artist notes highlighting areas requiring refinement—ensuring seamless collaboration between AI outputs and human artists. 🚨 Error Handling • Global error trigger across the workflow • Instant Slack alerts with failure details • Prevents silent failures and ensures pipeline reliability 🧩 Prerequisites • Seedance API (AI video generation) • Google Sheets OAuth2 (trigger input) • Jira API (task tracking) • Gmail OAuth2 (asset delivery) • Slack OAuth2 (alerts & QC failures) • Telegram Bot (team notifications) 💡 Key Benefits ✔ Automated roto matte generation with AI-assisted precision ✔ Multiple specialized passes for production flexibility ✔ Built-in QC scoring and intelligent decision routing ✔ Auto-generated Nuke scripts with pre-configured nodes ✔ Integrated task tracking via Jira ✔ Seamless delivery via email and team notifications ✔ Scalable pipeline for high-volume roto workflows 👥 Perfect For Roto and paint teams in VFX studios Compositors working with Nuke pipelines Film and post-production environments AI-assisted rotoscoping workflows Studios handling high-volume shot processing

How It Works This workflow automates end-to-end concert ticket booking validation and fan experience management using two coordinated AI agents. It is designed for ticketing platforms, event operators, and venue operations teams that must prevent fraud, manage inventory accurately, and deliver seamless customer communication at scale. The workflow solves key challenges such as duplicate bookings, bot-driven purchases, payment failures, overbooking, and inconsistent refund handling. When a booking request enters via webhook, inventory data is fetched and normalized. The Ticket Validation Agent analyzes structured booking, payment authorization, pricing tier rules, seat allocation, resale restrictions, and fraud signals to produce a standardized risk classification. Based on risk level, the workflow routes transactions for auto-approval, conditional handling, or escalation. The Fan Experience Orchestration Agent then manages confirmations, ticket system updates, waitlist activation, refund or compensation logic, and SLA-driven escalation to operations. All outcomes are merged and logged into an audit trail, ensuring compliance, transparency, and consistent service enforcement while minimizing manual review. Setup Steps Add OpenAI/Nvidia API credentials in n8n. Configure ticketing system HTTP endpoint. Connect Gmail for confirmations. Connect Slack for escalation alerts. Connect Google Sheets for audit logging. Define risk thresholds and SLA rules. Prerequisites n8n account, OpenAI API key, ticketing API access, Gmail, Slack, Google Sheets Use Cases Concert ticket sales, festival booking systems, venue seat management, VIP allocation handling Customization Adjust fraud thresholds, add SMS notifications, integrate CRM, extend loyalty logic Benefits Reduces fraud, automates fan communication, enforces ticketing policies

📊 Description Automate your inbound lead qualification pipeline by enriching raw lead data, scoring it with AI, and instantly creating follow-up tasks for your sales team. 🎯🤖 This workflow receives new leads via webhook, enriches them using RocketReach to fetch verified emails and contact details, applies confidence-based filtering, and uses GPT-4o-mini to score each lead based on seniority, company fit, and data quality. High-quality leads automatically generate Asana tasks and Slack notifications, while low-quality leads are safely filtered out — ensuring your team focuses only on the best opportunities. 🚀📋 🔁 What This Template Does 1️⃣ Receives inbound lead data via webhook (name, company, job title, LinkedIn URL). 🌐 2️⃣ Normalizes incoming data into a clean, structured format. 🧾 3️⃣ Enriches lead profiles using RocketReach to fetch emails and phone numbers. 📇 4️⃣ Calculates email confidence scores based on quality grades (A–D). 📊 5️⃣ Filters out low-confidence leads automatically. 🚫 6️⃣ Uses AI (GPT-4o-mini) to score qualified leads from 1–10. 🤖 7️⃣ Assigns priority levels (High / Medium / Low) with reasoning. 🧠 8️⃣ Creates an Asana task for leads scoring above the threshold. ✅ 9️⃣ Sends Slack notifications for both qualified and disqualified leads. 💬 🔟 Returns a structured webhook response with scoring results. 🔁 1️⃣1️⃣ Sends Gmail alerts automatically if any workflow error occurs. 🚨 ⭐ Key Benefits ✅ Eliminates manual lead enrichment and qualification ✅ Uses verified contact data from RocketReach ✅ AI scoring ensures consistent, unbiased lead evaluation ✅ Automatically routes high-quality leads to sales via Asana ✅ Keeps teams informed with real-time Slack notifications ✅ Prevents sales effort from being wasted on low-quality leads 🧩 Features Webhook-based inbound lead intake RocketReach profile enrichment Email confidence scoring logic AI lead scoring with strict JSON output Configurable quality and score thresholds Automatic Asana task creation Slack alerts for qualified and disqualified leads Gmail-based error handling Frontend-ready webhook responses 🔐 Requirements RocketReach API key OpenAI API key (GPT-4o-mini recommended) Asana OAuth2 credentials Slack API credentials Gmail OAuth2 credentials (for error alerts) Webhook client sending lead details (first_name, last_name, company, job_title, linkedin_url) 🎯 Target Audience B2B sales teams handling inbound leads Revenue operations (RevOps) teams SaaS companies optimizing lead qualification Lead generation agencies Automation teams building AI-driven sales pipelines

Sync your Google Calendar events with Google Sheets and get daily Slack summaries with meeting statistics. FEATURES: Real-time sync of new and updated events Auto-categorization (Meeting, 1:1, Interview, Demo, Focus Time) Platform detection (Google Meet, Zoom, Teams) Daily statistics dashboard Cancellation tracking Optional email notifications to attendees FLOWS: New Event: Log to Sheets + Slack notification + Optional email Updated Event: Update Sheets + Slack notification Canceled Event: Log cancellation + Slack alert Daily Summary (8AM): Meeting time stats + Schedule to Slack SETUP: Connect Google account with Calendar access Create Google Sheet with 3 tabs: Events: ID, Synced At, Title, Category, Date, Day, Start Time, End Time, Duration, Platform, Attendees, Status, Meeting Link Cancellations: ID, Canceled At, Title, Original Date, Original Time, Affected Attendees Statistics: Date, Total Events, Meeting Time, Minutes, Busy %, Status, Virtual, In-Person Replace YOUR_DOCUMENT_ID in all Sheets nodes Connect Slack (#calendar, #errors channels) Optional: Connect Gmail for attendee notifications DAILY STATISTICS: Total events count Time spent in meetings Busy percentage of work day Virtual vs in-person breakdown Full day schedule IDEAL FOR: Anyone wanting to track their calendar, analyze meeting patterns, or get daily schedule summaries on Slack.

This workflow automatically collects customer reviews from Google, Facebook, Trustpilot, and Yelp, analyzes their sentiment using AI, sends real-time alerts for negative feedback, and generates a weekly summary report. It is ideal for businesses that want to monitor their online reputation across multiple platforms and respond quickly to customer concerns. How It Works Daily Schedule**: Triggers the workflow every day at 09:00. Review Collection**: Fetches new reviews from Google, Facebook, Trustpilot, and Yelp using their official APIs. Data Normalization**: Merges and standardizes all reviews into a unified format. AI Sentiment Analysis**: Uses GPT-4 to analyze the sentiment and extract key insights from each review. Negative Review Alerts**: Sends a Slack notification to managers if a negative review is detected. Logging**: Saves all reviews and their analysis to a Google Sheet for record-keeping. Weekly Reporting**: Every Monday, aggregates the past week’s reviews, generates an AI-powered summary, and emails it to management. Configuration API Credentials: Google My Business API: Create a project in Google Cloud, enable the My Business API, and generate OAuth credentials. Facebook Graph API: Create a Facebook App, request the necessary permissions, and obtain a Page Access Token. Trustpilot API: Register for a Trustpilot Business account and generate an API key. Yelp Fusion API: Sign up for Yelp Fusion, create an app, and get your API key. OpenAI API: Create an account at OpenAI, generate an API key for GPT-4 access. Slack API: Create a Slack App, enable Incoming Webhooks, and get the webhook URL. Google Sheets API: Enable the Google Sheets API in Google Cloud and create OAuth credentials. Set Up Environment Variables: Add all API keys, tokens, and configuration values in the Workflow Configuration node or as n8n credentials. Google Sheet Setup: Create a Google Sheet with columns for review data and share it with your service account email. Slack Channel: Set up a Slack channel for alerts and add the webhook URL in the configuration. Email Settings: Configure the recipient email address for weekly reports in the workflow. Usage Activate the workflow after configuration. Reviews will be collected and analyzed daily. Negative reviews trigger instant Slack alerts. Every Monday, a summary report is sent via email. Use Case: Monitor and respond to customer feedback across Google, Facebook, Trustpilot, and Yelp, automate sentiment analysis, and keep management informed with actionable weekly insights.

Description This workflow is designed for B2B/SaaS teams who want to secure renewals before it’s too late. It runs every day, identifies all accounts whose licenses are up for renewal in J–30, enriches them with CRM, product usage and support data, computes an internal churn risk level, and then triggers the appropriate playbook: HIGH risk** → full escalation (tasks, alerts, emails) MEDIUM risk** → proactive follow-up by Customer Success LOW risk** → light renewal touchpoint / monitoring Everything is logged into a database table so that you can build dashboards, run analysis, or plug additional automations on top. How it works Daily detection (J–30 renewals) A scheduled trigger runs every morning and queries your database (Postgres / Supabase) to fetch all active subscriptions expiring in 30 days. Each row includes the account identifier, name, renewal date and basic commercial data. Data enrichment across tools For each account, the workflow calls several business systems to collect context: HubSpot → engagement history Salesforce → account profile and segment Pipedrive → deal activities and associated products Analytics API → product feature usage and activity trends Zendesk → recent support tickets and potential friction signals All of this is merged into a single, unified item. Churn scoring & routing An internal scoring step evaluates the risk for each account based on multiple signals (engagement, usage, support, timing). The workflow then categorizes each account into one of three risk levels: HIGH – strong churn signals → needs immediate attention MEDIUM – some warning signs → needs proactive follow-up LOW – looks healthy → light renewal reminder A Switch node routes each account to the relevant playbook. Automated playbooks 🔴 HIGH risk Create a Trello card on a dedicated “High-Risk Renewals” board/list Create a Jira ticket for the CS / AM team Send a Slack alert in a designated channel Send a detailed email to the CSM and/or account manager 🟠 MEDIUM risk Create a Trello card in a “Renewals – Follow-up” list Send a contextual email to the CSM to recommend a proactive check-in 🟢 LOW risk Send a soft renewal email / internal note to keep the account on the radar Logging & daily reporting For every processed account, the workflow prepares a structured log record (account, renewal date, risk level, basic context). A Postgres node is used to insert the data into a churn_logs table. At the end of each run, all processed accounts are aggregated and a daily summary email is sent (for example to the Customer Success leadership team), listing the renewals and their risk levels. Requirements Database A table named churn_logs (or equivalent) to store workflow decisions and history. Example fields: account_id, account_name, end_date, riskScore, riskLevel, playbook, trello_link, jira_link, timestamp. External APIs HubSpot (engagement data) Salesforce (account profile) Pipedrive (deals & products) Zendesk (support tickets) Optional: product analytics API for usage metrics Communication & task tools Gmail (emails to CSM / AM / summary recipients) Slack (alert channel for high-risk cases) Trello (task creation for CS follow-up) Jira (escalation tickets for high-risk renewals) Configuration variables Thresholds are configured in the Init config & thresholds node: days_before_renewal churn_threshold_high churn_threshold_medium These parameters let you adapt the detection window and risk sensitivity to your own business rules. Typical use cases Customer Success teams who want a daily churn watchlist without exporting spreadsheets. RevOps teams looking to standardize renewal playbooks across tools. SaaS companies who need to prioritize renewals based on real risk signals rather than gut feeling. Product-led organizations that want to combine usage data + CRM + support into one automated process. Tutorial video Watch the Youtube Tutorial video About me : I’m Yassin a Project & Product Manager Scaling tech products with data-driven project management. 📬 Feel free to connect with me on Linkedin

🎫 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: Application Submission Journalist fills out form on your event website (name, email, media outlet, photo, phone) Data Validation Webhook receives application and checks for required fields (name, email, photo) Email Verification VerifiEmail API validates email domain, checks MX records, and confirms media affiliation Credential Generation Generates unique press ID (PRESS-XXX-timestamp) Creates QR code linking to verification portal Sets 30-day validity period 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 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 Event Check-In Security scans QR code at event entrance, verifies credentials instantly 🚀 Setup Instructions Quick Start (15 minutes): Import Workflow Download the JSON file In n8n: Click Workflows → Import from File Upload the JSON and open the workflow Configure Webhook Activate the workflow Copy the webhook URL from the Webhook Trigger node Add this URL to your website form's action attribute 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 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 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 Update Email Content Open "Send Press Pass Email" node Customize email text, support contact info Update company/event branding Modify footer with your details Configure Slack Channel Open "Notify Organizers (Slack)" node Select your preferred notification channel Customize notification message format 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": "[email protected]", "media_outlet": "BBC News", "photo_url": "https://randomuser.me/api/portraits/women/50.jpg", "phone": "+44-1234567890", "event_name": "Tech Summit 2025" }' 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.

Automated Email Verification & Digital Health Card Generator Overview Transform your clinic's patient check-in process with this fully automated pre-registration system. When patients submit their appointment information through your website, this workflow instantly verifies their email, generates a professional digital health card with a scannable QR code, stores it securely in Google Drive, and sends personalized notifications to both the patient and your reception team—all in under 20 seconds. What This Workflow Does This comprehensive automation handles the entire patient pre-check-in journey: Receives Patient Data - Webhook captures form submissions from your website or app with patient details (name, email, phone, appointment date/time, symptoms, age, gender) Validates & Cleans Data - Automatically validates required fields, cleans input data, and generates a unique patient ID with timestamp for tracking Verifies Email Address - Uses VerifiEmail API to ensure email deliverability by checking RFC compliance, MX records, and filtering out disposable/spoof emails Generates QR Code - Creates a unique verification URL and scannable QR code for instant patient identification at reception Builds Professional Health Card - Generates a beautiful, responsive HTML health card featuring: Patient information grid (name, ID, email, phone, age/gender, appointment) Chief complaints/symptoms section Embedded QR code for quick check-in Important appointment instructions Modern gradient design with mobile-responsive layout Converts to PNG Image - Uses HTMLCSSToImg API to convert the HTML card into a high-quality PNG image (900x1200px) Stores in Google Drive - Uploads the health card to an organized "Patients record" folder with patient ID-based naming for easy retrieval Emails Patient - Sends a beautifully formatted email to the patient containing: Their health card as a PNG attachment Appointment details and confirmation Google Drive link for backup access Check-in instructions and preparation tips Notifies Reception Team - Sends real-time Slack message to clinic reception with patient details, verification status, and Drive link Logs to Database - Records complete patient information, timestamps, verification status, and file links in Google Sheets for tracking and analytics Returns Success Response - Sends JSON response back to the website form with patient ID, confirmation, and Drive link Key Features ✅ Email Verification - VerifiEmail API integration prevents failed deliveries and fake emails ✅ Unique Patient IDs - Timestamp-based IDs ensure no duplicates (format: PAT-{timestamp}-{random}) ✅ QR Code Generation - Free QR Server API creates scannable codes for instant check-in ✅ Professional Design - Modern, gradient-styled health cards with responsive layout ✅ Multi-format Output - PNG image format for easy viewing on any device ✅ Cloud Storage - Secure Google Drive storage with organized folder structure ✅ Multi-channel Notifications - Email to patient + Slack to staff for complete coverage ✅ Comprehensive Logging - Google Sheets database for analytics and record-keeping ✅ Error Handling - Graceful failure for invalid emails with user notification ✅ Webhook Response - Real-time feedback to website form for seamless UX ✅ Indian Locale Support - Date/time formatting in Indian format with 12-hour time ✅ Mobile Responsive - Health cards look great on both desktop and mobile devices Perfect For 🏥 Medical Clinics & Healthcare Providers - Streamline patient pre-registration and reduce waiting times 🦷 Dental Practices - Digital check-in for appointments with patient history 💉 Diagnostic Centers - Pre-appointment verification for lab tests and scans 👨‍⚕️ Specialist Doctors - Organized patient records with symptoms documentation 🏃 Physiotherapy Clinics - Track patient visits and treatment history 💆 Wellness Centers & Spas - Appointment management with customer details 🐕 Veterinary Clinics - Pet owner pre-registration system 📋 Any Appointment-Based Business - Adaptable to salons, consultancies, or service providers Business Benefits 💰 Reduced No-Shows - Email verification ensures valid contact information ⏱️ Time Savings - Eliminates manual data entry at reception 📊 Better Analytics - Automated logging provides insights into patient flow ✨ Professional Image - Modern, branded health cards improve patient experience 🔒 Secure Records - Cloud storage with organized folder structure 📱 Contactless Check-in - QR codes enable touch-free reception process 🎯 Improved Communication - Multi-channel notifications keep everyone informed 🚀 Scalable System - Handles high volumes without additional staff Required Services & Credentials VerifiEmail API - Email verification service Sign up at: https://verifi.email HTMLCSSToImg API - HTML to image conversion Sign up at: https://htmlcsstoimg.com Google Drive - Cloud file storage Requires: Google Account with Drive access Gmail - Email delivery Requires: Google Account Slack - Team notifications Requires: Slack workspace Google Sheets - Database logging Requires: Google Account Customization Options Change Health Card Design: Edit the "Build Health Card HTML" node Modify CSS styles, colors, layout, fonts Add clinic logo by including `` tag in header Adjust Email Template: Edit the "Email Health Card to Patient" node Customize subject line, message content, styling Add clinic branding and contact information Modify Slack Message: Edit the "Notify Reception Team" node Change message format, add emojis, include additional fields Integrate with different channels Add PDF Generation: Insert an additional HTTP Request node after "Build Health Card HTML" Use a PDF conversion API (like PDFMunk or Puppeteer) Upload both PNG and PDF to Google Drive Add SMS Notifications: Insert Twilio or similar SMS node after email verification Send appointment confirmation via SMS Include patient ID and appointment time Multi-language Support: Modify the HTML template to support multiple languages Add language detection based on patient input Translate email and Slack messages Troubleshooting Guide Email Verification Fails: Check VerifiEmail API key is correct Verify API quota hasn't been exceeded Test with known valid email address Image Generation Fails: Check HTMLCSSToImg API credentials Verify HTML content is valid (no syntax errors) Check API rate limits Google Drive Upload Fails: Re-authenticate Google Drive OAuth2 credentials Check folder permissions Verify folder ID is correct Email Not Sending: Re-authenticate Gmail OAuth2 credentials Check email attachment size limits Verify "Less secure app access" if using password auth Slack Message Not Posting: Check Slack app permissions Verify channel exists and bot is invited Re-authenticate Slack credentials Google Sheets Not Logging: Re-authenticate Google Sheets credentials Verify sheet name and column headers match exactly Check sheet permissions Performance & Scalability Expected Performance: Single execution: 15-20 seconds Concurrent executions: Supports multiple parallel workflows API rate limits: Respects all third-party API limits Volume Handling: Small clinics: <50 patients/day - Perfect Medium practices: 50-200 patients/day - Excellent Large hospitals: 200+ patients/day - Consider API tier upgrades Security & Compliance ✅ Data Privacy - Patient data transmitted securely via HTTPS ✅ Access Control - OAuth2 authentication for all Google services ✅ Secure Storage - Files stored in private Google Drive folders ✅ Audit Trail - Complete logging in Google Sheets with timestamps ✅ Email Verification - Prevents data leakage to invalid addresses ✅ No Data Storage in n8n - Patient data passes through, not stored Tags healthcare, medical, clinic, patient-management, appointment, email-verification, qr-code, google-drive, gmail, slack, automation, workflow, pre-checkin, health-card, verifi-email, htmlcsstoimg, medical-records, patient-portal, healthcare-automation, clinic-management Category Healthcare & Medical Subcategory Patient Management & Appointment Systems License MIT License - Free to use, modify, and distribute with attribution

This workflow provides a comprehensive weather reporting system with two main functionalities: a scheduled daily summary and an interactive AI agent for dynamic queries. Who's it for? This template is ideal for anyone who wants to stay updated on the weather, from individuals planning their day to teams needing automated daily briefings. It's also a great example for developers and n8n users who want to explore the capabilities of AI Agents and integrating external APIs in their workflows. What it does / How it works This workflow operates in two distinct modes: Scheduled Daily Summary: The workflow triggers automatically every day at 9:00 AM (customizable) or can be run manually. It fetches the latest weather data for a specified location (default is near Chiba, Japan) from the Open-Meteo API. It then formats a message with the day's maximum and minimum temperatures. Finally, it sends this summary to a designated Gmail address and a Slack channel. AI-Powered Forecasts via Chat: When you send a message to the Chat Trigger webhook, it activates the AI Agent. The AI Agent, powered by an OpenAI model, understands natural language questions like "What's the humidity right now?" or "Will it be warmer tomorrow?". The agent uses an HTTP Request tool to fetch real-time, specific data from the weather API to answer your question. The generated answer is then sent back to you via both Gmail and Slack. How to set up Configure Credentials: Add your credentials for OpenAI, Gmail, and Slack in the credentials menu. Set Your Location: In the Fetch Weather Data and HTTP Request Tool for AI nodes, update the latitude and longitude in the URL to your desired location. Update Email and Slack: In the Send Email Summary and Send AI Response via Email nodes, change the recipient email address to your own. In the Send Slack Summary and Send AI Response via Slack nodes, select your desired Slack channel. Adjust the Schedule: Modify the Schedule Trigger node to change the time or frequency of the daily summary. Activate the Workflow: Click the "Active" toggle in the top-right corner to enable the workflow. How to customize the workflow Change the Message:** You can easily customize the notification message in the Format Daily Summary node (for the summary) and in the Send... nodes for both flows. Add More Data:** The Open-Meteo API provides a wealth of data. You can fetch additional information like precipitation, wind speed, or UV index by modifying the URL in the HTTP Request nodes. Integrate Other Services:** Add other notification nodes like Discord, Telegram, or Microsoft Teams to send the weather reports to more platforms.

💬 AI Gmail Support Automation with Google Gemini, OpenAI & Pinecone 🚀 How it Works This workflow turns your Gmail inbox into an AI-powered customer support assistant using Google Gemini, OpenAI embeddings, and Pinecone vector search. It automatically classifies incoming emails, retrieves context-based answers from your knowledge base, and replies instantly saving your support team valuable time. 🔁 Workflow Overview Gmail Trigger** → Detects new incoming customer emails. Intent Classifier** → Identifies if the email is a support query or something else. Vector Store (Pinecone)** → Retrieves the most relevant information. Email Support Agent (Gemini)** → Generates a clear, human-like response. Gmail Node** → Sends the AI-generated reply automatically. Slack Notification** → Updates your team about the response. Label Query** → Adds Gmail labels for tracking and organization. This automation provides 24/7 AI-based email support, faster customer responses, and zero manual data lookup — ideal for busy teams handling repetitive queries. 👥 Who It’s For SaaS companies** managing frequent customer support requests Startups and agencies** looking to automate inbox replies Customer success teams** aiming to improve response time Freelancers or small businesses** who want smart, auto-handled Gmail support ⚙️ Set Up Steps Estimated setup time: 10–15 minutes Connect your Gmail and Slack accounts to n8n. Add your API keys: Google Gemini API key OpenAI API key Link your Pinecone Vector Database (or create a new one). Customize the system message in the “Email Support Agent” node to match your tone or brand style. Send test emails to ensure the automation responds correctly and labels messages as intended. Check Slack notifications to confirm your team gets updates on replies. 💡 Detailed setup notes are included in the sticky notes inside the workflow. 🧩 Integrations Used Gmail API Google Gemini LLM OpenAI Embeddings Pinecone Vector Database Slack API 💡 Key Benefits Provides instant AI-based email replies 24/7 Reduces manual workload for support teams Maintains consistent and accurate tone using your knowledge base Keeps your inbox organized with automatic labels and team alerts Ideal for scaling customer support without hiring more agents

Description Automatically send personalized customer feedback requests once a support ticket is marked as closed and centralize responses for service quality tracking. Uses Google Sheets as the ticket source, filters only resolved tickets, and delivers tailored survey invitations via Gmail. Ensures timely, relevant outreach while reducing manual follow-ups. 📧✨ What This Template Does Fetches support ticket data from a Google Sheets database (“Ticket status dummy”). 📊 Filters for tickets where Status = closed only. 🎯 Sends a personalized feedback request email via Gmail, including ticket details (ID, subject, customer name). 💌 Provides a dynamic link to your survey form (Typeform/Google Form). 🔗 Runs on manual trigger (can be scheduled/automated later). ▶️ Key Benefits Targeted communication — only resolved tickets receive surveys. Personalized emails — includes customer name + ticket details. Zero manual work — feedback requests are automatically generated. Quality insights — structured process for customer satisfaction measurement. Improved experience — timely outreach builds trust and engagement. 🌟 Features Smart filtering for closed tickets only. 🛡️ Dynamic Gmail email templates with emojis + survey link. 💬 Google Sheets integration for centralized ticket management. 📂 Fully customizable email subject, body, and survey form. ✍️ Manual trigger for testing; can be extended with schedules/webhooks. ⏱️ Requirements n8n instance (cloud or self-hosted). Google Sheets with ticket data (must include: Status, Ticket No., Description, Email, Owner). Gmail account connected via OAuth2 credentials. Survey form (Typeform/Google Form) with accessible link. Target Audience Customer Support Teams seeking structured feedback. 🛎️ HR & Internal IT Teams using ticket-based systems (Keka, Google Sheets). 👥 Managers wanting data-driven insights into support quality. 📈 Businesses committed to continuous service improvement. 🚀 Step-by-Step Setup Instructions Prepare Google Sheet with required columns: Status, Ticket No., Description, Email, Owner. In n8n, connect Google Sheets and Gmail credentials. Update the Gmail node with your survey link. Import workflow JSON and assign credentials to nodes. Run Manual Trigger to test → verify email delivery. Extend automation with schedules or webhooks for ongoing campaigns.

Description: Keep your API documentation accurate and reliable with this n8n automation template. The workflow automatically tests your FAQ content related to authentication and rate limits, evaluating each answer using Azure OpenAI GPT-4o-mini for completeness, edge-case coverage, and technical clarity. It logs all results to Google Sheets, scores FAQs from 0–10, and sends Slack alerts when low-quality answers are detected. Ideal for API teams, developer relations managers, and technical writers who want to maintain high-quality documentation with zero manual review effort. ✅ What This Template Does (Step-by-Step) ▶️ Manual Trigger or On-Demand Run Start the evaluation anytime you update your FAQs — perfect for regression testing before documentation releases. 📖 Fetch FAQ Q&A from Google Sheets Reads FAQ questions and answers from your designated test sheet (columns A:B). Each Q&A pair becomes a test case for AI evaluation. 🤖 AI Evaluation via GPT-4o-mini Uses Azure OpenAI GPT-4o-mini to evaluate how well each FAQ covers critical aspects of API authentication and rate limiting. The AI provides a numeric score (0–10) and a short explanation. 🔍 Parse & Format AI Results Extracts structured JSON data (Question, Score, Explanation, Timestamp) and prepares it for reporting and filtering. 💾 Save Evaluation to Google Sheets Appends all results to a Results Sheet (A:D) — creating a running history of FAQ quality audits. ⚠️ Filter for Low-Scoring FAQs Identifies any FAQ with a score below 7, flagging them as needing review or rewrite. 🔔 Send Slack Alerts for Weak Entries Posts an alert message in your chosen Slack channel, including: The question text Score received AI’s explanation Link to the full results sheet This ensures your documentation team can quickly address weak or incomplete FAQ answers. 🧠 Key Features 🤖 AI-powered FAQ quality scoring (0–10) 📊 Automated tracking of doc health over time 📥 Seamless Google Sheets integration for results storage ⚙️ Slack notifications for underperforming FAQs 🧩 Ideal for continuous documentation improvement 💼 Use Cases 📘 Validate FAQ accuracy before API documentation updates ⚡ Auto-test new FAQ sets during content refresh cycles 🧠 Ensure API rate limit and auth topics cover all edge cases 📢 Alert documentation owners about weak answers instantly 📦 Required Integrations Google Sheets API – for reading and storing FAQs and test results Azure OpenAI (GPT-4o-mini) – for evaluating FAQ coverage and clarity Slack API – for sending quality alerts and notifications 🎯 Why Use This Template? ✅ Ensures API FAQ accuracy and completeness automatically ✅ Replaces tedious manual content reviews with AI scoring ✅ Builds an ongoing record of documentation improvements ✅ Keeps technical FAQs consistent, relevant, and developer-friendly

📘 Description: This automation streamlines client review collection and sentiment summarization for Techdome using HighLevel CRM, Azure OpenAI GPT-4o, Gmail, Slack, and Google Sheets. It starts by pulling recently won deals from HighLevel, then generates and sends AI-written HTML review request emails with built-in Google Review and feedback form links. After waiting 24 hours, it fetches the client’s reply thread, summarizes the sentiment using GPT-4o, and posts a clean update to Slack for team visibility. Any failures—API errors, empty responses, or data validation issues—are logged automatically to Google Sheets for full transparency and QA. The result: a fully hands-free Client Appreciation + Feedback Intelligence Loop, improving brand perception and internal responsiveness. ⚙️ What This Workflow Does (Step-by-Step) ▶️ When Clicking ‘Execute Workflow’ (Manual Trigger) Allows on-demand execution or scheduled testing of the workflow. Initiates the fetch for all newly “Won” deals from HighLevel CRM. 🏆 Fetch All Won Deals from HighLevel Retrieves all opportunities labeled “won” in HighLevel, gathering essential client details such as name, email, and deal information to personalize outgoing emails. 🔍 Validate Deal Fetch Success (IF Node) Checks each record for a valid id field. ✅ True Path: Moves ahead to generate AI email content. ❌ False Path: Logs the event to Google Sheets under the error log sheet. 🧠 Configure GPT-4o Model (Azure OpenAI) Initializes the GPT-4o engine that powers all language-generation tasks in this workflow—ensuring precise tone, correct formatting, and safe structured HTML output. 💌 Generate Personalized Review Request Email (AI Agent) Uses GPT-4o to create a tailored, HTML-formatted email thanking the client for their business and requesting feedback. Includes two clickable CTA buttons: ⭐ Google Review Link: 📝 Internal Feedback Form: Google Form link for in-depth feedback Each email maintains Techdome’s friendly, brand-consistent voice with clean inline CSS styling. 📨 Send Review Request Email to Client (Gmail Node) Automatically sends the AI-generated email to the client’s registered address through Gmail. Ensures timely post-service communication without manual follow-ups. ⏳ Wait for 24 Hours Before Next Action Pauses the workflow for 24 hours to give clients time to read and respond to the review request. 📥 Retrieve Email Thread for Response (Gmail Node) After the waiting period, fetches the Gmail thread associated with the initial email to capture client replies or feedback messages. 🧠 Configure GPT-4o Model (Summarization Engine) Prepares another GPT-4o instance specialized for summarizing client replies into concise, sentiment-aware Slack messages. 💬 Summarize Client Feedback (AI Agent) Analyzes the Gmail thread and produces a short Slack-formatted summary using this structure: 🎉 New Client Review Received!Client: <Name> Feedback: <Message snippet> Sentiment: Positive / Neutral / Negative Focuses on tone clarity and quick readability for internal teams. 📢 Announce Review Summary in Slack Posts the AI-generated summary in a designated Slack channel, keeping success and support teams instantly informed of client sentiments and feedback trends. 📊 Log Errors in Google Sheets Appends all failures—including fetch issues, missing fields, or parsing errors—to the Google Sheets “error log sheet,” maintaining workflow reliability and accountability. 🧩 Prerequisites HighLevel CRM OAuth credentials (to fetch deals) Azure OpenAI GPT-4o access (for AI-driven writing and summarization) Gmail API connection (for sending & reading threads) Slack API integration (for posting summaries) Google Sheets access (for error logging) 💡 Key Benefits ✅ Automates personalized review outreach after project completion ✅ Waits intelligently before analyzing responses ✅ Uses GPT-4o to summarize client sentiment in human tone ✅ Sends instant Slack updates for real-time visibility ✅ Keeps audit logs of all errors for debugging 👥 Perfect For Client Success and Account Management Teams Agencies using HighLevel CRM for project delivery Teams aiming to collect consistent client feedback and reviews Businesses wanting AI-assisted sentiment insights in Slack

Introduction Automates travel planning by aggregating flights, hotels, activities, and weather via APIs, then uses AI to generate professional itineraries delivered through Gmail and Slack. How It Works Webhook receives requests, searches APIs (Skyscanner, Booking.com, Kiwi, Viator, weather), merges data, AI builds itineraries, scores options, generates HTML emails, delivers via Gmail/Slack. Workflow Template Webhook → Extract → Parallel Searches (Flights/Hotels/Activities/Weather) → Merge → Build Itinerary → AI Processing → Score → Generate HTML → Gmail → Slack → Response Workflow Steps Trigger & Extract: Receives destination, dates, preferences, extracts parameters. Data Gathering: Parallel APIs fetch flights, hotels, activities, weather, merges responses. AI Processing: Analyzes data, creates itinerary, ranks recommendations. Delivery: Generates HTML email, sends via Gmail/Slack, confirms completion. Setup Instructions API Configuration: Add keys for Skyscanner, Booking.com, Kiwi, Viator, OpenWeatherMap, OpenRouter. Communication: Connect Gmail OAuth2, Slack webhook. Customization: Adjust endpoints, AI prompts, HTML template, scoring criteria. Prerequisites API keys: Skyscanner, Booking.com, Kiwi, Viator, OpenWeatherMap, OpenRouter Gmail account Slack workspace n8n instance Use Cases Corporate travel planning Vacation itinerary generation Group trip coordination Customization Add sources (Airbnb, TripAdvisor) Filter by budget preferences Add PDF generation Customize Slack format Benefits Saves 3-5 hours per trip Real-time pricing aggregation AI-powered personalization Automated multi-channel delivery

Who’s it for Teams that collect meeting requests via a form and want instant, error-free scheduling: customer success, sales, education, agencies, and community managers. How it works / What it does This workflow ingests a form submission (name, email, preferred date/time), checks Google Calendar for conflicts, and branches automatically. If the slot is free, it creates a calendar event, spins up a Zoom meeting, emails the guest a confirmation, and posts a Slack summary to your team. If busy, it sends a polite “please pick another time” email. Time handling defaults to Asia/Tokyo and converts to ISO internally to keep downstream integrations consistent. How to set up Import the workflow and rename nodes for clarity if needed. Open the Workflow Configuration (Set) node and adjust variables (calendar ID, meeting duration, Slack channel, sender info). Map your form fields in Extract Booking Details. Connect credentials in each service node (Google Calendar, Zoom, Gmail, Slack). Test once with a real submission. Requirements Active accounts and n8n credentials for Google Calendar, Zoom, Gmail, and Slack. A form or webhook source that sends name, email, and a valid datetime. How to customize the workflow Duration & buffers: Change end time calculation in Extract Booking Details. Time zones: If you accept multiple time zones, normalize before building ISO strings. Email copy: Personalize confirmation/alternative-time messages and add attachments if desired. Slack format: Enrich the post with fields (host, Zoom join URL, internal tags). Routing: Add CRM updates or reminders after the “slot free” branch. Security note: No hardcoded API keys in HTTP nodes. Configure all credentials via n8n’s credential manager.

Streamline client onboarding and project setup from hours to minutes with AI-driven automation. This intelligent workflow eliminates manual coordination, builds proposals, creates projects in Asana, welcomes clients on Slack, and logs everything — ensuring 90% faster onboarding and zero dropped steps. What This Workflow Does Transforms your client onboarding from scattered tools and emails into one seamless automation: 📝 Capture Client Details – Jotform intake form collects client, company, and project information. 🧠 AI-Powered Analysis – LangChain AI Agent analyzes the project scope, estimates effort, and recommends team composition. 📄 Generate Proposal – Automatically builds a professional HTML proposal summarizing goals, timeline, and estimated hours. 🗂️ Create Asana Project – Generates a new project with all key details, milestones, and assigned team members. 💬 Slack Collaboration – Creates a dedicated Slack channel, sends welcome messages, and introduces the project team. 📧 Welcome Email – Sends a personalized onboarding email to the client with project summary and next steps. 💼 CRM Sync – Creates or updates a HubSpot contact with complete project and client information. 📊 Audit Logging – Logs all onboarding activity to Google Sheets for centralized record-keeping. Key Features 🤖 AI Proposal Generation – Uses LangChain AI to generate smart project summaries and resource plans. ⚙️ End-to-End Automation – From form submission to project creation, communication, and CRM logging. 💬 Smart Slack Setup – Automatic channel creation and messaging for internal coordination. 📧 Personalized Client Emails – Beautifully formatted, professional onboarding emails. 🗂️ Asana Integration – Project creation with dynamic task templates and priorities. 📊 Google Sheets Logging – Instant audit trail for every client submission and generated proposal. 💼 CRM Integration – Automatically syncs client data with HubSpot for sales and account tracking. Perfect For 🚀 Agencies & Service Providers – Automate client onboarding, proposal creation, and task setup. 🏢 Consultancies – Quickly turn client requests into structured projects with assigned resources. 💻 Freelancers & Creators – Impress clients with AI-built proposals and instant communication. 📈 Growing Teams – Scale onboarding without extra admin or coordination time. 🧠 Operations Teams – Ensure consistency and transparency across all onboarding activities. What You’ll Need Required Integrations 🧾 Jotform – Client intake form (project details, budget, company info). Create your form for free on Jotform using this link 🤖 AI Agent – For analyzing project scope and building proposals. 🗂️ Asana – Project creation and task assignment. 💬 Slack – For automated client channel creation and internal communication. 📧 Gmail – For onboarding and proposal emails. 💼 HubSpot – CRM contact creation and project linkage. 📊 Google Sheets – For logging all onboarding and AI results. Optional Enhancements 📄 PDF Generation (PDF Munk) – Convert AI-generated proposals into downloadable PDFs. 💬 Slack Interactive Approvals – Add buttons for internal review before client communication. 📈 Performance Dashboard – Connect Google Sheets data to Looker Studio for tracking onboarding times. 🌍 Multilingual Support – Add translation nodes for international clients. 🔐 File Attachments – Send proposal PDFs or onboarding kits automatically via Gmail. Quick Start 1️⃣ Import Template – Copy and import the JSON file into your n8n workspace. 2️⃣ Set Up Jotform – Create a form with fields for client name, company, project name, budget, and requirements. 3️⃣ Add Credentials – Connect Jotform, AI Agent, Asana, Slack, Gmail, HubSpot, and Google Sheets. 4️⃣ Configure Sheet ID – Replace YOUR_SHEET_ID in the Google Sheets node. 5️⃣ Customize Proposal HTML – Edit AI prompt and branding to reflect your company’s style. 6️⃣ Test Workflow – Submit a test form and verify Slack, Asana, Gmail, and Sheets outputs. 7️⃣ Deploy – Activate workflow and share the Jotform link with your sales or operations team. Customization Options 1️⃣ Proposal Branding – Customize proposal HTML with logos, brand colors, and formatting. 2️⃣ AI Prompt Tuning – Refine the LangChain AI prompt to match your tone or project style. 3️⃣ Task Templates – Adjust task names, assignees, and due dates in the Asana creation node. 4️⃣ Slack Messaging – Update welcome message formatting and team introduction details. 5️⃣ CRM Fields – Map additional HubSpot properties for better data tracking. 6️⃣ Sheet Logging – Add more columns for tracking team recommendations or proposal scores. Expected Results ⚡ 90% Faster Onboarding – Reduce manual setup from hours to minutes. 🤖 AI Precision – Intelligent proposals and team allocations that impress clients instantly. 📈 Zero Missed Steps – Every project automatically created, communicated, and logged. 💬 Seamless Collaboration – Slack, Gmail, and Asana in perfect sync. 🗂️ Complete Transparency – Every onboarding step logged for accountability and improvement. 🏆 Use Cases 🧑‍💼 Marketing & Creative Agencies – Automate creative project scoping and proposal creation. 💻 Software Development Teams – Rapidly assess client tech requirements and allocate developers. 🧾 Consulting Firms – Build data-backed, AI-enhanced proposals for client engagements. 🏢 Corporate PMOs – Standardize project setup and approvals across multiple departments. Pro Tips 💡 Refine AI Prompt – Include examples of past projects to improve proposal quality. 💬 Add Slack Approvals – Insert “manager approval” logic before sending proposals. 📄 Attach PDFs – Use PDF Munk for branded, downloadable proposals. 📊 Track Conversion – Link HubSpot deal stage changes based on Asana progress. 📅 Monitor Efficiency – Use Sheet timestamps to calculate average onboarding time. Learning Resources This workflow demonstrates: AI integration using Agents Multi-app orchestration and data syncing Advanced HTML and email template customization Real-world Asana and Slack API usage CRM syncing and Google Sheets logging Modular, scalable n8n workflow design Workflow Structure Visualization 📝 Jotform Submission ↓ 🧠 AI Project Analysis (Agent) ↓ 📄 Proposal Generation (HTML) ↓ 🗂️ Asana Project Creation ↓ 💬 Slack Channel Setup & Message ↓ 📧 Gmail Welcome Email ↓ 💼 HubSpot Contact Creation ↓ 📊 Google Sheets Log Ready to Revolutionize Client Onboarding? Import this template today and let AI handle the heavy lifting. Your team saves hours, your clients get instant engagement — and your entire process runs flawlessly. ✨

Description Automate daily KPI tracking and reporting by integrating ClickUp tasks and Google Sheets lead data into a unified dashboard. This workflow computes performance metrics, analyzes sentiment, and delivers visualized reports to Slack and Gmail for instant team insights. 📊💬📧 What This Template Does Triggers automatically every day using a cron scheduler. ⏰ Fetches project task data from ClickUp, including status, priority, and assignee metrics. Retrieves lead generation data and responses from Google Sheets. Merges both data sources to create a unified performance dataset. Computes detailed KPI metrics (task completion, overdue %, sentiment analysis, response trends). Formats data for reporting and visualization. Posts a concise KPI summary snapshot to a designated Slack channel. Sends a professionally formatted HTML report via Gmail. Notifies your Slack channel instantly in case of any workflow errors. Key Benefits ✅ Eliminates manual KPI tracking and reporting. ✅ Combines ClickUp and Google Sheets data into one view. ✅ Provides real-time insights for decision-making. ✅ Automates daily updates for consistent visibility. ✅ Delivers both quick Slack summaries and detailed email reports. ✅ Built-in error alerting ensures uninterrupted automation. Features Scheduled daily cron trigger for automated execution. OAuth2-secured integrations with ClickUp, Google Sheets, Slack, and Gmail. Parallel data fetching for faster performance. Smart KPI calculations with sentiment and trend analysis. Custom HTML email template with visual charts and highlights. Slack snapshot notifications for instant updates. Error-handling mechanism with Slack alerts. Requirements ClickUp account with OAuth2 credentials. Google Sheets access with OAuth2 credentials. Slack API credentials with chat:write permission. Gmail OAuth2 credentials for report delivery. Target Audience Project managers tracking performance KPIs. Operations teams needing daily performance visibility. Marketing and sales teams monitoring task and lead metrics. Automation and analytics engineers building executive dashboards. Step-by-Step Setup Instructions Connect your ClickUp, Google Sheets, Slack, and Gmail accounts. 🔑 Replace placeholder IDs (Sheet ID, Channel ID, Email) with your actual values. Adjust the cron trigger time as per your timezone. Test with sample data to confirm correct KPI calculations. Enable workflow to start daily automated execution. 🚀

Upwork Messages Notifications (Gmail to Slack) - Fully Automated Alerts This n8n workflow streamlines how you receive Upwork client messages, sending instant notifications to Slack. It demonstrates two approaches: a code-based extraction and an AI-powered one with Google Gemini. Use Cases Instant Communication:** Get real-time alerts for new Upwork client messages in your team's Slack channel. Improved Responsiveness:** Quickly respond to client inquiries and maintain strong communication. Centralized Notifications:** Keep all your essential work-related notifications in one place. Good to Know The workflow is set to poll your Gmail every 3 minutes for unread Upwork messages, which can be reduced or increased. The AI Information Extractor with Google Gemini provides a more refined and robust method for data parsing compared to custom code. Usage of Google Gemini may incur costs. Refer to Gemini Pricing for updated information. Google Gemini models can be geo-restricted. If you encounter a "model not found" error, it might not be available in your region. How it Works Method 1: Code-Based Extraction Gmail Trigger: The workflow starts by monitoring your Gmail for new, unread emails from "via Upwork". Code Node: A custom JavaScript code block is used to extract the client's name and the message content directly from the email's text. Slack Notification: The extracted client name and message are then formatted and sent as a new message to a designated Slack channel. Method 2: AI-Powered Extraction with Google Gemini (Recommended) Gmail Trigger X: Similar to Method 1, this part also triggers on new unread Upwork emails. Information Extractor (AI): This powerful node, powered by Google Gemini, takes the entire email text and intelligently extracts structured information like the "client" name and the "message" content based on a defined schema. This method is more robust and requires less manual parsing logic. Google Gemini Chat Model: (Implicitly used by the Information Extractor) This node provides the underlying AI capabilities for intelligent information extraction. Send to Slack X: The refined output from the AI Information Extractor (client name and message) is then sent to a Slack channel. How to Use Gmail Credentials: Ensure you have configured your Gmail OAuth2 credentials in n8n for both "Gmail Trigger" nodes. Slack Credentials: Set up your Slack OAuth2 credentials in n8n for both "Send to Slack" nodes and select the desired Slack channel. Google Gemini Credentials: For the AI-powered workflow, you'll need to set up your Google Gemini API key as a credential in n8n. Activate Workflows: Enable both workflows in n8n to start receiving notifications. You can compare the output quality of each method. Requirements n8n instance** (self-hosted or cloud) Gmail Account** connected to Upwork notifications. Slack Workspace** and a designated channel for notifications. Google Gemini API key** for the AI-powered extraction workflow.

This workflow tracks week-over-week changes in Google Search Console performance and highlights the top movers across keyword segments like brand, nonbrand, and content categories. Instead of providing a routine check, it focuses on significant movements by: Sending a Slack alert only if a query crosses a defined movement threshold. Emailing a structured report with the Top 25 increases and Top 25 decreases for clicks, including % changes and linked URLs It’s designed to surface the most important shifts, helping SEO teams catch big wins, losses, or anomalies early. How it works Runs weekly (e.g. every Monday) to compare last week’s GSC data to the week prior. Segments traffic based on query and page (e.g. brand terms, category page URLs, etc.). Calculates delta and % change for clicks, CTR, impressions, and position. Filters and flags top movers with large shifts (default: ±200 clicks and ±30%). Sends Slack alerts only if meaningful changes are detected. Emails a full HTML table report showing the Top 25 up/down queries per segment. Setup steps Requires a connected Google Search Console account. Slack alert is included by default (can be replaced with email, webhook, or other tools). Customize your brand terms and URL filters to match your segments (e.g. recipes, blog, category pages). Typical setup time: 15–25 minutes depending on the number of segments and filters you want. Note: “Recipes” is used in the example to show how to segment by content type. You can update this to reflect your own site’s structure.

The Error Notification workflow is designed to instantly notify you whenever any other n8n workflow encounters an error, using popular communication channels like Telegram and Gmail—with optional support for Discord, Slack, and WhatsApp. 💡 Why Use Error Notification workflow? Immediate Awareness:** Get instant alerts when workflows fail, preventing unnoticed errors and downtime. Multi-Channel Flexibility:** Notify your team via Telegram, Gmail, and optionally Slack, Discord, or WhatsApp. Detailed Context:** Receive rich error information including the error message, node name, time, and execution link for quicker fixes. Easy Integration:** Built with native n8n nodes and customizable code, simple to adopt without complex setup. Open Source & Free:** Use and adapt this workflow at no cost, making professional error monitoring accessible. ⚡ Who Is This For? n8n Workflow Developers:** Quickly spot and respond to automation issues in development or production. Operations Teams:** Maintain uptime and swiftly troubleshoot errors across multiple workflows. Small to Medium Businesses:** Gain professional error alerting without expensive monitoring tools. Automation Enthusiasts:** Enhance your automation reliability with real-time failure notifications. ❓ What Problem Does It Solve? This workflow embedd error detection and notification directly within your n8n instance. It automates the process of catching errors as they occur, compiling meaningful context, and delivering it instantly via your preferred messaging platforms. This drastically reduces your response time to issues and streamlines error management, improving your automation reliability and operational confidence. 🔧 What This Workflow Does ⏱ Trigger: Listens for any error generated in your n8n workflows using the n8n Error Trigger node. 📎 Step 2: Executes a Code node that formats a detailed error message capturing workflow name, error node, description, timestamp, and an execution URL. 🔍 Step 3: Sends the formatted error notification to multiple communication channels: Telegram and Gmail by default, plus optionally Discord, Slack, and WhatsApp (disabled by default). 💌 Step 4: Delivers rich, parsed HTML-formatted messages to ensure error readability and immediate actionability. 🔐 Setup Instructions Import the provided .json file into your n8n instance (Cloud or self-hosted). Set up credentials: Gmail OAuth credentials for sending emails via Gmail node Telegram API credentials for Telegram notifications (Optional) Discord Webhook URL credential for Discord notifications (Optional) Slack Webhook credential for Slack notifications (Optional) WhatsApp connection credentials (if enabled) Customize the Code node if needed to adjust the error message format or target chat IDs. Update the chat IDs and recipient details in each notification node according to your channels. Test the workflow by manually triggering an error in another workflow to verify proper notifications. 🧩 Pre-Requirements Active n8n instance (cloud or self-hosted) with version supporting Error Trigger node Telegram bot credentials and chat ID (Optional) Gmail, Discord, Slack, or WhatsApp accounts and webhook credentials if you want to use those channels 🛠️ Customize It Further Enable and configure additional notification nodes like Slack or WhatsApp to fit your team's communication style. Customize the error message template in the Code node to include extra metadata or format it differently (e.g., markdown). Integrate with incident management tools via webhook nodes or create tickets automatically on error. 🧠 Nodes Used Error Trigger Code Telegram Gmail Discord (disabled) Slack (disabled) WhatsApp (disabled) Sticky Note (for description) 📞 Support Made by: khaisa Studio Tag: notification,error,monitoring,workflow,automation,alerts Category: Monitoring & Alerts Need a custom? Need a custom? contact me on LinkedIn or Web

What it does This workflow automatically processes incoming emails with intelligent AI classification, creating draft responses and sending Slack notifications based on email content. How it works Monitors emails with the 'AI-Agent' label AI classification into categories: Inquiry, Support, Newsletter, Action Item Adds appropriate labels to emails automatically Creates draft replies for Support and Inquiry emails Sends Slack notifications for Action Items and Newsletter summaries Setup Requirements Gmail OAuth2 credentials configured OpenAI API credentials (or other AI provider) Slack OAuth2 credentials (if notifications desired) Gmail labels created (see setup instructions below) How to customize Modify classification categories in the AI Agent Adjust label mappings in the Parse Classification node Customize draft response templates Configure different Slack channels for different email types

🤖 AI Reddit Scout Agent: Auto Post Analysis & Insights Stay ahead of trends and conversations with this intelligent n8n workflow that automatically monitors Reddit, analyzes discussions using AI, and delivers actionable insights to your team via Slack and Gmail. Perfect for market research, content inspiration, and competitive intelligence. 🔄 How It Works This automated 4-step intelligence gathering system runs daily to keep you informed: Step 1: Scheduled Monitoring The workflow automatically triggers daily (default: 9 AM) to scan Reddit for fresh discussions and trending topics. Step 2: Smart Content Retrieval The Reddit API integration searches specified subreddits using customizable filters: Target subreddits (e.g., r/ChatGPT, r/technology, r/startups) Keyword matching for specific topics Post ranking criteria (hot, top, new) Engagement thresholds (upvotes, comments) Step 3: AI-Powered Analysis Each retrieved post is processed by GPT-4 through a specialized agent that: Extracts key discussion points and themes Classifies topics in 3-5 word categories Generates concise one-sentence summaries Identifies sentiment and engagement patterns Highlights actionable insights and trends Step 4: Multi-Channel Distribution Analyzed insights are automatically delivered to: Slack channels for immediate team visibility Gmail inboxes for stakeholders and decision-makers Formatted with links back to original Reddit discussions ⚙️ Setup Steps Prerequisites Reddit account (for API access) OpenAI API key with GPT-4 access Slack workspace with posting permissions Gmail account for email distribution n8n instance (cloud or self-hosted) Configuration Steps Credential Setup Reddit API: Configure Reddit node with API credentials OpenAI API Key: Required for AI analysis and summarization Slack OAuth2: Connect workspace for channel posting Gmail OAuth2: Enable email distribution functionality Reddit Configuration Subreddit Selection: Define target communities to monitor Professional: r/entrepreneur, r/marketing, r/sales Technology: r/artificial, r/MachineLearning, r/programming Industry-specific: r/fintech, r/biotech, r/startups Search Parameters: Set keywords and filters Keywords: "AI trends", "market analysis", "customer feedback" Time ranges: past day, week, or month Minimum engagement thresholds AI Analysis Customization Default analysis prompt can be tailored for: Market Research Focus: Extract business insights and opportunities Competitive Intelligence: Identify competitor mentions and sentiment Content Ideas: Find trending topics for content creation Customer Research: Analyze user pain points and feedback Distribution Setup Slack Integration: Choose channels for different content types #market-intelligence for business insights #content-ideas for creative inspiration #competitive-intel for competitor discussions Email Configuration: Set recipient lists and formatting preferences Schedule Optimization Frequency: Daily, weekly, or custom intervals Timing: Optimize for team availability and time zones Volume Control: Limit posts per execution to avoid overwhelm 🚀 Use Cases Market Research & Intelligence Trend Identification: Spot emerging technologies and methodologies Customer Sentiment: Monitor brand mentions and user feedback Competitive Analysis: Track competitor discussions and reputation Industry Insights: Stay updated on regulatory changes and news Content Marketing Topic Discovery: Find trending subjects for blog posts and videos Audience Research: Understand community questions and pain points Content Validation: Test ideas before creating full content pieces Engagement Strategies: Learn what resonates with target audiences Product Development Feature Requests: Identify commonly requested functionality User Experience Feedback: Discover usability issues and improvements Market Validation: Gauge interest in new product concepts Beta Testing Insights: Monitor feedback on product releases Sales & Business Development Lead Generation: Find potential customers discussing relevant problems Objection Handling: Understand common concerns and hesitations Partnership Opportunities: Identify potential collaboration prospects Market Education: Understand knowledge gaps in your target market Investment & Strategy Startup Monitoring: Track emerging companies and funding news Technology Assessment: Evaluate new tools and platforms Risk Assessment: Monitor potential threats and challenges Opportunity Identification: Spot underserved markets and niches 🔧 Advanced Customization Options Multi-Subreddit Orchestration Configure different analysis approaches: Technical Communities: Focus on innovation and implementation details Business Communities: Extract market opportunities and strategies User Communities: Emphasize pain points and solution requests News Communities: Highlight breaking developments and reactions Sentiment & Engagement Scoring Enhance analysis with quantitative metrics: Sentiment Analysis: Positive, negative, neutral classification Engagement Prediction: Likelihood of viral content Influence Scoring: Identify high-authority contributors Trend Momentum: Track discussion growth over time Content Filtering & Prioritization Implement smart content curation: Quality Thresholds: Minimum upvotes, comments, or awards Relevance Scoring: AI-based topic matching and ranking Duplicate Detection: Avoid repetitive content in summaries Language Processing: Handle multiple languages and slang Extended Integration Options Connect additional platforms and tools: CRM Integration: Push leads to Salesforce, HubSpot, or Pipedrive Documentation Tools: Save insights to Notion, Obsidian, or Confluence Analytics Platforms: Feed data to Google Analytics or Mixpanel Social Media: Cross-post insights to Twitter, LinkedIn, or Facebook 📊 Output Examples Sample Slack Message: 🔍 Reddit Intelligence Report - r/ChatGPT 📊 Top Discussion: "Why I stopped using ChatGPT for coding" 📝 Topic: AI Tool Limitations & Alternatives 📋 Summary: Users discussing ChatGPT's declining code quality and exploring alternatives like Claude and GitHub Copilot for development work. 📈 Engagement: 847 upvotes, 234 comments 💭 Sentiment: Mixed (concerns about accuracy, praise for alternatives) 🔗 View Discussion: [Reddit Link] Key Insights: Growing demand for specialized coding AI tools Quality consistency remains a major user concern Opportunity for developer-focused AI solutions Generated at 9:15 AM • Next scan: Tomorrow 9:00 AM Gmail Report Format: Subject: Daily Reddit Intelligence - AI & Technology Trends 📡 REDDIT SCOUT REPORT Date: March 15, 2024 🎯 TOP INSIGHTS TODAY: AI Development Tools (r/programming) Discussion: "Best AI coding assistants in 2024" Insight: Developers increasingly comparing specialized tools vs general AI Engagement: High (500+ upvotes) Startup Funding (r/entrepreneur) Discussion: "Raised $2M seed round - lessons learned" Insight: Current funding landscape and investor priorities Engagement: Moderate (150+ upvotes) Customer Feedback (r/SaaS) Discussion: "Why our churn rate dropped 40%" Insight: Onboarding and support strategy impacts Engagement: High (300+ upvotes) 🔗 View all discussions: [Links included] Powered by AI Reddit Scout Agent Next report: Tomorrow at 9:00 AM 🛠️ Troubleshooting & Best Practices Common Issues & Solutions API Rate Limiting Implement exponential backoff delays Distribute requests across multiple time periods Cache results to minimize redundant calls Monitor Reddit API status and limits Content Quality Control Set minimum engagement thresholds Filter out low-quality or spam posts Implement keyword blacklists for irrelevant content Regular prompt tuning for better AI analysis Information Overwhelm Limit posts per subreddit per day Prioritize by engagement and relevance scores Create digest formats for high-volume periods Allow team members to customize their alerts Optimization Strategies Performance Enhancement Use parallel processing for multiple subreddits Implement caching for repeated analysis Optimize OpenAI prompt length and complexity Monitor and optimize workflow execution time Cost Management Balance AI analysis depth with API costs Use different models for different content types Implement smart filtering before AI analysis Track ROI through engagement metrics Team Adoption Start with pilot programs in specific departments Provide training on interpreting AI insights Create feedback loops for continuous improvement Establish clear action protocols for different insight types 📈 Success Metrics Intelligence Quality Indicators Relevance Score: Percentage of insights that lead to action Timeliness: How quickly trends are identified vs competitors Accuracy: Validation of AI predictions against actual outcomes Engagement: Team interaction with distributed insights Business Impact Measurements Content Performance: Improvement in content engagement rates Market Timing: Success rate of trend-based decisions Competitive Advantage: Early identification of opportunities/threats Time Savings: Reduction in manual research and monitoring time 📞 Questions & Support Need assistance with your AI Reddit Scout Agent setup or customization? 📧 Technical Support Email: [email protected] Response Time: Within 24 hours on business days Expertise: Reddit API integration, AI prompt optimization, workflow scaling 🎥 Learning Resources YouTube Channel: https://www.youtube.com/@YaronBeen/videos Complete setup and configuration guides Advanced filtering and analysis techniques Integration tutorials for popular business tools Troubleshooting common issues 🤝 Professional Networking LinkedIn: https://www.linkedin.com/in/yaronbeen/ Connect for ongoing automation support Share your intelligence gathering success stories Access to exclusive workflow templates and updates 💬 Support Request Guidelines Include in your message: Target subreddits and use cases Current team size and distribution needs Specific industries or topics of interest Integration requirements with existing tools Any error messages or unexpected behaviors

How It Works Trigger: Watches for new emails in Gmail with PDF/image attachments. OCR: Sends the attachment to OCR.space API (https://ocr.space/OCRAPI) to extract invoice text. Parsing: Extracts key fields: Vendor Invoice number Amount Currency Invoice date Due date Description Validation Logic: Checks if amount is valid Ensures vendor and invoice number are present Flags high-value invoices (e.g., over $10,000) Routing: If invalid: Sends a Slack message highlighting issues Labels email as Rejected If valid: Logs the invoice into Google Sheets Sends a Slack message to the finance team for approval After approval, creates a draft invoice in Xero Labels the email as Processed in Gmail Set up steps • Estimated setup time: 45-60 mins • You’ll need connected credentials for Gmail, Slack, Google Sheets, and Xero • Replace the default API key for OCR.space with your own (in the HTTP Request node) • Update Slack channel IDs and label IDs to match your workspace • Adjust invoice validation rules as needed (e.g. currency, red flag conditions) All detailed explanations and field mappings are provided in sticky notes within the workflow.

📘 Description This workflow is a fully automated AI matte painting generation system for VFX pipelines, designed to convert a single environment prompt into multiple cinematic background variations. It handles generation, validation, multi-variant rendering, compositing preparation, review workflows, and final delivery—eliminating manual coordination between artists, supervisors, and production systems. ⚙️ Step-by-Step Flow The process begins with a webhook trigger that serves as the shot request intake layer, receiving a POST request containing the environment prompt, shot code, optional plate image URL, and metadata such as project, sequence, and supervisor details. This input is then passed through a validation and normalization stage, ensuring all required fields are present while standardizing elements like sequence codes, project IDs, Slack channels, and timestamps. Once validated, the system fans out the request into four distinct cinematic variations—day (overcast realism), dusk (golden hour lighting), night (moonlit cinematic), and fog (atmospheric depth)—with each variant assigned a custom-engineered prompt. At the core of the workflow, a dynamic mode selection logic determines whether to use image-to-video generation (if a plate image is provided) or text-to-video generation (if no reference is available), while also configuring parameters such as audio generation, aspect ratio, and duration. Each variation is then submitted as an independent job to the Seedance API for AI video generation, returning unique job IDs for tracking. A polling loop handles asynchronous processing by checking the status of each job every 20 seconds until all reach a “succeeded” state, operating independently per variation. Once completed, the system constructs detailed metadata for each asset, including video URL, atmosphere type, variant ID, resolution, duration, and tags such as AI-generated and review status. In parallel, it generates an auto-configured Nuke compositing template with pre-built nodes for plate input, AI background, merge setup, color grading placeholders, and output writing. For production tracking, a Jira review task is created for each variation, while all assets are logged within the ClickUp system. An aggregation layer then consolidates all four variations into a single structured summary, formatted for seamless Slack delivery. A Slack notification is sent to the supervisor with the complete review package, including links to all variations, Jira tickets, inline Nuke scripts, and associated metadata. Finally, the system downloads the generated video assets and completes the workflow by sending an email to the requester with the video attachments and full production context, ensuring a smooth end-to-end delivery pipeline. 🚨 Error Handling • Global error trigger • Instant Slack alert • Prevents silent failures across pipeline 🧩 Prerequisites • Seedance API (video generation) • Slack OAuth2 • Gmail OAuth2 • Jira Cloud • ClickUp API • Webhook integration (input system) 💡 Key Benefits ✔ Parallel generation of multiple cinematic variations ✔ Automatic decision between image-to-video vs text-to-video ✔ Built-in compositing (Nuke script auto-generation) ✔ Full production pipeline (generation → review → delivery) ✔ Async-safe with polling loop ✔ Centralized asset tracking (Jira + ClickUp) ✔ Zero manual VFX coordination 👥 Perfect For VFX studios Film/TV production pipelines AI-driven matte painting workflows Previsualization teams Creative automation systems

How it works Complaints arrive via Gmail or a web form webhook Claude AI classifies each complaint: fault category, priority (P1/P2/P3), tenant tone, and drafts an acknowledgement email The right technician is looked up in Airtable by fault category A work order is created and the tenant receives an ACK email with their ticket reference and SLA commitment The FM team is notified in Slack with ticket summary An hourly schedule checks open tickets — any past their SLA deadline trigger an urgent escalation to FM management How to set up Connect Gmail to the Gmail Trigger and Send ACK email nodes Create your Airtable base with a Complaints table and a Technician table (one row per fault category) Connect Airtable, Anthropic, and Slack in their respective nodes If using a web form, point it to the Webhook URL

Overview This workflow automates invoice processing directly from your email inbox. It captures invoice attachments, extracts structured data using OCR and AI, validates totals, and securely processes invoices. If issues are detected, it routes them for human review. Approved invoices are recorded in QuickBooks and logged for auditing. How It Works Email Trigger Monitors a Gmail label and downloads invoice attachments automatically. Configuration & Metadata Sets OCR API, thresholds, and captures invoice details like vendor, timestamp, and file hash. File Processing Routes PDFs to a text extractor and images to an OCR API. AI Data Extraction AI converts raw text into structured invoice data with confidence scores. Validation Recalculates totals and verifies subtotal, tax, and final amounts. Data Privacy Masks sensitive fields like PAN, GST, and bank account details. Review Decision Flags invoices for review if validation fails or confidence is low. Human Review (if needed) Sends Slack alert and waits for approval before proceeding. Accounting Integration Creates a bill in QuickBooks for approved invoices. Audit Logging Stores processing details in Google Sheets for traceability. Notifications Sends a success message after processing is complete. Setup Instructions Connect Gmail trigger and configure the invoice label (e.g., "AP Inbox") Add OCR API endpoint in the configuration node Connect OpenAI credentials for data extraction Connect Slack for alerts and notifications Connect QuickBooks for bill creation Add Google Sheets ID for audit logging Configure: Validation tolerance Confidence threshold Test with sample invoice emails Activate the workflow Use Cases Automating accounts payable workflows Reducing manual invoice data entry Validating invoices before accounting entry Handling invoice approvals with human-in-the-loop Maintaining audit logs for compliance Requirements Gmail account (with label setup) OpenAI API credentials OCR API (e.g., OCR.space or Google Vision) Slack workspace QuickBooks account Google Sheets (for audit logs) n8n instance with file handling enabled Notes You can adjust validation tolerance and confidence thresholds based on your needs. Extend validation logic in the Code node for stricter financial checks. Replace QuickBooks or Google Sheets with your preferred tools if needed. Ensure secure handling of sensitive financial data in production environments.

Generate personalized concert ticket PDFs with QR codes using PDF Generator API, then email them to attendees, log sales to Google Sheets, and notify organizers via Slack — all triggered from a simple web form. Who is this for Event organizers, ticketing teams, and developers who need an automated pipeline to issue branded PDF concert tickets with unique QR codes for venue entry — without building a custom backend. How it works An attendee fills out a web form with their name, email, event details, seat number, and ticket tier (General / VIP / Backstage). The workflow generates a unique ticket ID and prepares all data for the PDF template. PDF Generator API renders a personalized PDF ticket. The QR code is a native template component that encodes the ticket ID automatically. A styled HTML confirmation email with a download link is sent to the attendee via Gmail. The ticket details are logged to a Google Sheets spreadsheet for tracking and attendance management. A Slack notification alerts the event organizer with a summary of the newly issued ticket. Set up PDF Generator API — Sign up at pdfgeneratorapi.com, create a ticket template with a QR Code component bound to {{ ticket_id }}, and note your template ID. Template ID — Open the "Prepare Ticket Data" Code node and replace the TEMPLATE_ID value with your own. Credentials — Connect your accounts in each node: PDF Generator API, Gmail, Google Sheets, and Slack. Google Sheets — Create a spreadsheet with columns: Ticket ID, Attendee, Email, Event, Venue, Date, Seat, Tier, PDF URL, Issued At. Set the spreadsheet ID in the "Log Ticket Sale" node. Slack — Choose a channel (e.g. #tickets) in the "Notify Event Organizer" node. Requirements PDF Generator API account (free trial available) Gmail account (OAuth) Google Sheets account (OAuth) Slack workspace (optional — remove the last node if not needed) How to customize Output format** — The PDF node returns a hosted URL by default (valid 30 days). Switch to File output to attach the PDF directly to the email instead. Ticket tiers** — Add or rename tiers in the form node and update the tier mapping logic in the "Prepare Ticket Data" Code node. Email design** — Edit the "Build Confirmation Email" Code node to match your brand colors and layout. Remove Slack** — Simply delete the "Notify Event Organizer" node if you don't need organizer alerts. Add payment** — Insert a Stripe or payment node before the form confirmation to handle paid tickets.

Who is this for SMB sales teams and SaaS companies who want to automatically prioritize and nurture new leads without manual qualification. Perfect for businesses getting 50+ leads per month who need to identify high-value prospects quickly. How it works When a new contact is created in HubSpot, the workflow automatically enriches their data using Clearbit's company database. A scoring algorithm evaluates company size, industry fit, and job title relevance, then Gemini AI analyzes the enriched data to provide additional insights and generate personalized outreach content. Hot leads (score 80+) receive immediate personalized emails and trigger Slack notifications to the sales team. Warm leads (50-79) are added to nurturing sequences. Cold leads are simply scored for future reference. All scoring data and reasoning are logged to Google Sheets for analysis and optimization. How to set up Configure credentials for HubSpot, Clearbit API, Gemini AI, Gmail, Slack, and Google Sheets. Create a Google Sheet for scoring history with the column headers shown in the workflow. Update the Slack channel name in the notification node and customize the Gmail sender settings. Requirements HubSpot with contact creation access Clearbit Enrichment API account Google Gemini AI API key Gmail account for sending emails Slack workspace for notifications Google Sheets for tracking How to customize Adjust scoring criteria in the Set node including target industries, company size weights, and role priorities. Modify hot/warm score thresholds (default 80/50). Customize email templates and Slack message format within the Gemini AI prompt. Add additional scoring factors in the Code node calculation.

Who is this for? Founders, product managers, content strategists, indie hackers, and anyone who wants to automatically monitor tech industry trends across multiple sources — without manually browsing Hacker News and Product Hunt every day. What this workflow does This workflow scans public RSS feeds from Hacker News and Product Hunt daily, scores every item against configurable keyword groups (AI, SaaS, No-Code, Dev Tools, etc.), clusters the results into ranked themes, and delivers a prioritized intelligence report via Slack and email. All signals and themes are logged to Google Sheets for historical trend analysis. How it works Daily trigger fires on a configurable schedule (default: every 24 hours). Fetches RSS feeds from Hacker News (posts with 50+ points) and Product Hunt in parallel. Parses and normalizes all feed items — extracting titles, descriptions, URLs, and publish dates from RSS/Atom XML. Scores each item against 7 weighted keyword groups. Title matches receive a bonus multiplier. Source weights (Hacker News 1.5x, Product Hunt 1.3x) amplify signals from higher-authority sources. Clusters into themes — groups scored items by primary category, calculates theme strength using source diversity and volume bonuses, and classifies each as VERY_STRONG, STRONG, MODERATE, or WEAK. Builds an intelligence report with theme rankings, top 10 signals, and action items for surging topics. Generated in both plain text (Slack) and HTML (email). Delivers and logs — posts to Slack, sends HTML email, and appends both individual signals and theme summaries to separate Google Sheet tabs. Setup steps Connect Google Sheets OAuth2 credentials and update the Sheet ID in both "Log Signals to Sheet" and "Log Themes to Sheet" nodes. Create a Google Sheet with two tabs: signal — headers: date, title, source, score, category, url themes — headers: date, category, signal_level, theme_strength, item_count, sources, top_keywords Connect Slack OAuth2 credentials and configure your target channel in the "Post Report to Slack" node. Connect Gmail OAuth2 credentials and update [email protected] in the "Email Daily Report" node. Activate the workflow. Requirements n8n instance (self-hosted or cloud) Google Cloud project with Sheets API enabled Slack workspace with a bot configured Gmail account with OAuth2 credentials (or swap for SMTP) No API keys needed for RSS feeds — they are publicly accessible How to customize Add more RSS feeds** — duplicate a feed node (e.g., TechCrunch, Reddit, Lobsters), connect it to the Merge node as an additional input, and add the parsing logic in the "Parse All RSS Feeds" code node. Edit keyword groups** — modify the keywordGroups object in the "Score and Classify Signals" node. Add your industry-specific keywords, adjust weights, and rename categories. Adjust source weights** — change the weight multipliers in the parser node to reflect which sources you trust most. Theme thresholds** — modify the strength cutoffs (30 = VERY_STRONG, 15 = STRONG, 8 = MODERATE) in the "Aggregate Signals into Themes" node. Schedule** — change from daily to hourly for real-time monitoring, or weekly for a digest format. Add AI analysis** — insert an LLM node after the report builder to generate strategic commentary on detected trends.

Who is this for Customer support teams and operations managers who receive support requests via email and need automated triage. Works well for small to mid-size teams using Notion as their ticket tracker. What this workflow does This workflow watches a Gmail inbox for incoming support emails. Each email is analyzed by Gemini AI to determine its category (billing, technical, feature request, or general), priority level, and a suggested response draft. A new page is created in a Notion database with all classified fields. Critical tickets trigger an immediate Slack alert to the on-call team, while all tickets get a summary notification. Setup Add a Gmail OAuth2 credential and configure label or address filters. Add a Google Gemini API credential for email classification. Add a Notion API credential and create a database with columns: Title, Category, Priority, Status, Summary. Add a Slack OAuth2 credential and set your alerts channel. Requirements Gmail account with OAuth2 access Google Gemini API key Notion workspace with API integration enabled Slack workspace with OAuth2 app How to customize Edit the AI prompt in "Classify ticket with AI" to add more categories or adjust priority rules. Change the critical priority condition in "Is critical priority" to include high-priority tickets. Replace Notion with Airtable or Google Sheets for a different ticket backend.

📊 Description Automate employee leave tracking and communication with structured notifications and reminders 📅📣. This workflow checks a centralized Google Sheet daily to detect when leave periods start or end. When leave begins, it notifies your HR Slack channel and reminds the employee to update their availability. When leave ends, it sends a return notification and follow-up reminder. All actions are reflected back in Google Sheets to maintain a single source of truth. Ideal for growing teams that want a simple, reliable way to manage leave visibility without manual follow-ups or status tracking. What This Template Does 🌐 Runs automatically on a daily schedule 📄 Reads employee leave data from Google Sheets 🧮 Validates and evaluates leave start and end dates 🔀 Routes employees into activation or reset flows 📣 Sends Slack notifications to the HR or admin channel 📧 Sends reminder emails to employees at the right time 📊 Updates leave status in Google Sheets to prevent duplicates 🔁 Processes employees sequentially for reliable execution Key Benefits ✅ Eliminates manual leave tracking ✅ Improves visibility for HR and leadership ✅ Ensures employees receive timely reminders ✅ Prevents duplicate notifications using status flags ✅ Keeps Google Sheets updated as the single source of truth ✅ Scales easily as your team grows Features Daily scheduled leave check Google Sheets as centralized leave database Smart activation and reset logic Slack channel notifications Automated employee reminder emails Status tracking with idempotent processing Sequential execution to avoid API rate limits Configurable Slack channel settings Requirements Google Sheets OAuth2 credentials Slack OAuth2 credentials Gmail OAuth2 credentials Google Sheet with the following columns: Employee Email, Name, Start Date, End Date, Status, Last Updated Target Audience 🏢 HR and People Operations teams 🚀 Growing startups managing distributed teams 📊 Operations teams needing structured leave tracking 🤖 Automation builders creating internal workflow systems

📘 Description This workflow automates daily re-engagement for HubSpot leads that were previously paused due to timing. It runs every 24 hours, fetches recent leads with activity data, and filters only those marked as “bad timing,” ensuring active opportunities are not disturbed. Qualified leads are processed in batches, and an AI agent generates a short, polite follow-up email designed to reopen the conversation without sounding salesy. Instead of sending automatically, the workflow creates a Gmail draft for human review and notifies the assigned owner in Slack. If AI generation fails, the workflow sends a Slack alert with the lead details so manual follow-up can still happen. This ensures consistent reactivation of cold leads without silent failures or missed opportunities. ⚙️ What This Workflow Does (Step-by-Step) ⏰ Daily Trigger (Every 24h) Runs the workflow once per day. 📥 HubSpot: Fetch Recent Leads + Activity Fields Pulls up to 20 leads with key activity and lifecycle properties needed for follow-up timing. 🚦 Filter: Lead Status = BAD_TIMING Keeps only leads that were previously paused due to timing (targets cold opportunities only). 🔄 Batch Leads (Split In Batches) Processes leads one-by-one / in batches to prevent rate-limit issues and keep execution stable. ✍️ AI: Generate Re-Engagement Follow-Up Email Body Creates a short, friendly follow-up message based on lead context (no CRM labels, no salesy tone). 🧩 Parse AI JSON Normalizes AI output into usable fields (subject/body/toEmail/owner details). 📩 Gmail: Create Follow-Up Draft Email Creates a Gmail draft (human-in-the-loop; no auto-send). 🔔 Slack: Notify Owner to Re-Engage Lead Notifies the assigned owner that a draft is ready and the lead is worth revisiting. ⚠️ Build AI Error Payload Builds a clean error context (lead name/email + AI error message). 🚨 Slack: Alert AI Draft Failure Alerts the owner when AI fails so the lead can be followed up manually. 🧩 Prerequisites • n8n instance • HubSpot App Token (read access to leads + properties) • Azure OpenAI credentials (GPT-4o) for email generation • Gmail OAuth2 (draft creation permissions) • Slack API token (DM user messaging permissions) 💡 Key Benefits ✔ Daily automated re-engagement for paused leads ✔ Prevents random outreach to active leads ✔ Human-in-the-loop safety via Gmail drafts (no auto-send) ✔ Owner notifications ensure follow-up execution ✔ Batch processing avoids rate-limit instability ✔ Strong failure handling prevents silent lead drops 👥 Perfect For SDR teams managing large HubSpot pipelines Founders doing lightweight outbound follow-ups Sales ops teams wanting structured reactivation loops Agencies re-engaging cold inbound / outbound leads

Customer Support Triage Automation with AI, ClickUp and Google Sheets 📘 Description This workflow automates the complete customer support email triage process by intelligently classifying incoming support emails, validating AI outputs, assigning tickets to appropriate teams, and orchestrating all downstream actions in a consistent, trackable manner. It is designed for support teams that need to instantly categorise and route high volumes of customer inquiries while maintaining quality, accountability, and fast response times. The workflow is triggered automatically when new emails arrive in your support inbox. Incoming emails are analysed by Grok AI to determine ticket category (Bug Report, Feature Request, Billing Question, Technical Support, General Inquiry, or Marketing Email) and urgency level (Low, Medium, High, Critical). A validation layer ensures AI outputs meet quality standards with automatic corrections for invalid responses. Based on the categorisation, the workflow applies intelligent routing rules to assign tickets to the right team (Engineering, Billing, Product, or Support), calculates SLA deadlines based on urgency, and detects escalation triggers like negative sentiment or churn risk keywords. For every ticket, the workflow runs parallel actions: it creates a detailed ClickUp task for team tracking, logs complete ticket information to Google Sheets for analytics, sends real-time Slack notifications to appropriate channels, and delivers a professional acknowledgement email to the customer with ticket details and tracking links. ⚙️ What This Workflow Does (Step-by-Step) 📧 Email Intake - Fetches new support emails from the Outlook inbox automatically. 📝 Assign Email Values - Normalises email data into a consistent structure for processing. 🧠 AI Analysis with Grok - Classifies tickets by category and urgency using AI reasoning. 🔍 Parse AI Response - Extracts structured data from AI output and adds metadata. ✅ Validate AI Response - Ensures outputs meet quality standards with automatic fixes for invalid categories or missing summaries. 🎯 Smart Assignment & SLA - Routes tickets to appropriate teams, calculates SLA deadlines (1 hour for Critical, 4 hours for High, 24 hours for Medium, 48 hours for Low), and flags escalation cases based on sentiment or urgency. 📋 Create ClickUp Task - Generates organised tasks with priority levels, tags, and complete ticket context. 🔗 Get ClickUp Task URL - Captures task links for tracking and reference. 📊 Log to Google Sheets - Records all ticket details in a centralised tracking spreadsheet. 💬 Team Notification (Slack) - Alerts the support team with ticket summary and ClickUp link. 🚨 Escalation Notification (Slack) - Sends urgent alerts to the escalation channel for critical or high-risk tickets. ✉️ Customer Acknowledgement (Email) - Delivers professional auto-reply with ticket details, SLA timeline, and tracking link. 🧩 Prerequisites • Microsoft Outlook or Gmail account for support inbox • Grok API credentials (x.ai) - can be replaced with OpenAI or Claude • Google Sheets OAuth2 for ticket tracking • ClickUp API access for task management • Slack API access for team notifications • Gmail OAuth2 for customer acknowledgement emails 💡 Key Benefits ✔ Instant categorisation of all incoming support emails ✔ Intelligent team routing based on ticket type and urgency ✔ Automatic SLA deadline calculation and tracking ✔ Built-in validation prevents AI errors from reaching customers ✔ Escalation detection for negative sentiment and churn risk ✔ Complete audit trail in Google Sheets ✔ Real-time team awareness via Slack ✔ Professional customer communication with zero delay ✔ Seamless ClickUp integration for task management 👥 Perfect For Customer support teams handling high email volumes SaaS companies managing technical support requests Operations teams needing instant triage and routing Businesses requiring strict SLA compliance Support organisations using ClickUp for task management Teams wanting complete visibility and accountability