Airtable and Slack integration

📊 Description Streamline management decision-making by automatically evaluating high-priority tenders, generating AI-powered executive summaries, and routing them for approval inside Slack. 🤖📩 This workflow pulls pending tenders from Airtable, uses GPT-4o-mini to evaluate urgency, business opportunity, and risk, and generates a structured summary with a Go/No-Go recommendation. Tenders that qualify are pushed to Slack with interactive approval buttons, and the final decision instantly updates Airtable and triggers a confirmation email to your bid team. Perfect for fast-moving procurement, bidding, and sales teams that require structured, high-quality tender assessments. 📊⚡ 🔁 What This Template Does 1️⃣ Runs daily via Schedule Trigger to fetch high-priority pending tenders from Airtable. ⏰ 2️⃣ Sends each tender to the AI agent for evaluation (urgency, risk, opportunity). 🤖 3️⃣ Generates structured JSON output: — urgency — priorityScore — executive summary — Go/No-Go recommendation — reasoning 4️⃣ Formats AI output for Slack review and Airtable updates. 📝 5️⃣ Checks if tender qualifies as “High urgency + High score + Go.” 🚦 6️⃣ Sends interactive Slack message with Approve/Reject buttons. 💬 7️⃣ If approved → updates Airtable status to Approved and sends Gmail confirmation. 📧 8️⃣ If rejected or low-score → updates Airtable status accordingly. ✏️ 9️⃣ If no priority tenders exist → sends fallback Slack notification. 📭 ⭐ Key Benefits ✅ Eliminates manual tender review and scoring ✅ AI creates consistent, executive-ready summaries ✅ Fast approval flow inside Slack with built-in decision logging ✅ Clear Go/No-Go framework for quality tender selection ✅ Updates Airtable automatically with final decision ✅ Sends email confirmation for approved tenders — ensuring next steps start immediately 🧩 Features Daily Airtable lookup for high-priority tenders GPT-4o-mini AI scoring & structured evaluation Automatic Go/No-Go decision logic Slack interactive approval (Approve / Reject) Auto-update to Airtable (Status = Approved / Pending) Gmail confirmation email to the bid team JSON output parser for reliable AI formatting Tender link embedding for quick access 🔐 Requirements Airtable Personal Access Token OpenAI API key (GPT-4o-mini) Slack API credentials Gmail OAuth2 credentials Airtable table with tender fields (Priority, Status, Summary, Dates, etc.) 🎯 Target Audience Procurement teams evaluating multiple tenders Management teams needing fast approval workflows Business development & bidding teams Companies tracking tenders in Airtable Organizations adopting AI-assisted decision processes

⚡ AI Copywriter Pro: Instant Ad Copy & CTA Generator Transform product details into compelling marketing copy in seconds. This intelligent n8n workflow takes basic product information and generates professional ad copy with powerful calls-to-action using GPT-4, then distributes the results to your team via Slack or stores them in Airtable for future use. 🚀 How It Works This streamlined 4-step automation delivers professional marketing copy instantly: Step 1: Simple Form Input Users submit basic product information through a clean web form - just product name and key features required. Step 2: AI-Powered Generation The workflow sends product details to GPT-4 with a specialized copywriting prompt that creates: Compelling 2-sentence ad copy optimized for conversions 3 powerful call-to-action phrases with different urgency levels Professional tone tailored for marketing campaigns Step 3: Structured Processing The AI response is automatically parsed into clean, labeled fields ready for immediate use across marketing channels. Step 4: Multi-Channel Distribution Generated content is simultaneously: Posted to your designated Slack channel for team review Logged in Airtable for campaign tracking and reuse ⚙️ Setup Steps Prerequisites Active OpenAI API account with GPT-4 access Slack workspace with admin permissions Airtable account for content storage n8n instance (cloud or self-hosted) Configuration Steps Credential Setup OpenAI API Key**: Required for GPT-4 content generation Slack OAuth2**: Needed for posting messages to channels Airtable Personal Access Token**: Essential for database operations Form Configuration The workflow automatically generates a web form at: your-n8n-instance.com/form/[webhook-id] Form fields are pre-configured for: Product Name (text input) Product Features (textarea for detailed descriptions) Form can be embedded on websites or shared as standalone link Slack Integration Setup Connect your Slack workspace to n8n Create or select target channel for ad copy notifications Update the channelId parameter with your channel's ID Test connection with sample message Airtable Database Preparation Create new base or use existing one Set up table with columns: Product Name (Single line text) Product Features (Long text) Ad Copy (Long text) CTAs (Long text) Copy base and table IDs from Airtable URLs Update workflow parameters accordingly AI Prompt Customization The default prompt generates versatile marketing copy, but you can customize for: Industry-specific terminology Brand voice and tone Target audience demographics Campaign objectives (awareness, conversion, retention) 🎯 Use Cases E-commerce & Retail Product Launch Campaigns**: Generate copy for new product announcements Seasonal Promotions**: Create urgency-driven messaging for sales events Category Pages**: Develop compelling descriptions for product collections Social Media Ads**: Produce scroll-stopping copy for Facebook and Instagram SaaS & Technology Feature Announcements**: Craft clear, benefit-focused messaging Free Trial Campaigns**: Generate conversion-optimized trial signup copy Case Study Promotions**: Create compelling success story headlines Webinar Marketing**: Develop registration-driving event descriptions Agency & Freelance Client Presentations**: Rapidly prototype copy concepts for pitches A/B Testing**: Generate multiple copy variations for campaign testing Campaign Brainstorming**: Kickstart creative sessions with AI-generated ideas Content Calendar Filling**: Populate social media schedules efficiently Startup & Small Business MVP Marketing**: Create professional copy without hiring agencies Investor Pitches**: Generate compelling product descriptions Website Content**: Populate landing pages with conversion-focused copy Email Campaigns**: Develop subject lines and promotional content Content Marketing Blog Post Promotions**: Generate social media copy for article shares Newsletter CTAs**: Create compelling subscription and engagement prompts Video Descriptions**: Develop YouTube and social video copy Podcast Promotions**: Generate episode descriptions and listener CTAs 🔧 Advanced Customization Options Multi-Tone Generation Modify the prompt to generate different copy styles: Professional & Corporate: "Generate formal, trust-building copy..." Casual & Friendly: "Create conversational, approachable messaging..." Urgent & Scarcity: "Develop time-sensitive, action-driving copy..." Luxury & Premium: "Craft sophisticated, high-end positioning..." Batch Processing Enhancement Add nodes for processing multiple products: Split in Batches**: Handle bulk product lists Merge**: Combine results for team review Item Lists**: Process CSV uploads of product catalogs Quality Control Integration Implement approval workflows: Human Review Step**: Add manual approval before publishing Sentiment Analysis**: Score copy for emotional impact Brand Guidelines Check**: Validate against company voice standards A/B Test Setup**: Generate multiple variations automatically Extended Distribution Connect additional platforms: Email Marketing**: Send to Mailchimp, ConvertKit, or HubSpot Social Media**: Post directly to Facebook, Twitter, LinkedIn CMS Integration**: Push to WordPress, Webflow, or custom sites Project Management**: Create tasks in Asana, Trello, or Monday.com 📊 Output Examples Sample Input: Product Name: EcoSmart Water Bottle Product Features: Self-cleaning UV technology, 24-hour temperature retention, BPA-free stainless steel, leak-proof design, 500ml capacity Generated Ad Copy: Stay hydrated and eco-conscious with the EcoSmart Water Bottle—featuring revolutionary self-cleaning UV technology that eliminates 99.9% of bacteria while keeping your drinks perfectly chilled for 24 hours! Experience the future of hydration with premium stainless steel construction that's as durable as it is sustainable. CTAs: • Order Your EcoSmart Bottle Today • Join the Clean Hydration Revolution • Get 24-Hour Freshness Now Slack Notification Format: 🎯 NEW AD COPY GENERATED Product: EcoSmart Water Bottle 📝 Ad Copy: Stay hydrated and eco-conscious with the EcoSmart Water Bottle—featuring revolutionary self-cleaning UV technology that eliminates 99.9% of bacteria while keeping your drinks perfectly chilled for 24 hours! Experience the future of hydration with premium stainless steel construction that's as durable as it is sustainable. 🔥 Call-to-Actions: • Order Your EcoSmart Bottle Today • Join the Clean Hydration Revolution • Get 24-Hour Freshness Now Ready to use in campaigns! 🚀 🛠️ Troubleshooting & Best Practices Common Issues & Solutions API Rate Limits Monitor OpenAI usage dashboard Implement delay nodes for high-volume processing Consider upgrading to higher tier plans Inconsistent Output Quality Refine prompts with specific examples Add output validation rules Include brand guidelines in system prompt Integration Failures Verify all API credentials are current Test connections individually before full workflow Check service status pages for outages Optimization Strategies Cost Management Use GPT-4o-mini for routine copy generation Reserve GPT-4 for premium campaigns Cache common responses to reduce API calls Quality Enhancement A/B test different prompt variations Collect team feedback on generated copy Maintain library of high-performing examples Workflow Efficiency Set up monitoring alerts for failures Create backup workflows for critical campaigns Document customizations for team reference 📈 Performance Tracking Key Metrics to Monitor Generation Speed**: Average time from input to output Approval Rate**: Percentage of AI copy used without edits Campaign Performance**: Click-through rates of AI-generated content Cost Per Copy**: API costs per generated piece Success Indicators Reduced copywriting turnaround time (target: under 30 seconds) Increased campaign launch frequency Higher team satisfaction with copy quality Measurable improvement in conversion rates 📞 Questions & Support Need help setting up or customizing your AI Copywriter Pro workflow? 📧 Direct Support Email**: [email protected] Response Time**: Within 24 hours on business days Specialties**: Custom prompt engineering, integration troubleshooting, workflow optimization 🎥 Video Tutorials YouTube Channel**: https://www.youtube.com/@YaronBeen/videos Complete setup walkthrough Advanced customization techniques Integration with popular marketing tools Prompt engineering masterclass 🤝 Professional Network LinkedIn**: https://www.linkedin.com/in/yaronbeen/ Connect for ongoing automation support Share your copywriting success stories Get early access to new workflow templates 💬 What to Include in Support Requests Your specific industry or use case Current marketing tools and platforms Sample products you want to test with Any custom requirements or brand guidelines Screenshots of any errors or unexpected outputs Ready to revolutionize your copywriting process? Deploy this workflow and watch your marketing team's productivity soar while maintaining professional, conversion-focused messaging!

Still reminding people about their tasks manually every morning? Let’s be honest — who wants to start the day chasing teammates about what they need to do? What if Slack could do it for you — automatically, at 9 a.m. every day — without missing anything, and without you lifting a finger? In this tutorial, you’ll build a simple automation with n8n that checks Airtable for active tasks and sends reminders in Slack, daily. Here’s the flow you’ll build: Schedule Trigger → Search Records (Airtable) → Send Message (Slack) STEP 1 : Set up your Airtable base Create a new base called Tasks Add a table (for example: Projects, To-Do, or anything relevant) Add the following fields: | Field | Type | Example | | -------- | ----------------- | ------------------------------------------- | | Title | Text | Finalize quote for Client A | | Assignee | Text | Baptiste Fort | | Email | Email | [email protected] | | Status | Single select | In Progress / Done | | Due Date | Date (dd/mm/yyyy) | 05/07/2025 | Add a few sample tasks with the status In Progress so you can test your workflow later. STEP 2 Create the trigger in n8n In n8n, add a Schedule Trigger node Set it to run every day at 9:00 a.m.: Trigger interval: Days Days Between Triggers: 1 Trigger at hour: 9 Trigger at minute: 0 This is the node that kicks off the workflow every morning. STEP 3 : Search for active tasks in Airtable This step is all about connecting n8n to your Airtable base and pulling the tasks that are still marked as "In Progress". Add the Airtable node In your n8n workflow, add a node called: Airtable → Search Records You can find it by typing "airtable" in the node search. Create your Airtable Personal Access Token If you haven’t already created your Airtable token, here’s how: 🔗 Go to: https://airtable.com/create/tokens Then: Name your token something like TACHES Under Scopes, check: ✅ data.records:read Under Access, select only the base you want to use (e.g. “Tâches”) Click “Save token” Copy the personal token Set up the Airtable credentials in n8n In the Airtable node: Click on the Credentials field Select: Airtable Personal Access Token Click Create New Paste your token Give it a name like: My Airtable Token Click Save Configure the node Now fill in the parameters: Base: Tâches Table: Produits (or Tâches, depending on what you called it) Operation: Search Filter By Formula: {Statut} = "En cours" Return All: ✅ Yes (make sure it’s enabled) Output Format: Simple Test the node Click “Execute Node”. You should now see all tasks with Statut = "En cours" show up in the output (on the right-hand side of your screen), just like in your screenshot. STEP 4: Send each task to Slack Now that we’ve fetched all the active tasks from Airtable, let’s send them to Slack — one by one — using a loop. Add the Slack node Drag a new node into your n8n workflow and select: Slack → Message Name it something like Send Slack Message You can find it quickly by typing "Slack" into the node search bar. Connect your Slack account If you haven't already connected your Slack credentials: Go to n8n → Credentials Select Slack API Click Create new Paste your Slack Bot Token (from your Slack App OAuth settings) Give it a clear name like Slack Bot n8n Choose the workspace and save Then, in the Slack node, choose this credential from the dropdown. Configure the message Set these parameters: Operation: Send Send Message To: Channel Channel: your Slack channel (e.g. #tous-n8n) Message Type: Simple Text Message Message template Paste the following inside the Message Text field: Message template Paste the following inside the Message Text field: New task for {{ $json.name }}: {{ $json["Titre"] }} 👉 Deadline: {{ $json["Date limite"] }} Example output: New task for Jeremy: Relancer fournisseur X 👉 Deadline: 2025-07-04 Test it Click Execute Node to verify the message is correctly sent in Slack. If the formatting works, you’re ready to run it on schedule 🚀 Want to scale your workflows? Visit 0vni – Agence automatisation.

Overview This workflow automates the end-to-end process of creating, optimizing, and publishing content on WordPress. It integrates AI-powered tools, Airtable, and WordPress plugins to generate high-quality, on-brand posts effortlessly. Perfect for content creators, marketers, and business owners looking to save time and scale their content strategy. Features Content Creation: AI-Powered Content:** Generates SEO-friendly blog posts with structured headings, relevant keywords, and meta descriptions. Custom Prompts:** Tailor the AI-generated content to match your brand’s tone and voice. SEO Optimization: RankMath Plugin Integration:** Updates RankMath SEO with focus keywords and meta descriptions, ensuring your content is search-engine optimized. Content Management: Airtable Integration:** Organizes content ideas, drafts, and publishing schedules in one place. Easily scalable for teams or solo creators. Visuals: Branded Featured Images:** Automatically generates on-brand images for every post. Publishing: Effortless Formatting:** Adapts content to fit your WordPress theme and schedules it for publication. Workflow Steps Trigger: Initiated manually or on a schedule. Content Management: Retrieves and organizes ideas from Airtable. Content Generation: Generates AI-driven blog content tailored to your audience. SEO Optimization: Automatically updates RankMath with SEO details. Featured Image Creation: Produces on-brand images for the post. Publishing: Formats and schedules the post on WordPress. Prerequisites API Keys: OpenAI Airtable WordPress REST API RankMath SEO Plugin Custom Code: Add a small update to your WordPress theme’s functions.php file to enable seamless automation. Customization Replace Airtable with another content management system if preferred. Adjust AI prompts to reflect different tones, styles, or industries. Add integrations for additional plugins, analytics, or storage services. Usage Import the workflow into your n8n instance. Configure API credentials for WordPress, Airtable, OpenAI, and RankMath. Update your functions.php file with the provided code snippet. Customize prompts and Airtable structure for your content needs. Trigger the workflow manually or set it on a schedule. Notes Experiment with Airtable views or add filters for more granular control over your content pipeline. Extend the workflow to include social media posting or analytics tracking. For questions, refer to n8n documentation or reach out to the creator. Tools Used Airtable OpenAI GPT WordPress REST API RankMath SEO Plugin Feel free to adapt and extend this workflow to meet your specific needs! 🎉

