Automated Multi-Factor Supplier Risk Scoring and Alerting - n8n Workflow

• Procurement Managers and Directors seeking to automate due diligence and risk monitoring.
• Supply Chain Analysts needing real-time, multi-factor supplier risk scores.
• Organizations requiring high-availability, automated risk-alerting solutions.
• Users looking for advanced n8n templates utilizing complex logic and external services.

Supply chain resilience is critical. Manually monitoring financial health (like D&B data), operational performance, and geopolitical news for every supplier is resource-intensive and often delayed. This robust n8n workflow solves this by running a comprehensive, multi-factor assessment daily. It integrates internal operational data (Postgres) with external financial (D&B) and reputational (NewsAPI) information. The centralized calculation logic determines a risk score, automatically applying criticality multipliers and instantly sending priority alerts using the Gmail n8n node to the relevant stakeholders. This highly customizable n8n templates solution ensures timely intervention and proactive risk mitigation.

This automation initiates daily with an n8n trigger and executes the following steps:

1. Initiation: The Schedule n8n trigger runs every day at 6:00 AM.


2. Configuration: The Risk Settings n8n node defines the critical thresholds (e.g., High Risk > 60) and the email addresses for the Procurement and Risk Management teams.


3. Data Collection: The workflow fetches a list of 'active' suppliers from the PostgreSQL database. For each supplier, it executes three parallel requests:

1. Scoring Engine: The custom Code n8n node aggregates all collected data. It applies weighted scoring logic (35% financial, 30% operational, 15% news sentiment, 10% geopolitical, 10% criticality level) to derive the final riskscore and assign a risklevel (low, medium, high, critical).


2. Alerting Flow: A series of If n8n node filters direct the flow based on the calculated risk level:

1. Tracking: Regardless of the alert level, the result is logged using the Google Sheets n8n node for audit and historical tracking, completing the comprehensive n8n workflow.

1. Import: Import this n8n workflow JSON into your n8n instance.


2. Credentials Setup: You will need to configure credentials for the following services:

1. Customization: Edit the 'Risk Settings' n8n node to define your specific risk thresholds and recipient emails (procurementEmail, riskManagerEmail). Update the Google Sheets n8n node with your specific Document ID and Sheet Name for logging.


2. Activate: Save and activate the n8n workflow. It will automatically run daily based on the schedule n8n trigger.

This advanced n8n workflow utilizes several key nodes:

Daily Risk Assessment (Schedule Trigger n8n trigger): Sets the automation to run daily at 6:00 AM, ensuring consistent monitoring.
Risk Settings (Set n8n node): Centralizes configuration, defining customizable risk score thresholds (31, 61, 81) and stakeholder email addresses using JSON parameters.
Get Active Suppliers & Get Performance Data (PostgreSQL n8n node): Performs SQL queries to retrieve base supplier data and historical operational metrics (delivery, quality) necessary for the scoring calculation.
Get Financial Health & Monitor News & Events (HTTP Request n8n node): Integrates external data sources (D&B and NewsAPI) via API calls. Dynamic expressions use supplier IDs and names to fetch specific, timely data for risk calculation.
Calculate Risk Score (Code n8n node): The analytical heart of this n8n workflow. It executes a complex JavaScript algorithm to combine five risk factors (financial, operational, news, geopolitical, criticality) into a single, weighted riskscore and determines the appropriate risklevel.
Filter Critical Risks / High Risks / Medium Risks (If n8n node): Provides conditional routing, directing the workflow to the appropriate notification path based on the score calculated by the previous n8n node.

• Send Critical Alert / High Risk Alert / Medium Risk Alert (Gmail n8n node): Sends tiered, highly visual HTML emails to different recipients based on the severity. Critical alerts contain detailed impact analysis and immediate action items.