Score supplier reliability from incident reports with Claude and Google Sheets
Needs changesNeeds changes. This template uses 1 thing(s) that n8n 3.0 removes: AI Agent v1 (old agent modes). 1 breaking item(s) found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 19 nodes and runs when an HTTP POST request hits its webhook URL. Along the way it connects Anthropic Chat Model. It also calls sheets.googleapis.com and api.sendgrid.com over HTTP.
How it runs
Trigger: When an HTTP POST request hits its webhook URL.
- Set - Prepare Incident Context (Edit Fields (Set)): sets 17 fields: supplierId, supplierName, supplierType…
- AI - Classify & Extract Incident Details (AI Agent): runs an AI agent, with model: Anthropic - Classification Model
- JS - Parse Incident Classification Output (Code): runs custom JavaScript code
- If: checks a condition and branches into true / false
- JS - Calculate Updated Reliability Score (Code): runs custom JavaScript code
- Respond to Webhook: sends the response back to the webhook caller
- Wait: pauses before continuing
- AI - Generate Supplier Recommendation (AI Agent): runs an AI agent, with model: Anthropic - Recommendation Model
- JS - Parse Recommendation Output (Code): runs custom JavaScript code
- JS - Format Final Scorecard Record (Code): runs custom JavaScript code
…plus 6 more steps. See the full node list below.
Services it uses
HTTP calls to: sheets.googleapis.com, api.sendgrid.com
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- AI Agent v1 (old agent modes) in AI - Classify & Extract Incident Details (v1.6), AI - Generate Supplier Recommendation (v1.6): replace with Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.
| Removed in 3.0 | Replace with |
|---|---|
| AI Agent v1 (old agent modes) AI - Classify & Extract Incident Details (v1.6), AI - Generate Supplier Recommendation (v1.6) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (9)
- Webhook
n8n-nodes-base.webhook - Edit Fields (Set)
n8n-nodes-base.set - AI Agent
@n8n/n8n-nodes-langchain.agent - Anthropic Chat Model
@n8n/n8n-nodes-langchain.lmChatAnthropic - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Respond to Webhook
n8n-nodes-base.respondToWebhook - Wait
n8n-nodes-base.wait - HTTP Request
n8n-nodes-base.httpRequest
From the author
Quick overview This workflow receives supplier incident reports via webhook, uses Anthropic Claude to classify severity and root cause, calculates an explainable reliability score, logs each incident to Google Sheets, and sends SendGrid email alerts when a…