Automate supplier risk scoring with D&B, NewsAPI & alerts to Gmail

by Rodrigue Gbadou ✓ · 808 views · created 2025-07-16 · Engineering, AI Summarization

What this workflow does

This workflow has 14 nodes and runs on a schedule (cron expression). Along the way it connects Postgres, Gmail and Google Sheets. It also calls api.newsapi.org over HTTP.

How it runs

Trigger: On a schedule (cron expression).

1. Risk Settings (Edit Fields (Set)): sets or maps fields
2. Get Active Suppliers (Postgres): uses Postgres
3. Get Financial Health (HTTP Request): calls an HTTP API (GET)
4. Monitor News & Events (HTTP Request): calls api.newsapi.org (GET)
5. Get Performance Data (Postgres): uses Postgres
6. Calculate Risk Score (Code): runs custom JavaScript code
7. Filter Critical Risks (If): checks a condition and branches into true / false
8. Filter High Risks (If): checks a condition and branches into true / false
9. Filter Medium Risks (If): checks a condition and branches into true / false
10. Track Risk Assessment (Google Sheets): append row (sheet)

…plus 3 more steps. See the full node list below.

Services it uses

PostgresGmailGoogle Sheets

HTTP calls to: api.newsapi.org

Before you upgrade to n8n 3.0

Nodes used (8)

• Schedule Triggern8n-nodes-base.scheduleTrigger
• Edit Fields (Set)n8n-nodes-base.set
• Postgresn8n-nodes-base.postgres
• HTTP Requestn8n-nodes-base.httpRequest
• Coden8n-nodes-base.code
• Ifn8n-nodes-base.if
• Gmailn8n-nodes-base.gmail
• Google Sheetsn8n-nodes-base.googleSheets

From the author

How it works - Continuous monitoring: Real-time surveillance of supplier performance, financial health, and operational status - Risk scoring: AI-powered assessment of supplier risks across multiple dimensions (financial, operational, geopolitical) -…

View the original on n8n.io → Check your own copy