Book a free audit
  1. Home
  2. Insights
  3. What to automate first

Playbook · Automation

What to automate in your business, and what to automate first.

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.

What to automate first, and why the choice matters

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.

Step 1: List your recurring tasks for two weeks

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:

  • What the task is, in one sentence ("enter supplier invoices into QuickBooks")
  • Roughly how long it takes each time
  • How often it came up
  • Which systems were involved: email, CRM, spreadsheet, accounting, a supplier portal
  • What went wrong, if anything: a typo, a missed follow-up, a late reply

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.

Step 2: Score which business processes to automate

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.

Frequency

How often does it happen? Daily tasks beat monthly ones, because every minute saved repeats.

Time per instance

How long does it take each time, including switching between apps and checking the result afterwards?

Error cost

What happens when it goes wrong? A mistyped invoice amount, a lost lead or a missed deadline costs more than a misfiled photo.

Rule clarity

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.

Data availability

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.

An example scoring table

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.

Illustrative example: five-factor automation scores for a fictional service business
Task (example)FrequencyTime eachError costRule clarityData availableTotal
Entering supplier invoices into accounting4345521
Replying to new website inquiries5344420
Sending appointment reminders5235520
Building the weekly sales report2434417
Chasing unsigned estimates3234416
Annual insurance renewal paperwork1543316
Deciding which jobs get a discount2351213

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.

Start boring

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:

  • Moving information from forms and emails into your CRM, and sending follow-ups on time (see CRM and follow-up automation)
  • Reading invoices, receipts and intake forms into structured data (see document processing)
  • Reminders that go out on a schedule
  • Weekly reports assembled from several systems
workflow · invoice-entry● running

    Quick wins vs foundational projects

    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.

    Red flags: what not to automate yet

    Some tasks look like good candidates and aren't. Watch for these.

    A broken process

    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.

    Low-volume tasks

    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.

    Judgment with no rules

    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.

    Knowledge that lives in one head

    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.

    Steps that change every month

    If the process is still being worked out, wait until it settles. Automating a moving target means rebuilding it over and over.

    Measure results before and after

    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:

    • How many times it happens in a typical week
    • How long it takes each time, timed on a few real examples rather than guessed
    • How often it goes wrong, and what kind of errors happen
    • How long customers or colleagues wait, for example the time from inquiry to first reply

    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.

    A checklist for choosing your first automation

    • We listed recurring tasks for two weeks, including the small ones
    • We scored each task on frequency, time per instance, error cost, rule clarity and data availability
    • Our first choice happens at least weekly and follows rules we can write down
    • The data it needs is already in a system, an email or a document
    • The process works on paper before we automate it
    • We know which steps need a person's approval, and who that person is
    • We recorded a baseline: volume, time per task, error rate and wait time
    • We agreed what "working" looks like and when we'll check

    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

    Related guides and services

    Free workflow audit

    Let's score your list together.

    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