📌 Overview This n8n-powered workflow automates the entire lifecycle of real estate lead intake, qualification, routing, assignment, and reporting across multiple channels. It brings WhatsApp inquiries and website form submissions into a single intelligent system, where leads are processed conversationally using AI, deduplicated, normalized, assigned fairly to agents, logged into a centralized CRM, and reported on weekly. Designed specifically for real estate agencies, brokerages, and property teams, this system replaces manual follow-ups, spreadsheet chaos, and uneven agent assignments with a scalable, modular automation that can grow to include Facebook Lead Ads and Google Lead Forms without breaking downstream logic. 🧠 What It Does This workflow automates the full real estate lead pipeline. It: Collects inbound leads from WhatsApp and website forms. Uses AI to extract, validate, and structure lead information. Normalizes all leads into a consistent schema across sources. Detects and prevents duplicate leads (both within-run and CRM-level). Routes leads intelligently based on property interest. Assigns leads fairly using round-robin agent logic. Stores all leads and assignments in a centralized CRM. Sends automated notifications to agents and internal teams. Generates weekly lead, duplicate, and assignment reports. Is designed to be easily extended to Facebook Lead Ads and Google Lead Forms. 💡 Why This Workflow Real estate teams don’t struggle with demand — they struggle with lead management. This workflow was built to solve common real estate problems: Leads lost in WhatsApp chats Duplicate inquiries wasting agent time Uneven lead distribution across agents Manual CRM updates No visibility into weekly lead performance Instead of patching tools together, this workflow provides a single automated system that is reliable, extensible, and client-ready. 👤 Who It’s For This workflow is ideal for: Real estate agencies managing high WhatsApp and form lead inquiry volume Brokerages with multiple agents needing fair lead assignment Property developers handling inbound marketing leads Real estate lead generation teams Automation freelancers building reusable real estate systems ⚙️ How It Works 🧩 1. Lead Intake Workflow 🎯 Purpose Collect inbound leads from multiple channels and normalize them into a unified structure. 🛠 How It Works WhatsApp & Website Triggers Leads enter the system via: WhatsApp messages Website inquiry forms Lead Normalization Regardless of source, all leads are transformed into a common structure: First name, Last name, Phone number, Email, What is your budget range?, and others This ensures new channels (Facebook Lead Ads, Google Lead Forms) can be added later without changing core logic. 🧩 2. AI Lead Processing Workflow 🎯 Purpose Convert unstructured messages into clean, usable lead data. 🛠 How It Works AI Conversation Handling An AI agent processes inbound messages to: Extract missing details Validate lead intent Standardize property interest categories Data Validation Ensures required fields exist before moving forward. 🧩 3. Deduplication Workflow 🎯 Purpose Prevent duplicate leads from entering the system or being reassigned. 🛠 How It Works In-Execution Duplicate Check Prevents the same lead from being processed twice in a single run. CRM-Level Duplicate Detection Checks existing records using: Phone number Email Duplicate leads are flagged and excluded from reassignment while still logged for reporting. 🧩 4. Lead Routing & Agent Assignment Workflow 🎯 Purpose Assign leads fairly and intelligently to agents. 🛠 How It Works Property-Based Routing Leads are routed based on property type (e.g. Single-Family, Multi-Family, Condo). Round-Robin Assignment Agents are rotated automatically to ensure: Fair distribution No manual favoritism Predictable assignment logic 🧩 5. CRM Storage & Notifications Workflow 🎯 Purpose Keep all lead data centralized and notify the right people instantly. 🛠 How It Works CRM Logging (Airtable) Stores: Lead details** Assigned agent Source Deduplicates (Separate table) Timestamps Automated Notifications Sends alerts via: Email Slack So agents can respond immediately. 🧩 6. Weekly Reporting Workflow 🎯 Purpose Provide visibility into lead performance and system health. 🛠 How It Works Runs on a weekly schedule Generates summaries for: Total leads Duplicate leads Agent assignments Can be separated into its own workflow for scalability and reuse. 🛠 How to Set It Up Import the .json file into your n8n instance. Connect the required credentials: WhatsApp Trigger (Auth Connection) WhatsApp Business Cloud (Access Token) OpenAI API Key Airtable API Key (Access Token) Gmail Slack API Key (Access Token) Configure your data sources: Update the Airtable base and table names to match your CRM structure Real Estate Qualifier column names: First name | Last name | Phone number | Email | Location | Property Type | Timeframe | Payment Source | Pre Approved | Has Agent (Yes, No) | Lead (New, Contacted, Follow-up, Converted, Couldn't Convert) | Source | Assigned Agent | Assigned Time | Qualified (Yes, No) | Transcript | Summary Real Estate Qualifier Duplicate column names: First name | Last name | Phone number | Email | Location | Property Type | Timeframe | Payment Source | Pre Approved | Has Agent (Yes, No) | Source Customize business logic: Update agent pools and routing rules Adjust AI prompts if needed Review deduplication and reporting settings Activate the workflow: Click Publish to activate the workflow Send a test lead via WhatsApp or website form to confirm everything works 🎨 Customization Tips Add More Channels**: Plug in Facebook Lead Ads or Google Lead Forms — no restructuring needed. Routing Logic**: Customize routing by location, budget, or property category. CRM Expansion**: Add more fields (Notes, Follow-Up Status, Deal Stage). Reporting**: Extend weekly reports or connect to BI tools. Ads Integration**: Leads can optionally be passed into Facebook or Google Ads workflows after normalization. 📬 Contact For Enquiries: [email protected] Thank you for exploring this workflow!

What if your quote requests managed themselves? Every quote request is a potential deal — but only if it's handled quickly, properly, and without things falling through the cracks. What if instead of copy-pasting emails and pinging teammates manually, your entire process just... ran itself? This automation makes it happen: it captures form submissions, notifies your sales team on Slack, stores leads in Airtable, and sends an email confirmation to the client — all in one seamless n8n flow. ⚙️ Tools used Tally** – to collect client quote requests n8n** – to automate everything, no code needed Airtable** – to store leads and track status Slack** – to instantly notify your sales team Gmail** – to confirm the request with the client 🧩 Flow structure overview Trigger from a Tally form using a webhook Extract and format the data Create a new record in Airtable Send a message to Slack Wait 5 minutes Send an email confirmation via Gmail 📥 Step 1 – Webhook (Tally) This node listens for incoming quote requests from the Tally form. HTTP Method:** POST Path:** /Request a Quote Authentication:** None Respond:** Immediately The data arrives as an array inside body.data.fields. Each field has a label and a value that we’ll need to map manually. 🧹 Step 2 – Edit Fields (Set) This step extracts usable values from the raw form data. Example mapping: Name = {{ $json.body.data.fields[0].label }} Email Address = {{ $json.body.data.fields[1].value }} Type of Service Needed = {{ $json.body.data.fields[2].value }} Estimated Budget = {{ $json.body.data.fields[3].value }} Preferred Timeline = {{ $json.body.data.fields[4].value }} Additional Details or Questions = {{ $json.body.data.fields[5].value }} 📊 Step 3 – Create record in Airtable We send the cleaned fields into a database (CRM) in Airtable. Operation:** Create Base & Table:** Request a Quote - Airtable Base Mapping:** Manual field-to-column matching Each quote submission becomes a new record with all project details. 📣 Step 4 – Send a message to Slack This node notifies your sales team immediately in a Slack channel. Message format: :new: New quote request received! 👤 Name: {{ $json.fields.Name }} 📧 Email: {{ $json.fields.Email }} 💼 Service: {{ $json.fields["Type of Service"] }} 💰 Budget: {{ $json.fields["Estimated Budget (€)"] }} ⏱️ Timeline: {{ $json.fields["Preferred Timeline"] }} 📝 Notes: {{ $json.fields["Additional Details"] }} ⏳ Step 5 – Wait 5 minutes This node simply delays the email by 5 minutes. Why? To give a human salesperson time to reach out manually before the automated confirmation goes out. It adds a personal buffer. 📧 Step 6 – Send confirmation via Gmail To:** {{ \$('Edit Fields').item.json\["Email Address"] }} Subject:** Thanks for your quote request 🙌 Email Type:** HTML Message body: Hi {{ $('Edit Fields').item.json.Name }}, Thanks a lot for your quote request — we’ve received your information! Our team will get back to you within the next 24 hours to discuss your project. Talk soon, — The WebExperts Team ✅ Final result With this automation in place: The client feels acknowledged and taken seriously Your team gets notified in real time You store everything in a clean, structured database All this without writing a single line of backend code. It’s fast, scalable, and business-ready.

🎯 Workflow Goal Still manually checking form responses in your inbox? What if every submission landed neatly in Airtable — and you got a clean Slack message instantly? That’s exactly what this workflow does. No code, no delay — just a smooth automation to keep your team in the loop: Tally → Airtable → Slack Build an automated flow that: receives Tally form submissions, cleans up the data into usable fields, stores the results in Airtable, and automatically notifies a Slack channel. Step 1 – Connect Tally to n8n What we’re setting up A Webhook node in POST mode. Technical Add a Webhook node. Set it to POST. Copy the generated URL. In Tally → Integrations → Webhooks → paste this URL. Submit a test response on your form to capture a sample structure. Step 2 – Clean the data After connecting Tally, you now receive raw data inside a fields[] array. Let’s convert that into something clean and structured. Goal Extract key info like Full Name, Email, Phone, etc. into simple keys. What we’re doing Add a Set node to remap and clean the fields. Technical Add a Set node right after the Webhook. Add new values (String type) manually: Name: Full Name → Value: {{$json"fields"["value"]}} Name: Email → Value: {{$json"fields"["value"]}} Name: Phone → Value: {{$json"fields"["value"]}} (Adapt the indexes based on your form structure.) Use the data preview in the Webhook node to check the correct order. Output You now get clean data like: { "Full Name": "Jane Doe", "Email": "[email protected]", "Phone": "+123456789" } Step 3 – Send to Airtable ✅ Once the data is cleaned, let’s store it in Airtable automatically. Goal Create one new Airtable row for each form submission. What we’re setting up An Airtable – Create Record node. Technical Add an Airtable node. Authenticate or connect your API token. Choose the base and table. Map the fields: Name: {{$json["Full Name"]}} Email: {{$json["Email"]}} Phone: {{$json["Phone"]}} Output Each submission creates a clean new row in your Airtable table. Step 4 – Add a delay ⌛ After saving to Airtable, it’s a good idea to insert a short pause — this prevents actions like Slack messages from stacking too fast. Goal Wait a few seconds before sending a Slack notification. What we’re setting up A Wait node for X seconds. ✅ Technical Add a Wait node. Choose Wait for X minutes. Step 5 – Send a message to Slack 💬 Now that the record is stored, let’s send a Slack message to notify your team. Goal Automatically alert your team in Slack when someone fills the form. What we’re setting up A Slack – Send Message node. Technical Add a Slack node. Connect your account. Choose the target channel, like #leads. Use this message format: New lead received! Name: {{$json["Full Name"]}} Email: {{$json["Email"]}} Phone: {{$json["Phone"]}} Output Your Slack team is notified instantly, with all lead info in one clean message. Workflow Complete Your automation now looks like this: Tally → Clean → Airtable → Wait → Slack Every submission turns into clean data, gets saved in Airtable, and alerts your team on Slack — fully automated, no extra work. Looking for professional automation support? Try 0vni – Agence automatisation.

Stop manually checking keyword rankings and let automation do the work for you. This comprehensive SEO monitoring workflow automatically tracks your keyword positions, compares them against your target URLs, and instantly alerts your team via Slack whenever rankings change - ensuring you never miss critical SEO movements. ✨ What This Workflow Does: 📊 Automated Rank Checking**: Continuously monitors keywords stored in Airtable 🔍 Real-Time SERP Analysis**: Uses Firecrawl API to fetch current search rankings 📈 Intelligent Comparison**: Compares current vs. previous rankings automatically 📝 Database Updates**: Updates Airtable records with new ranking data 🚨 Instant Alerts**: Sends Slack notifications only when rankings change 🎯 Target URL Matching**: Specifically tracks your domain's position in search results 🔧 Key Features: Trigger-based automation** that activates when Airtable data changes Smart rank comparison** logic that prevents false alerts Conditional notifications** - only alerts on actual ranking changes Clean data management** with automatic Airtable updates Team collaboration** through Slack integration Scalable monitoring** for unlimited keywords 📋 Prerequisites: Airtable account with Personal Access Token Firecrawl API key for SERP data Slack workspace with API access Basic Airtable setup with keyword data 🎯 Perfect For: SEO agencies managing multiple client campaigns Digital marketing teams tracking organic performance Content creators monitoring content rankings E-commerce businesses tracking product visibility Startups needing cost-effective SEO monitoring Any business serious about search visibility 💡 How It Works: Data Collection: Fetches keywords, target URLs, and current ranks from Airtable SERP Analysis: Queries Firecrawl API for real-time search results Rank Detection: Searches results for your target URL and determines position Smart Comparison: Compares new ranking against stored data Database Update: Updates Airtable with latest ranking information Conditional Alert: Sends Slack notification only if ranking changed Team Notification: Delivers actionable ranking updates to your team 📦 What You Get: Complete n8n workflow with all integrations configured Airtable template with proper field structure Firecrawl API integration setup Slack notification templates Comprehensive setup documentation Sample keyword data for testing 🚀 Benefits: Save Hours Weekly**: Eliminate manual rank checking Never Miss Changes**: Get instant alerts on ranking movements Team Alignment**: Keep everyone informed via Slack Historical Tracking**: Maintain ranking history in Airtable Cost Effective**: Replace expensive SEO tools with automation Scalable Solution**: Monitor unlimited keywords effortlessly 💡 Need Help or Want to Learn More? Created by Yaron Been 📧 Support: [email protected] 🎥 YouTube Tutorials: https://www.youtube.com/@YaronBeen/videos 💼 LinkedIn: https://www.linkedin.com/in/yaronbeen/ Discover more SEO automation workflows and digital marketing tutorials on my channels! 🏷️ Tags: SEO, Keyword Tracking, Airtable, Slack, Firecrawl, SERP, Automation, Rank Monitoring, Digital Marketing, Search Rankings

This workflow exports every table in a base as its own CSV, saves the files in a time-stamped folder in Amazon S3, pings you on Slack, and optionally prunes older copies. You get an automated weekly backup that is easy to inspect or re-import as needed. You can easily swap the S3 node for the storage provider of your choice. ++How it works++ Weekly Backup Schedule trigger fires weekly Sets and formats the week ex. [2025-W12] Create a folder in S3 bucket with the week Loops through all tables in Airtable base creating CSVs and uploading to the new path Slack message is sent on completion Monthly Prune Schedule trigger fires weekly Sets a cut-off date 4 weeks in the past Lists folders in S3 Deletes all folders > 4 weeks old ++Setup Steps++ Clone workflow Swap credentials for Airtable, AWS, and Slack Ensure AWS credential has appropriate IAM policy to manage bucket & objects Set workflow to "Active"

UPDATE This is an updated version of the previous Ultimate Content Generator for WordPress v2. https://n8n.io/workflows/2737-ultimate-content-generator-for-wordpress/ It includes an additional workflow to generate content using Anthropic Claude in addition to OpenAI 4o. I also mofidied it to use the AI Agent Tool node with structured output for more consistent outputs. Lastly, the workflow updates a new table in AirTable with the published blog post url and featured image url. Overview- This workflow automates the end-to-end process of creating, optimizing, and publishing content on WordPress. It integrates AI-powered tools, Airtable, and WordPress plugins to generate high-quality, on-brand posts effortlessly. Perfect for content creators, marketers, and business owners looking to save time and scale their content strategy. Features Content Creation: AI-Powered Content: Generates SEO-friendly blog posts with structured headings, relevant keywords, and meta descriptions. Custom Prompts: Tailor the AI-generated content to match your brand’s tone and voice. SEO Optimization: RankMath Plugin Integration: Updates RankMath SEO with focus keywords and meta descriptions, ensuring your content is search-engine optimized. Content Management: Airtable Integration: Organizes content ideas, drafts, and publishing schedules in one place. Easily scalable for teams or solo creators. Visuals: Branded Featured Images: Automatically generates on-brand images for every post. Publishing: Effortless Formatting: Adapts content to fit your WordPress theme and schedules it for publication. Workflow Steps Trigger: Initiated manually or on a schedule. Content Management: Retrieves and organizes ideas from Airtable. Content Generation: Generates AI-driven blog content tailored to your audience. SEO Optimization: Automatically updates RankMath with SEO details. Featured Image Creation: Produces on-brand images for the post. Publishing: Formats and schedules the post on WordPress. Prerequisites API Keys: OpenAI Claude Airtable WordPress REST API Custom Code: Add a small update to your WordPress theme’s functions.php file to enable seamless automation. Customization Replace Airtable with another content management system if preferred. Adjust AI prompts to reflect different tones, styles, or industries. Add integrations for additional plugins, analytics, or storage services. Usage Import the workflow into your n8n instance. Configure API credentials for WordPress, Airtable, OpenAI, Claude and Slack. Update your functions.php file with the provided code snippet. Customize prompts and Airtable structure for your content needs. Trigger the workflow manually or set it on a schedule. Notes Experiment with Airtable views or add filters for more granular control over your content pipeline. Extend the workflow to include social media posting or analytics tracking. Feel free to adapt and extend this workflow to meet your specific needs! 🎉

This n8n template monitors active support issues in Linear.app to track the mood of their ongoing conversation between reporter and assignee using Sentiment Analysis. When sentiment dips into the negative, a notification is sent via Slack to alert the team. How it works A scheduled trigger is used to fetch recently updated issues in Linear using the GraphQL node. Each issue's comments thread is passed into a simple Information Extractor node to identify the overall sentiment. The resulting sentiment analysis combined with the some issue details are uploaded to Airtable for review. When the template is re-run at a later date, each issue is re-analysed for sentiment Each issue's new sentiment state is saved to the airtable whilst its previous state is moved to the "previous sentiment" column. An Airtable trigger is used to watch for recently updated rows Each matching Airtable row is filtered to check if it has a previous non-negative state but now has a negative state in its current sentiment. The results are sent via notification to a team slack channel for priority. Check out the sample Airtable here: https://airtable.com/appViDaeaFw4qv9La/shrq6HgeYzpW6uwXL How to use Modify the GraphQL filter to fetch issues to a relevant issue type, team or person. Update the Slack channel to ensure messages are sent to the correct location or persons. The Airtable also serves to give a snapshot of Sentiment across support tickets for a given period. It's possible to use this to assess the daily operations. Requirements Linear for issue tracking (but feel free to use another system if preferred) Airtable for Database OpenAI for LLM and Sentiment Analysis Customising the workflow Add more granular levels of sentiment to reduce the number of alerts. Explore different types of sentiment based on issue types and customer types. This may help prioritise alerts and response. Run across teams or categories of issues to get an overview of sentiment across the support organisation.

This workflow automates the process of gathering LinkedIn advice articles, extracting their content, and generating unique contributions for each article using an AI model. The contributions are then posted to a Slack channel and a NocoDB database for record-keeping. The workflow is triggered weekly to ensure new articles are continuously collected and responded to. Who is this for? This workflow is designed for professionals, marketers, and content creators looking to boost their LinkedIn presence by regularly engaging with LinkedIn advice articles. It’s especially useful for those who want to be seen as a "thought leader" or "top voice" in their niche by contributing relevant and unique advice to trending topics. What problem is this workflow solving? Manually searching for relevant LinkedIn articles, reading through them, and crafting thoughtful contributions can be time-consuming. This workflow solves that by automating the process of finding new articles, extracting key content, and generating AI-powered contributions. It helps users stay consistently active on LinkedIn, contributing value to trending discussions. What this workflow does Triggers Weekly: The workflow is set to run every Monday at 8:00 AM. Search Google for LinkedIn Advice Articles: Uses a predefined Google search URL to find the latest LinkedIn advice articles based on the user's area of expertise. Extract LinkedIn Article Links: A code node extracts all LinkedIn advice article links from the search results. Retrieve Article Content: For each article link, the workflow retrieves the HTML content and extracts the article title, topics, and existing contributions. Generate AI-Powered Contributions: The workflow sends the extracted article content to an AI model, which generates unique, helpful advice for each topic within the article. Post to Slack & NocoDB: The AI-generated contributions, along with the article links, are posted to a designated Slack channel and stored in a NocoDB database for future reference. Setup Google Search URL: Update the Google search URL with the relevant LinkedIn advice query for your field (e.g., "site:linkedin.com/advice 'marketing automation'"). Slack Integration: Connect your Slack account and specify the Slack channel where you want the contributions to be posted. NocoDB Integration: Set up your NocoDB project to store the generated contributions along with the article titles and links. How to customize this workflow Change Search Terms**: Modify the Google search URL to focus on a different LinkedIn topic or expertise area. Adjust Trigger Frequency**: The workflow is set to run weekly, but you can adjust the frequency by changing the schedule trigger. Enhance Contribution Quality**: Customize the AI model's prompt to generate contributions that align with your brand voice or content strategy. Workflow Summary This workflow helps users maintain a consistent presence on LinkedIn by automating the discovery of new advice articles and generating unique contributions using AI. It is ideal for professionals who want to engage with LinkedIn content regularly without spending too much time manually searching and drafting responses.

(Retail) VIP Customer Escalation Flow This workflow automatically monitors new Zendesk support tickets, identifies VIP customers, generates AI-based ticket summaries, alerts available support agents on Slack and sends a consolidated email for non-VIP tickets. This workflow listens for new Zendesk tickets and checks whether the customer is a VIP.VIP tickets are prioritized using AI summaries and instant Slack alerts, while non-VIP tickets are grouped and sent as a single email notification to the support team. You get: Instant VIP ticket alerts on Slack** AI-generated issue summary and next steps** Automatic agent availability check** One clean email for all non-VIP tickets** Ticket tracking stored for reporting** Ideal for support teams who want to prioritize high-value customers without manual effort. Quick Start – Implementation Steps Connect your Zendesk account and enable the Zendesk Trigger. Add your OpenAI API key for ticket summarization. Connect your Slack workspace and select users/channels. Configure Airtable to store VIP ticket data (optional but recommended). Connect Gmail to send non-VIP ticket summary emails. Activate the workflow — automation starts immediately. What It Does This workflow automates VIP ticket handling and notifications: Detects new Zendesk support tickets. Checks if the ticket belongs to a VIP customer. Uses AI to summarize VIP ticket issues and suggest next steps. Saves VIP ticket data for tracking and audits. Finds active support agents on Slack. Sends direct Slack alerts to active agents or a fallback channel. Collects non-VIP tickets into a single list. Sends one summary email for all non-VIP tickets. This prevents alert fatigue while ensuring VIP customers get fast attention. Who’s It For This workflow is ideal for: Customer support teams Helpdesk managers SaaS and e-commerce businesses High-touch B2B support teams Operations teams handling VIP customers Anyone needing smarter ticket prioritization Requirements to Use This Workflow To run this workflow, you need: n8n instance** (cloud or self-hosted) Zendesk account** with API access OpenAI API key** Slack workspace** with bot permissions Gmail account** (or SMTP alternative) Airtable account** (optional, for logging) How It Works Ticket Trigger – Workflow starts when a new Zendesk ticket is created. VIP Check – Verifies whether the ticket contains a VIP tag. AI Summary – AI reads the ticket and generates a short summary and next steps. Save VIP Ticket – VIP tickets are stored for tracking and reporting. Agent Availability Check – Slack users are checked for online presence. Slack Alert – Sends alert to an active agent or team channel. Non-VIP Collection – Non-VIP tickets are grouped together. Email Notification – One summary email is sent to the support team. Setup Steps Import the workflow JSON into n8n. Configure Zendesk Trigger with OAuth. Add your OpenAI credentials. Map fields in the Airtable node (if used). Connect Slack API and select users/channels. Configure Gmail recipient and email format. Test with a sample VIP and non-VIP ticket. Activate the workflow. How To Customize Nodes Customize VIP Logic You can enhance VIP detection by: Adding spend-based logic Checking customer lifetime value Using CRM or database lookups Customize Slack Alerts You may add: Emojis or mentions (@here, @team) Ticket priority highlighting Direct Zendesk ticket links Customize Email Content You can: Add branding Include SLA warnings Add escalation notes Customize AI Output Adjust the AI prompt to: Change summary length Add tone (urgent, polite, technical) Include troubleshooting steps Add-Ons (Optional Enhancements) You can extend this workflow to: Auto-assign tickets to senior agents Add SLA breach detection Log VIP interactions to CRM Add sentiment analysis Create dashboards using Airtable or Google Sheets Trigger SMS or WhatsApp alerts Add priority-based routing (VIP / High / Normal) Use Case Examples 1\. VIP Customer Escalation Ensure top customers always get instant attention. 2\. Support Load Management Reduce Slack and email noise with grouped notifications. 3\. AI-Assisted Support Help agents understand issues faster with AI summaries. 4\. Audit & Reporting Track VIP issues and resolutions over time. Troubleshooting Guide | Issue | Possible Cause | Solution | |-----------------------|--------------------------|-----------------------------------| | No Slack alert | No active users | Check fallback channel | | AI summary missing | OpenAI key invalid | Reconnect OpenAI credentials | | Multiple emails sent | Aggregate node missing | Ensure aggregation is enabled | | VIP not detected | Tag mismatch | Check tag name and case | | Airtable error | Field mismatch | Match column names exactly | Need Expert Help? If you need help extending this workflow with advanced features like adding CRM integration, advanced VIP logic, dashboards or scaling this for production then our n8n automation experts at WeblineIndia can help you build reliable, enterprise-ready automations.

Upwork Proposal Automation with AI, Airtable and Slack 📘 Description This workflow automates the complete Upwork job discovery and proposal generation process by continuously monitoring job listings, intelligently filtering opportunities based on your skill set, generating personalised AI-written proposals, and delivering instant notifications — all without any manual effort. The workflow is triggered automatically every minute via Vollna's RSS feed, which monitors Upwork job postings matching your configured search filters. Each new job listing is parsed and analysed to extract key details, including title, description, budget, required skills, and job ID. A skills matching engine scores each job against your defined skill set and filters out weak matches. Duplicate jobs are automatically detected and skipped using Airtable as a reference store, ensuring AI credits are never wasted on already-processed listings. For every qualified new job, GPT-4o-mini generates a tailored 150–250-word proposal that references specific details from the job post, aligns your experience to the client's exact requirements, and ends with a clear call to action. The proposal and all job metadata are saved to an Airtable base for review. A formatted Slack notification is sent instantly with the full job details and generated proposal, allowing you to review, edit, and apply directly from Upwork with a single click. ⚙️ What This Workflow Does (Step-by-Step) 📡 RSS Feed Monitoring — Polls Vollna's Upwork RSS feed every minute for new job listings matching your skill keywords. Vollna replaces Upwork's discontinued native RSS feed (removed August 2024) and supports 30+ filter parameters, including category, budget, and client history. 🔍 Parse & Extract — Extracts structured fields from each RSS item, including job title, full description, budget, required skills, posted date, job ID, and clean Upwork job URL (decoded from Vollna's redirect format). 🎯 Filter: Skills Match — Scores each job against your defined skill list. Jobs scoring fewer than 2 matched skills are dropped immediately, ensuring only relevant opportunities proceed. ⭐ Filter: Client Quality — Filters out clients with ratings below 4.5. New clients with no rating history are allowed through by default. 🔁 Duplicate Detection — Queries Airtable to check if the job ID has already been processed in a previous run. Duplicate jobs are silently skipped without generating a proposal. 🤖 AI Proposal Generation — Calls GPT-4o-mini with a structured prompt containing the job details and your freelancer profile. Generates a concise, personalised proposal that opens with a specific reference to the job post, highlights relevant experience with real numbers, proposes a concrete first step, and ends with a soft call to action. 💾 Save to Airtable — Creates a new record in your Airtable base with all job fields, matched skills, match score, generated proposal, and status set to "New" for review tracking. 💬 Slack Notification — Sends a formatted message to your Slack channel with the job title, budget, match score, matched skills, required skills, direct Upwork job link, and the full AI-generated proposal — ready to copy and submit. 🧩 Prerequisites Vollna account** — Free tier available at vollna.com. Create a job filter matching your skills and copy the RSS feed URL from the Filters section OpenAI API key** — Used for GPT-4o-mini proposal generation (~$0.007 per proposal) Airtable account** — Free tier supports up to 1,000 records. Create a base with the schema below Slack workspace** — Bot token with chat:write permission, invited to your target channel 🗄️ Airtable Base Schema Create a table called Upwork Proposals with these fields: | Field Name | Type | |---|---| | Job Title | Single line text | | Job URL | URL | | Upwork URL | URL | | Posted At | Date | | Budget | Single line text | | Skills Required | Long text | | Matched Skills | Long text | | Match Score | Number | | AI Proposal | Long text | | Status | Single select: New, Reviewed, Applied, Skipped | | Job ID | Single line text | | Notes | Long text | 💰 Cost Estimate | Item | Estimated Cost | |---|---| | Vollna (free tier) | $0/mo | | GPT-4o-mini (50 proposals/day) | $1–3/mo | | Airtable (free tier) | $0/mo | | n8n self-hosted (AWS t3.small) | ~$10–15/mo | | Total | ~$11–18/mo | ⚙️ Setup Instructions Vollna — Sign up at vollna.com, create a job filter with your target keywords and skill categories, then copy the RSS feed URL from the Filters section Airtable — Create a new base and table using the schema above. Copy your Base ID from the Airtable URL and connect your Personal Access Token in n8n credentials OpenAI — Add your OpenAI API key as an n8n credential (HTTP Header Auth with Authorisation: Bearer sk-...) Slack — Create a Slack app, add chat:write scope, install to your workspace, invite the bot to your channel with /invite @your-bot-name Customise the AI prompt — Open the Build OpenAI Payload node and update the MY PROFILE section with your actual name, skills, and experience details Update skill filters — In the Filter: Skills Match node, update the YOUR_SKILLS array to match your exact skill set Publish the workflow — Click Publish. The RSS trigger will begin polling Vollna every minute automatically 💡 Key Benefits ✔ Fully automated job discovery — no manual searching required ✔ Skills-based filtering ensures AI only runs on relevant jobs ✔ Personalised proposals referencing specific job details — not generic templates ✔ Airtable CRM for tracking proposal status and conversion rates ✔ Instant Slack alerts with one-click access to apply on Upwork ✔ Deduplication prevents reprocessing the same job across runs ✔ Modular design — swap OpenAI for Claude or AWS Bedrock with minimal changes ✔ Cost-optimised — GPT-4o-mini keeps proposal generation under $3/month at scale 👥 Perfect For Freelancers on Upwork wanting to automate proposal writing Agencies managing multiple freelancer profiles Developers and automation specialists looking to win more technical contracts Anyone spending more than 30 minutes per day manually browsing and applying to Upwork jobs

Facebook Group Auto-Moderation This workflow automatically monitors Facebook Group posts, analyzes them using AI, detects policy violations, logs incidents, notifies moderators and automatically hides high-severity posts to keep the community clean and safe. This workflow listens to new Facebook Group posts in real time, processes each post individually and sends the post content to AI for moderation.If a post violates group rules (spam, scam, hate, adult content or aggressive promotion), the workflow alerts moderators, stores the violation in Airtable and automatically hides the post if the severity is high. You receive: Real-time AI moderation of Facebook Group posts** Automatic hiding of high-risk content** Slack alerts for moderation actions** Airtable logging for audit and tracking** Ideal for Facebook Group admins who want fast, consistent and automated moderation without manual review of every post. Quick Start – Implementation Steps Connect the Facebook Group Webhook to your n8n instance. Add your Facebook Page Access Token as an environment variable. Connect OpenAI credentials for content moderation. Configure Slack for alerts and Airtable for logging. Test using sample Facebook post data. Activate the workflow. What It Does This workflow automates Facebook Group moderation: Receives new group posts via webhook. Splits and processes posts one by one. Normalizes post data (ID, message, user, time). Sends post content to AI for moderation analysis. Determines: Violation or not Category (spam, scam, hate, adult, etc.) Severity (low / medium / high) Logs violations into Airtable. Sends alerts to Slack. Automatically hides posts marked as high severity. Notifies the team whether auto-hide succeeded or failed. Who’s It For This workflow is ideal for: Facebook Group admins & moderators Community management teams Social media operations teams Platforms handling large group volumes Anyone needing automated moderation at scale Requirements to Use This Workflow To run this workflow, you need: n8n instance** (cloud or self-hosted) Facebook Group Webhook subscription** Facebook Page Access Token** OpenAI API key** Slack workspace** with API access Airtable base** + Personal Access Token How It Works Receive Facebook Post – Webhook captures new group posts. Process Posts – Posts are handled one at a time. Normalize Data – Extracts clean post and user details. AI Moderation – AI analyzes the post for rule violations. Violation Check – Determines whether action is needed. Severity Check – Only high-risk posts are auto-hidden. Hide Post – Facebook API hides the post automatically. Log & Notify – Slack alerts + Airtable records are created. Setup Steps Import the workflow JSON into n8n. Configure the Webhook node and subscribe it to your Facebook Group. Add FB\_PAGE\_ACCESS\_TOKEN in n8n environment variables. Connect OpenAI, Slack and Airtable credentials. Verify Airtable field names match the workflow mapping. Test using pinned sample data. Activate the workflow. How To Customize Nodes Customize Moderation Rules Edit the AI Content Moderation node to: Adjust strictness Add or remove categories Change severity logic Customize Slack Alerts You can add: Emojis Mentions (@channel / @here) Direct links to the Facebook post Customize Auto-Hide Logic Change the Severity High? IF node to: Auto-hide medium severity Disable auto-hide completely Add manual approval steps Add-Ons (Optional Enhancements) You can extend this workflow to: Add moderator approval before hiding posts Auto-ban repeat offenders Track user violation history Generate daily moderation summaries Add sentiment analysis Create dashboards using Airtable Interfaces Support multiple Facebook Groups Use Case Examples 1\. Spam Control Automatically hide promotional or scam posts. 2\. Community Safety Detect hate or adult content instantly. 3\. Moderator Efficiency Reduce manual review workload. 4\. Audit & Compliance Maintain a clear violation history in Airtable. 5\. Large Group Management Scale moderation without adding moderators. Troubleshooting Guide | Issue | Possible Cause | Solution | |----------------------|----------------------------|-------------------------------------------------------| | No posts received | Webhook not subscribed | Verify Facebook webhook setup | | AI result missing | OpenAI error | Check API key & rate limits | | Post not hidden | Token permission issue | Verify Page Access Token permissions | | Slack alert not sent | Invalid Slack credentials | Reconnect Slack API | | Airtable error | Field mismatch | Match Airtable column names exactly | Need Help? If you need help extending this workflow with multi-group moderation, advanced AI rules, dashboards or production-scale automation, our n8n automation experts at WeblineIndia can assist with custom workflow design and deployment.

🧩 Description Automatically qualify, score, and route new leads using a hybrid AI + rule-based scoring engine. This workflow analyzes incoming leads from Airtable, enriches them with OpenAI-powered qualification, applies deterministic business rules, and instantly alerts your sales team in Slack when a high-intent lead is detected. 🎯 Who’s it for Sales teams that want instant alerts for high-intent leads Founders who need automated qualification without hiring SDRs Marketing teams running paid campaigns and capturing inbound leads RevOps teams building structured, explainable scoring systems If you store leads in Airtable and want AI-assisted qualification with fallback logic (not just blind AI scoring), this template is for you. 🤖 What it does This workflow implements a hybrid lead scoring model: Triggers when a new lead is created in Airtable. Normalizes and standardizes lead data. Sends structured context to OpenAI for qualification. Validates the AI response (strict JSON parsing). Falls back to deterministic scoring if AI fails. Combines AI score (50% weight) + rule-based score. Updates Airtable with: Final score (0–100) Hot/Warm/Cold tag AI reasoning Confidence level Sends Slack alerts: 🔥 Hot leads (score ≥ 80) ⚠️ AI scoring failures (manual review required) Unlike basic AI-only scoring, this workflow guarantees reliability by combining LLM reasoning with business logic. 🔄 How it works Lead intake & guardrail Airtable Trigger watches for new records. A guard condition prevents re-processing already scored leads (processed = true). AI qualification engine A structured prompt sends lead context to OpenAI. A code node vlidates and safely parses the JSON. If invalid - fallback scoring is activated + Slack alert. Deterministic scoring layer Business logic evaluates: Company size Role authority (Founder, Executive, Manager) Industry relevance Intent message length The deterministic score is capped at 50. How deteministic scoring works? Larger companies receive higher baseline scores: 1-10: 5 11-50: 10 51-200: 20 201-500": 25 501-1000": 30 1000+: 35 You can increase or decrease these values depending on your Ideal Customer Profile (ICP). Industry boost Technology/Software: 10 SaaS/Cloud Services: 15 Cybersecurity: 20 IT Services/Consulting: 10 If your product is industry-specific, this is where you fine-tune relevance. Role authority boost Decision-making power increases lead quality: Founder → +20 Executive → +20 Manager → +10 Head → +10 The workflow detects these keywords inside the role field and applies the corresponding boost. Intent boost (message length) Longer intent messages imply higher purchase interest: 100 characters → +15 50 characters → +8 Hybrid scoring formula Final Score = (AI Score × 0.5) + Deterministic Score Tag thresholds: 80–100 → Hot 50–79 → Warm 0–49 → Cold CRM update The workflow updates Airtable with: score ai_score deterministic_score tag ai_reason score_confidence processed = true Sales alert logic If: Tag = Hot Score ≥ 80 → Slack sends an immediate notification to the sales team. 📋 Requirements You’ll need: Airtable account (Base with Leads table) OpenAI API credentials Slack bot credentials n8n (Cloud or Self-hosted) No API keys are hardcoded. All credentials use secure n8n credential storage. 🛠️ How to set up Import the workflow. Connect credentials: Airtable OpenAI Slack Update: Airtable Base ID Table name Slack channel Ensure your Airtable table includes: lead_id (unique) first_name (text) last_name (text) email phone job_role (single select) industry (single select) company_size (single select) intent_message (long text) - score (number) ai_score (number) deterministic_score (number) tag (text) ai_tag (text) score_confidence (text) created_at (created time) processed (checkbox/boolean) Activate the workflow. 🎛️ How to customize This template uses a hybrid scoring model, combining: 🤖 AI qualification score (50% weight) 📊 Deterministic rule-based scoring (fully customizable) All deterministic scoring logic can be modified inside the Hybrid Lead Scoring Engine Code node. That node contains the full business rule logic for: Company size scoring Industry boosts Role authority boosts Intent-based scoring Final score calculation formula You can easily adjust: AI scoring weight (currently 50%) Hot lead threshold (currently 80) Slack notification logic AI prompt instructions (to match your ICP) You can also: Add email notifications Route Warm leads to nurturing workflows Push Hot leads into a CRM like HubSpot or Salesforce ✨ Why this template is different Uses AI with validation and fallback Prevents double-processing Preserves explainability (AI reasoning stored in CRM) Avoids over-reliance on LLM output Production-ready structure with clear separation of logic blocks This is not just AI scoring — it’s a resilient, sales-ready qualification engine.

This weekly workflow automatically identifies new ranked keywords for your domain within Google’s top 10 results without manual SERP monitoring. On each run, the workflow fetches the latest ranking and search volume data using the DataForSEO Labs API and stores a fresh results snapshot in Airtable. It then compares this data with the previous set to identify any new keywords your domain started ranking for, focusing on queries that rank in the top 10. All newly ranked top-10 keywords are logged in Airtable, along with their ranking position and search volume. Once new terms and rankings are identified, the workflow sends you a Slack summary highlighting the latest changes. Who’s it for SEO experts and marketers who want an automated way to track new top-ranking keywords on Google for their domain(s). What it does This workflow automatically detects when your domain enters top-10 results for new keywords on Google, records them in Airtable, and sends a weekly summary via Slack. How it works Runs on a predefined schedule (default: weekly). Reads your keywords and target domains from Airtable. Fetches the latest Google rankings and keyword metrics via DataForSEO API. Compares the latest data with the previous run. Logs newly ranked top-10 keywords to Airtable. Sends a Slack summary with key changes. Requirements DataForSEO account and API credentials Airtable table with your keywords, following the required column structure. Airtable table with your target domains, following the required column structure. Slack account Customization You can easily customize this workflow by adjusting the run schedule, changing the minimum ranking threshold (e.g., top 5 or top 20), exporting results to other tools, and tailoring the Slack message content to your team’s workflow.

This n8n workflow automates job discovery by scanning company career pages, extracting open positions using AI, filtering them by department, and sending real-time alerts via Slack and email. It is ideal for monitoring targeted job roles (such as Engineering) across multiple companies without manual checking. Use Cases Targeted Job Monitoring: Automatically track new job postings for a specific department or role. Faster Job Alerts: Receive instant Slack and email notifications when relevant positions are found. Multi-Company Career Tracking: Monitor multiple company career pages from a single Airtable base. Reduced Noise: Filter out irrelevant roles and avoid empty or misleading notifications. Good to Know The workflow runs on a schedule and processes career pages stored in Airtable. Jobs are processed in batches with a delay node to avoid rate limits or scraping issues. Google Gemini is used for intelligent job extraction and filtering, which may incur API costs. If no relevant jobs are found, the workflow safely returns “No matching positions found” to prevent false alerts. Some Gemini models may be geo-restricted depending on your region. How it Works Step 1: Job Source & Scheduling A Schedule Trigger starts the workflow and defines the job category to monitor (e.g., Engineering). Airtable is queried to fetch all company career page URLs. Step 2: Scraping & Extraction Each career page is scraped using Decodo. Google Gemini analyzes the raw page content and extracts job titles with application URLs while ignoring navigation and non-job content. Step 3: Data Cleaning & Structuring A JavaScript code node cleans the AI output, removes noise (e.g., “No open positions”), and converts results into structured job items. Step 4: AI-Based Filtering A second AI Agent compares extracted jobs against the target department and keeps only relevant roles. Step 5: Notifications Matching jobs are sent instantly to Slack and email. How to Use Airtable Credentials: Connect Airtable and store career page URLs in the table. Google Gemini Credentials: Add your Gemini API key for AI extraction and filtering. Slack Credentials: Select a user or channel to receive job alerts. Gmail Credentials: Configure Gmail to receive job notification emails. Schedule Setup: Adjust the trigger interval based on how often you want job checks. Activate Workflow: Enable the workflow to start automated job monitoring. Requirements n8n instance (self-hosted or cloud) Airtable base with company career page URLs Google Gemini API key Slack workspace Gmail account for email notifications

Automated Invoice Intelligence: PDF-to-JSON Financial Orchestrator 🎯 Description This is an elite enterprise-grade solution for Accounts Payable and Finance Ops teams. It automates the high-volume extraction of unstructured data from PDF invoices using the HTML to PDF (Parse PDF to JSON) node, transforming raw email attachments into validated, audit-ready financial records across multiple platforms. ✨ The Sovereign Lifecycle Intelligent Intake & Validation - Monitors Gmail for incoming invoices. Implements a strict validation layer to ensure only valid PDF binaries enter the intelligence stream, filtering out noise and non-invoice attachments. Atomic JSON Transformation - Leverages the HTML to PDF (Parse PDF to JSON) node to decompose monolithic PDF files into structured data objects. This allows the system to treat document text as actionable data points. AI Ledger Mapping - A sophisticated hybrid-intelligence Code Node acts as a virtual "Financial Controller." It uses advanced pattern matching to extract key fields (Vendor Name, Invoice Number, Tax, and Total Amount) and calculates a Confidence Score for every entry. Conditional Approval Gating - Implements a "Trust-but-Verify" architecture: Auto-Process: High-confidence extractions of standard value invoices are posted immediately. Human-in-the-Loop (HITL): Low-confidence results (<0.7) or high-value invoices (>$5,000) are automatically diverted to a Review Queue in Google Sheets. Multi-Platform Ledger Sync - Simultaneously synchronizes data across Google Sheets (for real-time reporting) and Airtable (for project management), ensuring a single source of truth. Forensic Archival & Alerts - Moves original files to a secure Google Drive archive. High-priority items trigger instant Slack and Gmail alerts for the finance team. 💡 Key Technical Features Heuristic Pattern Matching:** Dynamically handles various invoice layouts by analyzing financial context and keywords. Math Integrity Check:** Automatically verifies if (Subtotal + Tax = Total) to boost extraction confidence. Bi-Directional Governance:** Keeps track of every document with a unique Processing ID and metadata log for regulatory compliance. 🚀 Benefits ✅ 95% Reduction in Data Entry - Shifts human effort from manual typing to high-level oversight. ✅ Financial Risk Mitigation - Automatically flags high-value transactions and extraction anomalies before they hit the books. ✅ Real-Time Visibility - Instant updates to financial dashboards the moment an invoice is received. Tags: #finance #accounts-payable #pdf-to-json #automation #fintech #google-sheets #airtable Category: Finance & Operations | Difficulty: Advanced

WooCommerce Failed Order Fetch, Airtable Logging & Slack Alerts This workflow automatically checks WooCommerce for failed orders on a schedule, processes each order individually, prevents duplicate entries using Airtable, stores new failed orders centrally, and sends clear AI-generated Slack alerts. It ensures clean data, avoids duplicate records and helps teams act quickly on failed payments. Quick Implementation Steps Set your WooCommerce domain in the Set WooCommerce Domain node. Add WooCommerce API Key + Secret in the Fetch Failed Orders From WooCommerce node. Connect your Airtable Base/Table in the Search Records and Save Failed Order to Airtable nodes. Add your OpenAI API key to the AI node. Connect your Slack account + target channel. Enable the workflow and let it run automatically. What It Does This workflow continuously monitors your WooCommerce store for failed orders without relying on webhooks. On every scheduled run, it fetches all orders marked as failed, processes them one by one, and checks Airtable using the order\_id to see whether the order has already been logged. If the order already exists, the workflow safely stops processing for that order and optionally sends an informational Slack message. If the order is new, the workflow formats the data, saves it into Airtable, generates a clean AI-written summary, and sends a Slack alert to the team. This approach ensures data accuracy and prevents duplicate records. Who’s It For WooCommerce store owners needing reliable failed-payment tracking Finance teams monitoring recovery opportunities Support teams requiring instant alerts Developers building reusable, idempotent workflows Agencies managing multiple WooCommerce stores Ops teams using Airtable for reporting and audits Requirements to Use This Workflow Active n8n instance (cloud or self-hosted) WooCommerce store with REST API access Airtable account with Base and Table Slack workspace with API access OpenAI API key (for AI-generated messages) Permission to write data to Airtable and Slack How It Works & How To Set Up Step 1: Configure the Scheduler Set how often the workflow runs in Check Failed Orders (Scheduler) (e.g., every 5 minutes, 15 minutes, or hourly). Step 2: Set Your WooCommerce Domain In Set WooCommerce Domain, enter your store domain: Plain textANTLR4BashCC#CSSCoffeeScriptCMakeDartDjangoDockerEJSErlangGitGoGraphQLGroovyHTMLJavaJavaScriptJSONJSXKotlinLaTeXLessLuaMakefileMarkdownMATLABMarkupObjective-CPerlPHPPowerShell.propertiesProtocol BuffersPythonRRubySass (Sass)Sass (Scss)SchemeSQLShellSwiftSVGTSXTypeScriptWebAssemblyYAMLXML yourstore.com This value is reused across the workflow. Step 3: Fetch Failed Orders In Fetch Failed Orders From WooCommerce, configure Basic Authentication using: Consumer Key Consumer Secret The workflow fetches: Plain textANTLR4BashCC#CSSCoffeeScriptCMakeDartDjangoDockerEJSErlangGitGoGraphQLGroovyHTMLJavaJavaScriptJSONJSXKotlinLaTeXLessLuaMakefileMarkdownMATLABMarkupObjective-CPerlPHPPowerShell.propertiesProtocol BuffersPythonRRubySass (Sass)Sass (Scss)SchemeSQLShellSwiftSVGTSXTypeScriptWebAssemblyYAMLXML https://{{wc_domain}}/wp-json/wc/v3/orders?status=failed Step 4: Loop & Duplicate Check Each failed order is processed individually using Loop Over Items. The workflow searches Airtable using Search Records to check whether the order\_id already exists. A Merge node ensures safe data handling, and the IF node decides whether the order is a duplicate or a new entry. Step 5: Format New Order Data The Format Order Data node normalizes WooCommerce data, maps failure reasons, builds admin and retry URLs, and prepares the data for storage. Step 6: Save to Airtable New failed orders are saved in Airtable using Save Failed Order to Airtable. Duplicate orders are skipped to prevent data duplication. Step 7: Generate & Send Slack Alerts For new failed orders, the workflow generates a concise AI-based summary and sends it to Slack. Duplicate orders can optionally trigger an informational Slack message. How To Customize Polling Frequency:** Change scheduler interval Duplicate Logic:** Modify Airtable search or IF condition Stored Fields:** Adjust Airtable field mappings Formatting Rules:* Edit JavaScript in Format Order Data* Slack Message Style:** Update AI prompt Optional Enhancements Retry-payment tracking with attempts count Customer notification via email or SMS Jira/Trello ticket creation Google Sheets or BI dashboard sync Multi-store WooCommerce support Example Use Cases Centralized failed-payment tracking in Airtable Instant Slack alerts for support and finance teams Clean reporting without duplicate records Faster issue resolution with AI summaries Scalable foundation for recovery automation Troubleshooting Guide | Issue | Possible Cause | Solution | | --------------------------- | ----------------------------------- | ------------------------------------------------------ | | No orders fetched | Wrong WooCommerce domain or API URL | Check Set WooCommerce Domain and HTTP Request URL | | 401 Unauthorized | Invalid API key/secret | Regenerate keys from WooCommerce → REST API | | Airtable record not created | Field mismatch | Confirm column names and types in Airtable | | Slack message empty | AI node prompt or path mismatch | Confirm output path: $json.output[0].content[0].text | | Workflow not running | Scheduler disabled | Ensure workflow is Active | | API timeout | Store too slow or blocked | Whitelist server IP or increase timeout in HTTP node | Need Help? If you need assistance customizing this workflow, adding new features or integrating more systems, feel free to reach out. The n8n automation team at WeblineIndia can help with: Advanced WooCommerce automations Multi-store workflows Airtable/Slack/OpenAI integrations Custom logic, validations and data pipelines And many such advanced automation solutions. We’re here to support you in scaling your automation journey.

📘 Description This workflow automates end-to-end AI-driven inventory intelligence, transforming Airtable stock data into optimized reorder recommendations, daily operational summaries, and instant Slack alerts. It fetches all inventory rows, validates structure, computes reorder and safety-stock metrics using strict formulas, merges multi-batch AI output into a unified dataset, and distributes actionable insights across Email and Slack. Invalid or corrupted Airtable rows are logged to Google Sheets for audit and cleanup. The workflow ensures deterministic inventory math (zero improvisation), strict JSON compliance, and reliable multi-channel reporting for operations teams. ⚙️ What This Workflow Does (Step-by-Step) ▶️ Manual Trigger – Start Inventory Optimization Runs the full optimization and reporting pipeline on demand. 📦 Fetch Inventory Records from Airtable Retrieves all SKU records (ID, ItemName, SKU, quantities, reorder levels) from the Airtable Inventory table. 🔍 Validate Inventory Record Structure (IF) Ensures each record contains a valid id. Valid → routed to AI optimization Invalid → saved to Google Sheets. 📄 Log Invalid Inventory Rows to Google Sheet Captures malformed or incomplete Airtable items for audit checks and data hygiene. 🧠 Configure GPT-4o — Inventory Optimization Model Defines the AI model for stock-level calculations using strict formulas: SuggestedReorderPoint = ReorderLevel × 1.2 SuggestedSafetyStock = ReorderLevel × 0.5 StockStatus logic: Critical if QuantityInStock ≤ SuggestedSafetyStock Needs Reorder if QuantityInStock ≤ SuggestedReorderPoint OK otherwise 🤖 Generate Inventory Optimization Output (AI) The AI engine analyzes each SKU and returns: Suggested reorder point Suggested safety stock Updated stock status Clean structured JSON for each item All without markdown, hallucination, or additional logic. 🧩 Merge AI Optimization Results (Code) Consolidates all partial AI responses into one complete JSON dataset containing all SKUs. 🧠 Configure GPT-4o – Email Summary Model Prepares the AI model used for generating a professional operations-team email. 📧 Generate Inventory Email Summary (AI) Creates a manager-ready email including: High-level inventory health Detailed SKU summaries Alerts for low, reorder-level, or critical stock Recommended actions for today’s operations 📨 Email Inventory Summary to Manager (Gmail) Sends the completed inventory summary to the operations manager. 🧠 Configure GPT-4o – Slack Summary Model Sets up GPT-4o to produce a compact, emoji-supported Slack summary. 💬 Generate Inventory Slack Summary (AI) Builds a Slack-optimized message containing: One-line inventory health Bullet list of SKUs with stock status Clear alerts for reorder-level or critical items One recommended action line 📡 Notify Operations Team on Slack Delivers the optimized Slack summary to the operations Slack user/channel for real-time visibility. 🧩 Prerequisites Airtable access token Azure OpenAI GPT-4o credentials Google Sheets OAuth Slack API credentials Gmail OAuth 💡 Key Benefits ✔ AI-powered stock calculations with strict formulas ✔ Reliable reorder and safety-stock predictions ✔ Instant multi-channel reporting (Email + Slack) ✔ Full audit logging for invalid data ✔ Zero hallucinations—pure structured JSON ✔ Faster decision-making for operations teams 👥 Perfect For Operations & supply-chain teams Inventory managers Retail & e-commerce units Businesses using Airtable for stock tracking

WooCommerce VIP Customer Automation This workflow automatically identifies VIP customers from your WooCommerce store based on their total spending and number of completed orders. It pulls new orders on a schedule, filters valid transactions, groups customers, calculates their VIP tier, stores them into Airtable and notifies your team in Slack.It removes all manual checking and ensures your team instantly knows when a high-value customer places an order. Quick Start – Implementation Steps Add your WooCommerce store domain and API credentials inside n8n. Configure Airtable and Slack credentials. Adjust VIP rules (lifetime spend or total orders) if needed. Activate the workflow — it will automatically detect VIPs and alert your team. What It Does This workflow fully automates VIP customer detection for WooCommerce stores. Every few minutes, it retrieves new orders via WooCommerce API. It filters only processing or completed orders and extracts essential fields such as customer ID, customer name order total and timestamps. The workflow then groups orders by customer to ensure duplicate orders don’t inflate metrics. For each customer, it fetches their complete order history, calculates lifetime value, counts total paid orders and assigns a VIP tier (Platinum, Gold or Silver). Once a customer qualifies, their details are saved into Airtable for tracking. A Slack message is simultaneously sent to inform your team so they can take immediate action — such as providing priority support, follow-up messages or special offers. This system runs completely on its own and keeps customer insights up-to-date without manual checks. Who’s It For This workflow is ideal for: WooCommerce store owners Customer support teams Marketing teams CRM & retention specialists eCommerce operations teams Businesses wanting automated VIP alerts Requirements to Use This Workflow You will need: A running n8n instance (cloud or self-hosted) A WooCommerce store with API keys A Slack workspace with API permissions An Airtable Base to store VIP customers Basic understanding of WooCommerce and Airtable fields How It Works Scheduled Trigger – Runs every few minutes to check for new orders. Domain Setup – Assigns the WooCommerce store domain used across API calls. Fetch Orders – Retrieves all orders from WooCommerce. Filter Valid Orders – Only keeps completed or processing orders. Format & Clean Data – Extracts only key order details. Deduplicate Customers – Only the first order per customer is processed. Fetch Order History – Gets lifetime order history for each customer. Calculate VIP Tier – Determines Platinum/Gold/Silver based on spend or order count. Filter VIP Only – Removes customers who do not qualify. Save to Airtable – Creates/updates VIP records. Notify Team on Slack – Sends VIP alerts instantly. Setup Steps Import this workflow JSON into n8n. Enter your WooCommerce API credentials in the HTTP Request nodes. Update the wc\_domain value in the “Set WooCommerce Domain” node. Configure Airtable credentials and select your Base + Table. Set your Slack channel ID inside the Slack node. Adjust VIP rules inside the “Calculate VIP Tier” code node if needed. Activate the workflow — it will now run automatically. How to Customize Nodes Adjust VIP Rules Edit the logic inside Calculate VIP Tier: Change Platinum threshold (₹20,000 or your value) Change Gold rule (5 orders or more) Add new VIP tiers Customize Airtable Fields You can modify: Table columns Field naming Additional customer details Customize Slack Alerts In the Slack node, change: Message format Channel ID Emoji, headings or urgency indicators Add-Ons (Optional Enhancements) You can extend this workflow with: Automatic email to VIP customers Loyalty point calculation Google Sheets export Integration with CRM platforms Send SMS notifications Separate VIP tiers into dedicated Slack channels Use Case Examples Notify support about high-value customers Track customers crossing spending milestones Identify loyal customers with 5+ repeat purchases Automatically sync VIP customers to CRM Trigger loyalty coupon generation Troubleshooting Guide | Issue | Possible Cause | Solution | |---------------------------|--------------------------------------------------|--------------------------------------------------------------| | No orders fetched | Wrong domain or API keys | Update WooCommerce credentials | | VIP not detected | Customer has low spend or low orders | Verify VIP rules in “Calculate VIP Tier” | | Airtable record not created | Incorrect table schema | Match Airtable fields with node mapping | | Slack alert missing | Wrong Slack channel ID or credentials | Re-check Slack authentication | | Guest users included | Missing customer_id filter | Ensure customer_id != 0 condition stays in place | Need Help? If you need assistance integrating this workflow, customizing VIP rules or adding new automations, our automation team at WeblineIndia is happy to help. You can also extend this system with loyalty engines, advanced analytics, multi-store support or any custom automation tailored for your eCommerce business.

How It Works This workflow automates IoT device compliance monitoring and anomaly detection for industrial operations. Designed for facility managers, quality assurance teams, and regulatory compliance officers, it solves the challenge of continuously monitoring sensor networks while ensuring regulatory adherence and detecting operational issues in real-time.The system runs every 15 minutes, fetching IoT sensor data and structuring it for analysis. Dual AI agents evaluate compliance against regulatory standards and detect operational anomalies. Issues trigger immediate email and Slack alerts for rapid response. Daily data aggregates into comprehensive ESG reports with AI-generated insights, automatically emailed to stakeholders for transparency and audit trails. Setup Steps Configure AirTable credentials and set 15-minute schedule interval Add OpenAI API keys for compliance and anomaly detection agents, configure regulatory thresholds Set Gmail/Slack credentials for alerts and ESG report distribution Prerequisites IoT sensor platform API access, OpenAI API key, Gmail/Slack accounts Use Cases Manufacturing quality control, environmental compliance monitoring Customization Modify sensor polling frequency, adjust compliance rules, customize anomaly thresholds Benefits Continuous compliance assurance, instant anomaly detection

How It Works This workflow automates tenant screening by analyzing payment history, credit, and employment data to predict rental risks. Designed for property managers, landlords, and real estate agencies, it solves the challenge of objectively evaluating tenant reliability and preventing payment defaults.The system runs daily assessments, fetching rent payment history, credit bureau reports, and employment records. An AI agent merges this data, calculates risk scores, and routes alerts based on severity. High-risk tenants trigger immediate email notifications for intervention, medium-risk cases post to Slack for monitoring, while low-risk updates save quietly to databases. Automated collection workflows initiate for high-risk cases. Setup Steps Configure payment history, credit bureau, and employment credentials in fetch nodes Add OpenAI API key for risk analysis and set Gmail/Slack credentials for alerts Customize risk score thresholds and routing rules in workflow logic Prerequisites Payment system API, credit bureau access, employment verification API Use Cases Rental application screening, existing tenant monitoring Customization Modify risk scoring criteria, adjust alert thresholds Benefits Reduces defaults through early detection, eliminates screening bias

AI-Powered Fake Review Detection Workflow Using n8n & Airtable This workflow automates the detection of potentially fake or manipulated product reviews using n8n, Airtable, OpenAI and Slack. It fetches reviews for a given product, standardizes the data, generates a unique hash to avoid duplicates, analyzes each review using an AI model, updates the record in Airtable and alerts the moderation team if the review appears suspicious. Quick Implementation Steps Add Airtable, OpenAI and Slack credentials to n8n. Create an Airtable Base with a reviews table. Connect the Webhook URL to your scraper or send sample JSON via Postman. Test the workflow by passing product and review URLs. Activate the workflow for continuous automated review screening. What It Does This workflow provides an automated pipeline to analyze product reviews and determine whether they may be fake or manipulated. It begins with a webhook that accepts product information and a scraper API URL. Using this information, the workflow fetches associated reviews. Each review is then expanded into separate items and normalized to maintain a consistent structure. The workflow generates a hash for deduplication, preventing multiple entries of the same review. New reviews are stored in Airtable and subsequently analyzed by OpenAI. The resulting risk score, explanation and classification are saved back into Airtable. If a review's score exceeds a predefined threshold, a structured Slack alert is sent to the moderation team. This ensures that high-risk reviews are escalated promptly while low-risk reviews are simply stored for recordkeeping. Who’s It For eCommerce marketplaces monitoring review integrity Sellers seeking automated fraud detection for product reviews SaaS platforms that accept user-generated reviews Trust & Safety and compliance teams Developers looking for an automated review-quality pipeline Requirements n8n (Cloud or Self-Hosted) Airtable Personal Access Token OpenAI API Key Slack Bot Token or Webhook Review Scraper API Basic understanding of Airtable field setup How It Works & How To Set Up Receive Product Data The workflow starts with the Webhook – Receive Product Payload, which accepts a list of products and their scraper URLs. Extract and Process Each Product Extract products separates the list into individual items. Process Each Product ensures that each product’s reviews are processed one at a time. Fetch and Validate Reviews Fetch Product Reviews calls the scraper API. IF – Has Reviews? determines whether any reviews were returned. Expand and Normalize Reviews Expand reviews[] to items splits reviews into individual items. Prepare Review Fields ensures consistent review structure. Generate Review Hash Generate Review Hash1 produces a deterministic hash based on review text, reviewer ID, and date. Airtable Deduplication Check Search Records by Hash checks whether the review already exists. Normalize Airtable Result cleans Airtable’s inconsistent empty output. Is New Review? decides if the review should be inserted or skipped. Store New Reviews Create Review Record inserts new reviews into Airtable. AI-Based Fake Review Analysis AI Fake Review Analysis sends relevant review fields to OpenAI. Parse AI Response ensures the output is valid JSON. Update Airtable With AI Results Update Review Record stores the AI’s score, classification, and reasoning. Moderation Alert Check Suspicious Score Threshold evaluates if the fake score exceeds a defined limit. If so, Send Moderation Alert posts a detailed message to Slack. How To Customize Nodes Fake Score Threshold Modify threshold in Check Suspicious Score Threshold. Slack Message Format Adjust text fields in Send Moderation Alert. AI Prompt Instructions Edit the instructions inside AI Fake Review Analysis. Airtable Fields Update mappings in both Create Review Record and Update Review Record. Additional Checks Insert enrichment steps before AI analysis, such as: reviewer profile metadata geolocation or reverse IP checks keyword density analysis Add-ons Notion integration for long-term review case tracking Jira or Trello integration for incident management Automated sentiment tagging Weekly review-risk summary reports Google Sheets backup for archived reviews Reviewer behavior modeling (number of reviews, frequency, patterns) Use Case Examples Detecting manipulated Amazon product reviews. Flagging repetitive or bot-like reviews for Shopify stores. Screening mobile app reviews for suspicious content. Quality-checking user reviews on multi-vendor marketplaces. Monitoring competitor-driven false negative or positive reviews. There can be many more scenarios where this workflow helps identify misleading product reviews. Troubleshooting Guide | Issue | Possible Cause | Solution | | ---------------------------- | ----------------------------------- | ------------------------------------------------------ | | No data after review fetch | Scraper API returned empty response | Validate scraper URL and structure | | Duplicate reviews inserted | Hash mismatch | Ensure Generate Review Hash1 uses the correct fields | | Slack alert not triggered | Bot not added to channel | Add bot to the target Slack channel | | AI response fails to parse | Model returned non-JSON response | Strengthen "JSON only" prompt in AI analysis | | Airtable search inconsistent | Airtable returns empty objects | Rely on Normalize Airtable Result for correction | Need Help If you need assistance customizing this workflow, integrating additional systems or designing advanced review moderation solutions, our n8n workflow development team at WeblineIndia is available to help. We offer support for: Workflow setup and scaling Custom automation logic AI-driven enhancements Integration with third-party platforms And so much more. Feel free to contact us for guidance, implementation or to build similar automated systems tailored to your needs.

WooCommerce Product Reviews: Sentiment Analysis with Slack Summary This workflow automatically fetches product reviews from your WooCommerce store, analyzes the sentiment of each review using AI, stores the results in Airtable and sends a summary of positive, neutral and negative reviews to Slack. It helps teams quickly understand overall customer feedback, track product sentiment and stay updated without manually reading all reviews. Quick Start – Implementation Steps Import the workflow JSON file into n8n. Configure credentials: WooCommerce HTTP Basic Auth (for fetching reviews) OpenAI API (for sentiment analysis) Airtable Personal Access Token (for storing reviews) Slack API (for sending summary messages) Adjust the Cron/Schedule Trigger node to your preferred interval (e.g., every 10 minutes). Test the workflow with a few reviews to ensure AI and Slack integrations work correctly. Activate the workflow after confirming functionality. What It Does This workflow automates sentiment analysis and team notification: Schedule Trigger** – Runs the workflow automatically at defined intervals. Set WooCommerce Domain** – Defines the WooCommerce store to fetch reviews from. Fetch Reviews** – Retrieves all recent product reviews using WooCommerce API credentials. Loop Over Items** – Processes reviews in smaller batches for efficiency. Message a Model** – Sends each review to OpenAI to detect sentiment (positive, neutral, negative) and generate a short summary. Merge & Code Nodes** – Combines original review data with AI results and ensures proper data alignment. If Node** – Checks sentiment for further processing. Create a Record (Airtable)** – Stores each review and its sentiment in Airtable. Code Summary Node** – Counts positive, neutral, and negative reviews to create a summary. Send a Message (Slack)** – Posts the sentiment summary to the team’s Slack channel for visibility. Who’s It For This workflow is ideal for: E-commerce managers tracking WooCommerce product feedback Customer support teams monitoring review sentiment Marketing and product teams seeking automated insights Teams using Airtable and Slack for data tracking and collaboration Requirements to Use This Workflow An n8n instance (cloud or self-hosted) WooCommerce store** with API access OpenAI API key** for sentiment analysis Airtable account** with base/table configured Slack workspace** with API access for messaging Basic familiarity with APIs and workflow automation How It Works Schedule Trigger – Executes the workflow at the defined interval. Set WooCommerce Domain – Configures which store to fetch reviews from. Fetch Reviews – Retrieves all recent product reviews from WooCommerce. Loop Over Items – Splits reviews into manageable batches. Message a Model – Sends reviews to AI for sentiment analysis and short summary. Merge & Code Nodes – Combines AI results with original review data and prepares it for storage and summary. If Node – Checks review sentiment for saving or further processing. Create a Record (Airtable) – Saves each review with sentiment and AI summary. Code Summary Node – Counts the number of positive, neutral, and negative reviews. Send a Message (Slack) – Sends a concise summary of review sentiment to the Slack channel. Setup Steps Import the workflow JSON into n8n. Add credentials: WooCommerce HTTP Basic Auth OpenAI API Airtable Personal Access Token Slack API Configure the WooCommerce domain in the Set WooCommerce Domain node. Test the workflow with sample reviews to ensure AI outputs correctly. Adjust the Schedule Trigger interval as needed. Activate the workflow after confirming that data flows correctly from WooCommerce → AI → Airtable → Slack. How To Customize Nodes Schedule Trigger Adjust interval (minutes, hours, days) as needed. Set WooCommerce Domain Replace with your store domain URL. Fetch Reviews Update endpoint or filters if needed. Ensure WooCommerce credentials are correct. Message a Model Change AI model or prompts to adjust sentiment analysis or summary style. Create a Record (Airtable) Map additional fields if needed. Ensure the table has the necessary columns for sentiment, summary, rating, and product info. Send a Message (Slack) Customize Slack message format. Change the channel ID to send summaries to the right team. Optional Enhancements Include historical review trends. Automatically trigger notifications only for negative reviews. Send summaries to email or other messaging apps. Visualize sentiment trends in Airtable or external dashboards. Use Case Examples Automated Sentiment Tracking – Understand customer feedback without manual reading. Team Alerts – Notify product and support teams about negative reviews quickly. Data Storage & Reporting – Keep historical sentiment in Airtable for trend analysis. Efficient Batch Processing – Process large number of reviews without overloading the system. Troubleshooting Guide | Issue | Possible Cause | Solution | |--------------------------|--------------------------------------------------|--------------------------------------------------------------| | Reviews not fetched | Wrong WooCommerce credentials or endpoint | Check WooCommerce HTTP Basic Auth and store domain | | AI analysis fails | OpenAI API key invalid or prompt error | Verify OpenAI credentials and prompt syntax | | Slack message missing | Incorrect Slack channel or API token | Check Slack credentials and channel ID | | Airtable not storing reviews | Table or field mismatch | Verify Airtable base, table, and column mapping | Need Help? If you need assistance setting up the workflow, customizing AI sentiment analysis or integrating Slack summaries, feel free to contact our n8n development team at WeblineIndia. We provide workflow automation, AI integration and reporting solutions for WooCommerce stores.

Smart Contract Event Monitor (Web3) This workflow automatically monitors the Ethereum blockchain, extracts USDT transfer events, filters large-value transactions, stores them in Airtable and sends a clean daily summary alert to Slack. This workflow checks the latest Ethereum block every day and identifies high-value USDT transfers. It fetches on-chain logs using Alchemy, extracts sender/receiver/value details, filters transactions above a threshold, stores them in Airtable and finally sends a single clear summary alert to Slack. You receive: Daily blockchain check (automated) Airtable tracking of all high-value USDT transfers A Slack alert summarizing the count + the largest transfer Ideal for teams wanting simple, automated visibility of suspicious or large crypto movements without manually scanning the blockchain. Quick Start – Implementation Steps Add your Alchemy Ethereum Mainnet API URL in both HTTP nodes. Connect and configure your Airtable base & table. Connect your Slack credentials and set the channel for alerts. Adjust the value threshold in the IF node (default: 1,000,000,000). Activate the workflow — daily monitoring begins instantly. What It Does This workflow automates detection of high-value USDT transfers on Ethereum: Fetches the latest block number using Alchemy. Retrieves all USDT Transfer logs from that block. Extracts structured data: Sender Receiver Amount Contract Block number Transaction hash Filters only transactions above a configurable threshold. Saves each high-value transaction into Airtable for record-keeping. Generates a summary including: Total number of high-value transfers The single largest transfer Sends one clean alert message to Slack. This ensures visibility of suspicious or large fund movements with no repeated alerts. Who’s It For This workflow is ideal for: Crypto analytics teams Blockchain monitoring platforms Compliance teams tracking high-value activity Web3 product teams Developers needing automated USDT transfer tracking Anyone monitoring whale movements / suspicious transactions Requirements to Use This Workflow To run this workflow, you need: n8n instance** (cloud or self-hosted) Alchemy API URL** (Ethereum Mainnet) Airtable base** + Personal Access Token Slack workspace** with API permissions Basic understanding of Ethereum logs, hex values & JSON data How It Works Daily Check – Workflow runs automatically at your set time. Get Latest Block Number – Fetches newest Ethereum block from Alchemy. Fetch USDT Logs – Queries all Transfer events (ERC-20 standard). Extract Transaction Details – Converts hex → readable data. Filter High-Value Transactions – Keeps only large value transfers. Save to Airtable – Adds each transfer record to your database. Generate Summary – Finds the largest transfer & total count. Send Slack Alert – Notifies your team with one clean summary. Setup Steps Import the provided n8n JSON file. Open the Get Latest Block and Fetch Logs HTTP nodes → add your Alchemy API URL. Ensure USDT contract address (already included):0xdAC17F958D2ee523a2206206994597C13D831ec7 Connect your Airtable account and map: Contract From Address To Address Value Block Number txHash Connect Slack API credentials and choose your channel. Change the threshold limit in the IF node if needed (default: 1B). Activate the workflow — done! How To Customize Nodes Customize Value Threshold Modify the IF node: Increase or decrease the minimum transfer value Change logic to smaller or larger whale-tracking Customize Airtable Storage You can add fields like: Timestamp Token symbol USD price (using price API) Transaction status Risk classification Customize Slack Alerts You may add: Emojis Mentions (@channel, @team) Links to Etherscan Highlighted blocks for critical transfers Customize Web3 Provider Replace Alchemy with: Infura QuickNode Public RPC (not recommended for reliability) Add-Ons (Optional Enhancements) You can extend this workflow to: Track multiple ERC-20 tokens Process several blocks instead of just the latest Add price conversion (USDT → USD value) Detect transfers to suspicious wallets Generate daily or weekly summary reports in Slack Create a dashboard using Airtable Interfaces Add OpenAI-based insights (large spike, suspicious pattern, etc.) Use Case Examples 1\. Whale Tracking Detect large USDT movements (>1M or >5M). 2\. Compliance Monitoring Log high-value transfers in Airtable for audits. 3\. Real-Time Alerts Slack alerts tell your team instantly about big movements. 4\. On-Chain Analytics Automate structured extraction of Ethereum logs. 5\. Exchange Monitoring Detect large inflows/outflows to known addresses. Troubleshooting Guide | Issue | Possible Cause | Solution | |------------------------|-----------------------------------|---------------------------------------------------------| | No data in Airtable | Logs returned empty | Ensure USDT transfer events exist in that block | | Values are “zero” | Hex parsing failed | Check extract-code logic | | Slack alert not sent | Invalid credentials | Update Slack API key | | Airtable error | Wrong field names | Match Airtable column names exactly | | HTTP request fails | Wrong RPC URL | Re-check Alchemy API key | | Workflow not running | Schedule disabled | Enable "Daily Check" node | Need Help? If you need help customizing or extending this workflow — adding multi-token monitoring, setting up dashboards, improving alerts or scaling this for production — our n8n workflow developers at WeblineIndia can assist you with advanced automation.

Automated Podcast Generation with n8n, OpenAI & Buzzsprout This workflow automatically turns any audio file uploaded to Google Drive into a complete podcast episode. It handles transcription, content generation, blog drafting, social copy creation, thumbnail generation, Airtable record updates, Buzzsprout publishing and finally notifies your team via Slack. It is a full “audio-to-published-podcast” automation that requires no manual editing. ⚡ Quick Start: 10-Step Fast Implementation Connect Google Drive, OpenAI, Airtable, Slack & Buzzsprout credentials. Upload an audio file to the Drive folder. Workflow triggers automatically. Audio → Text transcription via OpenAI Whisper. AI converts transcript into title, show notes, tags, publish date, etc. AI generates social content & blog article. AI generates YouTube thumbnail (URL saved). Data saved to Airtable. Episode uploaded to Buzzsprout. Slack receives final “Episode Published” notification. What It Does This workflow automates the complete lifecycle of podcast publishing. Once an audio file is placed inside a Google Drive folder, the system takes over: it transcribes the audio, generates structured metadata, creates rich content including a blog post and multiple social media captions and produces a YouTube-ready thumbnail. Generated content is saved into Airtable, ensuring you always have a centralized database of episode metadata. The workflow then uploads the processed audio file to Buzzsprout, creating a ready-to-publish podcast entry. Finally, it sends a Slack notification summarizing the episode details. This workflow eliminates hours of manual podcast editing, writing and uploading — providing a fast, reliable and repeatable content automation pipeline. Who’s It For Podcasters who want to automate production and publishing Marketing teams managing multiple content channels Creators who want to repurpose audio into blogs & social content Agencies or studios producing podcasts for clients Anyone wanting a hands-free “record → upload → publish” podcast system Airtable Table Structure (Required Fields) To run this workflow successfully, you must create one Airtable table that stores all generated podcast episode data. Below is the exact list of fields (with correct Airtable field types) that the workflow expects. | Field Name | Airtable Field Type | Purpose | | -------------------------- | ------------------- | --------------------------------------------------------- | | episode_title | Single line text | Title generated from the audio transcript | | record_Id | Auto number | Automatically generated unique internal record identifier | | episode_description | Long text | Description of the episode (AI-generated) | | show_notes | Long text | Detailed show notes generated from transcript | | suggested_publish_date | Single line text | Publish date suggested by AI | | blog_draft_markdown | Long text | SEO-optimized full blog draft | | linkedin_post | Long text | LinkedIn long-form post | | instagram_caption | Long text | Instagram caption + hashtags | | twitter_thread | Long text | Thread text (converted from array → single string) | | tiktok_script | Long text | Short TikTok/Shorts script | | youtube_thumbnail_url | URL | Thumbnail image URL generated by OpenAI | | buzzsprout_episode_id | Number | Episode ID returned from Buzzsprout | | audio_url | Single line text | Buzzsprout final audio file URL | | published_at | Single line text | Actual published datetime returned by Buzzsprout | | guid | Single line text | Unique GUID assigned by Buzzsprout | Notes for Users Setting Up the Table Do not use array fields — arrays are converted into strings before saving. record_Id is Airtable auto-number will generate it and it used for update record. published_at, audio_url, guid and buzzsprout_episode_id are populated after Buzzsprout upload. youtube_thumbnail_url is populated after the AI Image Generation node. Requirements To use this workflow, you need: n8n** self-hosted or cloud Google Drive account** (folder monitored for new audio uploads) OpenAI API Key** (Whisper + GPT + Image Generation) Airtable Base & API Key** Buzzsprout Podcast ID & API Token** Slack App / Bot Token** Audio file in MP3/WAV/M4A format How It Works & Setup Steps Step 1 — Google Drive Trigger Monitors a specific folder. When an audio file is uploaded, the workflow starts. Step 2 — Transcribe Audio with OpenAI Uses Whisper model to convert speech → text. Returned transcript is cleaned and extracted. Step 3 — Extract Episode Metadata Title Description Show notes Episode tags Suggested publish date All parsed and structured via OpenAI. Step 4 — Generate Social Media Content LinkedIn article post Twitter/X thread Instagram caption TikTok short script Step 5 — Generate Blog Draft Full SEO-optimized Markdown article created by OpenAI. Step 6 — Create YouTube Thumbnail OpenAI Image API 1280×720 thumbnail URL stored in Airtable. Step 7 — Save Everything to Airtable One single table Stores episode title, description, tags, blog draft, social content, thumbnail URL, and transcript. Step 8 — Upload Episode to Buzzsprout Audio file from Google Drive → uploaded via multipart/form-data Title & description set Response returns audio URL and episode ID These are stored in Airtable. Step 9 — Slack Notification Sends message containing: Episode Title Buzzsprout Episode ID Published At Date Thumbnail URL How to Customize Nodes Google Drive Trigger Change the folder ID to monitor a different source directory. OpenAI Metadata Prompt Adjust tone, style, summarization level or tag generation. Social Content Node Modify the prompt to produce longer posts, more thread tweets or add new channels. Image Generation Customize thumbnail style: minimal, realistic, bold text, brand colors, etc. Buzzsprout Upload Node Set episode[published_at] to schedule future releases. Slack Notification Add more fields such as show notes or Airtable record links. Add-Ons (Optional Enhancements) You may extend the workflow with: Auto-post to LinkedIn, X, Instagram, TikTok** via Buffer API Notion page creation** for drafting content Automatic transcript** upload to Google Docs Email notification** to hosts or guests Auto-publish** YouTube video version (using static background + audio) Use Case Examples Podcast Production Automation – Record audio, upload to Drive and get a fully published episode automatically. Content Repurposing Workflow – Turn one audio file into several content formats instantly. Marketing Team Efficiency – Auto-generate social posts for multiple platforms. Client Podcast Management – Agencies can manage episodes with zero manual work. Internal Communications – Convert internal voice memos into polished summaries and blogs. (There can be many more such use cases depending on customization.) Troubleshooting Guide | Issue | Possible Cause | Solution | | ------------------------------------- | ---------------------------------- | -------------------------------------------------------------------- | | Buzzsprout upload missing audio | Wrong field name or missing binary | Ensure file field is binary & set to correct Drive binary property | | Episode title missing in Buzzsprout | OpenAI JSON not parsed correctly | Check parse code & that episode_title exists | | Social content not stored in Airtable | Airtable field type mismatch | Convert arrays into strings before writing | | Thumbnail not displaying | Expired OpenAI image URL | Regenerate or store static copy in Drive | | Workflow not triggering | Wrong Drive folder ID | Update folder ID in trigger node | Need Help? If you need assistance customizing this workflow, adding new features or building similar automations, WeblineIndia’s n8n automation developers can help you design, optimize and scale enterprise-grade n8n workflows. Feel free to reach out for professional support anytime.

Real-Time WooCommerce Return Surge Detection with Slack Alerts & Airtable Logging This n8n workflow monitors WooCommerce refund activity to detect unusual spikes in product returns at the SKU level. It compares return volumes across rolling 24-hour windows, alerts teams in Slack when defined thresholds are exceeded and logs all detected events into Airtable for tracking and analysis. 🚀 Quick Start – Get This Running Fast Import the workflow into n8n. Connect your WooCommerce API credentials. Configure Slack and Airtable credentials. Set your preferred schedule interval. Activate the workflow and start monitoring returns automatically. What It Does This workflow is designed to automatically detect abnormal return behavior in a WooCommerce store. On every scheduled run, it fetches recent orders and refunds directly from the WooCommerce REST API. Refund records are mapped back to their original orders to accurately identify affected SKUs. Using a rolling time-window comparison, the workflow calculates current versus previous return counts per SKU. It identifies significant increases—either large percentage spikes or unusually high absolute return volumes. This ensures early detection of potential product quality, packaging or fulfillment issues. When a return surge is detected, the workflow sends a structured alert to a Slack channel and stores the alert data in Airtable. This creates a searchable, historical log that supports investigations, trend analysis and operational decision-making. Who’s It For This workflow is ideal for: eCommerce operations teams. Quality assurance and product managers. Customer support leads. Supply chain and fulfillment teams. Store owners running WooCommerce at scale. Requirements to Use This Workflow To use this workflow, you will need: An active WooCommerce store with REST API access. WooCommerce API credentials** (Consumer Key & Secret). An active Slack workspace with permission to post messages. An Airtable base and table for logging alerts. An n8n instance (self-hosted or cloud). How It Works & How To Set Up Workflow Execution Flow Schedule Trigger runs the workflow at a fixed interval. Time Window node defines current and previous 24-hour comparison windows. HTTP Orders fetches recent WooCommerce orders. HTTP Refunds fetches refund records. Orders_Fetch (Code) maps refunds to parent orders and extracts SKU-level data. Refund_details (Code) aggregates returns, compares windows, and calculates increases. IF Node checks surge conditions: ≥100% increase OR ≥25 current returns Set Fields enriches data with status, run date, and cooldown key. Slack Node sends a formatted alert message. Code Node normalizes Slack output into structured fields. Airtable Node stores alert records for future reference. Setup Instructions Replace {your_woocommerce_domain} with your actual store domain. Verify WooCommerce API permissions allow order and refund access. Select the correct Slack channel in the Slack node. Ensure Airtable column names match the workflow mappings. How To Customize Nodes You can easily adapt this workflow by: Changing the schedule frequency in the Schedule Trigger. Adjusting WINDOW_HOURS in the Code nodes. Modifying alert thresholds in the IF node. Customizing the Slack message format. Adding or removing Airtable fields for reporting needs. Add-ons (Optional Enhancements) This workflow can be extended with: Email or Microsoft Teams notifications. Jira or Linear ticket creation. Product auto-pause for extreme return spikes. Dashboard reporting using BI tools. Cooldown logic to prevent repeated alerts per SKU. Use Case Examples Common use cases include: Detecting defective product batches early. Identifying packaging or shipping damage trends. Monitoring supplier quality issues. Supporting refund root-cause analysis. Improving customer satisfaction metrics. There can be many more operational and analytical use cases based on your business needs. Troubleshooting Guide | Issue | Possible Cause | Solution | |------|---------------|----------| | No Slack alerts | Threshold not met | Lower IF condition limits | | Empty SKU values | Missing SKU in WooCommerce | Use product name or ID fallback | | No data in Airtable | Column mismatch | Verify field names and types | | API errors | Invalid credentials | Re-authorize WooCommerce API | | Duplicate alerts | Frequent schedule | Add cooldown or deduplication logic | Need Help? Need assistance setting this up or customizing it for your business? WeblineIndia can help you implement, extend or build similar automation workflows tailored to your operational needs. Whether you want advanced alerting, deeper analytics or cross-system integrations, our team is ready to help you get the most out of n8n automation.

✅ What problem does this workflow solve? Real estate leads move fast. Manually matching buyer requirements with available properties, sending details, updating CRM records, and notifying sales teams often causes delays and missed opportunities. This workflow automates property discovery, lead management, and team notifications, ensuring buyers get instant results and sales teams can follow up immediately. ⚙️ What does this workflow do? Captures buyer property requirements from a website form. Cleans and standardizes search data automatically. Matches buyer criteria with relevant properties from Airtable. Emails matched properties to the buyer instantly. Stores lead details in Airtable for CRM tracking. Notifies the sales team on Slack in real time. 💡 Main Use Cases Automatically match buyer requirements with properties in Airtable. Send personalised property listings to buyers via email. Store and track every lead centrally for sales follow-up. Notify agents instantly to improve response speed. Increase conversions with faster, automated engagement. 🧠 How It Works – Step by Step Website Form Submission A buyer submits a property inquiry form with: Location / City Property type (Apartment, Villa, Commercial, etc.) Budget Contact details The workflow is triggered instantly via webhook. Data Cleaning & Standardization Submitted inputs are cleaned and structured: Budget is normalised City and property type are standardised Data is prepared for property matching Property Matching (Airtable) A dynamic matching formula is generated. Airtable is searched for relevant properties. Matching includes a ±5% budget tolerance for flexibility. Send Matched Properties to Buyer A rich, formatted email is generated automatically. Includes property images, price, location, features, and a “View More Details” link. Email is sent instantly to the buyer. Lead Storage in Airtable Buyer details and preferences are stored in the Buyers table. Lead status is set to New for CRM tracking and follow-up. Sales Team Notification A Slack message is sent to the sales channel with: Buyer details Contact information City and preferred property type Agents can respond immediately to maximize conversion. 🗂 Integrations Used Webhook** – Capture property inquiry submissions Airtable** – Property database and lead CRM Gmail** – Email delivery to buyers Slack** – Real-time sales team alerts n8n Code Nodes** – Dynamic matching logic and email generation 👤 Who can use this? This workflow is ideal for: 🏢 Real estate agencies 🏘 Property brokers 📈 Sales-driven real estate teams 🚀 PropTech startups If your team wants faster lead response and smarter property matching, this automation delivers both. 🚀 Benefits ✅ No manual property searching ✅ Faster response times ✅ Centralised lead tracking ✅ Real-time sales alerts ✅ Better buyer experience

Snyk Vulnerability Automation Workflow with Webhook, Jira, Slack & Airtable This workflow receives vulnerability data(e.g., Snyk, Dependabot or any security scanner) from Snyk through a webhook, standardizes and validates the payload, checks Jira for duplicates using a unique vulnerability key, and either updates an existing Jira issue or creates a new one. It also sends real-time alerts to Slack and stores every new vulnerability in Airtable for reporting and auditing. The workflow ensures fast triage, prevents duplicate Jira tickets and centralizes all data for easy tracking. Quick Start – Implementation Steps Add the n8n Webhook URL to Snyk. Configure Jira, Slack and Airtable credentials in n8n. Adjust severity rules or Jira fields if required. Activate the workflow — vulnerability triage becomes fully automated. What It Does This workflow automates how your team processes vulnerabilities reported by Snyk. When a new vulnerability arrives, the system first normalizes the payload into a clean, consistent format. It then validates required fields such as the vulnerability ID, CVSS score, title and URL. If anything is missing, the workflow instantly sends a Slack alert so the team can review. If the payload is valid, the workflow assigns a severity level and generates a unique “vulnerability key.” This key is used to search Jira for existing issues. If a match is found, the workflow updates the existing Jira ticket and notifies the team. If no match exists, the workflow creates a brand-new Jira issue, sends a Slack alert and also writes the data into Airtable for centralized tracking and analytics. This ensures accurate documentation, avoids duplicates and gives teams visibility through both Jira and Airtable. Who’s It For This workflow is ideal for: DevOps and platform engineering teams Security engineers QA and development teams Companies using Snyk for vulnerability scanning Teams needing automated Jira creation and Airtable reporting Requirements to Use This Workflow To fully use this workflow, you need: An n8n instance (cloud or self-hosted) A Snyk webhook configured to send vulnerability notifications A Jira Software Cloud account A Slack workspace with bot permissions An Airtable base and personal access token Basic understanding of JSON fields How It Works Receive Vulnerability – Snyk posts data to an n8n webhook. Normalize Payload – Converts inconsistent Snyk formats into a standard structure. Validate Required Fields – Missing fields trigger a Slack alert. Assign Severity – CVSS score is mapped to Low/Medium/High/Critical. Generate Vulnerability Key – Used for deduplication (e.g., vuln-SNYK-12345). Check Jira for Matches – Searches by label to detect duplicates. Duplicate Handling – Updates existing Jira issue and sends Slack notification. Create New Issue – If no duplicate exists, creates a new Jira ticket. Store in Airtable – Adds a new vulnerability row for reporting and history. Slack Alerts – Notifies the team of new or updated vulnerabilities. Setup Steps Import the workflow JSON file into n8n. Configure credentials: Jira Slack Airtable Add the generated webhook URL inside your Snyk project settings. Update Jira project ID, issue type, or description fields as needed. Map Airtable fields (Title, CVSS, Severity, URL, Key, etc.). Update Slack channel IDs. Activate the workflow. How To Customize Nodes Customize Severity Rules Modify the node that maps CVSS score ranges: Change thresholds Add custom severity levels Map severity to Jira priority Customize Jira Fields Inside the Create or Update Jira Issue nodes, you can modify: Project ID Issue type Labels Description template Assigned user Customize Slack Messages Adjust Slack text blocks to: Change formatting Add emojis or styling Mention specific users or teams Send different messages based on severity Customize Airtable Storage Update the Airtable node to: Add new columns Save timestamps Link vulnerabilities to other Airtable tables Store more metadata for reporting Add-Ons (Optional Enhancements) You can extend this workflow with: Auto-close Jira tickets when Snyk marks vulnerabilities as “fixed”. Severity-based Slack routing (e.g., Critical → #security-alerts). Email notifications for high-risk vulnerabilities. Google Sheets or Notion logging for long-term tracking. Weekly summary report generated using OpenAI. Mapping vulnerabilities to microservices or repositories. Automated dashboards using Airtable Interfaces. Use Case Examples Automatic Vulnerability Triage – Instantly logs new Snyk findings into Jira. Duplicate Prevention – Ensures every vulnerability is tracked only once. Slack Alerts – Real-time notifications for new or updated issues. Airtable Reporting – Creates a central, filterable database for analysis. Security Team Automation – Reduces manual reviews and saves time. Troubleshooting Guide | Issue | Possible Cause | Solution | |-----------------------------|--------------------------------------------------|--------------------------------------------------------| | Slack alert not sent | Wrong API credentials or channel ID | Re-check Slack configuration | | Jira issue not created | Incorrect project ID / issue type | Update Jira node details | | Duplicate detection not working | Vulnerability key or label mismatch | Confirm key generation and JQL settings | | Airtable row not added | Wrong base or field mapping | Reconfigure Airtable node | | Webhook not triggered | Snyk not pointing to correct URL | Re-add the n8n webhook in Snyk | | Severity not correct | CVSS parsing error | Check normalization and mapping node | Need Help? If you need help setting up this workflow, customizing the logic, integrating new nodes or adding advanced reporting, feel free to reach out to our n8n automation development team at WeblineIndia. We can help automate with advanced security processes, build dashboards, integrate additional tools or expand the workflow as per your business needs.

Overview This workflow automates the "speed-to-lead" process for insurance agencies. It instantly triggers an AI voice call when a new lead comes in, qualifies their needs via conversation, and automatically generates and emails a personalized insurance proposal (Blueprint) using GPT-4. Who’s it for -Insurance Brokers & Agencies who want to automate the initial outreach and qualification of inbound leads. -Applicable to any type of Insurance (Life, Health, Home, Auto or bundling ) -Sales Teams who want to filter out unqualified leads and receive detailed call summaries for qualified prospects. -Any business willing to have a 24/7 virtual assistant that want to qualify potential customers intent and draft proposals. How it works Lead Ingestion: The workflow starts when a potential client submits an n8n web form (Name, Email, Phone Number). CRM Logging: The lead is immediately created in Airtable . AI Voice Call: The workflow triggers Vapi.ai to call the lead immediately. The AI agent acts as a representative to gather requirements. Analysis & Logic: Once the call ends, Vapi sends the call analysis and transcript back to n8n via a webhook. The workflow checks the "Success Evaluation" and ensures a "Type of Insurance" was identified. Path A: Qualified Lead gets a an insurance blueprint: OpenAI (GPT-4) generates a professional "Insurance Blueprint" email based on the call transcript and client needs (type of insurance the client is seeking). Email Dispatch: The proposal is sent directly to the client via Gmail. CRM Update: The Airtable record is updated to "Qualify" with the call summary. Error Handling: If the email fails to send, a Slack alert is sent to the team with the proposal text for manual follow-up. Path B: Unqualified Lead Notification: The team is alerted via Slack with the reason for disqualification. CRM Update: The Airtable record is updated to "Unqualified." with the call summary. Requirements Vapi.ai Account: For the AI voice telephony (requires a configured Assistant and Phone Number). OpenAI Account: For GPT-4 or any LLM model of your choice analysis used for proposals writing. Make sure to have enough tokens. Airtable Account: For lead management. Gmail Account: To send the proposals. Slack Account: For internal team notifications. How to set up Configure External Services Airtable: Create a base with a table with a name of your choice. Ensure it has the following columns: Name (Single text), Email (Email), Phone number (Phone/Text), Status (Single Select: Qualify, Unqualified), Type of Insurance (Text), and Call summary (Long Text). Vapi: Create an Assistant in Vapi. Give the assistant a system prompt according to what you want it to say during the call. Ensure you enable the "Server URL" in the Vapi dashboard to point to the Production URL of the Post call Webhook node in this workflow. Configure Credentials in n8n Add credentials for Airtable, OpenAI, Gmail, and Slack. In the Vapi call node, use your credentials or add your Vapi Private API Key to the header (Authorization: Bearer <YOUR_KEY>). Update Node Parameters Airtable Nodes: Select your specific Base and Table in both the "Create a record" and "Update record" nodes. Vapi Call Node: Input your assistantId, phoneNumberId in the JSON body with the actual IDs from your Vapi dashboard and change the international dialing code. Slack Nodes: Select the channel where you want notifications sent. How to customize the workflow Change the Persona: Open the Prepare Blueprint (OpenAI) node. Edit the System Message to change the agent's name and Insurance or agency name, tone, or the formatting of the email proposal. Adjust Qualification Logic: Open the Is Qualified? (If) node. You can modify the data Collection by adding more fields to the Form Trigger (e.g., "State," "Age") and map them through to the Airtable nodes and the Vapi assistant prompt context. Switch Communication Channels: Replace the Slack and Gmail nodes with other nodes (e.g., Microsoft Teams, Outlook) depending on your tech stack preferences.

📊 Description Ensure suppliers never miss a follow-up by automating overdue purchase order tracking and scheduling. 📦⏰ This workflow checks Airtable every weekday morning for open POs older than seven days without scheduled follow-ups, generates Google Calendar events, updates Airtable with the follow-up link, and sends notifications to your team via Slack and Gmail. It centralizes supplier management and eliminates manual reminders, helping operations teams stay on top of aging purchase orders and vendor commitments. 📅📣 🔁 What This Template Does 1️⃣ Runs on a weekday schedule (default: 10 AM) to scan Airtable for overdue open POs. 📆 2️⃣ Filters POs with missing follow-up links and older than 7 days. 🔍 3️⃣ Processes each overdue PO one by one. 🔄 4️⃣ Creates a Google Calendar event for each supplier follow-up. 📅 5️⃣ Saves the event link back into Airtable and updates follow-up status to “Pending.” 📝 6️⃣ Sends initial and final Slack notifications with PO details and scheduling links. 💬 7️⃣ Sends a Gmail confirmation email to the assigned supplier or internal team. ✉️ 8️⃣ Ensures all stakeholders have quick access to follow-up links and event details. 🔗 ⭐ Key Benefits ✅ Automates supplier follow-up scheduling with zero manual effort ✅ Prevents overdue purchase orders from being forgotten ✅ Consolidates PO aging logic, event creation, and notifications ✅ Keeps suppliers and internal teams aligned with one workflow ✅ Ensures follow-ups are consistently logged and traceable in Airtable ✅ Improves accountability for purchasing and operations teams 🧩 Features Weekday schedule trigger (cron-based) Airtable “Purchase Orders” table integration Google Calendar event creation with tracking links Airtable record update with follow-up status Slack notifications (initial + final) Gmail email confirmations Batch processing for multiple overdue POs Automated vendor accountability loop 🔐 Requirements Airtable Personal Access Token Google Calendar OAuth2 credentials Slack API token Gmail OAuth2 credentials Airtable table containing: PO ID, Supplier Info, Status, PO Date, Follow-up Link 🎯 Target Audience Procurement & purchasing teams Operations managers handling vendor communication Supply chain coordinators tracking overdue POs Teams using Airtable for purchase order management Businesses that need consistent supplier follow-ups

How it works This workflow automates the entire lifecycle of a service-based client, combining four distinct business flows into a single view: Intake Leads: Receives a webhook from your form builder, validates the data, optionally enriches the email using Clearbit, and creates records in Airtable and Notion. Manage Bookings: Processes scheduling webhooks to update lead status, create Google Calendar events, and send pre-call survey emails. Send Reminders: Runs a daily schedule to scan Airtable for upcoming calls and automatically sends 24h reminder emails to reduce no-shows. Onboard Clients: Reacts to successful payments by marking leads as "Paid," generating a Notion Onboarding Checklist, and sending a Welcome Kit via Email and WhatsApp. Set up steps Configure Credentials: Connect your accounts for Airtable, Notion, Slack, Google Calendar, and GMAIL. (Optional) Add credentials for Clearbit (enrichment) and Twilio (WhatsApp). Customize Emails: Open the four Email Send nodes. Customize the Body Text with your own booking links and survey URLs. Configure Tables & IDs: Update the Airtable nodes with your specific Base and Table names (e.g., tblLeads). Update the Notion nodes with your Database IDs for Projects and Onboarding. Connect Webhooks: Copy the Production URLs from the three Webhook nodes (Lead Intake, Booking, Payment) and paste them into your respective form, calendar, or payment provider settings.

AI Lead Enrichment & Notification System This n8n template automates the lead enrichment process for your business. Once a lead fills out a form, the workflow scrapes their website, provides a summary of their business, and logs everything into a CRM before notifying your team on Slack. Some use cases: "Speed-to-Lead" optimization, lead enrichment, automated prospect research. How it works Ingestion: A lead submits their details (Name, Email, Website) via a form. Intelligent scraping: The workflow scrapes the provided URL. AI Analysis: OpenAI's model (GPT-4o) analyzes the extracted data and determines whether there is enough info or if the workflow needs to scrape the "About Us" page. CRM Sync: The CRM (Airtable) is updated with the enriched data. Notification: An instant Slack notification is sent to the team channel. How to use the workflow Configure the form: Open the trigger form and input the required fields. Setup OpenAI: Ensure that your credentials are connected. Database mapping: Ensure your Airtable base has the following columns: Name, Website, AI Insight, Email, and Date. Slack setup: Specify the desired Slack channel for notifications. Test it out! Open the form, enter sample data (with a real website), and watch the system enrich the lead for you. Requirements OpenAI API Key** (For analyzing website content and generating summaries) Airtable** (For CRM and logging) Slack** (For team notifications)

AI Sales Analyst & Lead Router This n8n template handles the post-call process for your business. It uses the call recording to extract valuable data and handles the prospect based on their budget. Some use cases: Sales follow-ups, auto-qualifying leads based on budget, monetizing low-budget leads, and automatic data entry. How it works Ingestion: When a call recording is uploaded to a specific Google Drive folder, the workflow is triggered. Transcription: OpenAI's model transcribes the call recording. Analysis: The GPT-4o model analyzes the transcript and extracts crucial information. Lead classification: The extracted budget is checked against your defined threshold (e.g., $5,000). Hot leads (Budget > 5k): The workflow logs the data in Airtable (CRM), creates a high-priority task, and instantly alerts the team via a Slack channel. Warm leads (Budget < 5k): The workflow logs the data, creates a low-priority task, and emails the lead, offering a cheaper alternative. Logging: Every execution is logged in Airtable. How to use the workflow Configure Google Drive: Open the Trigger node and select the destination folder for the call recordings. Set your Threshold: Open the If node and set your desired budget (currently set to 5,000). Customize the email: Open the Gmail node in Phase 2B and modify the email according to your own preferences. Database mapping: Ensure that your Airtable base has the following columns: Client Name, Budget, Sentiment, Summary, Date, and Timeline. Test it out! Generate a sample audio file on ElevenLabs and upload it to your Google Drive folder. Requirements Google Drive** (For storing audio recordings) OpenAI API Key** (Access to OpenAI models) Airtable** (For CRM and System Logging) Trello** (For Task Management) Slack** (For Team Notifications) Gmail** (For sending automated emails)

AI Proposal Workflow Overview This workflow turns your sales calls + intake form into a polished, send-ready proposal. It pulls the latest call transcript from Fireflies, generates structured proposal content with Azure OpenAI, builds a proposal in PandaDoc, routes it for Slack approval, and then handles sending, CRM stage updates (Airtable/HubSpot), and automated follow-ups using the PandaDoc audit trail. This workflow is modular. You can replace each major tool: Fireflies** → Gong, Fathom, Wingman, Avoma (any transcript provider) PandaDoc** → DocuSign, Qwilr, Proposify, Google Docs API Slack Approval** → Gmail Approval, MS Teams Approval, Notion DB Approvals Airtable CRM** → HubSpot, Pipedrive, Salesforce, Zoho, Monday Sales CRM Intake Form** → Typeform, Tally, Jotform, HubSpot forms Azure OpenAI** → OpenAI, Anthropic Claude, Mistral, or any LLM connected through an API The core logic stays the same — you only swap the nodes. Who It’s For Agencies & consultants who send similar proposals after every call B2B SaaS / tech teams that want proposals going out within hours Solo operators who want AI to handle most of the draft but keep final control Teams already working out of Slack, wanting approval flows there How It Works Form Trigger (Client Proposal Intake) Client fills a form with: Name, email, website Industry / business context Problem, solution idea, scope Budget, timeline, deliverables Sales Call Intelligence (Fireflies or Gong) Workflow searches transcripts using the client email Fetches the relevant transcript + summary AI Proposal Generator (Azure OpenAI or any LLM) Sets initial variables (draftText, lastFeedback) Sends transcript + form data into LLM Returns structured JSON: introduction client_problem proposed_solution scope_of_work deliverables timeline_breakdown investment next_steps Proposal Creation (PandaDoc, DocuSign, etc.) Creates the proposal document from a template Fills tokens with AI-generated content Inserts pricing table using Budget Slack Approval Loop Slack message is sent to reviewer with: Approve button Request Changes button Optional comment thread for feedback If Approved: Proposal is sent automatically via PandaDoc/DocuSign Slack message to notify proposal has been sent If Changes Requested: Feedback + draft are stored Passed back into the LLM to regenerate New document is created and the Slack approval request is sent again This loop continues until approval happens CRM Update (Airtable / HubSpot) After proposal is sent, Stage → Proposal Sent Follow-Up System (PandaDoc Audit Trail) After a 48-hour wait: Audit trail is fetched If document is not yet signed: Reminder is sent Stage → Reminder Sent Slack message to notify a reminder has been sent If signed: Stage → Document Signed Ideal use cases Sales teams creating tailored proposals at scale Agencies responding quickly to inbound RFPs Freelancers producing polished proposals in minutes RevOps teams standardizing proposal formats SaaS companies automating repetitive proposal creation Requirements n8n (self-hosted or cloud) Transcript provider (Fireflies, Gong, Fathom, etc.) LLM API (Azure OpenAI, OpenAI, Claude, etc.) Proposal tool (PandaDoc, DocuSign, Qwilr) Slack API app for approval flow CRM (Airtable, HubSpot, Pipedrive) Intake form You can now integrate this into your lead workflow and let AI + automation handle proposal drafting, Slack approvals, sending, CRM updates, and follow-ups.

📊 Description Automate your content repurposing workflow by transforming long-form articles, blogs, and newsletters into short, high-signal, AI-ready social media snippets. ✍️🤖 This workflow fetches pending content from Airtable, generates 30-word snippets, data points, and quote-style insights using GPT-4o-mini, and updates the original record with all generated fields. If Facebook is selected as a target platform, the workflow automatically posts the best snippet via the Meta Graph API and logs the result. Perfect for content, marketing, and social media teams scaling daily publishing without manual rewriting. 🚀📣 🔁 What This Template Does 1️⃣ Fetches “pending” long-form content from Airtable. 📥 2️⃣ Processes all records in batches to avoid rate limits. 🔁 3️⃣ Sends full content + metadata to GPT-4o-mini to generate structured snippets. 🤖 4️⃣ Ensures valid JSON output via the structured parser. 📐 5️⃣ Updates Airtable with: — 30-word snippets — data points — quote insights — a recommended primary snippet — timestamps & status 6️⃣ Checks if Facebook is selected as a posting platform. ⚙️ 7️⃣ Automatically publishes the recommended snippet using the Meta Graph API. 📤 8️⃣ Updates Airtable again with post status + response. 📝 9️⃣ Sends a success notification to Slack with full details. 💬 ⭐ Key Benefits ✅ Automates creation of platform-ready social media snippets ✅ Produces AI-friendly, high-signal content that works for LLM discovery ✅ Eliminates manual rewriting for LinkedIn, Facebook, Twitter, Instagram ✅ Automatically posts to Meta if selected — hands-free publishing ✅ Maintains clean, structured content in Airtable for future reuse ✅ Saves time for marketing, growth, and social teams 🧩 Features Airtable integration for content fetch + update GPT-4o-mini AI snippet generation Structured JSON parser for clean, reliable AI output Auto-detection of selected social platforms Facebook Graph API publishing Slack notifications for success Scheduled automation for hands-free daily processing Full audit trail with timestamps 🔐 Requirements Airtable Personal Access Token OpenAI API key (GPT-4o-mini) Facebook Graph API credentials (for auto-posting) Slack API credentials n8n with LangChain nodes enabled 🎯 Target Audience Content marketing teams repurposing long-form content Social media managers publishing daily posts Growth teams optimizing content for AI search engines Agencies producing content at scale for multiple clients

🧠 How it works This workflow turns your website form into a fully automated AI Lead Qualification system. Whenever a new lead submits your form, the workflow: Receives the submission through a Webhook Cleans and normalizes the input fields Uses the AI Agent node to score and qualify the lead Saves all details (including AI analysis) into an Airtable CRM Automatically routes high-quality leads (score ≥ 7) Sends an instant Gmail notification Sends an AI-generated personalized auto-reply back to the lead This gives you a hands-free, intelligent front-door to your business — ensuring you only spend time on high-value opportunities. ⚙️ Set-up steps These steps help users configure the workflow quickly: Create a Webhook trigger – Copy the webhook URL and add it to your form tool (Tally, Typeform, Webflow, etc.). Prepare your Airtable base – Create a "Leads" table with fields for name, email, website, message, lead score, priority, use case, timeline, budget, and AI notes. Add the AI Agent node – Insert the provided System + User prompts – Enable Structured Output – Paste the JSON Schema included in the sticky note inside the workflow. Connect Airtable – Map the original form fields + AI Agent “output” fields to Airtable columns. Set up the Gmail node – Connect your Gmail account – Configure the notification email and auto-reply templates. Configure the IF node – Score ≥ 7 routes to the “Hot Lead” branch – Everything else is captured but not routed. Run a test submission – Verify that the workflow writes to Airtable – Confirm the Gmail notification + auto-reply are delivered – Adjust prompting if needed. All detailed explanations and prompt configurations are included inside the workflow through sticky notes for easy reference.

Automatically detect, classify, and document GitHub API errors using AI. This workflow connects GitHub, OpenAI (GPT-4o), Airtable, Notion, and Slack to build a real-time, searchable API error knowledge base — helping engineering and support teams respond faster, stay aligned, and maintain clean documentation. ⚙️📘💬 🚀 What This Template Does 1️⃣ Triggers on new or updated GitHub issues (API-related). 🪝 2️⃣ Extracts key fields (title, body, repo, and link). 📄 3️⃣ Classifies issues using OpenAI GPT-4o, identifying error type, category, root cause, and severity. 🤖 4️⃣ Validates & parses AI output into structured JSON format. ✅ 5️⃣ Creates or updates organized FAQ-style entries in Airtable for quick lookup. 🗂️ 6️⃣ Logs detailed entries into Notion, maintaining an ongoing issue knowledge base. 📘 7️⃣ Notifies the right Slack team channel (DevOps, Backend, API, Support) with concise summaries. 💬 8️⃣ Tracks & prevents duplicates, keeping your error catalog clean and auditable. 🔄 💡 Key Benefits ✅ Converts unstructured GitHub issues into AI-analyzed documentation ✅ Centralizes API error intelligence across teams ✅ Reduces time-to-resolution for recurring issues ✅ Maintains synchronized records in Airtable & Notion ✅ Keeps DevOps and Support instantly informed through Slack alerts ✅ Fully automated, scalable, and low-cost using GPT-4o ⚙️ Features Real-time GitHub trigger for API or backend issues GPT-4o-based AI classification (error type, cause, severity, confidence) Smart duplicate prevention logic Bi-directional sync to Airtable + Notion Slack alerts with contextual AI insights Modular design — easy to extend with Jira, Teams, or email integrations 🧰 Requirements GitHub OAuth2 credentials OpenAI API key (GPT-4o recommended) Airtable Base & Table IDs (with fields like Error Code, Category, Severity, Root Cause) Notion integration with database access Slack Bot token with chat:write scope 👥 Target Audience Engineering & DevOps teams managing APIs Customer support & SRE teams maintaining FAQs Product managers tracking recurring API issues SaaS orgs automating documentation & error visibility 🪜 Step-by-Step Setup Instructions 1️⃣ Connect your GitHub account and enable the “issues” webhook event. 2️⃣ Add OpenAI credentials (GPT-4o model for classification). 3️⃣ Create an Airtable base with fields: Error Code, Category, Root Cause, Severity, Confidence. 4️⃣ Configure your Notion database with matching schema and access. 5️⃣ Set up Slack credentials and choose your alert channels. 6️⃣ Test with a sample GitHub issue to validate AI classification. 7️⃣ Enable the workflow — enjoy continuous AI-powered issue documentation!

📘 Description: This workflow automates the Developer Q&A Classification and Documentation process using Slack, Azure OpenAI GPT-4o, Notion, Airtable, and Google Sheets. Whenever a new message is posted in a specific Slack channel, the workflow automatically: Captures and validates the message data Uses GPT-4o (Azure OpenAI) to check if the question matches any existing internal FAQs Logs answered questions into Notion as new FAQ entries Sends unanswered ones to Airtable for human follow-up Records any workflow or API errors into Google Sheets This ensures that every developer query is instantly categorized, documented, and tracked, turning daily Slack discussions into a continuously improving knowledge base. ⚙️ What This Workflow Does (Step-by-Step) 🟢 Slack Channel Trigger – Developer Q&A Triggers the workflow whenever a new message is posted in a specific Slack channel. Captures message text, user ID, timestamp, and channel info. 🧩 Validate Slack Message Payload (IF Node) Ensures the incoming message payload contains valid user and text data. ✅ True Path → Continues to extract and process the message ❌ False Path → Logs error to Google Sheets 💻 Extract Question Metadata (JavaScript) Cleans and structures the Slack message into a standardized JSON format — removing unnecessary characters and preparing a clean “question object” for AI processing. 🧠 Classify Developer Question (AI) (Powered by Azure OpenAI GPT-4o) Uses GPT-4o to semantically compare the question with an internal FAQ dataset. If a match is found → Marks as answered and generates a canonical response If not → Flags it as unanswered 🧾 Parse AI JSON Output (Code Node) Converts GPT-4o’s text output into structured JSON so that workflow logic can reference fields like status, answer_quality, and canonical_answer. ⚖️ Check If Question Was Answered (IF Node) If status == "answered", the question is routed to Notion for documentation; otherwise, it’s logged in Airtable for review. 📘 Save Answered Question to Notion FAQ Creates a new Notion page under the “FAQ” database containing the question, AI’s canonical answer, and answer quality rating — automatically building a self-updating internal FAQ. 📋 Log Unanswered Question to Airtable Adds unresolved or new questions into Airtable for manual review by the developer support team. These records later feed back into the FAQ training loop. 🚨 Log Workflow Errors to Google Sheets Any missing payloads, parsing errors, or failed integrations are logged in Google Sheets (error log sheet) for transparent tracking and debugging. 🧩 Prerequisites: Slack API credentials (for message trigger) Azure OpenAI GPT-4o API credentials Notion API connection (for FAQ database) Airtable API credentials (for unresolved questions) Google Sheets OAuth connection (for error logging) 💡 Key Benefits: ✅ Automates Slack Q&A classification ✅ Builds and updates internal FAQs with zero manual input ✅ Ensures all developer queries are tracked ✅ Reduces redundant questions in Slack ✅ Maintains transparency with error logs 👥 Perfect For: Engineering or support teams using Slack for developer communication Organizations maintaining internal FAQs in Notion Teams wanting to automatically capture and reuse knowledge from real developer interactions

AI Customer Support Triage with Gmail, OpenAI, Airtable & Slack How it Works This workflow monitors your Gmail support inbox every minute, automatically sending each unread email to OpenAI for intelligent analysis. The AI evaluates sentiment (Positive/Neutral/Negative/Critical), urgency level (Low/Medium/High/Critical), categorizes requests (Technical/Billing/Feature Request/Bug Report/General), extracts key issues, and generates professional response templates. The system calculates a priority score (0-110) by combining urgency and sentiment weights, then routes tickets accordingly. Critical issues trigger immediate Slack alerts with full context and 30-minute SLA reminders, while routine tickets post to standard monitoring channels. Every ticket logs to Airtable with complete analysis and thread tracking, then updates a Google Sheets dashboard for real-time analytics. A secondary AI pass generates strategic insights (trend identification, risk assessment, actionable recommendations) and stores them back in Airtable. The entire process takes seconds from email arrival to team notification, eliminating manual triage and ensuring critical issues get immediate attention. Who is this for? Customer support teams needing automated prioritization for high email volumes SaaS companies tracking support metrics and response times Startups with lean teams requiring intelligent ticket routing E-commerce businesses managing technical, billing, and return inquiries Support managers needing data-driven insights into customer pain points Setup Steps Setup time:** 20-30 minutes Requirements:** Gmail, OpenAI API key, Airtable account, Google Sheets, Slack workspace Monitor Support Emails: Connect Gmail via OAuth2, configure INBOX monitoring for unread emails AI Analysis Engine: Add OpenAI API key, system prompt pre-configured for support analysis Parse & Enrich Data: JavaScript code automatically calculates priority scores (no changes needed) Route by Urgency: Configure routing rules for critical vs routine tickets Slack Alerts: Create Slack app, get bot token and channel IDs, replace placeholders in nodes Airtable Database: Create base with "tblSupportTickets" table, add API key and Base ID (replace appXXXXXXXXXXXXXX) Google Sheets Dashboard: Create spreadsheet, enable Sheets API, add OAuth2 credentials, replace Sheet ID (1XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX) Generate Insights: Second OpenAI call analyzes patterns, stores insights in Airtable Test: Send test email, verify Slack alerts, check Airtable/Sheets data logging Customization Guidance Priority Scoring:** Adjust urgency weight (25) and sentiment weight (10) in Code node to match your SLA requirements Categories:** Modify AI system prompt to add industry-specific categories (e.g., healthcare: appointments, prescriptions) Routing Rules:** Add paths for High urgency, VIP customers, or specific categories Auto-Responses:** Insert Gmail send node after routine tickets for automatic acknowledgment emails Multi-Language:** Add Google Translate node for non-English support VIP Detection:** Query CRM APIs or match email domains to flag enterprise customers Team Assignment:** Route different categories to dedicated Slack channels by department Cost Optimization:** Use GPT-3.5 (~$0.001/email) instead of GPT-4, self-host n8n for unlimited executions Once configured, this workflow operates as your intelligent support triage layer—analyzing every email instantly, routing urgent issues to the right team, maintaining comprehensive analytics, and generating strategic insights to improve support operations. Built by Daniel Shashko Connect on LinkedIn

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

🔐 n8n Workflow: Role-Based Access Control (RBAC) for Telegram Automations This n8n workflow lets you control access to your internal Telegram bots and automation systems based on user roles and departments. It ensures that only authorized team members — defined in your employee database — can interact with specific parts of your workflow. Perfect for agencies, internal tools, or multi-team organizations where permissions differ across roles (e.g., Marketing, Sales, Administration). 📌 Section 1: Trigger & Input ⚡ Receive Message (Telegram Trigger) Purpose: Captures incoming messages from users interacting with your Telegram bot. How it works: When a user sends any message to the bot, the workflow retrieves their Telegram username and triggers the process. Benefit: Provides a secure and instant entry point for validating user identity before running any internal logic. 📌 Section 2: Role Lookup 📋 Employee Database (Data Table Node) Purpose: Fetches user details such as Position and Type from your internal employee table. Structure Example: UserName===Position===Type User_1===Marketing===SEO User_2===Administration===Manager User_3===Marketing===Target Benefit: Centralized employee management — you can update access levels (roles or departments) directly in the data table without editing the workflow. 📌 Section 3: Position & Role Check 🧩 Choose Position (Switch Node) Purpose: Determines the user’s department or role level (e.g., Marketing, Sales, Administration). 🧩 Check Role Type (Switch Node) Purpose: Performs a second-level check — filters users by Type (e.g., SEO, SMM, Target). Logic: Marketing → SEO → Send to SEO workflow branch Marketing → Target → Send to Ads branch Administration → Manager → Grant full access Sales → Employee → Limited access Benefit: Allows multi-level, role-based logic with different automation paths for each team or position. 📌 Section 4: Action Routing 💬 No Operation Nodes (Placeholders) Purpose: Represent different action branches — each can later be replaced with the logic specific to that department. Examples: “Target” branch → connect to ad performance automation “SEO” branch → connect to Google Search Console reports “Sales” branch → connect to CRM updates Benefit: A flexible access framework — ready to integrate with any process per department. 📊 Workflow Overview Table Section Node Name Purpose Trigger Telegram Trigger Captures user messages Lookup Employee Database Fetches user position and type Check Choose Position / Role Switch Defines access path based on role Routing No Operation Nodes Separate workflows per department 🎯 Key Benefits 🔐 Granular Access Control: Multi-level permission logic (Position + Role). ⚙️ Dynamic Role Management: Update access directly in your data table — no redeployment needed. 🧱 Modular Design: Add or replace department branches without affecting core logic. 🚀 Scalable Foundation: Perfect base for enterprise-grade permission systems or multi-team bots. 📈 Cross-Platform Ready: Can be adapted for Slack, Discord, or internal chat tools.