Monitor semiconductor board reliability with OpenAI and Slack alerts
Ready for 3.0What this workflow does
This AI workflow has 29 nodes and runs on a schedule (every 15 minutes) (plus 1 other trigger). Along the way it connects Google Sheets, OpenAI Chat Model, Data table and Slack and 1 more.
How it runs
Trigger: On a schedule (every 15 minutes) (plus 1 other trigger).
- Fetch Utilization Data (Google Sheets): uses Google Sheets
- Prepare Capacity Data (Edit Fields (Set)): sets 6 fields: bedUtilization, staffUtilization, equipmentUtilization…
- Supervisor Agent (AI Agent): runs an AI agent, with model: Supervisor Model; 9 tools (Code Tool, Calculator, Reporting Agent, Escalation Agent…); output parser: Structured Output Parser
- Prepare History Data (Edit Fields (Set)): sets 7 fields: timestamp, bedUtilization, staffUtilization…
- Store Capacity History (Data table): uses Data table
- Route by Severity (Switch): routes items into 3 branches
- Send Critical Alert (Slack): uses Slack
- Send Warning Alert (Slack): uses Slack
- Format Report Data (Edit Fields (Set)): sets 10 fields: reportTimestamp, department, bedUtilization…
- Merge: merges the data from its input branches
…plus 2 more steps. See the full node list below.
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.
Rarely used nodes in this template: n8n-nodes-base.emailSendHitlTool
Nodes used (18)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Webhook
n8n-nodes-base.webhook - Google Sheets
n8n-nodes-base.googleSheets - Edit Fields (Set)
n8n-nodes-base.set - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - AI Agent Tool
@n8n/n8n-nodes-langchain.agentTool - Calculator
@n8n/n8n-nodes-langchain.toolCalculator - Code Tool
@n8n/n8n-nodes-langchain.toolCode - Data table
n8n-nodes-base.dataTable - Data Table Tool
n8n-nodes-base.dataTableTool - Switch
n8n-nodes-base.switch - Slack Tool
n8n-nodes-base.slackTool - Email Send Hitl Tool
n8n-nodes-base.emailSendHitlTool - Slack
n8n-nodes-base.slack - Send Email
n8n-nodes-base.emailSend - Merge
n8n-nodes-base.merge
From the author
How It Works This workflow automates semiconductor board-level reliability monitoring using AI agents. It targets reliability engineers, manufacturing teams, and quality analysts. The system collects capacity, history, and sensor data, then applies…