Supplier Reliability Scoring n8n Workflow: Claude + Sheets + SendGrid

Score supplier reliability automatically—then escalate the risky ones

This Supplier Reliability Scoring n8n Workflow takes supplier incident reports submitted to a webhook, uses Anthropic Claude to classify and recommend actions, calculates an explainable 0–100 reliability score, logs every incident to Google Sheets, and sends escalation emails via SendGrid for high-risk suppliers.

What this workflow does

• Receives incident data via a POST webhook (supplier incident report + recent performance metrics).
• Extracts structured incident details with Anthropic Claude (e.g., severity, root cause, SLA breach status, and a short summary).
• Handles low-confidence reports: routes low-confidence or unclear cases to a “Needs Manual Review” webhook response instead of scoring them.
• Calculates an updated reliability score (0–100) and tier using a rule-based, explainable formula that applies severity, SLA breach, root-cause signals, and incident-rate penalties.
• Generates procurement guidance using Claude, producing a recommendation, reasoning, and corrective actions tied to the updated score.
• Logs the scorecard by appending a row to a Google Sheets “SupplierScorecard” tracker using the Google Sheets API.
• Escalates high-risk suppliers by sending emails through SendGrid when tier is At Risk/Critical or the recommendation is Probation/Terminate, then returns an escalated or routine JSON webhook result.

Use cases

• Automated supplier risk scoring whenever incidents occur (missed SLA, recurring defects, unclear root cause).
• Ops teams triage “needs review” cases without polluting scoring or tiering.
• Procurement teams keep a live supplier scorecard in Google Sheets and trigger email escalations automatically.

Technical details (nodes & integrations)

• n8n nodes: webhook, if, set, code, wait, sticky note
• LLM: Anthropic Claude (two chat model steps—classification + recommendation)
• Data logging: Google Sheets via OAuth2 + Google Sheets API (replace YOUR_SHEET_ID and target range)
• Email escalation: SendGrid