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 →
{
"nodes": [
{
"id": "d496660c-88be-4130-ad6c-32e55f820af0",
"name": "Set Default Error Workflow",
"type": "n8n-nodes-base.postgres",
"position": [
1700,
500
],
"parameters": {
"table": {
"__rl": true,
"mode": "list",
"value": "workflow_entity",
"cachedResultName": "workflow_entity"
},
"schema": {
"__rl": true,
"mode": "list",
"value": "public"
},
"columns": {
"value": {
"id": "={{ $json.id }}",
"settings": "={{ JSON.stringify({ ...$json.settings, errorWorkflow: $('Set Vars').item.json.default_error_workflow_id }, null, null) }}"
},
"schema": [
{
"id": "name",
"type": "string",
"display": true,
"removed": true,
"required": true,
"displayName": "name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "active",
"type": "boolean",
"display": true,
"removed": true,
"required": true,
"displayName": "active",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "nodes",
"type": "object",
"display": true,
"removed": true,
"required": true,
"displayName": "nodes",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "connections",
"type": "object",
"display": true,
"removed": true,
"required": true,
"displayName": "connections",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "createdAt",
"type": "dateTime",
"display": true,
"removed": true,
"required": false,
"displayName": "createdAt",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "updatedAt",
"type": "dateTime",
"display": true,
"removed": true,
"required": false,
"displayName": "updatedAt",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "settings",
"type": "object",
"display": true,
"removed": false,
"required": false,
"displayName": "settings",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "staticData",
"type": "object",
"display": true,
"removed": true,
"required": false,
"displayName": "staticData",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "pinData",
"type": "object",
"display": true,
"removed": true,
"required": false,
"displayName": "pinData",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "versionId",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "versionId",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "triggerCount",
"type": "number",
"display": true,
"removed": true,
"required": false,
"displayName": "triggerCount",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "id",
"type": "string",
"display": true,
"removed": false,
"required": true,
"displayName": "id",
"defaultMatch": true,
"canBeUsedToMatch": true
},
{
"id": "meta",
"type": "object",
"display": true,
"removed": true,
"required": false,
"displayName": "meta",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"id"
]
},
"options": {},
"operation": "update"
},
"credentials": {
"postgres": {
"name": "<your credential>"
}
},
"retryOnFail": true,
"typeVersion": 2.3
},
{
"id": "334c557c-bc6c-44f8-85ac-3cacc145cf2f",
"name": "Set Vars",
"type": "n8n-nodes-base.set",
"position": [
1040,
500
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "b2302801-f93e-4134-a785-47454dfe31d4",
"name": "default_error_workflow_id",
"type": "string",
"value": "2fgSBCqYJyEZWtTO"
},
{
"id": "efe2c80d-2b98-4a6b-8f76-7e2d5866c4ea",
"name": "default_error_exclusion_tag",
"type": "string",
"value": "default_error:false"
}
]
}
},
"retryOnFail": true,
"typeVersion": 3.3
},
{
"id": "858d36f2-1024-43dd-89e9-00402fb1bae2",
"name": "Exclude default_error:false Tagged Workflows",
"type": "n8n-nodes-base.filter",
"position": [
1480,
500
],
"parameters": {
"options": {},
"conditions": {
"options": {
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "911501c7-18cc-4292-a4e8-fe8f8c3cb8aa",
"operator": {
"type": "boolean",
"operation": "false",
"singleValue": true
},
"leftValue": "={{ $json.tags.some(item => item.name === $('Set Vars').item.json.default_error_exclusion_tag) }}",
"rightValue": ""
},
{
"id": "e22db4f5-ec03-4000-a996-d3150db17a73",
"operator": {
"type": "string",
"operation": "notEquals"
},
"leftValue": "={{ $json.settings.errorWorkflow ? $json.settings.errorWorkflow : \"\" }}",
"rightValue": "={{ $('Set Vars').item.json.default_error_workflow_id }}"
}
]
}
},
"retryOnFail": true,
"typeVersion": 2
},
{
"id": "f0ac7515-8175-458c-9357-b5246019a22c",
"name": "When clicking \"Test workflow\"",
"type": "n8n-nodes-base.manualTrigger",
"position": [
780,
580
],
"parameters": {},
"typeVersion": 1
},
{
"id": "2545b766-a0a0-4e31-9941-d51d5594aff6",
"name": "Schedule Trigger",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
780,
400
],
"parameters": {
"rule": {
"interval": [
{
"field": "hours",
"hoursInterval": 4
}
]
}
},
"notesInFlow": false,
"typeVersion": 1.1
},
{
"id": "901e4df3-4dd3-4b92-ac09-555d51d2d7e9",
"name": "Get All Workflows",
"type": "n8n-nodes-base.n8n",
"position": [
1260,
500
],
"parameters": {
"filters": {}
},
"credentials": {
"n8nApi": {
"name": "<your credential>"
}
},
"retryOnFail": true,
"typeVersion": 1
}
],
"connections": {
"Set Vars": {
"main": [
[
{
"node": "Get All Workflows",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger": {
"main": [
[
{
"node": "Set Vars",
"type": "main",
"index": 0
}
]
]
},
"Get All Workflows": {
"main": [
[
{
"node": "Exclude default_error:false Tagged Workflows",
"type": "main",
"index": 0
}
]
]
},
"When clicking \"Test workflow\"": {
"main": [
[
{
"node": "Set Vars",
"type": "main",
"index": 0
}
]
]
},
"Exclude default_error:false Tagged Workflows": {
"main": [
[
{
"node": "Set Default Error Workflow",
"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.
n8nApipostgres
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
Postgres Filter. Uses postgres, manualTrigger, scheduleTrigger, n8n. Event-driven trigger; 6 nodes.
Source: https://github.com/Zie619/n8n-workflows — 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.
Do you consistently forget to set a Default Error Workflow when creating new workflows? Then this helper workflow is for you!
Postgres, n8n
Reagendamiento_v2. Uses executeWorkflowTrigger, redis, httpRequest, n8n-nodes-evolution-api. Event-driven trigger; 89 nodes.
Execute Workflow Trigger, Redis, HTTP Request +3
This workflow acts as a junior finance research analyst for a UK boutique M&A or corporate finance team. It listens for Slack messages, classifies the request, gathers company or market data, and prod
HTTP Request, Google Drive, Google Docs +5
Agendamiento_v2. Uses n8n-nodes-evolution-api, redis, httpRequest, executeWorkflowTrigger. Event-driven trigger; 59 nodes.
N8N Nodes Evolution Api, Redis, HTTP Request +3
Cancelacion_v2. Uses executeWorkflowTrigger, redis, httpRequest, n8n-nodes-evolution-api. Event-driven trigger; 46 nodes.
Execute Workflow Trigger, Redis, HTTP Request +3