The question that gets skipped when automation comes up: does automating this task actually pay off?
The answer is not always yes. Automation has a setup cost and a maintenance cost — when the rules change, the flow has to change too.
The maths is simple
Three numbers decide whether a task is worth automating:
- 01How long it takes — minutes per run
- 02How often it repeats — times per day or week
- 03How clear the rule is — are there exceptions, does it need a human decision
Multiply the first two and you get the monthly loss. The third tells you whether it can be automated at all: automating a task full of exceptions creates a new control burden instead of removing work.
The tasks that pay off most
In my experience three kinds return the clearest result:
- Moving data — reading from one system and writing to another. Clear rule, no exceptions.
- Notifications — telling someone when something happens. Expensive when missed, cheap when automated.
- Regular reports — merging the same tables every month. Boring, so it gets postponed, and it piles up.
The tasks that pay off least
- Things done once a month — the setup cost never comes back
- Tasks with many exceptions — writing a rule for each takes longer than doing it by hand
- Tasks that need a human decision — automation cannot decide, it only applies the decision
Where to start
Write down the tasks you repeat over one week. Usually three to five come up, and one is clearly more expensive than the rest. Start with that single task.

