Predict transformer overload risk and send alerts via HTTP APIs, email, and Slack

by Oneclick AI Squad ✓ · 4 views · created 2026-08-14 · Engineering, AI Summarization

What this workflow does

This workflow has 22 nodes and runs on a schedule (every 15 minutes). Along the way it connects Google Sheets and Slack.

How it runs

Trigger: On a schedule (every 15 minutes).

1. JS - Define Transformer Fleet (Code): runs custom JavaScript code
2. Loop Over Transformers (Loop Over Items (Split in Batches)): loops over the items in batches
3. Fetch Real-Time Transformer Load Data (HTTP Request): calls an HTTP API
4. Fetch Temperature & Environmental Sensor Data (HTTP Request): calls an HTTP API
5. Fetch Historical Load & Incident Data (HTTP Request): calls an HTTP API
6. Merge: merges the data from its input branches
7. Wait: pauses before continuing
8. If: checks a condition and branches into true / false
9. JS - Calculate Overload Risk Score & Prediction (Code): runs custom JavaScript code
10. Google Sheets: append

…plus 7 more steps. See the full node list below.

Services it uses

Google SheetsSlack

Before you upgrade to n8n 3.0

Nodes used (11)

• Schedule Triggern8n-nodes-base.scheduleTrigger
• Coden8n-nodes-base.code
• Loop Over Items (Split in Batches)n8n-nodes-base.splitInBatches
• HTTP Requestn8n-nodes-base.httpRequest
• Mergen8n-nodes-base.merge
• Waitn8n-nodes-base.wait
• Ifn8n-nodes-base.if
• No Operation, do nothingn8n-nodes-base.noOp
• Google Sheetsn8n-nodes-base.googleSheets
• Send Emailn8n-nodes-base.emailSend
• Slackn8n-nodes-base.slack

From the author

Quick overview This workflow runs every 15 minutes to fetch transformer load, temperature, and 30-day historical data via HTTP APIs, calculates an overload risk score and projected time-to-overload, and sends an early warning email via SMTP when risk is High…

View the original on n8n.io → Check your own copy