Source Completion Gate Before Merge with Documented Waiting Queue
Loading workflow…
Workflow Description
An n8n template that stops partial results reaching a Merge node: each branch (CRM/ERP) runs through a Code node that appends a status card with item counts, then an append-mode Merge unifies the channel, and a gate check verifies both cards arrived with positive counts (or explicitly declared empty). Complete runs get a stamped completion field and one single output; incomplete runs are documented in a NoOp path listing the waiting source and its count.
How it works
- 1.Run Manual Trigger; Code emits fictional branch data including invalid rows
- 2.Each branch normalizes fields, skips rows lacking orderId, and appends an __statusCard with counts
- 3.Merge append gathers cards and rows into one channel
- 4.Completion Gate Check emits one item with per-source status and waiting list
- 5.If routes complete runs to Set stamping then a final single-output Code; incomplete runs go to NoOp
Use cases
- Preventing duplicate or partial Merge output when both branches fire
- Documenting waiting sources before issuing merged reports
- Unifying CRM and ERP data into one auditable output
Requirements
- n8n 2.44.6
- Only manualTrigger/code/set/if/merge/noOp/stickyNote nodes
- No credentials, no external calls
Setup and testing in n8n
- Import the JSON, run Manual Trigger, verify one final output with crm=2 and erp=2
- Remove erp rows and set declaredEmpty:true to verify the complete path with zero
- Empty a branch without declaring and verify NoOp shows the waiting source with count 0
Service Value
Ready-made workflow template for automation delivery and service execution.
Apps Used
Details
How to Use
- 1.Click "Download Template"
- 2.Open your n8n dashboard
- 3.Go to Workflows > Import from File
- 4.Select downloaded file and configure credentials
Nodes Used (10)
Manual Trigger
Manual Trigger
Emit Fictional Sample Orders
Code
Branch CRM Normalize + Status Card
Code
Branch ERP Normalize + Status Card
Code
Merge Append All Branches
Merge
Completion Gate Check
Code
IF Both Sources Complete
If
Stamp Documented Completion
Set
Final Single Unified Output
Code
NoOp Waiting Sources Log
No Op
Sticky - Stage Overview
Sticky Note
Sticky - Setup Guide
Sticky Note
Fresh workflows, straight to your inbox
Get newly published DROPIDEA workflows, a clear overview of what they do, and a link to explore them.
- New workflows
- Clear overviews
- Setup guides