Resume failed workflow runs from checkpoints with Postgres and Slack

by Oneclick AI Squad ✓ · 1 views · created 2026-10-02 · Engineering

What this workflow does

This workflow has 48 nodes and runs manually, when you click “Execute workflow” (plus 3 other triggers). Along the way it connects Postgres and Slack.

How it runs

Trigger: Manually, when you click “Execute workflow” (plus 3 other triggers).

1. Set - Mode Manual (Edit Fields (Set)): sets 1 field: entryMode
2. Set - Mode Webhook (Edit Fields (Set)): sets 1 field: entryMode
3. Set - Mode Sweeper (Edit Fields (Set)): sets 1 field: entryMode
4. Slack: uses Slack
5. Set - Checkpoint Config (Edit Fields (Set)): sets 10 fields: workflowName, maxStageAttempts, stageBackoffSeconds…
6. Postgres: run a query
7. Switch: routes items into 2 branches
8. Postgres: run a query
9. JS - Init Run (Code): runs custom JavaScript code
10. JS - Build Resume Requests (Code): runs custom JavaScript code

…plus 34 more steps. See the full node list below.

Services it uses

PostgresSlack

Before you upgrade to n8n 3.0

Nodes used (12)

• Manual Triggern8n-nodes-base.manualTrigger
• Webhookn8n-nodes-base.webhook
• Schedule Triggern8n-nodes-base.scheduleTrigger
• Edit Fields (Set)n8n-nodes-base.set
• Postgresn8n-nodes-base.postgres
• Switchn8n-nodes-base.switch
• Coden8n-nodes-base.code
• HTTP Requestn8n-nodes-base.httpRequest
• Ifn8n-nodes-base.if
• Waitn8n-nodes-base.wait
• Slackn8n-nodes-base.slack
• Error Triggern8n-nodes-base.errorTrigger

From the author

Quick overview This workflow implements a checkpoint-and-resume system for a multi-stage pipeline, storing stage outputs in Postgres and sending failure/recovery alerts to Slack, with manual, webhook, and scheduled triggers to start runs and automatically…

View the original on n8n.io → Check your own copy