Workflow Errors

{ "edges": [ { "to": "2f6722be-39f7-478f-a47d-4a16002dc008", "from": "30e8edaf-def4-4a18-821a-b439a095026c", "toPort": "0", "fromPort": "0" }, { "to": "eeaba522-a90a-4450-ad29-46dc0c9d66b6", "from": "2f6722be-39f7-478f-a47d-4a16002dc008", "toPort": "0", "fromPort": "0" }, { "to": "fea0ae9a-650d-4816-b02b-a26f20dff39c", "from": "8bd9894a-ec9a-443e-819b-be43a6fbc70a", "toPort": "0", "fromPort": "0" }, { "to": "31f714b3-2931-4221-957a-270215a0c32d", "from": "71ef77a5-6918-41c6-8ff0-37a0883b22b2", "toPort": "0", "fromPort": "ai_tool" }, { "to": "dd482380-098a-439e-9539-31407defc725", "from": "f30573e0-c346-47c2-99f5-b86d6310a109", "toPort": "0", "fromPort": "0" }, { "to": "795cbfbd-3f08-4c9d-a0be-0459c309ad73", "from": "d468bbe6-751d-4438-b859-cd1daa7ee8ce", "toPort": "0", "fromPort": "0" }, { "to": "e23d7bed-2310-40ab-9d34-465d56ddcd28", "from": "a0e8e245-d98c-4832-8138-b0bca4e7f6af", "toPort": "0", "fromPort": "0" }, { "to": "31f714b3-2931-4221-957a-270215a0c32d", "from": "83076dd7-5b22-427d-8365-71279af62184", "toPort": "0", "fromPort": "ai_languageModel" }, { "to": "e38c352e-5e5f-43c2-82a2-baaa24da284b", "from": "31f714b3-2931-4221-957a-270215a0c32d", "toPort": "0", "fromPort": "0" }, { "to": "9cc66afe-89cb-4dbf-9aff-05c56e181521", "from": "795cbfbd-3f08-4c9d-a0be-0459c309ad73", "toPort": "0", "fromPort": "0" }, { "to": "f30573e0-c346-47c2-99f5-b86d6310a109", "from": "9cc66afe-89cb-4dbf-9aff-05c56e181521", "toPort": "0", "fromPort": "0" }, { "to": "7378503f-bd85-4fdb-9144-a1fcb1354455", "from": "eeaba522-a90a-4450-ad29-46dc0c9d66b6", "toPort": "0", "fromPort": "0" }, { "to": "8bd9894a-ec9a-443e-819b-be43a6fbc70a", "from": "eeaba522-a90a-4450-ad29-46dc0c9d66b6", "toPort": "0", "fromPort": "0" }, { "to": "30e8edaf-def4-4a18-821a-b439a095026c", "from": "e23d7bed-2310-40ab-9d34-465d56ddcd28", "toPort": "0", "fromPort": "0" }, { "to": "31f714b3-2931-4221-957a-270215a0c32d", "from": "7378503f-bd85-4fdb-9144-a1fcb1354455", "toPort": "0", "fromPort": "0" } ], "nodes": [ { "id": "d468bbe6-751d-4438-b859-cd1daa7ee8ce", "name": "Error Trigger", "type": "trigger", "params": { "kind": "n8n-nodes-base.errorTrigger" }, "position": [ 160, -224 ] }, { "id": "795cbfbd-3f08-4c9d-a0be-0459c309ad73", "name": "Ignore Manual Failures", "type": "passthrough", "params": { "mode": "filter", "options": {}, "conditions": { "options": { "version": 3, "leftValue": "", "caseSensitive": true, "typeValidation": "strict" }, "combinator": "and", "conditions": [ { "id": "8ddebc82-8d35-4e0c-a74e-6f2099699f48", "operator": { "type": "string", "operation": "notEquals" }, "leftValue": "={{ $('Error Trigger').item.json.execution.mode }}", "rightValue": "manual" } ] } }, "position": [ 384, -224 ] }, { "id": "2f6722be-39f7-478f-a47d-4a16002dc008", "name": "Aggregate", "type": "passthrough", "params": { "mode": "aggregate", "options": {}, "aggregate": "aggregateAllItemData" }, "position": [ 816, 460 ] }, { "id": "f30573e0-c346-47c2-99f5-b86d6310a109", "name": "Time Saved", "type": "integration", "params": { "service": "timesaved", "operation": "run", "minutesSaved": 1, "__originalType": "n8n-nodes-base.timeSaved" }, "position": [ 832, -224 ] }, { "id": "8bd9894a-ec9a-443e-819b-be43a6fbc70a", "name": "Split Out", "type": "passthrough", "params": { "mode": "splitOut", "field": "data", "options": {}, "fieldToSplitOut": "data" }, "position": [ 1360, 720 ] }, { "id": "fea0ae9a-650d-4816-b02b-a26f20dff39c", "name": "Update Last Emailed At", "type": "passthrough", "params": { "mode": "noOp", "columns": { "value": { "lastEmailedAt": "={{ $now }}" }, "schema": [ { "id": "workflowId", "type": "string", "display": true, "removed": false, "readOnly": false, "required": false, "displayName": "workflowId", "defaultMatch": false }, { "id": "executionId", "type": "string", "display": true, "removed": false, "readOnly": false, "required": false, "displayName": "executionId", "defaultMatch": false }, { "id": "errorMessage", "type": "string", "display": true, "removed": false, "readOnly": false, "required": false, "displayName": "errorMessage", "defaultMatch": false }, { "id": "errorStack", "type": "string", "display": true, "removed": false, "readOnly": false, "required": false, "displayName": "errorStack", "defaultMatch": false }, { "id": "lastNodeExecuted", "type": "string", "display": true, "removed": false, "readOnly": false, "required": false, "displayName": "lastNodeExecuted", "defaultMatch": false }, { "id": "workflowName", "type": "string", "display": true, "removed": false, "readOnly": false, "required": false, "displayName": "workflowName", "defaultMatch": false }, { "id": "executionDate", "type": "string", "display": true, "removed": false, "readOnly": false, "required": false, "displayName": "executionDate", "defaultMatch": false }, { "id": "executionUrl", "type": "string", "display": true, "removed": false, "readOnly": false, "required": false, "displayName": "executionUrl", "defaultMatch": false }, { "id": "lastEmailedAt", "type": "dateTime", "display": true, "removed": false, "readOnly": false, "required": false, "displayName": "lastEmailedAt", "defaultMatch": false } ], "mappingMode": "defineBelow", "matchingColumns": [], "attemptToConvertTypes": false, "convertFieldsToString": false }, "filters": { "conditions": [ { "keyValue": "={{ $json.id }}" } ] }, "options": {}, "matchType": "allConditions", "operation": "update", "dataTableId": { "__rl": true, "mode": "list", "value": "zbjSiKe71GhTt8Pp", "cachedResultUrl": "/projects/NVPkP6ENY3Rv7l37/datatables/zbjSiKe71GhTt8Pp", "cachedResultName": "Workflow Errors" } }, "position": [ 1616, 720 ] }, { "id": "e23d7bed-2310-40ab-9d34-465d56ddcd28", "name": "Get Errors that were not Emailed", "type": "passthrough", "params": { "mode": "noOp", "filters": { "conditions": [ { "keyName": "lastEmailedAt", "condition": "isEmpty" } ] }, "operation": "get", "dataTableId": { "__rl": true, "mode": "list", "value": "zbjSiKe71GhTt8Pp", "cachedResultUrl": "/projects/NVPkP6ENY3Rv7l37/datatables/zbjSiKe71GhTt8Pp", "cachedResultName": "Workflow Errors" } }, "position": [ 368, 460 ] }, { "id": "9cc66afe-89cb-4dbf-9aff-05c56e181521", "name": "map fields to data table", "type": "set", "params": { "options": {}, "assignments": { "assignments": [ { "id": "7132728e-a39a-478e-9fc0-1f71f5593425", "name": "workflowId", "type": "string", "value": "={{ $('Error Trigger').item.json.workflow.id }}" }, { "id": "ca5be94a-3f39-423c-aa2e-a0103a8ae97e", "name": "executionId", "type": "string", "value": "={{ $('Error Trigger').item.json.execution.id }}" }, { "id": "64f740de-a897-46fc-86cd-5e7004df1bc5", "name": "errorMessage", "type": "string", "value": "={{ $('Error Trigger').item.json.execution.error.message ?? $('Error Trigger').item.json.values().toJsonString() }}" }, { "id": "e8f1f197-dbd0-44cc-bdf7-9e9318bd5922", "name": "errorStack", "type": "string", "value": "={{ $('Error Trigger').item.json.execution.error.stack }}" }, { "id": "851b421d-8d24-407e-b42f-ebb985dd5e73", "name": "lastNodeExecuted", "type": "string", "value": "={{ $('Error Trigger').item.json.execution.lastNodeExecuted }}" }, { "id": "bddb35ac-4d3a-432a-8896-f6a68d35f2a8", "name": "workflowName", "type": "string", "value": "={{ $('Error Trigger').item.json.workflow.name }}" }, { "id": "1ef62897-61cd-4a43-ba06-b4c83ce5febb", "name": "executionDate", "type": "string", "value": "={{ $now.format('yyyy-MM-dd') }}" }, { "id": "97ae6e2d-e7ab-4ed6-b393-9e79b8bf7974", "name": "executionUrl", "type": "string", "value": "={{ $('Error Trigger').item.json.execution.url }}" } ] } }, "position": [ 608, -224 ] }, { "id": "83076dd7-5b22-427d-8365-71279af62184", "name": "OpenAI Chat Model", "type": "llm", "params": { "model": "gpt-4.1-mini", "options": {}, "provider": "openai", "builtInTools": {} }, "position": [ 1496, 432 ] }, { "id": "31f714b3-2931-4221-957a-270215a0c32d", "name": "AI Error Summarizer", "type": "llm", "params": { "text": "=Workflow Errors: {{ JSON.stringify($('Aggregate').item.json.data) }}", "prompt": "=Workflow Errors: {{ JSON.stringify($('Aggregate').item.json.data) }}", "options": { "systemMessage": "You are my error summarizer agent. Your duty is to read through a list of errors, and provide a concise summary of the errors on my n8n workflows in well summarised pointers that is easy to go through and also provide some inputs on resolving those errors. Also give some quantitative representation for the number of errors. Give more priority to errors that have occurred many times. Do not cover all details of the errors, just a concise summary.\n\nGive me the output in html format, nothing else, no extra triple backticks or extra strings.\n\nI've given you a Calculator tool, if you find a need, but its not a necessity.\n\nTime right now: {{ $now }}" }, "provider": "openai", "promptType": "define", "approximated": true, "systemMessage": "You are my error summarizer agent. Your duty is to read through a list of errors, and provide a concise summary of the errors on my n8n workflows in well summarised pointers that is easy to go through and also provide some inputs on resolving those errors. Also give some quantitative representation for the number of errors. Give more priority to errors that have occurred many times. Do not cover all details of the errors, just a concise summary.\n\nGive me the output in html format, nothing else, no extra triple backticks or extra strings.\n\nI've given you a Calculator tool, if you find a need, but its not a necessity.\n\nTime right now: {{ $now }}" }, "position": [ 1488, 208 ] }, { "id": "e38c352e-5e5f-43c2-82a2-baaa24da284b", "name": "Email Error Details", "type": "integration", "params": { "sendTo": "user@example.com", "message": "={{ $json.output[0].content[0].text }}\n

\n{{ $('Code in JavaScript').item.json.html }}", "options": { "senderName": "Harshal Patil", "appendAttribution": false }, "service": "gmail", "subject": "=n8n Workflow Errors - {{ $now.minus(1,'days').format('yyyy-MM-dd') }}", "operation": "read" }, "position": [ 1840, 312 ] }, { "id": "dd482380-098a-439e-9539-31407defc725", "name": "Insert Error Details", "type": "passthrough", "params": { "mode": "noOp", "columns": { "value": { "errorStack": "={{ $('Error Trigger').item.json.execution.error.stack }}", "workflowId": "={{ $('Error Trigger').item.json.workflow.id }}", "executionId": "={{ $('Error Trigger').item.json.execution.id }}", "errorMessage": "={{ $('Error Trigger').item.json.execution.error.message }}", "executionUrl": "={{ $('Error Trigger').item.json.execution.url }}", "workflowName": "={{ $('Error Trigger').item.json.workflow.name }}", "executionDate": "={{ $now.format('yyyy-MM-dd') }}", "lastNodeExecuted": "={{ $('Error Trigger').item.json.execution.lastNodeExecuted }}" }, "schema": [ { "id": "workflowId", "type": "string", "display": true, "removed": false, "readOnly": false, "required": false, "displayName": "workflowId", "defaultMatch": false }, { "id": "executionId", "type": "string", "display": true, "removed": false, "readOnly": false, "required": false, "displayName": "executionId", "defaultMatch": false }, { "id": "errorMessage", "type": "string", "display": true, "removed": false, "readOnly": false, "required": false, "displayName": "errorMessage", "defaultMatch": false }, { "id": "errorStack", "type": "string", "display": true, "removed": false, "readOnly": false, "required": false, "displayName": "errorStack", "defaultMatch": false }, { "id": "lastNodeExecuted", "type": "string", "display": true, "removed": false, "readOnly": false, "required": false, "displayName": "lastNodeExecuted", "defaultMatch": false }, { "id": "workflowName", "type": "string", "display": true, "removed": false, "readOnly": false, "required": false, "displayName": "workflowName", "defaultMatch": false }, { "id": "executionDate", "type": "string", "display": true, "removed": false, "readOnly": false, "required": false, "displayName": "executionDate", "defaultMatch": false }, { "id": "executionUrl", "type": "string", "display": true, "removed": false, "readOnly": false, "required": false, "displayName": "executionUrl", "defaultMatch": false }, { "id": "lastEmailedAt", "type": "dateTime", "display": true, "removed": false, "readOnly": false, "required": false, "displayName": "lastEmailedAt", "defaultMatch": false } ], "mappingMode": "defineBelow", "matchingColumns": [], "attemptToConvertTypes": false, "convertFieldsToString": false }, "options": {}, "dataTableId": { "__rl": true, "mode": "list", "value": "zbjSiKe71GhTt8Pp", "cachedResultUrl": "/projects/NVPkP6ENY3Rv7l37/datatables/zbjSiKe71GhTt8Pp", "cachedResultName": "Workflow Errors" } }, "position": [ 1056, -224 ] }, { "id": "71ef77a5-6918-41c6-8ff0-37a0883b22b2", "name": "Calculator", "type": "integration", "params": { "service": "toolcalculator", "operation": "run", "__originalType": "@n8n/n8n-nodes-langchain.toolCalculator" }, "position": [ 1624, 432 ] }, { "id": "30e8edaf-def4-4a18-821a-b439a095026c", "name": "Sort", "type": "passthrough", "params": { "mode": "sort", "options": {}, "sortFieldsUi": { "sortField": [ { "fieldName": "createdAt" } ] } }, "position": [ 592, 460 ] }, { "id": "eeaba522-a90a-4450-ad29-46dc0c9d66b6", "name": "high error count or been a day1", "type": "passthrough", "params": { "mode": "filter", "options": {}, "conditions": { "options": { "version": 3, "leftValue": "", "caseSensitive": true, "typeValidation": "strict" }, "combinator": "or", "conditions": [ { "id": "f8de07d3-6fa6-466c-be6d-438aef94a5da", "operator": { "type": "array", "operation": "lengthGt", "rightType": "number" }, "leftValue": "={{ $json.data }}", "rightValue": 5 }, { "id": "5f907458-d775-445b-8517-1461eb84f68c", "operator": { "type": "boolean", "operation": "true", "singleValue": true }, "leftValue": "={{ DateTime.now().diff(DateTime.fromISO($('Sort').first()?.json?.createdAt), 'hours').hours.round() >= 24 }}", "rightValue": "" } ] } }, "position": [ 1040, 460 ] }, { "id": "a0e8e245-d98c-4832-8138-b0bca4e7f6af", "name": "Run every hour", "type": "trigger", "params": { "kind": "n8n-nodes-base.scheduleTrigger", "rule": { "interval": [ { "field": "hours" } ] } }, "position": [ 144, 460 ] }, { "id": "7378503f-bd85-4fdb-9144-a1fcb1354455", "name": "Generate Workflow Errors Table HTML", "type": "passthrough", "params": { "html": "=\n\n\n\n \n Workflow Errors\n\n\n \n \n \n \n \n \n \n \n \n \n \n \n {{ $('Aggregate').item.json.data.map((record, index) => {\n const bgColor = index % 2 === 0 ? '#f9f9f9' : '#ffffff';\n const executionTimestamp = record.createdAt ? new Date(record.createdAt).toISOString().replace('T', ' ').replace('Z', '').slice(0, 19) : 'N/A';\n return `\n \n \n \n \n \n \n \n \n `;\n }).join('') }}\n \n

Workflow Name	Execution Date	Execution Timestamp (UTC)	Failed Node	Error Message	View Execution
${record.workflowName \|\| 'N/A'}	${record.executionDate \|\| 'N/A'}	${executionTimestamp}	${record.lastNodeExecuted \|\| 'N/A'}	${record.errorMessage \|\| 'N/A'}	View

\n\n", "mode": "noOp" }, "position": [ 1264, 312 ] } ] }

Automated error monitoring and reporting system using data tables