An importable workflow that sorts records into ready, review and duplicate outputs while retaining the original values and reconciling the totals.
Get the workflow JSON · Quick start · Rules and data · Verification
Independent example · Fictional data · No credentials required · Verified with n8n 2.38.7
- Open workflow.json and download the raw file.
- Import it into a new n8n workflow.
- Click Execute workflow and open the output nodes.
The example uses a Manual Trigger and Code nodes. It runs without connecting an inbox, CRM or other external service.
| Output | Records | What it shows |
|---|---|---|
| Ready queue | 3 | Records that pass the example's checks. |
| Review queue | 4 | Incomplete, malformed or conflicting records. |
| Duplicate log | 1 | A repeated record with the same normalized fields. |
| Count and reconcile | 8 accounted for | Three ready + four review + one duplicate. |
Both versions of ID 002 go to review because their fields differ.
Each classified result includes original, normalized, changes and reasons. Open a queue to see the values and the decision.
IDs stay text. Surrounding whitespace is trimmed, and only the domain of an email address is lowercased. Basic email formatting is checked; ownership and deliverability are outside the example.
Matching IDs with identical normalized fields produce a duplicate record. Conflicting versions send the whole group to review. Unknown fields and malformed inputs are preserved for review.
Duplicate checks cover one run. A live import would also need a persistent check against existing records. Read the full rules and adaptation notes before connecting a real source.
The classifier tests use Node.js 24's built-in runner and need no packages:
git clone https://github.com/jackspiece/n8n-intake-example.git
cd n8n-intake-example
npm testnpm run build regenerates the export from the same classifier and fictional records. The verification guide explains the separate checks for the classifier and the actual seven-node n8n execution.
| File | Purpose |
|---|---|
| workflow.json | The importable n8n workflow. |
| classify.cjs | Classification and normalization rules. |
| example-records.json | The eight fictional inputs. |
| build-workflow.cjs | Generate the export from the source files. |
| check-execution.cjs | Check the actual n8n execution output. |
By jackspiece, under the MIT License. For a small automation project, open an enquiry with a redacted example. Scope, price and funding are agreed before client work starts. Keep private customer details out of public issues.