Workflow automation
Connect your email, CRM, spreadsheets and accounting so the tasks at the top of your list run on their own.
ExplorePlaybook · Automation
Ask any owner which tasks they'd happily never do again and the list comes quickly. Choosing which one to automate first is harder. Here is a simple two-week method for finding the business processes worth automating, ranking them and proving the result.
Your first automation sets the tone. If it saves real time and works reliably, your team trusts the next one. If it targets something rare, messy or political, it stalls, and automation gets filed under "tried that, didn't work."
The goal of the first project is not to automate the most impressive thing. It is to automate something that happens often, follows clear rules and costs you every week. That is a less exciting brief, and it is the one that works.
Memory is a poor guide to where time goes. The tasks that feel painful are often the rare, stressful ones. The real drain is usually the five-minute job done many times a week that nobody thinks about anymore.
For two weeks, ask everyone on the team (including you) to keep a simple running list. A shared spreadsheet works fine. For each recurring task, note:
Two weeks is long enough to catch the weekly jobs and short enough that people keep it up. For monthly or quarterly work like month-end reporting, add it from memory and mark how often it happens.
Don't filter while you collect. "Copying addresses out of emails" belongs on the list as much as "building the quarterly report." Small tasks are where the surprises are.
Once you have the list, score each task from 1 (low) to 5 (high) on five factors. You are not after precision. You are looking for the tasks that stand out.
How often does it happen? Daily tasks beat monthly ones, because every minute saved repeats.
How long does it take each time, including switching between apps and checking the result afterwards?
What happens when it goes wrong? A mistyped invoice amount, a lost lead or a missed deadline costs more than a misfiled photo.
Could you write down how to do it on one page? If two people on your team would handle the same case the same way, the rules are clear. If the answer depends on who you ask, they aren't clear yet.
Is the information the task needs already in a system, an email or a document? Or does it live in someone's head?
Add up the five scores and the highest totals become your shortlist. Then apply one sanity check: any task that scores 1 or 2 on rule clarity or data availability moves down the list, however high its total. A low score there means the process needs work before it can be automated.
If two tasks end up close, break the tie with two questions. Which one does your team complain about more? And which one touches customers? A task people are glad to hand over gets adopted faster, and a task that speeds up a customer's experience (a faster reply, a quicker invoice, a reminder that prevents a no-show) tends to show its value sooner than a purely internal one.
The table below is an illustrative example for a fictional small service business. The tasks and scores are made up to show how the method works. Your own list will look different.
| Task (example) | Frequency | Time each | Error cost | Rule clarity | Data available | Total |
|---|---|---|---|---|---|---|
| Entering supplier invoices into accounting | 4 | 3 | 4 | 5 | 5 | 21 |
| Replying to new website inquiries | 5 | 3 | 4 | 4 | 4 | 20 |
| Sending appointment reminders | 5 | 2 | 3 | 5 | 5 | 20 |
| Building the weekly sales report | 2 | 4 | 3 | 4 | 4 | 17 |
| Chasing unsigned estimates | 3 | 2 | 3 | 4 | 4 | 16 |
| Annual insurance renewal paperwork | 1 | 5 | 4 | 3 | 3 | 16 |
| Deciding which jobs get a discount | 2 | 3 | 5 | 1 | 2 | 13 |
Look at what happens. Invoice entry and inquiry replies rise to the top: they're frequent, rule-based, and the data is already sitting in emails and PDFs. Discount decisions score high on error cost but low on rule clarity, so they stay with a person. The insurance paperwork is painful, but it happens once a year, so an automation would likely take longer to build and maintain than it would ever save.
Score with the person who does the task, not only the person who manages it. They know the exceptions, the workarounds and the step that always takes longer than it should.
The best first automations are usually the dullest items on the list: data entry, reminders, filing, routing and status updates. That isn't a coincidence. Boring tasks tend to be frequent, rule-based and low-drama, which is exactly what makes them easy to automate well and easy to check.
Starting boring also builds the habits bigger projects need: clean data, clear rules, an exception path and someone who owns the result. Once invoice entry runs on its own, your team has seen how automation behaves, and the next project (perhaps an agent that drafts replies to customers) is a much smaller leap.
Good boring candidates include:
Your shortlist will usually split into two kinds of project.
Quick wins connect two or three systems around a single, well-defined task. Appointment reminders, form-to-CRM entry and overdue invoice alerts are typical. They're small in scope, show results early and carry little risk.
Foundational projects change how information flows through the business: one customer record that every tool reads from, a document pipeline that every invoice and form passes through, or an agent that handles the shared inbox. They take longer and need more planning, but they make every later automation easier.
A sensible plan usually starts with one quick win to build confidence, then commits to one foundational project. Avoid stacking up quick wins that each patch a different symptom of the same messy process. If several tasks on your list exist only because customer data lives in three places, fixing that is the real win. Our workflow automation projects often begin with exactly this kind of mapping.
Some tasks look like good candidates and aren't. Watch for these.
If the task is slow because the process itself is confused (unclear ownership, steps nobody agrees on, approvals that go missing), automation only makes the confusion faster. Fix the process on paper first, then automate the fixed version.
A job that happens a few times a year rarely repays the effort of building, testing and maintaining an automation. A checklist or a template is often enough.
Pricing exceptions, hiring decisions, delicate client conversations: if you can't describe how the decision gets made, software can't make it reliably. AI can help a person prepare by summarizing the history or drafting options, but the decision should stay with the person.
If the task depends on what one long-time employee remembers about each client, the first project is writing that knowledge down, not automating around it.
If the process is still being worked out, wait until it settles. Automating a moving target means rebuilding it over and over.
You can't show an automation worked unless you know what things looked like before it. Before anything is built, record a baseline for the task you chose:
After launch, measure the same things the same way for a few weeks. Add one new number: how many items the automation flagged for a person, and why. A steady stream of the same exception tells you where the rules need tightening.
Be honest in the comparison. Count the time people now spend reviewing and approving, not just the time the automation saves. A good result is still a good result after that subtraction, and an honest number is the one that convinces your team to do the next project.
If you'd like help running this exercise, it is the core of our free workflow audit: we sit with the people doing the work, list the tasks and score them together. See how our process works, or book a free workflow audit.
Keep reading
Connect your email, CRM, spreadsheets and accounting so the tasks at the top of your list run on their own.
ExploreWhen a task needs reading and judgment, not just fixed rules, an agent may be the right tool.
Read the guideInvoices, forms and PDFs are often the best first project. See how they become clean data.
ExploreFree workflow audit
We'll map your recurring tasks with the people who do them, score each one and tell you plainly which to automate first, which to fix first and which to leave alone. No cost, no obligation.
or email tom@columbusinnovate.com