Silent Item Loss Auditor for Execution Stage Counts
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.Manual Trigger starts the run
- 2.Code node emits four fictional summaries
- 3.Code node computes gaps, batch shortfall, validation errors and silent_loss
- 4.IF routes on silent_loss
- 5.Set builds SUSPICIOUS or HEALTHY report keeping all fields
- 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
- Import the JSON into n8n
- Run manually and inspect Audit Output
- Confirm exec-1002, exec-1003, exec-1004 are SUSPICIOUS and exec-1001 HEALTHY
- Change counts or remove stages to test edge cases
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 (8)
Start Manual Audit
Manual Trigger
Emit Sample Execution Summaries
Code
Compute Stage Gaps and Batches
Code
Is Execution Suspicious?
If
Build Suspicious Report
Set
Build Healthy Report
Set
Combine Audit Results
Merge
Audit Output
No Op
Note Input Schema
Sticky Note
Note Detection Logic
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