This workflow follows the OpenAI → Postgres 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 →
{
"name": "wf_event_controller_zabbix",
"nodes": [
{
"parameters": {
"path": "zabbix/event",
"httpMethod": "POST"
},
"id": "1",
"name": "Webhook Zabbix",
"type": "n8n-nodes-base.webhook",
"typeVersion": 2,
"position": [
200,
300
]
},
{
"parameters": {
"jsCode": "\nconst event=$json;\nreturn [{json:{\n ticket_id:`ISP-${Date.now()}`,\n severity:event.severity||'average',\n host:event.host||'unknown',\n problem:event.problem||'unknown',\n raw:event\n}}];\n"
},
"id": "2",
"name": "Normalize Event",
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
450,
300
]
},
{
"parameters": {
"operation": "executeQuery",
"query": "INSERT INTO isp.tickets(ticket_id,origen,estado,prioridad,resumen) VALUES('{{ $json.ticket_id }}','zabbix','ABIERTO','{{ $json.severity }}','{{ $json.problem }}');"
},
"id": "3",
"name": "Create Ticket",
"type": "n8n-nodes-base.postgres",
"typeVersion": 2.5,
"position": [
700,
300
]
},
{
"parameters": {
"model": "gpt-4o",
"prompt": "Analiza el evento Zabbix y determina si requiere escalamiento inmediato: {{$json.problem}}"
},
"id": "4",
"name": "AI Analysis",
"type": "@n8n/n8n-nodes-langchain.openAi",
"typeVersion": 1,
"position": [
950,
300
]
},
{
"parameters": {
"conditions": {
"string": [
{
"value1": "={{$json.severity}}",
"operation": "contains",
"value2": "high"
}
]
}
},
"id": "5",
"name": "Critical?",
"type": "n8n-nodes-base.if",
"typeVersion": 2,
"position": [
1200,
300
]
},
{
"parameters": {
"chatId": "={{$env.TELEGRAM_CHAT_ID}}",
"text": "Aprobar acci\u00f3n para ticket {{$json.ticket_id}} problema {{$json.problem}}"
},
"id": "6",
"name": "Telegram Approval",
"type": "n8n-nodes-base.telegram",
"typeVersion": 1,
"position": [
1450,
180
]
},
{
"parameters": {
"workflowId": "wf_auditoria"
},
"id": "7",
"name": "Audit",
"type": "n8n-nodes-base.executeWorkflow",
"typeVersion": 1,
"position": [
1450,
420
]
}
],
"connections": {
"Webhook Zabbix": {
"main": [
[
{
"node": "Normalize Event",
"type": "main",
"index": 0
}
]
]
},
"Normalize Event": {
"main": [
[
{
"node": "Create Ticket",
"type": "main",
"index": 0
}
]
]
},
"Create Ticket": {
"main": [
[
{
"node": "AI Analysis",
"type": "main",
"index": 0
}
]
]
},
"AI Analysis": {
"main": [
[
{
"node": "Critical?",
"type": "main",
"index": 0
}
]
]
},
"Critical?": {
"main": [
[
{
"node": "Telegram Approval",
"type": "main",
"index": 0
}
],
[
{
"node": "Audit",
"type": "main",
"index": 0
}
]
]
}
}
}
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
wf_event_controller_zabbix. Uses postgres, openAi, telegram. Webhook trigger; 7 nodes.
Source: https://github.com/tecno-consultores/ISP-Copilot/blob/main/workflows/wf_event_controller_zabbix.json — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
Satoshi Signal. Uses postgres, httpRequest, telegram, openAi. Webhook trigger; 9 nodes.
AI Relevance Analyzer - Improved. Uses postgres, openAi, telegram. Webhook trigger; 6 nodes.
Eu Clara – Funil Kiwify Completo. Uses postgres, openAi, httpRequest, gmail. Webhook trigger; 70 nodes.
Lua Nova - Sistema Completo. Uses postgres, httpRequest, openAi. Webhook trigger; 55 nodes.
User Signup & Verification: The workflow starts when a user signs up. It generates a verification code and sends it via SMS using Twilio. Code Validation: The user replies with the code. The workflow