{"product_id":"daily-azure-iot-hub-fleet-health-report-openai-gmail","title":"Daily Azure IoT Hub Fleet Health Report (OpenAI + Gmail)","description":"\u003ch3\u003eDaily Azure IoT Hub Fleet Health Report—AI Executive Summary + Gmail Email\u003c\/h3\u003e\n\u003cp\u003eRun a daily health check on your Azure IoT Hub devices and automatically receive an OpenAI-generated executive report by email—highlighting online, offline, stale (inactive \u0026gt; 24 hours), and disabled devices with actionable recommendations.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cp\u003eThis n8n automation runs every day at \u003cb\u003e9:00 AM\u003c\/b\u003e to assess your full IoT fleet and turn the results into a readable, leadership-friendly HTML summary.\u003c\/p\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eBuilds a short-lived Azure IoT Hub SAS token\u003c\/b\u003e from your provided IoT Hub connection string.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eQueries the Azure IoT Hub device registry\u003c\/b\u003e using the device query REST API to retrieve device status details such as connection state, last activity time, and reported properties.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eClassifies fleet health\u003c\/b\u003e into: \u003cb\u003eonline\u003c\/b\u003e, \u003cb\u003eoffline\u003c\/b\u003e, \u003cb\u003estale\u003c\/b\u003e (inactive for over 24 hours), and \u003cb\u003edisabled\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003eGenerates fleet totals plus a \u003cb\u003eper-device snapshot\u003c\/b\u003e of issues.\u003c\/li\u003e\n  \u003cli\u003eSends the summary JSON to \u003cb\u003eOpenAI\u003c\/b\u003e to produce a \u003cb\u003econcise HTML report\u003c\/b\u003e that includes risks, top problem devices, and recommendations.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eEmails the AI-generated HTML report\u003c\/b\u003e via \u003cb\u003eGmail\u003c\/b\u003e to your configured recipients.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eDaily operational monitoring for SaaS platforms managing connected devices in Azure IoT Hub.\u003c\/li\u003e\n  \u003cli\u003eQuick detection of device drop-offs (offline\/stale) and disabled assets—before they impact customers.\u003c\/li\u003e\n  \u003cli\u003eAutomated reporting for automation engineers and platform teams who want consistent fleet health updates without manual querying.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eSchedule:\u003c\/b\u003e Runs daily at 9:00 AM\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eAzure IoT Hub:\u003c\/b\u003e Uses a short-lived SAS token + IoT Hub device query REST API\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eOpenAI:\u003c\/b\u003e Converts fleet health JSON into an AI-generated HTML executive summary\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eGmail:\u003c\/b\u003e Sends the HTML report to specified recipients\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003en8n nodes mentioned:\u003c\/b\u003e set, code, gmail, switch, data table, sticky note\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003e\u003cb\u003eSetup required:\u003c\/b\u003e Provide an Azure IoT Hub connection string with registry read permissions (e.g., a shared access policy such as \u003ccode\u003eregistryRead\u003c\/code\u003e), add OpenAI credentials and select a model, then configure Gmail OAuth2 and recipient email addresses.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45876892369075,"sku":"N8N-18399","price":51.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/FOAAUOZM2p-q2B3scuJRJ_sSxZFLG6.png?v=1787303791","url":"https:\/\/buyflowscripts.com\/products\/daily-azure-iot-hub-fleet-health-report-openai-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}