Most growing businesses do not run on software. They run on spreadsheets.
A file for inventory. Another for orders. A third that someone rebuilds every month for reporting. It works — until it doesn't. Version conflicts, broken formulas, hours lost to copy-paste, and a nagging sense that the numbers are never quite right.
The usual advice is "get a system." But a full ERP is expensive, disruptive, and — for a lot of businesses — overkill. So the spreadsheets stay, and the manual work stays with them.
There is a middle path: targeted automation. Instead of ripping out how you work, you remove the painful parts of it. Here is how to think about it.
Start With Where Time Actually Leaks
Automation goes wrong when you try to automate everything at once. It goes right when you find the two or three tasks that quietly eat hours every week.
Look for work that is repetitive, rule-based, and frequent:
- Re-typing data from one place into another (emails into a spreadsheet, invoices into accounting)
- Consolidating several files into one report
- Chasing people for updates, approvals, or payments
- Copying the same numbers into a dashboard every Monday
If a task follows a rule and happens more than a few times a week, it is a candidate. If it needs real human judgement every time, it usually is not.
You Can Keep the Spreadsheet
This is the part most business owners do not expect: automation does not mean abandoning Excel or Google Sheets. In many cases we automate around the spreadsheet.
- A form that writes clean, validated rows straight into your sheet — no more broken manual entry
- A script that pulls data from several files and produces the consolidated report automatically
- Reminders that fire when a value crosses a threshold (stock low, invoice overdue)
- An AI step that reads incoming invoices or receipts and fills in the fields for you
The team keeps working the way it already knows. The busywork just disappears in the background.
Where AI Fits
"AI automation" sounds abstract until you attach it to a real task. In practice, AI is very good at the messy step that traditional automation could never handle: understanding unstructured input.
Reading a PDF invoice and extracting the totals. Sorting incoming messages by intent. Drafting a first-pass reply. Summarising a pile of documents. Answering routine customer questions from your own knowledge base. These are the steps that used to require a person — and are now cheap to automate.
Paired with ordinary workflow automation, AI turns "a human has to look at this first" into "the system handles the standard cases and only escalates the odd ones."
A Sane Rollout
You do not need a six-month project. A good automation rollout looks like this:
- Audit. Find the highest-impact, lowest-risk task — usually the one everyone complains about.
- Pilot. Automate that one thing and measure the hours saved.
- Expand. Once it is proven, move to the next task.
Each step pays for itself before you commit to the next. That is the opposite of a big-bang system implementation, and it is why it works for smaller businesses.
When You Have Outgrown Spreadsheets
Sometimes the honest answer is that spreadsheets really are the bottleneck, and it is time for a proper system. If you are constantly reconciling data between files, or you cannot answer basic questions about your business quickly, that is the signal. At that point a well-implemented Odoo or custom ERP is the right move — and even then, you migrate in stages, not overnight. For a fuller view of measuring whether that investment paid off, see our note on digital transformation ROI.
But most businesses are not there yet. They just need the manual grind taken off their plate.
The Takeaway
Spreadsheet chaos is not a sign you need to spend big. It is a sign that a handful of repetitive tasks have quietly grown past what manual work can handle. Automate those, keep what works, and you get most of the benefit of a "system" without the cost or the disruption.
That is exactly the kind of work we do at CERIS. If your team is drowning in manual steps, book a free automation audit and we will find the ones worth removing first.
