Alert on Equipment Health Issues with Teams & Google Sheets

This n8n workflow provides advanced monitoring for IoT equipment health, fetching real-time data from an API (temperature, voltage, operational status) via a Cron trigger every 15 minutes. It compares metrics against configurable thresholds in a Set node, triggering an MS Teams webhook notification if issues are detected, and appending detailed logs to a Google Sheet for auditing and analysis.

Benefits include proactive issue detection to prevent downtime, centralized logging for trend analysis, seamless integration with popular tools like MS Teams for team alerts, and easy customization without coding. It saves time on manual checks, reduces operational risks, and scales for multiple devices.

Ideal for renewable energy operators (solar/wind farms), plant maintenance teams, remote infrastructure monitoring, and IoT platforms. Quick setup: import JSON, configure endpoints/thresholds/Sheets ID in the Set node, and activate for instant 15-minute automation.

Requirements: n8n instance, equipment API, MS Teams webhook, Google Sheets. Optional SMTP for emails.