What to automate first: 5 workflows every growing business should put on autopilot

Automation isn't only chatbots. These five workflows (lead logging, inbox to pipeline, KPI trackers, monthly reports and reminders) save hours every week.

When people hear “AI automation”, they often picture a chatbot. But for many growing businesses, the biggest wins are quieter. They’re the copying, chasing and report-building that eats hours every week and still leaves managers unsure what’s going on. Nobody puts “copy leads from WhatsApp into a spreadsheet” on a job description, yet somebody does it, every week, usually when they’d rather be doing something else.

These are the five workflows we recommend automating first, in roughly this order. Several of them can run on Google Workspace, which many businesses already pay for, so you don’t need a big budget to start.

1. Every lead in one place, automatically

The problem: Enquiries arrive through the website form, the sales inbox, social media DMs and phone calls. Nobody has the full list, and some leads are never followed up. When the manager asks how many enquiries came in last month, the honest answer is “I’d have to check”.

The workflow: Every form submission lands in one Google Sheet automatically, with the date, source and what they asked about. The right person gets an email or chat notification straight away. Leads from calls and DMs are added through a short form, so they end up in the same sheet.

Why first: You can’t improve follow-up, or measure marketing, until every lead is counted. It’s also the quickest one to build, which gives you a visible win.

2. Inbox to pipeline

The problem: For businesses that sell through quotes, the real pipeline lives in email: requests for quotes, quotes sent, payment confirmations, purchase orders, delivery notes. To find out where a deal stands, someone has to dig through threads, and the person who knows is often on leave.

The workflow: A small Apps Script reads the sales inbox on a schedule, recognises each type of email by keywords, and logs it against the right deal and stage. AI can help by tagging which product or category an enquiry is about.

Why it matters: Managers see every deal from enquiry to delivery without asking anyone, and nothing quietly stalls. It also means the pipeline stays up to date without anyone having to remember to update it.

3. KPI trackers people will actually fill in

The problem: Targets live in meetings. Each person tracks their work differently, if at all, and month-end means chasing updates.

The workflow: One simple tracker per role or department, with:

  • dropdowns for fixed options (status, category, yes or no), so data stays clean
  • plain text only where it’s needed, such as names and notes
  • real dates, not text that looks like a date
  • a new tab each month, with the previous month archived automatically
  • targets that calculate progress on their own

Each tracker feeds a management dashboard, using IMPORTRANGE or a script, so leaders can see the whole business in one place.

A tip: Keep the trackers about KPIs only. Mixing in bonus calculations makes them harder to agree and less likely to be filled in honestly. And keep them short. A tracker that takes five minutes gets filled in. One that takes thirty gets avoided.

4. The report that writes itself

The problem: Someone spends half a day every month pulling numbers from different tools into a report that’s out of date as soon as it’s sent. By the time it reaches the people who need it, the decisions have already been made without it.

The workflow: A script collects the numbers from your trackers, email platform and ad accounts into one summary sheet, then emails it to the right people every Monday or on the first of the month. AI can draft a short plain-English summary of what changed, for a person to check before it goes out.

5. Reminders that don’t rely on memory

The problem: Quotes go unanswered, renewals slip past, and follow-ups depend on someone remembering. Memory works well until the week gets busy, which is exactly when a follow-up matters.

The workflow: Your tracker checks dates every morning. If a quote has had no update for three days, or a renewal is due in two weeks, the owner gets a reminder. You can also send customers a polite automated email, but a personal follow-up from a real person usually works better for big decisions.

How to choose your first workflow

Ask two questions about each task your team does by hand:

  1. How many hours a month does it take?
  2. What goes wrong when it’s done late or not at all?

Start with the task that scores highest on both. Build it, live with it for a month, then add the next. Automation works best in small, reliable steps, not one giant system nobody understands.

Mistakes we see

  • Automating a messy process. If the steps aren’t clear when a person does them, a script will only do the confusion faster. Tidy the process first.
  • Building something only one person understands. Write down what the automation does and where it runs, so it can survive someone leaving.
  • Skipping the check. Look at the output after the first week. Automations fail quietly, and nobody notices until a number looks wrong.
  • Starting with the exciting one. The chatbot is more fun to talk about than lead logging, but it’s lead logging that gets you the numbers.

A note on tools

Expensive software isn’t needed to start. Google Sheets, Forms, Gmail and Apps Script cover a surprising amount. Make, Zapier and n8n connect tools that don’t talk to each other. A CRM makes sense once your team and pipeline outgrow spreadsheets, and it’s much easier to adopt when your stages and data are already clean.


Want help choosing where to start? Our Automation Sprint maps one process with you, builds it on your accounts and hands it over with a written guide. Or tell us what’s taking up your team’s time.

Quick answers

What should a small business automate first?

Five workflows are a good start: logging every lead in one place, moving inbox enquiries into a pipeline, KPI trackers people will actually fill in, monthly reports that write themselves, and reminders that do not rely on memory.

How do I choose my first workflow to automate?

Ask two questions about each task your team does by hand: how many hours a month it takes, and what goes wrong when it is done late or not at all. Start with the task that scores highest on both.

Do I need special software to automate these?

Not always. Several of these workflows can run on Google Workspace, which many businesses already pay for.

Free resource

Find your funnel leaks in 20 minutes

Get the Funnel Leak Checklist: 25 quick checks across your whole customer journey, with a simple score so you know what to fix first.

By submitting this form, you agree to be added to our mailing list. We'll send your free checklist, news of new free tools and one practical selling tip every two weeks. You can unsubscribe in one click. See our privacy policy.

Free checklist

Where are your leads slipping away?

By submitting this form, you agree to be added to our mailing list. We'll send your free checklist, news of new free tools and one practical selling tip every two weeks. You can unsubscribe in one click. See our privacy policy.