Skip to content
AI Agents

Silent Item Loss Auditor for Execution Stage Counts

8 nodes 69 5 Manual trigger
Download

Loading workflow…

Workflow Description

The workflow takes JSON execution summaries listing, per stage, items in, items out and an intentional-drop flag, plus expected and executed batch counts. A Code node computes in-stage gaps and handoff gaps between consecutive stages, ignores intentional drops, detects batch shortfalls and invalid counts. An IF node routes suspicious executions to a report naming the first loss location and size, and healthy ones to a separate report, then results are merged. It does not read n8n logs automatically.

How it works

  1. 1.Manual Trigger starts the run
  2. 2.Code node emits four fictional summaries
  3. 3.Code node computes gaps, batch shortfall, validation errors and silent_loss
  4. 4.IF routes on silent_loss
  5. 5.Set builds SUSPICIOUS or HEALTHY report keeping all fields
  6. 6.Merge appends results and NoOp shows them

Use cases

  • Reviewing apparently successful executions after data-loss reports
  • Verifying batch loops completed

Requirements

  • Execution summary JSON prepared manually from the execution log
  • Mark filter stages with intentional_drop=true
  • No credentials needed

Setup and testing in n8n

  1. Import the JSON into n8n
  2. Run manually and inspect Audit Output
  3. Confirm exec-1002, exec-1003, exec-1004 are SUSPICIOUS and exec-1001 HEALTHY
  4. Change counts or remove stages to test edge cases

Service Value

Ready-made workflow template for automation delivery and service execution.

Apps Used

Manual Trigger Code If Set Merge No Op

Details

Trigger Manual trigger
Nodes 8
Apps 6
Views 69
Downloads 5

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 (8)

Start Manual Audit

Manual Trigger

#1

Emit Sample Execution Summaries

Code

#2

Compute Stage Gaps and Batches

Code

#3

Is Execution Suspicious?

If

#4

Build Suspicious Report

Set

#5

Build Healthy Report

Set

#6

Combine Audit Results

Merge

#7

Audit Output

No Op

#8

Note Input Schema

Sticky Note

#9

Note Detection Logic

Sticky Note

#10
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