← Back to blog

Automated a process with ChatGPT or Excel? Here's where the makeshift solution breaks

At some point you had a process that was eating your time - a weekly report, some data processing, messages sent to customers - and you figured, rightly, that there had to be a better way. You opened ChatGPT or set up an Excel file with formulas and maybe a macro, linked a few steps together, and it worked. The process moved faster, and you solved a problem without waiting for a budget, a vendor or approvals.

That's not a mistake. It's exactly the right instinct for a business owner looking for solutions with what's on hand. And you're not alone: more and more business owners, at companies of every size, are trying to automate repetitive processes with the tools they already use. The trouble comes later, when the solution you built starts to creak - and usually you can't tell right away why.

This article shows where automation with ChatGPT or Excel breaks down, why it happens and how to recognize the point where you've outgrown the tool. The goal isn't to tell you that you did it wrong. It's to show you where these tools stop, before a mistake costs you.

For some perspective: a 2025 MIT report looked at hundreds of AI initiatives in companies and found that, despite tens of billions of dollars invested, the vast majority of organizations get no business results from them, precisely because these solutions are fragile and don't fit the way work actually gets done. In other words, if the solution you built has started to let you down, you're not an isolated case. More often than not, it's a pattern.

Why ChatGPT and Excel look like the right answer at first

Before getting into where they break, it helps to see why they work at first - because they do work, no question about it.

ChatGPT and Excel are right there, you already have them, they cost next to nothing extra and you don't depend on anyone to use them. You can shape them quickly: write an instruction, build a formula, link two columns and get a result in minutes. For a simple process, that really is enough for a good while. You get speed right away, with no investment and no waiting.

That's exactly why they're the natural choice. A business owner short on time isn't looking for the perfect solution, just the one that gets them unstuck today. ChatGPT and Excel do exactly that. Starting with them isn't the problem. The problem is that these tools were designed for something other than carrying a business process that repeats day after day, month after month - and you only see that later.

Where the makeshift solution starts to break

Things don't get complicated with an announcement. The solution doesn't suddenly stop. It starts making mistakes here and there, needing more and more attention, depending on more and more things that all have to go right at the same time. Here are the three ways that happens.

Hidden errors that cost money

The most dangerous problem is the one you can't see. An Excel formula that pulls from the wrong cell after you inserted a row. A ChatGPT answer that looks right but contains a made-up number or misreads an unusual input. These mistakes don't stop the process, which makes them far more expensive - they slip into invoices, reports and decisions, and you find them late, after the damage is done.

A marketing specialist would call this functional risk: the solution doesn't perform the way you expect, but because it seems to work, nobody checks. The more the process touches money or customers, the more a silent error costs you.

The time maintenance swallows

A makeshift automation works perfectly on the day you build it. Then something around it changes: the supplier who sends you data changes the file format, an app changes how it responds, someone adds a new column, ChatGPT gets an update and starts answering differently. Each time, something breaks, and you or someone on your team has to step in and fix it.

So the solution that was supposed to save you time ends up eating it - not all at once, but in small, repeated fixes that are hard to predict. These solutions fail because of fragile workflows and a poor fit with day-to-day operations. They're built on sand, and sand shifts.

Everything depends on one person

The third problem is the hardest to spot. A homemade solution usually lives in one person's head - yours, or the employee who built it and knows how it's wired, what each step does and where to look if it breaks. As long as that person is around and remembers, everything seems fine.

But if they leave the company, go on vacation or simply forget a detail a few months later, you're left with a mechanism nobody understands anymore. There's no documentation, no one to take it over, no system - just a personal build you can't hand off. For a company that wants to grow, that dependence on one person is a hidden weak spot.

Why this happens

All three problems have the same root: ChatGPT and Excel weren't designed as process systems. They're general-purpose tools, very good at what they do - Excel is a calculation tool, ChatGPT is an assistant that understands and produces text, among other things. Neither was built to carry, unsupervised, a business process that runs indefinitely, with inputs that change and a lot riding on the result.

If you want to understand the difference between the types of solutions, we explained in detail the difference between a chatbot, a deterministic agent and an AI agent.

A system built for a process has stable rules, catches exceptions, flags when something is off, can be checked and can be handed over to someone else. A makeshift solution has none of these safety nets. It works as long as everything around it stays the same and the person who remembers how it works is around. Otherwise, it's exposed.

There's also a common thinking trap here. A makeshift solution seems free, because you didn't pay anything visible for it. But its cost isn't in the purchase price. It's hidden elsewhere: in maintenance time, in errors caught too late, in the risk of getting stuck. Specialists call this total cost of ownership - what a solution really costs you over the whole time you use it, not just up front. Seen that way, free at the start can turn out more expensive than it looks.

How to tell you've outgrown the tool

Not every makeshift automation needs replacing. Plenty of simple processes live happily for years in an Excel file with a few formulas, without causing headaches. The question isn't whether your solution is good or bad, but whether you've passed the point where the tool is still enough. Here are a few signs that you have:

  • You regularly spend time fixing something that should run on its own;
  • You've already found at least one error that reached a customer or an important report;
  • The process has stopped at some point because one person was missing or didn't remember how it worked;
  • Only one person can explain how the solution is built;
  • As the company grew, the solution started struggling with higher volume;
  • You rely on it for something that matters - money, compliance, customers - but have no way to check that it works correctly every time.

If you recognized yourself in two or more of these situations, it doesn't mean you did something wrong. It just means your process has grown beyond what a general-purpose tool can carry, and it's worth thinking about it differently - as a system built for that process, not a workaround kept alive with effort.

Frequently asked questions

Can I automate a process with ChatGPT?

Yes, up to a point. ChatGPT handles one-off text tasks well - summaries, drafts, replies. The limit shows up when you want that to become a stable process that runs on its own, with changing inputs and results you need to be able to rely on. That's where fragility and hard-to-catch errors come in.

Why doesn't Excel automation work in the long run?

Excel works great for calculations and simple workflows, but a macro or a file full of complex formulas is sensitive to any change: an inserted row, a new column, a changed format. Each change can quietly break a formula, and the resulting errors are hard to notice. Over time, maintenance ends up costing more than it saved.

How do I know if my makeshift solution is still good enough?

Look at three things: how much time you lose fixing it, whether it has already caused errors with consequences, and whether it depends on a single person. If any of the answers worries you, you've probably outgrown the tool.

Isn't a professional solution just an extra expense?

It has a visible cost, that's true. But the right comparison isn't with zero. It's with the hidden cost of the makeshift solution - maintenance time, errors, the risk of getting stuck. Looked at as a total cost over the whole time you use it, the math often changes.

Why do so many companies get it wrong when they automate on their own?

Because they put a general-purpose tool to work on a job that needs a system built for the process. The 2025 MIT report shows that most AI initiatives in companies produce no results for exactly this reason: fragile workflows and a poor fit with how work is actually done.

In place of a conclusion

If you automated a process with ChatGPT or Excel, you did something good: you looked for a more efficient way with the means you had. These tools often take you surprisingly far. But only up to a point.

Beyond that point - when errors slip in silently, when maintenance eats your time, when everything hangs on one person - a better tool won't fix it. You need to look at the problem differently: as a process that deserves a system built for it, one that's stable, can be checked and doesn't depend on anyone's memory. Only you can say where your process is on that road. What matters is knowing the road exists and recognizing the signs when they show up.