This workflow follows the Execute Workflow Trigger → 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-33 manage_schedule",
"nodes": [
{
"parameters": {
"workflowInputs": {
"values": [
{
"name": "action",
"type": "string"
},
{
"name": "cron",
"type": "string"
},
{
"name": "run_at",
"type": "string"
},
{
"name": "label",
"type": "string"
},
{
"name": "id",
"type": "string"
}
]
}
},
"id": "trigger",
"name": "WF Input",
"type": "n8n-nodes-base.executeWorkflowTrigger",
"typeVersion": 1.1,
"position": [
0,
0
]
},
{
"parameters": {
"rules": {
"values": [
{
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "loose"
},
"combinator": "and",
"conditions": [
{
"id": "c1",
"leftValue": "={{ $json.action }}",
"rightValue": "create_recurring",
"operator": {
"type": "string",
"operation": "equals"
}
}
]
},
"renameOutput": true,
"outputKey": "create_recurring"
},
{
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "loose"
},
"combinator": "and",
"conditions": [
{
"id": "c2",
"leftValue": "={{ $json.action }}",
"rightValue": "create_onetime",
"operator": {
"type": "string",
"operation": "equals"
}
}
]
},
"renameOutput": true,
"outputKey": "create_onetime"
},
{
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "loose"
},
"combinator": "and",
"conditions": [
{
"id": "c3",
"leftValue": "={{ $json.action }}",
"rightValue": "cancel",
"operator": {
"type": "string",
"operation": "equals"
}
}
]
},
"renameOutput": true,
"outputKey": "cancel"
},
{
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "loose"
},
"combinator": "and",
"conditions": [
{
"id": "c4",
"leftValue": "={{ $json.action }}",
"rightValue": "list",
"operator": {
"type": "string",
"operation": "equals"
}
}
]
},
"renameOutput": true,
"outputKey": "list"
}
]
},
"options": {}
},
"id": "switch",
"name": "Action",
"type": "n8n-nodes-base.switch",
"typeVersion": 3.2,
"position": [
200,
0
]
},
{
"parameters": {
"operation": "executeQuery",
"query": "insert into schedules (type, cron, label) values ('recurring', $1, nullif($2,'')) returning id, type, cron, label, active",
"options": {
"queryReplacement": "={{ $json.cron }},{{ $json.label || '' }}"
}
},
"id": "createrec",
"name": "Create recurring",
"type": "n8n-nodes-base.postgres",
"typeVersion": 2.4,
"position": [
420,
-150
],
"credentials": {
"postgres": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"operation": "executeQuery",
"query": "insert into schedules (type, run_at, label) values ('onetime', $1::timestamptz, nullif($2,'')) returning id, type, run_at, label, active",
"options": {
"queryReplacement": "={{ $json.run_at }},{{ $json.label || '' }}"
}
},
"id": "createone",
"name": "Create onetime",
"type": "n8n-nodes-base.postgres",
"typeVersion": 2.4,
"position": [
420,
-50
],
"credentials": {
"postgres": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"operation": "executeQuery",
"query": "update schedules set active = false where id = $1::bigint returning id, type, label, active",
"options": {
"queryReplacement": "={{ $json.id }}"
}
},
"id": "cancel",
"name": "Cancel",
"type": "n8n-nodes-base.postgres",
"typeVersion": 2.4,
"position": [
420,
50
],
"credentials": {
"postgres": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"operation": "executeQuery",
"query": "select id, type, cron, run_at, label, active, last_run from schedules order by id",
"options": {}
},
"id": "list",
"name": "List",
"type": "n8n-nodes-base.postgres",
"typeVersion": 2.4,
"position": [
420,
150
],
"credentials": {
"postgres": {
"name": "<your credential>"
}
},
"executeOnce": true,
"alwaysOutputData": true
},
{
"parameters": {
"mode": "runOnceForAllItems",
"jsCode": "const rows = $input.all().map(i => i.json).filter(j => j && Object.keys(j).length);\nreturn [{ json: { count: rows.length, result: rows } }];"
},
"id": "shape",
"name": "Shape result",
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
640,
0
]
}
],
"connections": {
"WF Input": {
"main": [
[
{
"node": "Action",
"type": "main",
"index": 0
}
]
]
},
"Action": {
"main": [
[
{
"node": "Create recurring",
"type": "main",
"index": 0
}
],
[
{
"node": "Create onetime",
"type": "main",
"index": 0
}
],
[
{
"node": "Cancel",
"type": "main",
"index": 0
}
],
[
{
"node": "List",
"type": "main",
"index": 0
}
]
]
},
"Create recurring": {
"main": [
[
{
"node": "Shape result",
"type": "main",
"index": 0
}
]
]
},
"Create onetime": {
"main": [
[
{
"node": "Shape result",
"type": "main",
"index": 0
}
]
]
},
"Cancel": {
"main": [
[
{
"node": "Shape result",
"type": "main",
"index": 0
}
]
]
},
"List": {
"main": [
[
{
"node": "Shape result",
"type": "main",
"index": 0
}
]
]
}
},
"settings": {
"executionOrder": "v1",
"errorWorkflow": "PNJMA4NbQGmp1xKv"
}
}
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.
postgres
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
WF-33 manage_schedule. Uses executeWorkflowTrigger, postgres. Event-driven trigger; 7 nodes.
Source: https://github.com/killerwaz/research-overseer/blob/master/workflows/wf33-manage-schedule.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.
Reagendamiento_v2. Uses executeWorkflowTrigger, redis, httpRequest, n8n-nodes-evolution-api. Event-driven trigger; 89 nodes.
Agendamiento_v2. Uses n8n-nodes-evolution-api, redis, httpRequest, executeWorkflowTrigger. Event-driven trigger; 59 nodes.
Cancelacion_v2. Uses executeWorkflowTrigger, redis, httpRequest, n8n-nodes-evolution-api. Event-driven trigger; 46 nodes.
Save_Extraction. Uses executeWorkflowTrigger, postgres, httpRequest. Event-driven trigger; 22 nodes.
Youtube Searcher. Uses splitInBatches, httpRequest, manualTrigger, executeWorkflowTrigger. Event-driven trigger; 21 nodes.