Business ops

2 Missing, 2 Extra, 2 Changed: A Free n8n Count Check Emails One Daily Order Report, Even on Clean Days

  • Level Advanced
  • Setup1–3 hrs (estimated)
  • Evidence Some evidence
  • CostNot stated in source
  • No-codeNo
n8nSource-linkedNeeds verification

What they did

This n8n workflow runs every morning at 7:00, reads yesterday's orders at a source and a destination, matches them by order ID and sends one email listing missing, extra and mismatched rows. The test email showed 2 missing, 2 extra (including a duplicate) and 2 changed, like an amount of 245 becoming 254. It sends on clean days too, so if the email stops arriving you know the check itself broke. The builder shared the full JSON free.

How it went

One daily email showing exactly which orders didn't sync correctly.

Worth knowing

  • Tested only on n8n Data Tables, per the post; swap in your own systems carefully. Turn on 'Always Output Data' or the check can go quiet.

Prompt

Cleaned version rewritten from the source — not a direct quote.

Every morning at 7, compare yesterday's orders in [source system] with [destination system] by order ID. Email me one report: orders missing at the destination, orders only at the destination, and orders where amount or status differ. Send the email even when everything matches.

Recommended

Try it in Grok Bot

Grok Bot can compare two order lists daily and email you the differences.

  1. Copy the prompt (button below).
  2. Open Grok Bot chat and paste it. Replace any [bracketed] placeholders.
  3. Connect the listed tools (Email) as connectors when Grok Bot asks.
  4. If the task repeats, ask: "Make this a daily routine."

Alternatives: the same prompt works in n8n, Claude, ChatGPT Agent, OpenClaw.

Set it up

Tools: Email · Stack: n8n + Data Tables + SMTP email

  1. Read the original source for full context.
  2. Connect the tools your agent needs.
  3. Paste the prompt and replace [bracketed] placeholders.
  4. Run once manually and check the output before scheduling it.

Generic suggested steps, not from the source.

Evidence

n8n community post with free JSON: daily 07:00 compare, missing/extra/different lists, sends on clean days, 2-hour write margin, Always Output Data explained

Source: Web · 2026-10-22 · Verified by us: not yet · Report broken or outdated

Related use cases

Inbox & communicationReddit

6-class email router for a 22-person consultancy

An IMAP trigger feeds an OpenAI classifier that routes 80–120 emails a day to Slack, Pipedrive and Zendesk. It hit 94% accuracy on 500 emails and saves 11 hours a week.

  • Level Intermediate
  • Setup1–3 hrs*
  • Evidence Some evidence
n8nSource-linked
MoneyReddit

Invoice capture for a distributor: 4m12s down to 38s each

A shared Gmail label feeds an extractor, totals are validated to €0.01, low-confidence fields go to a human, and results push to Sage. 87% need no human touch.

  • Level Intermediate
  • Setup1–3 hrs*
  • Evidence Some evidence
n8nMakeSource-linkedNeeds verification