Qualify and route sales leads with Mistral-Saba AI and MCDM scoring
How It Works
The workflow starts with a scheduled trigger that activates at set intervals. Behavioral data from multiple sources is parsed and sent to the MCDN routing engine, which intelligently assigns leads to the right teams based on predefined rules. AI-powered scoring evaluates each prospect’s potential, ensuring high-quality leads are prioritized. The results are synced to the CRM, and updates are reflected on an analytics dashboard for real-time visibility.
Setup Steps
- Trigger: Define schedule frequency.
- Data Fetch: Configure APIs for all behavioral data sources.
- MCDN Router: Set routing rules, thresholds, and team assignments.
- AI Models: Connect OpenAI/NVIDIA APIs and configure scoring prompts.
- CRM Integration: Enter credentials for Salesforce, HubSpot, or other CRMs.
- Dashboard: Link to analytics tools like Tableau or Google Sheets for reporting.
Prerequisites
API credentials: NVIDIA AI, OpenAI, CRM platform; data sources; spreadsheet/analytics access
Use Cases
Lead prioritization for sales teams; customer segmentation; automated routing;
Customization
Adjust routing rules, add custom scoring models, modify team assignments, expand data sources, integrate additional AI providers
Benefits
Reduces manual lead routing 90%; improves scoring accuracy; accelerates sales cycle; enables data-driven team assignments;
Qualify and Route Sales Leads with AI and MCDM Scoring
This n8n workflow automates the process of qualifying and routing sales leads by leveraging AI for lead scoring and a Multi-Criteria Decision Making (MCDM) approach to assign leads to the most suitable sales representative.
What it does
This workflow streamlines your lead management by:
- Triggering on a Schedule: The workflow starts at predefined intervals, ready to process new leads.
- Fetching Lead Data (Placeholder): An
HTTP Requestnode is included, likely as a placeholder to fetch new lead data from a CRM or lead capture system. - Preparing Lead Data: The
Edit Fields (Set)node transforms and standardizes the incoming lead information, ensuring consistency for the AI agent. - AI-Powered Lead Qualification: An
AI Agentnode (powered by LangChain) uses theOpenRouter Chat Modelto analyze lead details. This agent is equipped with aCode Toolto perform specific logic or calculations, likely related to scoring or evaluating the lead's potential. - Aggregating AI Output: The
Aggregatenode collects and combines the results from the AI agent, preparing them for the next step. - Routing Leads with MCDM: A
Codenode implements a Multi-Criteria Decision Making (MCDM) algorithm to score leads based on various factors (e.g., AI qualification, lead source, company size, etc.) and determine the best sales representative to assign them to. - Conditional Routing: The
Switchnode then uses the MCDM score or assigned representative to route the lead to the appropriate downstream system (e.g., CRM, Slack, email) for further action. - Documentation: A
Sticky Noteprovides additional context or instructions within the workflow.
Prerequisites/Requirements
- n8n Instance: A running n8n instance.
- OpenRouter API Key: Required for the
OpenRouter Chat Modelto access various AI models. - AI Agent Configuration: The
AI Agentnode needs to be configured with the specific prompts and instructions for lead qualification. - Code Tool Logic: The
Code Toolwithin the AI Agent needs to contain the specific logic or API calls it should execute. - MCDM Logic: The
Codenode implementing the MCDM algorithm needs to be customized with your specific scoring criteria and sales representative assignment rules. - Lead Source (HTTP Request): A system or API endpoint from which to fetch new sales leads (e.g., CRM, web form submissions).
- Destination Systems: Access and credentials for the systems where leads will be routed (e.g., CRM, Slack, email service).
Setup/Usage
- Import the Workflow: Download the provided JSON and import it into your n8n instance.
- Configure Credentials:
- Set up your OpenRouter API Key credential for the
OpenRouter Chat Modelnode. - Configure any other necessary credentials for the
HTTP Requestnode (if fetching from an authenticated source) and your final routing destinations.
- Set up your OpenRouter API Key credential for the
- Customize HTTP Request: Update the
HTTP Requestnode (ID: 19) to fetch lead data from your specific source. Adjust the URL, method, headers, and body as needed. - Refine Lead Data Preparation: Modify the
Edit Fields (Set)node (ID: 38) to correctly map and transform the fields from your lead source into a format suitable for the AI agent. - Configure AI Agent:
- Adjust the
AI Agentnode (ID: 1119) with your desired prompts and instructions for qualifying leads. - Customize the
Code Tool(ID: 1197) to perform any specific actions or calculations the AI agent needs to execute.
- Adjust the
- Implement MCDM Logic:
- Edit the
Codenode (ID: 834) to define your Multi-Criteria Decision Making (MCDM) algorithm. This includes:- Identifying the criteria for lead scoring (e.g., industry, company size, budget, AI qualification score).
- Assigning weights to each criterion.
- Defining the logic for calculating a final lead score.
- Implementing the rules for assigning the lead to a specific sales representative based on the score and representative availability/specialization.
- Edit the
- Set up Routing Logic: Configure the
Switchnode (ID: 112) to route leads based on the output of your MCDM logic (e.g., to different CRM pipelines, Slack channels, or email lists). Add the necessary nodes after theSwitchto perform the actual routing actions. - Activate the Workflow: Once configured, activate the workflow. It will run according to the schedule defined in the
Schedule Triggernode.
Related Templates
Send Rapiwa WhatsApp apology & reorder link when Shopify order is cancelled
Who Is This For? This n8n workflow listens for order cancellations in Shopify, extracts relevant customer and order data, checks if the customer’s phone number is registered on WhatsApp via the Rapiwa API, and sends a personalised apology message with a re-order link. It also logs successful and unsuccessful attempts in Google Sheets for tracking. What This Workflow Does Listens for cancelled orders in your Shopify store Extracts customer details and order information Generates a personalised apology message including a reorder link Sends the message to customers via WhatsApp using a messaging API (e.g., Twilio or Rapiwa) Logs the communication results for tracking purposes Key Features Real-Time Cancellation Detection: Automatically triggers when an order is cancelled Personalised Messaging: Includes customer name, order details, and a direct reorder link WhatsApp Integration: Sends messages via WhatsApp for higher engagement Error Handling: Logs successful and failed message deliveries Reorder Link: Provides a convenient link for customers to reorder with one click Requirements n8n instance with nodes: Shopify Trigger, HTTP Request (for WhatsApp API), Code, Google Sheets (optional) Shopify store with API access WhatsApp messaging provider account with API access Valid customer phone numbers stored in Shopify orders How to Use — Step-by-Step Setup Credentials Setup Shopify API: Configure Shopify API credentials in n8n to listen for order cancellations WhatsApp API: Set up WhatsApp messaging credentials (e.g., Twilio, Rapiwa, or any supported provider) Google Sheets (Optional): Configure Google Sheets OAuth2 if you want to log communications Configure Trigger Set the workflow to trigger on Shopify order cancellation events Customize Message Content Modify the apology message template to include your store branding and tone Ensure the reorder link dynamically includes the customer's cancelled order info Set Up WhatsApp Node Connect your WhatsApp API credentials Ensure the phone numbers are formatted correctly for WhatsApp delivery Google Sheet Required Columns You’ll need two Google Sheets (or two tabs in one spreadsheet): A Google Sheet formatted like this ➤ sample The workflow uses a Google Sheet with the following columns to track coupon distribution: | Name | Number | Email | Address | Price | Title | Re-order Link | Validity | Status | | -------------- | ------------- | --------------------------------------------------- | ----------------- | ----------- | -------------- | ------------------------------------------------------------------------------------------------------------------------------------------------ | ------------ | ---------- | | Abdul Mannan | 8801322827799 | contact@spagreen.net | Dhaka, Bangladesh | BDT 1955.00 | Pakistani Lawn | Link 🔗 | unverified | not sent | | Abdul Mannan | 8801322827799 | contact@spagreen.net | Dhaka, Bangladesh | BDT 1955.00 | Pakistani Lawn | Link 🔗 | verified | sent | Important Notes Phone Number Validation: Ensure customer phone numbers are WhatsApp-enabled and formatted properly API Rate Limits: Respect your WhatsApp provider’s API limits to avoid throttling Data Privacy: Always comply with privacy laws when messaging customers Error Handling: Monitor logs regularly to handle failed message deliveries Testing: Test thoroughly with dummy data before activating the workflow live Useful Links Dashboard: https://app.rapiwa.com Official Website: https://rapiwa.com Documentation: https://docs.rapiwa.com Support & Help WhatsApp: Chat on WhatsApp Discord: SpaGreen Community Facebook Group: SpaGreen Support Website: https://spagreen.net Developer Portfolio: Codecanyon SpaGreen
Automate job searching & resume customization with AI, LinkedIn & Google Sheets
🤖 AI-Powered Job Matcher & Resume Customizer Description This advanced workflow automates the entire job search and preparation process, moving beyond simple notifications to provide AI-driven career intelligence. It connects to LinkedIn to scrape fresh job postings, filters against jobs you've already seen, and then uses powerful LLMs (Mistral Large/Small) to perform a detailed resume-to-job match, generate tailored cover letters, and provide concrete resume improvement suggestions. All data is logged into a Google Sheet for comprehensive tracking, and a clean, single Daily Digest Email summarizes the top 5 matches found each day. --- ✨ Key Features Automated Scheduling: Runs daily to find new job postings. Multi-Keyword Search: Uses your main job title and three alternate titles generated by an AI Agent for maximum search coverage. LinkedIn Web Scraping: Pulls new job URLs, details, location, and salary data from LinkedIn Search results. Duplicate Prevention: Uses the Compare Datasets node to ensure only new, unseen jobs are processed against your master Google Sheet. Intelligent Matching (LLM): The workflow performs a detailed job-to-resume comparison, generating: A Match Score (0-100) with evidence for alignment in skills, experience, and domain. A Tailored Cover Letter specific to the job title and company. Actionable Resume Improvement points (e.g., [ADD], [QUANTIFY]) to optimize your resume for the specific role. Centralized Tracking: Saves all job data, match scores, cover letters, and resume suggestions to a Google Sheet. Professional Daily Digest: Sends a single, clean HTML email summarizing the top 5 highest-scoring job matches for easy review. --- 🛠️ Prerequisites n8n Credentials: Google Drive: To download your resume (PDF/DOCX file URL). Google Sheets: To connect to your job tracking sheet. Gmail: To send the daily digest email. Mistral Cloud: For the LLM processing (Resume Breakdown, Job Matching, and Resume Analysis). External Files: A Job Tracking Google Sheet (used as a master database). Your current Resume file (PDF recommended, hosted on Google Drive). Setup Notes: Update the file links (Download Resume node) and Google Sheet details (Get row(s)/Append nodes). Set your personal email address in the Send Digest Email node. Review the LLM prompts to tailor the AI agent's persona and output fields to your exact needs.
Automate peer review assignments with GPT-4-nano, Slack and email notifications
Introduction Automate peer review assignment and grading with AI-powered evaluation. Designed for educators managing collaborative assessments efficiently. How It Works Webhook receives assignments, distributes them, AI generates review rubrics, emails reviewers, collects responses, calculates scores, stores results, emails reports, updates dashboards, and posts analytics to Slack. Workflow Template Webhook → Store Assignment → Distribute → Generate Review Rubric → Notify Slack → Email Reviewers → Prepare Response → Calculate Score → Store Results → Check Status → Generate Report → Email Report → Update Dashboard → Analytics → Post to Slack → Respond to Webhook Workflow Steps Receive & Store: Webhook captures assignments, stores data. Distribute & Generate: Assigns peer reviewers, AI creates rubrics. Notify & Email: Alerts via Slack, sends review requests. Collect & Score: Gathers responses, calculates peer scores. Report & Update: Generates reports, emails results, updates dashboard. Analyze & Alert: Posts analytics to Slack, confirms completion. Setup Instructions Webhook & Storage: Configure endpoint, set up database. AI Configuration: Add OpenAI key, customize rubric prompts. Communication: Connect Gmail, Slack credentials. Dashboard: Link analytics platform, configure metrics. Prerequisites OpenAI API key Gmail account Slack workspace Database or storage system Dashboard tool Use Cases University peer review assignments Corporate training evaluations Research paper assessments Customization Multi-round review cycles Custom scoring algorithms Benefits Eliminates manual distribution Ensures consistent evaluation