by Samir Saci
Tags: Logistics, Supply Chain, OTIF, KPI Tracking, Performance Management, AI Analysis, Notion Context Hi! I'm Samir, Supply Chain Engineer, Data Scientist based in Paris, and founder of LogiGreen. > Let's use AI with n8n to automate supply chain performance tracking! Tracking On-Time In-Full (OTIF) delivery performance is critical for retail logistics, but manually compiling data, computing KPIs, and writing analysis reports is time-consuming and error-prone. This workflow automates the entire process: collecting shipment data, aggregating weekly KPIs, generating AI powered performance analyses, and pushing everything into a Notion dashboard. For business inquiries, you can find me on LinkedIn Demo of the workflow The workflow collects shipment records from your TMS and WMS, then aggregates them by week. An AI Agent analyses each week's performance and generates summary cards in Notion. Weekly OTIF data is automatically pushed to a Notion database for tracking and visualisation. Who is this template for? This template is ideal for logistics and supply chain teams looking to automate KPI reporting: Supply chain managers** tracking delivery performance across carriers and warehouses Logistics analysts** who need automated weekly OTIF scorecards Operations teams** looking to leverage AI for performance insights Tutorial A complete tutorial (with explanations of every node) is available on YouTube: What does this workflow do? This automation uses Notion databases and OpenAI AI Agents to build a complete OTIF scorecard: The workflow is triggered manually (or on a schedule). Shipment data is collected from your TMS and WMS systems. Records are aggregated by week, computing On-Time rate, In-Full rate, and OTIF rate. An AI Agent analyses each week's performance and identifies trends, issues, and recommendations. Weekly KPI rows are pushed to the Daily OTIF Summary database in Notion. Per-week AI analysis cards are created in the AI Generated Analysis database. A second AI Agent generates a global performance summary across all weeks. The global summary card is updated in Notion with the overall analysis. Next Steps Before running the workflow, follow the sticky notes and configure: Connect your Notion API credentials and update the database IDs in all Notion nodes Add your OpenAI API Key to the AI Agent nodes Update the "Collect Shipments from TMS & WMS" node with your actual data source (API, Google Sheets, or database) Adjust the AI prompts to match your specific KPI thresholds and business context Set up the Notion template with the two required databases: "Daily OTIF Summary" and "AI Generated Analysis" Duplicate the Notion template to your workspace before connecting the workflow (Optional) Change the trigger from manual to a scheduled cron for automated weekly reporting Submitted: 8 March 2026 Template designed with n8n version 2.10.12
by WeblineIndia
Daily WooCommerce Sales Snapshot to Slack with Google Sheets Logging This workflow automatically collects WooCommerce sales data every day, calculates key sales metrics, sends a clean summary to Slack and logs the same data into Google Sheets for historical tracking. It helps teams stay informed about daily performance without manually checking dashboards or reports. Quick Implementation Steps (Get Started Fast) Import the workflow JSON into n8n. Connect your WooCommerce, Slack and Google Sheets credentials. Verify the Slack channel and Google Sheet selection. Activate the workflow. Receive daily sales updates automatically. What It Does This workflow runs on a daily schedule and fetches all recent orders from a WooCommerce store. It filters the orders to include only paid ones (Processing and Completed) and further narrows them down to those created within the last 24 hours. Using separate Code nodes, the workflow calculates essential sales metrics such as total revenue, number of orders, average order value (AOV) and the top-selling products. These metrics are merged into a single structured object for consistent downstream use. Finally, the workflow sends a formatted sales summary to a Slack channel for quick visibility and appends the same data as a row in Google Sheets. This creates a reliable daily log that can be used for trend analysis and reporting. Who’s It For WooCommerce store owners Sales and operations teams Marketing teams tracking daily performance Business managers who prefer Slack updates Analysts maintaining sales history in spreadsheets Requirements to Use This Workflow Active WooCommerce store with API access n8n instance (self-hosted or cloud) Slack workspace with permission to post messages Google Sheets document for logging data Valid credentials configured in n8n for: WooCommerce Slack Google Sheets How It Works A Schedule Trigger runs the workflow once per day. Orders are fetched from WooCommerce. Only paid orders (Processing / Completed) are considered. Orders from the last 24 hours are filtered. Sales metrics are calculated: Total Revenue Order Count Average Order Value (AOV) Top Selling Products Metrics are merged into a single object. A formatted summary is: Sent to Slack Appended or updated in Google Sheets How To Set Up Configure the Schedule Trigger time. Add WooCommerce credentials. Review paid order filtering logic. Select Slack channel. Select Google Sheet and worksheet. Test the workflow. Activate it. How To Customize Nodes Change schedule time in the Schedule Trigger. Modify order statuses in the Filter Paid Orders node. Adjust the 24-hour window in the Code node. Increase or decrease top products count. Customize Slack message formatting. Add or remove Google Sheets columns. Add-ons (Optional Enhancements) Weekly or monthly summaries Revenue comparison (day-over-day / week-over-week) Revenue threshold alerts Multiple Slack channels Dashboard integrations from Google Sheets Use Case Examples Daily sales snapshot for store owners Morning updates for sales teams Automated sales logging for finance teams Performance tracking without dashboards Remote team visibility via Slack Many more variations are possible depending on business needs. Troubleshooting Guide | Issue | Possible Cause | Solution | |------|---------------|----------| | Slack message not received | Slack credentials or channel issue | Verify Slack API and channel | | Google Sheet not updating | Incorrect sheet or mapping | Recheck sheet selection | | Orders missing | Order status filter too strict | Update filter conditions | | Revenue incorrect | Time filter issue | Verify last 24-hour logic | | Workflow not running | Workflow inactive | Activate workflow | Need Help? If you need help setting up, customizing or extending this workflow, our n8n automation experts at WeblineIndia can assist. We specialize in: n8n automation workflows Business process automation Custom integrations and reporting Contact WeblineIndia to build reliable and scalable automation tailored to your business.
by WeblineIndia
Landing Page Lead Intake via Webhook to Zoho CRM, Jira Task & Slack Alerts This n8n workflow captures lead data from a landing-page webhook, validates required fields and then processes the lead by creating a Zoho CRM Lead, generating a Jira Task and notifying a Slack channel. If required fields are missing, the workflow skips CRM + Jira creation and instead notifies Slack with available lead details. ⚡ Quick Start: 5-Step Fast Implementation Import this workflow JSON into n8n. Configure credentials: Zoho CRM OAuth2, Jira Cloud, Slack OAuth2. Copy the webhook URL and connect it to your landing page form. Ensure your form sends: first_name, last_name, company_name, email, phone, title, description, referrer. Activate workflow → send test POST → verify Zoho, Jira & Slack outputs. What It Does This workflow works as an automated lead pipeline. When the landing page sends JSON to the webhook, the workflow checks if last_name and company_name are present. If both fields exist, it proceeds to create a Zoho CRM lead, then generates a Jira task using the same data. A detailed Slack message is then posted with all lead information and the newly created Jira task ID. If any of the required fields are missing, the workflow does not create CRM or Jira entries. Instead, it sends a Slack notification with available details so teams can intervene manually without incorrect CRM data entry. Who’s It For Marketing teams capturing leads from landing pages. Sales teams using CRM and Jira for task tracking. Internal teams who want Slack alerts for new leads. Agencies and startups handling inbound lead flow. Anyone requiring automated lead routing without manual work. Prerequisites n8n instance Zoho CRM OAuth2 credential Jira Software Cloud credential Slack OAuth2 credential A landing page that sends POST JSON payloads Required payload fields: first_name last_name company_name email phone title description referrer How to Use & Setup Step 1: Import Workflow Go to n8n → Workflows → Import workflow JSON. Step 2: Configure Credentials Add your credentials in: Zoho CRM (Create a lead) Jira Software Cloud (Create an issue) Slack (Send a message & Send a message1) Step 3: Connect Webhook Copy the Webhook URL from the Webhook node and configure your landing page to send POST JSON to it. Step 4: Field Validation The If node checks: last_name exists company_name exists If both exist → CRM + Jira + Slack If missing → Slack-only alert Step 5: Test Workflow Send sample JSON using your landing page or Postman. Check Zoho CRM, Jira task creation, and Slack messages. Step 6: Activate Workflow Enable workflow after verification. How To Customize Nodes? Webhook Node Add/remove expected fields Modify payload structure If Node Add more validations Switch to OR logic Zoho CRM Lead Node Add additional fields Modify CRM field mapping Jira Task Node Change project, issue type, priority, assignee Modify description template Slack Nodes Change channel Rewrite notification messages Add Slack formatting Add-ons (Optional Enhancements) Email notification to lead Google Sheets entry logging Duplicate lead detection Lead scoring system CRM sync extensions (Contact, Account, etc.) Use Case Examples Marketing campaign lead automation. Instant Slack alerts for new inbound leads. Customer inquiry → Jira task workflow. Data quality enforcement (avoid CRM pollution). Trigger for larger lead qualification workflow. (And many more possible use cases.) Troubleshooting Guide | Issue | Possible Cause | Solution | |-------|----------------|----------| | Webhook not triggered | Wrong webhook URL or wrong HTTP method | Check URL and ensure POST is used | | Zoho lead not created | Invalid credentials or missing required mapping | Reconnect Zoho credentials and verify fields | | Jira task not created | Wrong project/issue/assignee config | Verify project, issue type & permissions | | Slack message not sent | Token expired or incorrect channel ID | Re-authenticate Slack and confirm channel | | Workflow stops at If node | last_name or company_name missing | Update landing page form to include fields | | Slack message missing values | Wrong field names in payload | Ensure JSON fields match expected structure | Need Help? For assistance with setup, customization or building enhanced automation workflows, our n8n team at WeblineIndia can help you build & optimize your automations. We support: Workflow customization Add-on development Integration with other CRMs or apps Advanced automation logic
by Dhruv from Saleshandy
Automatically import new user signups from any database, filter by signup date, and enroll users into your Saleshandy email sequence for immediate engagement. Activity is logged to a spreadsheet (e.g., Google Sheets) for tracking and analytics. Fully configurable, no hardcoded values. Prerequisites A database with a users table (fields: id, full_name, email, created_at) Saleshandy account with API key and an active sequence. Spreadsheet (e.g., Google Sheets) with columns: ID, Name, Email, Created_at Configured OAuth/API credentials for each service How It Works Fetches new signups from your database within your desired date range (e.g., daily or weekly). Splits user names and formats user data as needed. Adds each user to your Saleshandy sequence using their name and email. Logs every processed record in your spreadsheet for further tracking and analytics. Runs automatically on your defined schedule (example: daily trigger). Set Up Steps Estimated time: 10–20 minutes Collect your database and Saleshandy access credentials, and spreadsheet info. Edit database node(s) to include your connection and correct date filter. Set your Saleshandy API key and target sequence ID. Enter your spreadsheet link or ID and authenticate as needed. Test the workflow with a small user batch before scheduling it for routine runs. Check sticky notes by each workflow node for details and best practices. Requirements Database connection credentials and access Saleshandy API key and sequence ID Google Sheets (or alternative) setup credentials Customisation Tips Edit the date filter to adjust the range (last day, week, month, or custom) Add error-handling nodes to catch issues with API calls or data Set up notifications (email, Slack, etc.) for process success/failure Rename nodes to reflect your business logic or steps Replace the manual trigger with a webhook or scheduled cron if desired Configure workflow variables for all credentials and IDs—avoid hardcoding
by Jitesh Dugar
Turn your best 5-star reviews into a daily stream of branded social proof content -- fully automated. This workflow pulls the oldest unposted 5-star review from Google Sheets, generates a custom quote card using the hcti.io HTML-to-image API, uploads it via Upload to URL to get a stable public CDN link, and publishes it directly to Instagram with a formatted caption. The source row is updated to prevent duplicate posts and the team is notified on Slack. What This Workflow Does Review Dispatch Automation Schedule Trigger** -- fires daily at 9 AM. Adjust the cron expression for any cadence (twice weekly, every other day, etc.) Google Sheets -- Fetch Review** -- reads the Reviews sheet filtering for Rating = 5 and Posted = FALSE, sorted by Submitted At ascending for FIFO queue dispatch. Fetches exactly one row per run. IF -- Has Valid Review** -- exits the workflow cleanly on the false branch if no unposted reviews remain. No errors, no failed executions. Dynamic Quote Card Generation Code -- Prepare Fields** -- cleans the raw sheet row: truncates review text to card-safe length, formats the star rating as a count, builds the full Instagram caption with attribution line and hashtag block (max 2200 characters). Set -- Assemble HTML Card** -- constructs a 1080x1080px HTML/CSS quote card template using n8n expressions that reference prepared text fields and env var brand colors. HTML is built in a Set node rather than a Code node to avoid Web Application Firewall false positives on template submission. HTTP -- hcti.io** -- sends the HTML string to the hcti.io API (HTML/CSS to Image) which renders it as a PNG and returns an image URL. Free tier covers 100 renders per month. CDN Bridge via Upload to URL Upload to URL** -- mandatory step. Instagram Graph API requires a direct public HTTPS image URL and rejects binary payloads and base64 strings. This node downloads the rendered PNG from hcti.io and re-uploads it to a CDN, returning a stable public URL Instagram can access. Code -- Merge Fields** -- combines the CDN URL from Upload to URL with the caption and review metadata from the earlier Code node using cross-node reference. Instagram Two-Step Publish Flow HTTP -- IG Create Media Container** -- Step 1 of Instagram publishing. POSTs the CDN image URL and caption to /v19.0/{ig_user_id}/media. Returns a container_id that Instagram uses to stage and validate the image. Wait 6s** -- processing buffer to ensure Instagram completes async validation before the publish call. HTTP -- IG Publish Container** -- Step 2. Calls /media_publish with the container_id. Returns the live Instagram Post ID confirming the post is on the feed. Logging and Notification Google Sheets -- Mark as Posted** -- updates the source row: sets Posted = TRUE and writes back the Post ID and timestamp. Prevents the same review from being picked up on the next scheduled run. Slack -- Notify Team** -- sends reviewer name, a 100-character review snippet, the Post ID, and the CDN card URL so the team can verify what went live. Key Features Queue-based dispatch** -- reviews post in submission order (FIFO). Oldest unposted 5-star review goes first on every run, keeping the feed chronologically authentic. WAF-safe card assembly** -- the HTML quote card is built in a Set node using n8n expressions rather than as a raw string in a Code node. This avoids Cloudflare WAF false positives during template submission. Mandatory CDN bridge** -- Upload to URL is a required step, not optional. Instagram's API will reject any image that is not a direct public HTTPS URL, including hcti.io's own image URLs in some configurations. Duplicate-safe** -- the Google Sheets update node writes Posted = TRUE immediately after publish. The same review can never be re-queued. Source-agnostic** -- works with Google Reviews, Trustpilot, Capterra, or any form tool (Typeform, Tally, Jotform) that appends rows to a Google Sheet. Fully customizable card design** -- background color, text color, and accent color are all controlled by environment variables. No code changes needed to rebrand. What You Will Need Credentials Google Sheets OAuth2** -- connected to your Reviews spreadsheet hcti.io Basic Auth** -- user ID and API key from hcti.io (free tier available at hcti.io) Upload to URL** -- credentials configured in n8n Instagram Graph API** -- Business or Creator account access token Slack OAuth2** -- for team notifications Google Sheets Columns Required Reviewer Name -- Review Text -- Rating -- Source -- Posted -- Submitted At -- Instagram Post ID -- Posted At -- Card Image URL Perfect For SaaS companies** -- automate a daily customer love post from your existing review pipeline E-commerce brands** -- convert 5-star product reviews into social proof content on a consistent schedule Hospitality and restaurants** -- publish verified guest reviews from Google or Tripadvisor automatically Agencies** -- run one instance per client by swapping env vars, with a separate Google Sheet per brand Retail and service brands** -- keep Instagram active with authentic customer voices without any manual effort
by Harshil Agrawal
This workflow allows you to create an affiliate, add metadata, and add the affiliate to a program. Tapfiliate node: This node allows you to create a new affiliate in Tapfiliate. Tapfiliate1 node: This node allows you add metadata to the affiliate that you created previously. Based on your use-case, you may or may not require this node. Tapfiliate2 node: This node allows you to add the affiliate that you created previously to a program. Based on your use-case, you might want to replace the Start node with a trigger node that gets you the information of an affiliate.
by Yaron Been
CSO Agent with Sales Team Description Complete AI-powered sales department with a Chief Sales Officer (CSO) agent orchestrating specialized sales team members for comprehensive revenue operations and sales automation. Overview This n8n workflow creates a comprehensive sales department using AI agents. The CSO agent analyzes sales opportunities and delegates tasks to specialized agents for lead generation, copywriting, proposals, objection handling, demos, and follow-up sequences. Features Strategic CSO agent using OpenAI O3 for complex sales strategy and decision-making Six specialized sales agents powered by GPT-4.1-mini for efficient execution Complete sales funnel coverage from lead generation to deal closure Automated proposal and contract generation Objection handling playbooks and closing techniques Demo preparation and presentation materials Follow-up and nurture campaign automation Team Structure CSO Agent**: Strategic sales oversight and team coordination (O3 model) Lead Generation Specialist**: Prospecting, research, qualification, cold outreach Sales Copywriter**: Pitch decks, proposals, sales collateral, persuasive content Proposal & Contract Specialist**: Deal structuring, terms negotiation, contracts Objection Handler**: Sales objections, responses, closing techniques Demo & Presentation Expert**: Demo scripts, presentation materials, call preparation Follow-up & Nurture Specialist**: Sequence campaigns, relationship building How to Use Import the workflow into your n8n instance Configure OpenAI API credentials for all chat models Deploy the webhook for chat interactions Send sales requests via chat (e.g., "Create a complete B2B SaaS sales campaign") The CSO will analyze and delegate to appropriate specialists Receive comprehensive sales deliverables and strategies Use Cases Complete Sales Funnels**: Lead generation → Qualification → Demo → Proposal → Close Account-Based Sales**: Personalized outreach strategies for enterprise accounts Product Launch Sales**: Go-to-market strategy with full sales enablement Objection Playbooks**: Comprehensive responses to common sales objections Demo Optimization**: Compelling presentations tailored to different audiences Follow-up Automation**: Systematic nurturing to prevent lead loss Proposal Generation**: Professional proposals with terms and pricing Sales Training**: Objection handling and closing technique development Requirements n8n instance with LangChain nodes OpenAI API access (O3 for CSO, GPT-4.1-mini for specialists) Webhook capability for chat interactions Optional: Integration with CRM systems (Salesforce, HubSpot, etc.) Cost Optimization O3 model used only for strategic CSO decisions GPT-4.1-mini provides 90% cost reduction for specialist tasks Parallel processing enables simultaneous agent execution Template library reduces redundant content generation Integration Options Connect to CRM systems for lead management Integrate with email platforms for outreach automation Link to proposal and contract management tools Export to sales enablement platforms Performance Metrics Lead qualification accuracy and conversion rates Proposal win rates and deal velocity Objection handling success rates Demo-to-close conversion optimization Follow-up engagement and response rates Contact & Resources Website**: nofluff.online YouTube**: @YaronBeen LinkedIn**: Yaron Been Tags #SalesOps #LeadGeneration #SalesEnablement #RevenueGrowth #SalesAutomation #B2BSales #SalesStrategy #ProposalAutomation #DemoOptimization #SalesAI #n8n #OpenAI #MultiAgentSystem #SalesTech #RevOps #PipelineAutomation
by Harshil Agrawal
This workflow allows you to send daily weather updates via an SMS message using the Plivo node. Cron node: The Cron node will trigger the workflow daily at 9 AM. OpenWeatherMap node: This node will return data about the current weather in Berlin. To get the weather updates for your city, you can enter the name of your city instead. Plivo node: This node will send an SMS with the weather update, which was sent by the previous node.
by Jonathan
This workflow uses a WooCommerce trigger that will run when a new customer has been added, It will then add the customer to Mautic. To use this workflow you will need to set the credentials to use for the WooCommerce and Mautic nodes.
by Muh Resky Adiansyah
Lead-Routing-Engine-with-SLA-Auto-Reassignment This repository contains an SLA-based lead routing workflow built in n8n, designed to ensure fast lead response, fair sales distribution, and controlled escalation without relying on a full CRM system. The workflow focuses on routing discipline and operational safety, not feature completeness. What This Workflow Does At a high level, the system: 1) Accepts new leads from a generic intake form 2) Assigns leads to sales reps using round-robin 3) Enforces a response SLA 4) Automatically re-routes uncontacted leads 5) Allows sales to mark leads as CONTACTED via Slack 6) Escalates to a manager once if SLA is repeatedly violated Architecture Overview Core Components 1) n8n 2) Google Sheets 3) Slack Primary Data Stores 1) sales_sheet (list of active sales reps) 2) lead_sheet (lead state and routing history) 3) routing_state_sheet (global routing + escalation flags) End-to-End Flow A) Lead Intake & Normalization 1) New leads enter via Form Trigger 2) Phone numbers are normalized to 62xxxxxxxx (Indonesia International Direct Dialing code) 3) A unique lead_id is generated 4) Lead is initialized with: stage = NEW route_count = 0 B) Initial Assignment (Round Robin) 1) Active sales reps are loaded from sales_sheet 2) Global last_index is read from routing_state_sheet 3) Lead is assigned to the next sales rep in sequence 4) Assignment metadata is stored: assigned sales timestamps route count 5) last_index is updated centrally C) Slack Notification (New Lead) 1) Assigned sales receives a Slack message 2) Message includes a “Mark as CONTACTED” button 3) SLA expectation is clearly communicated (1 hour by default) D) SLA Monitoring (Scheduled) 1) A scheduled trigger runs every hour 2) Workflow scans leads where: stage = NEW SLA window has elapsed since last assignment E) SLA Re-Routing For each qualifying lead: 1) Lead is reassigned to the next sales rep 2) Route count is incremented 3) Timestamps are updated 4) Slack notification is sent to the new assignee This process repeats until the lead is contacted or escalated. F) Controlled Escalation If route_count >= threshold (default: 10): 1) Workflow checks escalation state (escalated_<lead_id>) 2) If not escalated yet: Manager is notified via Slack Escalation flag is written 4) If already escalated: No further action is taken Escalation is one-time per lead. G) Stage Update via Slack (CONTACTED) 1) Sales marks a lead as CONTACTED via Slack button 2) Incoming Slack action is validated: Only assigned sales is allowed Only if current stage is NEW 3) Update is idempotent 4) Unauthorized or stale actions receive Slack feedback Once contacted: 1) SLA routing stops 2) Lead remains stable Safeguards Built In 1) Ownership enforcement (Only the assigned sales rep can update a lead) 2) Idempotent stage transitions (Prevents duplicate or stale Slack actions) 3) One-time escalation (No notification spam) 4) Fail-fast behavior (Missing sales data or malformed payloads halt execution early) Google Sheets Schema sales_sheet | Column | Description | |----------|-----------------| | name | Sales name | | email | Optional | | slack_id | Slack user ID | | active | ON / TRUE | lead_sheet | Column | Description | | -------------- | --------------------- | | lead_id | Unique identifier | | name | Lead name | | phone | Normalized phone | | stage | NEW / CONTACTED / QUALIFIED / CLOSED LOST | | assigned_sales | Current owner | | sales_slack_id | Slack ID | | route_count | Number of re-routes | | created_at | Creation timestamp | | assigned_at | Last assignment | | last_routed_at | Last SLA routing | | contacted_at | When marked contacted | routing_state_sheet | key | value | | ------------------- | ---------------------- | | last_index | Last round-robin index | | escalated_<lead_id> | Escalation timestamp | Limitations (By Design) 1) Google Sheets is not transactional 2) SLA enforcement is time-bucketed, not real-time 3) No concurrency locking across parallel runs 4) Slack is required for interaction 5) This is not a CRM, only a routing engine These constraints are explicit and intentional. When This Design Works Well 1) Small to mid-size teams 2) Human-response SLAs (minutes/hours) 3) Teams needing discipline, not heavy tooling 4) CRM-lite or pre-CRM environments When to Migrate Consider migrating if you need: 1) High-volume ingestion 2) Sub-minute SLA guarantees 3) Strong transactional consistency 4) Advanced analytics or forecasting The routing logic itself is portable to SQL or CRM systems.
by Abdullah Alshiekh
🧩 What Problem Does It Solve? Meta’s ad forms often generate unqualified leads from casual scrollers. This workflow uses WhatsApp and AI to automatically verify, qualify, and prioritize real leads — saving time and boosting sales efficiency. 📝 Description This workflow automates lead qualification for businesses using Meta Ads (Facebook/Instagram Lead Ads) to filter out irrelevant leads. It ensures only confirmed prospects enter your CRM by: Collecting new Facebook leads Verifying via WhatsApp confirmation Classifying responses with AI Updating CRM status based on intent When a new Facebook lead arrives: Lead details are extracted (name/phone/email) Zoho CRM is checked for existing contacts WhatsApp confirmation request is sent AI classifies the response (confirmed/declined/human/invalid) CRM status is updated automatically Sales team receives only verified leads 🎯 Key Advantages for Meta Ads ✅ Blocks 60%+ irrelevant leads based on WhatsApp non-response ✅ Reduces fake submissions by requiring active confirmation ✅ Prevents CRM bloat through duplicate checking ✅ Identifies hot leads via instant "human_requested" escalation ✅ Saves sales team hours by auto-declining "no" responses 🛠️ Features Facebook Lead Ads integration via Graph API WhatsApp messaging via Twilio AI response classification (Gemini) Zoho CRM synchronization Duplicate lead prevention Customizable confirmation flow Error-resistant JSON parsing CRM owner assignment Status-based routing 🔧 Requirements Facebook Access Token with ads_management & leads_retrieval permissions Twilio Account with WhatsApp-enabled number Zoho CRM with custom "Status" field Gemini API Key (or alternative LLM) n8n credentials configured for: Twilio (API SID/token) Zoho CRM (OAuth2) Google Gemini (or alternative LLM) ⚙️ Customization Tips 1-Adjust Classification Criteria Modify the AI prompt in Classify Response (AI) node 2-Customize CRM Status Values Update field IDs in Zoho nodes 3-Modify Messaging Edit WhatsApp templates in Send WhatsApp Confirmation 4-Set Owner Assignment Replace owner ID in Prepare Owner ID node 🧠 Use Case Examples Real Estate Agencies: Filter speculative inquiries from serious buyers Medical Clinics: Verify appointment requests before scheduling SAAS Companies: Qualify free trial sign-ups Education Providers: Confirm course interest before counselor assignment Auto Dealerships: Screen test drive requests from tire-kickers If you need help get in touch on Linkedin
by Matthieu
🔧 AI-Powered Cold Call Machine 🎯 Purpose The AI-Powered Cold Call Machine is a fully automated workflow designed to generate qualified leads from LinkedIn, evaluate them using AI-based scoring, identify key decision-makers, and generate personalized cold call scripts. All results are saved to a Google Sheet-based CRM. ⚙️ How It Works 1. Initialization Triggered either manually or via schedule. Pulls configuration from a Google Sheet’s Settings tab (e.g., target product, keywords, company size, API key). 2. Company Search on LinkedIn Uses the Ghost Genius API to search for companies based on cleaned, relevant keywords extracted by OpenAI. Handles pagination, up to 1000 companies per batch. 3. Company Filtering Each company goes through: Data enrichment via Ghost Genius (website, size, followers, etc.). Filtering: Must have a LinkedIn page with a website. Must have 200+ followers. Deduplication: checks if the company already exists in the CRM. 4. AI-Based Company Scoring A specialized AI model scores each company from 0 to 10 based on: Industry fit. Size/location alignment. Potential pain points that match your offering. If the company is new and relevant (score ≥ 7), it is saved in the Companies sheet. 5. Decision Maker Identification Uses Sales Navigator API (via Ghost Genius) to find employees with targeted job titles. For each matching profile: Enriches contact data (title, bio, etc.). Retrieves phone number (if available). Generates a 20-second personalized cold call script using OpenAI, based on company and profile data. Saves all information in the Leads tab of the CRM. If no decision maker is found, the company status is marked accordingly. 📈 Outcome A fully enriched, qualified lead database. Custom cold call scripts** ready to be used by SDRs or founders. Zero manual work – from search to lead generation, everything is automated. 💡 Use Case Perfect for SDRs, founders, or growth marketers looking to scale cold outreach without sacrificing personalization or running into LinkedIn scraping limits.