AutomationFlowsWeb Scraping › Alert on Equipment Health Issues with Google Sheets and Ms Teams Integration

Alert on Equipment Health Issues with Google Sheets and Ms Teams Integration

ByWeblineIndia @weblineindia on n8n.io

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…

Cron / scheduled trigger★★★★☆ complexity6 nodesHTTP RequestGoogle DriveMicrosoft Teams
Web Scraping Trigger: Cron / scheduled Nodes: 6 Complexity: ★★★★☆ Added:

This workflow corresponds to n8n.io template #6958 — we link there as the canonical source.

This workflow follows the Google Drive → HTTP Request recipe pattern — see all workflows that pair these two integrations.

The workflow JSON

Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →

Download .json
{
  "id": "CirUj0MHUPmdvfKX",
  "meta": {
    "templateCredsSetupCompleted": true
  },
  "name": "Advanced Equipment Health Monitor with MS Teams Integration (n8n | API | Google Sheets)",
  "tags": [],
  "nodes": [
    {
      "id": "736d1ff8-3c90-47c7-aaff-88d8939d38f4",
      "name": "HTTP Request",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -448,
        112
      ],
      "parameters": {
        "url": "https://688c83a8cd9d22dda5cd6aec.mockapi.io/temperature_n8n/equipments",
        "options": {}
      },
      "typeVersion": 4.2
    },
    {
      "id": "fb624d6e-fc9a-406f-836d-9de8557d1bca",
      "name": "Convert to File",
      "type": "n8n-nodes-base.convertToFile",
      "position": [
        0,
        0
      ],
      "parameters": {
        "options": {
          "fileName": "equipment_list.xls"
        },
        "operation": "xls"
      },
      "typeVersion": 1.1
    },
    {
      "id": "57db253d-57b4-40e4-9616-eabec25a59ac",
      "name": "Upload file",
      "type": "n8n-nodes-base.googleDrive",
      "position": [
        240,
        0
      ],
      "parameters": {
        "driveId": {
          "__rl": true,
          "mode": "list",
          "value": "My Drive"
        },
        "options": {},
        "folderId": {
          "__rl": true,
          "mode": "list",
          "value": "root",
          "cachedResultName": "/ (Root folder)"
        }
      },
      "credentials": {
        "googleDriveOAuth2Api": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 3
    },
    {
      "id": "9cb3ac4f-151f-4152-926b-23f5961c7b0d",
      "name": "Condition check for Temp and voltage",
      "type": "n8n-nodes-base.if",
      "position": [
        -224,
        112
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "504acc0c-666e-4e06-8d8e-a9016931b140",
              "operator": {
                "type": "number",
                "operation": "gt"
              },
              "leftValue": "={{ $json.temp }}",
              "rightValue": 60
            },
            {
              "id": "ee25a1d3-8cf0-421c-9268-6695ed0a5416",
              "operator": {
                "type": "number",
                "operation": "gt"
              },
              "leftValue": "={{ $json.voltage }}",
              "rightValue": 20
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "03921e71-6889-4da9-9657-e066fe24a17d",
      "name": "Schedule Trigger for Every 15 Min",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -656,
        112
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "field": "minutes",
              "minutesInterval": 15
            }
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "4e37c01e-ba3f-4d62-9b64-cf9e2c8161f0",
      "name": "Create chat message",
      "type": "n8n-nodes-base.microsoftTeams",
      "position": [
        320,
        288
      ],
      "parameters": {
        "chatId": {
          "__rl": true,
          "mode": "list",
          "value": ""
        },
        "message": "=",
        "options": {},
        "resource": "chatMessage"
      },
      "credentials": {
        "microsoftTeamsOAuth2Api": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 2
    }
  ],
  "active": false,
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "fa42135d-6255-44b0-9234-16e4ac02477a",
  "connections": {
    "HTTP Request": {
      "main": [
        [
          {
            "node": "Condition check for Temp and voltage",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Convert to File": {
      "main": [
        [
          {
            "node": "Upload file",
            "type": "main",
            "index": 0
          },
          {
            "node": "Create chat message",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger for Every 15 Min": {
      "main": [
        [
          {
            "node": "HTTP Request",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Condition check for Temp and voltage": {
      "main": [
        [
          {
            "node": "Convert to File",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}

Credentials you'll need

Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.

Pro

For the full experience including quality scoring and batch install features for each workflow upgrade to Pro

About this workflow

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…

Source: https://n8n.io/workflows/6958/ — original creator credit. Request a take-down →

More Web Scraping workflows → · Browse all categories →

Related workflows

Workflows that share integrations, category, or trigger type with this one. All free to copy and import.

Web Scraping

Proactively alert to service endpoint changes and pod/container issues (Pending, Not Ready, Restart spikes) using Prometheus metrics, formatted and sent to Slack.

HTTP Request
Web Scraping

Tired of being let down by the Google Drive Trigger? Rather not exhaust system resources by polling every minute? Then this workflow is for you!

HTTP Request, Execute Workflow Trigger
Web Scraping

Triggers at a regular interval or via a webhook request. Solves AWS WAF challenge then makes a request to fetch the product page. Extracts product data from the retrieved HTML page. Compares the curre

N8N Nodes Capsolver, HTTP Request
Web Scraping

Automatically monitor billable Kimai projects every weekday morning and receive a formatted HTML email when a project deadline is approaching or its hour budget is running low. If nothing requires att

Email Send, HTTP Request
Web Scraping

This n8n template shows how to upload a file in your Google Drive desired folder, compress it with the iLovePDF tool and move the compressed file to another folder.

Google Drive, Google Drive Trigger, HTTP Request