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, genera...
🔌 Nodes & Integrations Used (3)
📖 Implementation & Setup Guide
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.
⚡ How to import this workflow into n8n:
- Click the Direct Download JSON button above to save
Manage incident reporting in PagerDuty and CrateDB.json. - Log in to your n8n Cloud or self-hosted n8n instance.
- In your workflow canvas, click the menu in top-right and select Import from File (or paste the JSON directly).
- Configure your credentials (e.g. API keys, database URLs) in the corresponding node settings.
- Click Execute Workflow to test and switch to Active!
Related Support & Operations Workflows
View All in Support & Operations →Automated Customer Service Ticket Creation Notifications with
How it works: This workflow automates your customer service with built in notifications for your users & ticket creation with Asana. If a user submits a form...
Clockify Ticket Status Sync
Production-ready n8n automation template for Clockify Ticket Status Sync built by AhiXLight. Seamlessly connects Clockify, HTTP Request with 6 configured nodes.
ConnectWise New Ticket Alerts to Teams
Production-ready n8n automation template for ConnectWise New Ticket Alerts to Teams built by AhiXLight. Seamlessly connects Redis, HTTP Request, Microsoft Teams with 8 configured nodes.
Create a new Freshdesk ticket
Companion workflow for Freshdesk node documentation !workflow-screenshot