Back to Templates
This n8n workflow automatically monitors equipment health by fetching real-time metrics like temperature, voltage and operational status. If any of these parameters cross critical thresholds, an alert is instantly sent to a Microsoft Teams channel and the event is logged in Google Sheets. The workflow runs every 15 minutes by default.
Tool | Purpose |
---|---|
n8n Instance | To run and schedule automation |
HTTP API | Access to your equipment or IoT platform health API |
Microsoft Teams | Incoming Webhook URL configured |
Google Sheets | Logging and analytics |
SMTP (optional) | For email-based alternatives or expansions |
Import Workflow:
.json
file.Update Configurations:
apiEndpoint
: URL to fetch equipment data.teamsWebhookUrl
: Your MS Teams channel webhook.temperatureThreshold
: Example = 80voltageThreshold
: Example = 400googleSheetId
: Google Sheet ID (must be shared with n8n service account).Check Webhook Integration:
Run & Monitor:
Customization | How |
---|---|
Add more parameters (humidity, pressure) | Extend the HTTP + IF node conditions |
Change alert frequency | Edit the Cron node |
Use Slack or Email instead of Teams | Replace MS Teams node with Slack or Email node |
Add PDF Report Generation | Use HTML → PDF node and email the report |
Export to Database | Add a PostgreSQL or MySQL node instead of Google Sheets |
Add-on | Description |
---|---|
📦 Auto-Ticketing | Auto-create issues in Jira, Trello or ClickUp for serious faults |
📊 Dashboard Sync | Send real-time logs to BigQuery or InfluxDB |
🧠 Predictive Alerts | Use machine learning APIs to flag anomalies |
🗂 Daily Digest | Compile all incidents into a daily summary email or Teams post |
📱 Mobile Alert | Integrate Twilio for SMS alerts or WhatsApp notifications |
Issue | Possible Cause | Solution |
---|---|---|
No Teams alert | Incorrect webhook URL or formatting | Recheck the Teams webhook and payload |
Workflow not triggering | Cron node misconfigured | Ensure it’s set to run every 15 mins and workflow is active |
Google Sheet not updating | Sheet ID is wrong or not shared | Share Sheet with your n8n Google service account |
No data from API | Endpoint URL is down or wrong | Test the endpoint manually with Postman or browser |
Need help tailoring this to your exact equipment type or expanding the workflow?
👉 Contact WeblineIndia – Expert automation partners for renewable energy, infrastructure and enterprise workflows.