{"product_id":"supplier-reliability-scoring-n8n-workflow-claude-sheets-sendgrid","title":"Supplier Reliability Scoring n8n Workflow: Claude + Sheets + SendGrid","description":"\u003ch3\u003eScore supplier reliability automatically—then escalate the risky ones\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003eSupplier Reliability Scoring n8n Workflow\u003c\/strong\u003e takes supplier incident reports submitted to a webhook, uses \u003cstrong\u003eAnthropic Claude\u003c\/strong\u003e to classify and recommend actions, calculates an \u003cstrong\u003eexplainable 0–100 reliability score\u003c\/strong\u003e, logs every incident to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and sends escalation emails via \u003cstrong\u003eSendGrid\u003c\/strong\u003e for high-risk suppliers.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives incident data\u003c\/strong\u003e via a \u003ccode\u003ePOST\u003c\/code\u003e webhook (supplier incident report + recent performance metrics).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExtracts structured incident details\u003c\/strong\u003e with Anthropic Claude (e.g., severity, root cause, SLA breach status, and a short summary).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHandles low-confidence reports\u003c\/strong\u003e: routes low-confidence or unclear cases to a \u003cstrong\u003e“Needs Manual Review”\u003c\/strong\u003e webhook response instead of scoring them.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalculates an updated reliability score\u003c\/strong\u003e (0–100) and tier using a \u003cstrong\u003erule-based, explainable\u003c\/strong\u003e formula that applies severity, SLA breach, root-cause signals, and incident-rate penalties.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates procurement guidance\u003c\/strong\u003e using Claude, producing a recommendation, reasoning, and corrective actions tied to the updated score.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs the scorecard\u003c\/strong\u003e by appending a row to a Google Sheets “SupplierScorecard” tracker using the Google Sheets API.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEscalates high-risk suppliers\u003c\/strong\u003e by sending emails through SendGrid when tier is \u003cstrong\u003eAt Risk\/Critical\u003c\/strong\u003e or the recommendation is \u003cstrong\u003eProbation\/Terminate\u003c\/strong\u003e, then returns an escalated or routine JSON webhook result.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAutomated supplier risk scoring whenever incidents occur (missed SLA, recurring defects, unclear root cause).\u003c\/li\u003e\n  \u003cli\u003eOps teams triage “needs review” cases without polluting scoring or tiering.\u003c\/li\u003e\n  \u003cli\u003eProcurement teams keep a live supplier scorecard in Google Sheets and trigger email escalations automatically.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details (nodes \u0026amp; integrations)\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes:\u003c\/strong\u003e webhook, if, set, code, wait, sticky note\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLLM:\u003c\/strong\u003e Anthropic Claude (two chat model steps—classification + recommendation)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eData logging:\u003c\/strong\u003e Google Sheets via OAuth2 + Google Sheets API (replace \u003ccode\u003eYOUR_SHEET_ID\u003c\/code\u003e and target range)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEmail escalation:\u003c\/strong\u003e SendGrid\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45732205789363,"sku":"N8N-17505","price":39.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/EE1Z_v-lUSk5JGNB7zMR3_miygjJjZ.png?v=1785143027","url":"https:\/\/buyflowscripts.com\/products\/supplier-reliability-scoring-n8n-workflow-claude-sheets-sendgrid","provider":"N8N Commerce","version":"1.0","type":"link"}