Send daily Azure IoT Hub fleet health reports with OpenAI and Gmail
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 15 nodes and runs on a schedule (cron 0 9 * * *). Along the way it connects Gmail and OpenAI.
How it runs
Trigger: On a schedule (cron 0 9 * * *).
- Fleet Config (Edit Fields (Set)): sets or maps fields
- Generate SAS Token (Code): runs custom JavaScript code
- Query All Devices (HTTP Request): calls an HTTP API (POST)
- Classify Fleet (Code): runs custom JavaScript code
- Email — Run Failed (Gmail): uses Gmail
- Read Previous Run (Data table): get
- Compute Deltas (Code): runs custom JavaScript code
- AI Summary (OpenAI): uses OpenAI
- Build Report (Code): runs custom JavaScript code
- Route by Severity (Switch): routes items into 3 branches
…plus 4 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.
Nodes used (8)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - Code
n8n-nodes-base.code - HTTP Request
n8n-nodes-base.httpRequest - Gmail
n8n-nodes-base.gmail - Data table
n8n-nodes-base.dataTable - OpenAI
@n8n/n8n-nodes-langchain.openAi - Switch
n8n-nodes-base.switch
From the author
Quick overview This workflow runs daily at 9:00 AM to query your Azure IoT Hub device registry, classify fleet health (online, offline, stale, disabled), generate an HTML executive summary with OpenAI, and email the report through Gmail. How it works 1. Runs…