The Monday-morning job that runs itself: messy export in, clean report + alert out.
Before: the export your tools give you
orders.csv, exactly as the store spat it out
loading…
Spot the problems: three date formats, three currency notations,
duplicate rows from double-clicked exports, names in random casing.
Someone fixes this by hand every week. It takes an hour. It's error-prone. It's nobody's favorite job.
After: the report nobody had to make
…
To: you@yourshop.example · Subject: 📊 Weekly digest — auto-generated
…
How it works in production
Your export lands (email attachment, shared folder, or API) — the bot picks it up on a schedule.
Cleaning rules run: dedupe, normalize dates/currency/names, flag anything it can't fix for a human.
The report bakes and the digest lands in your inbox or Slack. Nobody opens a spreadsheet.