Skip to main content

Evaluate supply chain risk and orchestrate contingencies with Claude, Google Sheets, Gmail and Slack

Workflow preview

Workflow preview
100%
Evaluate supply chain risk and orchestrate contingencies with Claude, Google Sheets, Gmail and Slack preview
Open on n8n.io

1. Workflow Overview

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 evalua...

Best for

  • Engineering automation workflows
  • AI Summarization automation workflows
  • advanced n8n builders looking for reusable templates

Tools used

n8n-nodes-base.scheduletrigger, n8n-nodes-base.set, n8n-nodes-base.googlesheets, n8n-nodes-base.code, @n8n/n8n-nodes-langchain.agent, @n8n/n8n-nodes-langchain.lmchatanthropic, @n8n/n8n-nodes-langchain.outputparserstructured, n8n-nodes-base.switch

Source and attribution

This workflow is cataloged by N8N Workflows and links back to its original n8n.io source page by Cheng Siong Chin.

Original n8n.io source

1.1 Workflow description

Title
Evaluate supply chain risk and orchestrate contingencies with Claude, Google Sheets, Gmail and Slack
Workflow name
Evaluate supply chain risk and orchestrate contingencies with Claude, Google Sheets, Gmail and Slack

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 retrieves risk data from spreadsheets, calculates severity indicators, then routes items through specialized AI agents—critical risks trigger coordinated multi-agent assessment with Gmail and Slack alerts, medium risks undergo standard AI evaluation, while low risks receive automated acknowledgment. Each severity level follows distinct processing paths ensuring appropriate review depth, stakeholder notification, and audit documentation.

Setup Steps

  1. Connect Google Sheets with risk data
  2. Configure Anthropic API credentials for Claude Model nodes
  3. Set up Gmail authentication for notification delivery
  4. Connect Slack workspace and specify channel IDs for critical/low risk alerts
  5. Customize risk thresholds
  6. Update parser regex patterns in Code nodes matching assessment output format

Prerequisites

Active accounts: Google Sheets, Anthropic Claude API, Gmail, Slack.

Use Cases

Enterprise compliance monitoring, operational risk management

Customization

Modify scoring formulas, adjust severity thresholds, add custom AI criteria

Benefits

Eliminates manual triage, ensures consistent standards, accelerates critical response

1.2 Logical Blocks

This catalog entry is organized from the workflow JSON. The node-level section below shows the executable blocks available for review before importing the template.

2. Block-by-Block Analysis

Block 1 - Schedule Trigger

Type / Role
n8n-nodes-base.scheduleTrigger - scheduleTrigger
Config choices
Version 1.3

Block 2 - Workflow Configuration

Type / Role
n8n-nodes-base.set - set
Config choices
Version 3.4

Block 3 - Fetch Risk Data

Type / Role
n8n-nodes-base.googleSheets - googleSheets
Config choices
Version 4.7

Block 4 - Aggregate Risk Indicators

Type / Role
n8n-nodes-base.code - code
Config choices
Version 2

Block 5 - Risk Signal Agent

Type / Role
@n8n/n8n-nodes-langchain.agent - agent
Config choices
Version 3.1

Block 6 - Anthropic Model - Risk Agent

Type / Role
@n8n/n8n-nodes-langchain.lmChatAnthropic - lmChatAnthropic
Config choices
Version 1.3

Block 7 - Risk Assessment Output Parser

Type / Role
@n8n/n8n-nodes-langchain.outputParserStructured - outputParserStructured
Config choices
Version 1.3

Block 8 - Route by Risk Level

Type / Role
n8n-nodes-base.switch - switch
Config choices
Version 3.4

Block 9 - Coordination Agent

Type / Role
@n8n/n8n-nodes-langchain.agent - agent
Config choices
Version 3.1

Block 10 - Anthropic Model - Coordination Agent

Type / Role
@n8n/n8n-nodes-langchain.lmChatAnthropic - lmChatAnthropic
Config choices
Version 1.3

Block 11 - Coordination Output Parser

Type / Role
@n8n/n8n-nodes-langchain.outputParserStructured - outputParserStructured
Config choices
Version 1.3

Block 12 - Slack Notification Tool

Type / Role
n8n-nodes-base.slackTool - slackTool
Config choices
Version 2.4

Block 13 - Gmail Approval Tool

Type / Role
n8n-nodes-base.gmailTool - gmailTool
Config choices
Version 2.2

Block 14 - Impact Assessment Agent Tool

Type / Role
@n8n/n8n-nodes-langchain.agentTool - agentTool
Config choices
Version 3

Block 15 - Anthropic Model - Impact Agent

Type / Role
@n8n/n8n-nodes-langchain.lmChatAnthropic - lmChatAnthropic
Config choices
Version 1.3

Block 16 - Impact Assessment Output Parser

Type / Role
@n8n/n8n-nodes-langchain.outputParserStructured - outputParserStructured
Config choices
Version 1.3

Block 17 - Log Risk Assessment

Type / Role
n8n-nodes-base.googleSheets - googleSheets
Config choices
Version 4.7

Block 18 - Low Risk Notification

Type / Role
n8n-nodes-base.slack - slack
Config choices
Version 2.4

Block 19 - Merge Results

Type / Role
n8n-nodes-base.merge - merge
Config choices
Version 3.2

Block 20 - Sticky Note

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 21 - Sticky Note1

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 22 - Sticky Note2

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 23 - Sticky Note3

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 24 - Sticky Note4

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Showing the first 24 of 26 workflow blocks. Download the JSON for the full node graph.

3. Summary Table

Workflow Evaluate supply chain risk and orchestrate contingencies with Claude, Google Sheets, Gmail and Slack
Complexity advanced
Nodes 26
Categories Engineering, AI Summarization
Author Cheng Siong Chin
Published 11 Feb 2026

4. Reproducing the Workflow from Scratch

  1. 1. Download the workflow JSON

    Use the JSON export at /data/workflows/13316/13316.json as the source template for this automation.

  2. 2. Import the template into n8n

    Open n8n, import the downloaded JSON, and review each node before activating the workflow.

  3. 3. Configure credentials and variables

    Replace placeholder credentials, API keys, webhook URLs, account IDs, and environment-specific values with your own settings.

  4. 4. Test with sample data

    Run the workflow manually or in a staging workspace, inspect node output, and confirm downstream systems receive the expected data.

  5. 5. Activate and monitor

    Enable the workflow only after testing, then monitor executions, errors, and rate limits during the first production runs.

5. General Notes & Resources

Review imported nodes carefully before activation. This catalog entry is intended to help you inspect the workflow structure, understand required services, and find related templates faster.

Node names, credentials, schedules, webhook paths, and external service limits may need adjustment for your workspace.

Frequently asked questions

What does Evaluate supply chain risk and orchestrate contingencies with Claude, Google Sheets, Gmail and Slack do?

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 evalua...

What do I need before importing this workflow?

Review the workflow JSON, configure any required credentials in n8n, and test the automation in a safe workspace before using it in production.

Can I customize this workflow?

Yes. Use the block-by-block analysis and the downloadable JSON to inspect each node, then adjust credentials, prompts, schedules, filters, or destinations for your Engineering, AI Summarization use case.