Evaluate supply chain risk and orchestrate contingencies with Claude, Google Sheets, Gmail and Slack
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 19 nodes and runs on a schedule (every hour). Along the way it connects Google Sheets, Anthropic Chat Model, Slack and Gmail.
How it runs
Trigger: On a schedule (every hour).
- Workflow Configuration (Edit Fields (Set)): sets 6 fields: riskDataSheetId, logSheetId, slackChannelId…
- Fetch Risk Data (Google Sheets): uses Google Sheets
- Aggregate Risk Indicators (Code): runs custom JavaScript code
- Risk Signal Agent (AI Agent): runs an AI agent, with model: Anthropic Model - Risk Agent; output parser: Risk Assessment Output Parser
- Route by Risk Level (Switch): routes items into 3 branches
- Coordination Agent (AI Agent): runs an AI agent, with model: Anthropic Model - Coordination Agent; 3 tools (Gmail Approval Tool, Slack Notification Tool, Impact Assessment Agent Tool); output parser: Coordination Output Parser
- Low Risk Notification (Slack): uses Slack
- Merge: merges the data from its input branches
- Log Risk Assessment (Google Sheets): append or update
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (13)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - AI Agent
@n8n/n8n-nodes-langchain.agent - Anthropic Chat Model
@n8n/n8n-nodes-langchain.lmChatAnthropic - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Switch
n8n-nodes-base.switch - Slack Tool
n8n-nodes-base.slackTool - Gmail Tool
n8n-nodes-base.gmailTool - AI Agent Tool
@n8n/n8n-nodes-langchain.agentTool - Slack
n8n-nodes-base.slack - Merge
n8n-nodes-base.merge
From the author
How It Works This workflow automates enterprise risk management by intelligently routing risks across three severity tiers. Built for compliance teams and risk managers, it eliminates manual evaluation bottlenecks and inconsistent escalation. The system…