The report you rebuild every Monday morning

The clearest automation brief I ever get sounds like a complaint, not a spec: "every Monday I spend an hour pulling numbers from three places into one spreadsheet, and then I email it." That sentence alone is enough to quote from.

Why these are easy wins

Recurring reports are usually built from data that already exists somewhere — a bank feed, a CRM export, an analytics dashboard, a shared inbox. The work isn't collecting the numbers, it's the manual stitching: opening tabs, copying cells, checking nothing moved, formatting it so it looks the same as last week's.

That stitching is exactly what software is good at and people are bad at — not because people can't do it, but because doing it right every single week, forever, with zero errors, is a genuinely unreasonable thing to ask of a human.

What "automated" actually means here

Usually not a fully unattended pipeline with alerts and dashboards — that's a bigger, different project. Usually it means: one button, or one scheduled email, that produces the exact document someone used to build by hand, with the same numbers in the same places. Boring on purpose. The goal is to delete an hour, not to impress anyone with the architecture.

If you can describe your report as "the thing I copy into the same template every week," you already have the spec. The rest is just building it.