Skip to content
AI Agents

Source Completion Gate Before Merge with Documented Waiting Queue

10 nodes 71 8 Manual trigger
Download

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. 1.Run Manual Trigger; Code emits fictional branch data including invalid rows
  2. 2.Each branch normalizes fields, skips rows lacking orderId, and appends an __statusCard with counts
  3. 3.Merge append gathers cards and rows into one channel
  4. 4.Completion Gate Check emits one item with per-source status and waiting list
  5. 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

  1. Import the JSON, run Manual Trigger, verify one final output with crm=2 and erp=2
  2. Remove erp rows and set declaredEmpty:true to verify the complete path with zero
  3. 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

Manual Trigger Code Merge If Set No Op

Details

Trigger Manual trigger
Nodes 10
Apps 6
Views 71
Downloads 8

How to Use

  1. 1.Click "Download Template"
  2. 2.Open your n8n dashboard
  3. 3.Go to Workflows > Import from File
  4. 4.Select downloaded file and configure credentials

Nodes Used (10)

/

Manual Trigger

Manual Trigger

#1

Emit Fictional Sample Orders

Code

#2

Branch CRM Normalize + Status Card

Code

#3

Branch ERP Normalize + Status Card

Code

#4

Merge Append All Branches

Merge

#5

Completion Gate Check

Code

#6

IF Both Sources Complete

If

#7

Stamp Documented Completion

Set

#8

Final Single Unified Output

Code

#9

NoOp Waiting Sources Log

No Op

#10

Sticky - Stage Overview

Sticky Note

#11

Sticky - Setup Guide

Sticky Note

#12
Stay in the loop

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

Be first to discover what is new

Your name, your email, and one confirmation.

Email confirmation · Unsubscribe anytime