Manage Incident Reporting in PagerDuty and CrateDB
This workflow automatically monitors the functionality of a factory. The workflow logs machine data coming from factory sensors in a CrateDB database, generates an incident report in PagerDuty, and notifies the responsible staff members when the temperature of a machine crosses the threshold value. This workflow builds on a [workflow that generates factory data](https://n8n.io/workflows/608). Read more about this use case and how to build both workflows with step-by-step instructions in the blog post [*How to automate your factory's incident reporting*](https://n8n.io/blog/learn-to-automate-your-factorys-incident-reporting-a-step-by-step-guide/). ## Prerequisites - A PagerDuty account and [credentials](https://docs.n8n.io/integrations/nodes/n8n-nodes-base.pagerduty/) - AMQP, an ActiveMQ connection, and [credentials](https://docs.n8n.io/integrations/credentials/amqp/) - A CrateDB instance running locally or on a server, and [credentials](https://docs.n8n.io/integrations/credentials/cratedb/). ## Nodes - [AMQP Trigger node](https://docs.n8n.io/integrations/trigger-nodes/n8n-nodes-base.amqptrigger/) starts the workflow. - [IF node](https://docs.n8n.io/integrations/core-nodes/n8n-nodes-base.if/) filters sensor values higher than 50°C. - [PagerDuty node](https://docs.n8n.io/integrations/nodes/n8n-nodes-base.pagerduty/) creates an incident in the account. - [Set nodes](https://docs.n8n.io/integrations/core-nodes/n8n-nodes-base.set/) set the required incident information and sensor data, respectively. - [CrateDB nodes](https://docs.n8n.io/integrations/nodes/n8n-nodes-base.cratedb/) ingest the information data and machine sensor data, respectively. - [Function node](https://docs.n8n.io/integrations/core-nodes/n8n-nodes-base.function/) converts degrees from Celsius to Fahrenheit.
- Platform
- n8n
- Category
- Internet of Things
- Price
- $9.99
- Creator
- Harshil Agrawal
- if
- set
- noOp
- crateDb
- function
- pagerDuty
- amqpTrigger
How to import this workflow into n8n
- 1Purchase or download the workflow to get the n8n workflow JSON file.
- 2In your n8n instance, open Workflows and choose "Import from File" (or paste the JSON with Ctrl+V on the canvas).
- 3Open each node marked with a credential warning and connect your own accounts and API keys.
- 4Run the workflow once manually to verify the data flow, then toggle it to Active.
Related Internet of Things workflows
- Automated Weather Alerts and Analysis Using AI and Home Assistant$14.99
- AI-Driven Handbook Generator with Multi-Agent Orchestration$24.99
- Vehicle Telematics Analyzer for Efficient Device Management$24.99
- Automate Solar Energy Monitoring and Alerts with Gmail, Google Sheets, and Slack$9.99
- Automate Network Disconnection Alerts with Omada, Gmail, and Pushover$14.99
- Automate IoT Sensor Data Cleaning and Logging to InfluxDB$4.99
More from Harshil Agrawal
Need this deployed? We'll set it up for you.
Our automation experts deploy this workflow in your stack, connect your accounts, and verify it works — or build a custom solution from scratch.