We Stopped Copying Google Form Responses by Hand. Here’s What We Did Instead.

There’s a big difference between a process being digital and a process actually being efficient.

I was reminded of that recently while looking at a process built around Google Forms and Google Sheets.

Thanks for reading Behind the Service Call! Subscribe for free to receive new posts and support my work.

On the surface, it seemed pretty streamlined.

Someone filled out a Google Form. Their answers went into a spreadsheet. Everything was online. No paper forms. No filing cabinets.

But then a person had to take the information from that response sheet and copy it into another spreadsheet where the team actually worked.

When the person moved further along in the process, their information had to be moved again.

When they reached onboarding, they filled out another form with additional information. That landed in another response sheet. Someone then had to take those answers and get the right information into the right places.

The business had gone digital.

The manual work was still very much alive.

The problem wasn’t Google Forms

This is important because the answer wasn’t, “We need to get rid of Google Forms.”

The forms were doing their job just fine.

The problem was everything happening between the forms and the places where the team needed the information.

The workflow looked something like this:

Person fills out a form → response lands in a spreadsheet → team member copies the information → working pipeline gets updated → person reaches another stage → information gets moved again → another form is sent → new responses come in → someone updates more spreadsheets.

None of those individual steps sounds terrible.

That’s probably why processes like this survive for so long.

But multiply a few minutes of copying and checking by dozens or hundreds of people. Add in the possibility of pasting something into the wrong row, forgetting to update one tab, or having two versions of the same information in different places.

Suddenly, a fairly ordinary process is eating up a lot more time than anyone realizes.

This is where I brought in ChatGPT

Not to write an email.

Not to summarize a meeting.

Not to give me a formula I could paste into a spreadsheet.

I used it as a partner to help me rethink the workflow itself.

I explained what was happening now, where the information started, where it eventually needed to go, what the team needed to be able to see and manage, and what changed as someone moved through the process.

Then we started working backward from the question:

Why are people moving this information at all?

That question changed the project.

Instead of asking how to make the copying faster, we started asking how much of the copying could disappear.

What the new process does

The Google Forms can still exist.

The difference is that the information collected through them now automatically feeds into the working system instead of sitting in a response sheet waiting for someone to move it.

The initial form data can populate the enrollment pipeline automatically.

As someone progresses, their information can flow into the places where the team needs it for onboarding, scheduling, rosters, or session management automatically.

Additional information collected later can be connected back to that same person automatically, instead of creating another disconnected set of answers someone has to reconcile.

In one part of the system, simply adding a person’s email address to the roster can pull their existing information into the appropriate fields.

The team still makes decisions.

The team still manages the process.

But the team doesn’t have to spend nearly as much time acting as the bridge between one spreadsheet and another.

And that distinction matters.

AI doesn’t have to replace the software you already use

I think this is one of the biggest misconceptions about using AI in a small business.

People hear “AI” and assume they need entirely new software, some elaborate AI platform, or a developer building custom technology behind the scenes.

Sometimes you might.

A lot of the time, you don’t.

You may already have most of the tools you need.

The opportunity is figuring out how they should work together.

In this case, Google Forms and Google Sheets weren’t the problem. The problem was that the original system had been built one step at a time.

“We need to collect this information. Make a form.”

“We need somewhere to manage these people. Make a spreadsheet.”

“We need more information before their session. Make another form.”

Each decision made sense on its own.

Over time, though, you end up with employees carrying information from one piece of the system to another.

That’s where AI can be incredibly useful.

Not because it magically knows how your business should operate, but because you can give it the whole messy process and work through it together.

The hard part usually isn’t the technology

Once we identified what was actually happening, there were several ways we could have approached the solution.

That’s the part I think gets missed when people talk about using AI in business.

AI can help build things. Automation tools can connect things. Spreadsheets can do far more than most businesses realize.

But first, somebody has to understand the business process well enough to know what should happen.

Automating a bad process just gives you a faster bad process.

So before I start thinking about which tool might fix something, I want to understand where information comes from, who needs it, what decisions have to be made along the way, and where people are spending time doing things that don’t actually require their judgment.

That’s often where the biggest opportunities are hiding.

Look for the places where humans are acting like software

If you’re wondering where AI or automation could help in your own business, this is one of the first things I’d look for.

Where is someone:

• copying information from one system into another?

• entering the same customer information more than once?

• moving rows between spreadsheets?

• updating several places every time a status changes?

• taking information from an intake form and manually creating a job, customer record, estimate, or project?

• checking one list so they know what to update on another list?

• sending the same follow-up based on the same trigger over and over?

For a home service business, that could show up almost anywhere.

A customer fills out an estimate request, and someone retypes the information into another system.

A new employee completes onboarding paperwork, and someone manually creates the internal records.

A job is booked, and someone has to update a schedule, a customer tracker, and a follow-up list.

A technician submits information from the field, and someone in the office has to reorganize it before anyone can use it.

Those are the places worth paying attention to.

Not because every one of them should be automated.

But because every one of them deserves the question:

Does a person actually need to be doing this?

You don’t need to know the solution yet

I think this is where a lot of business owners get stuck.

They notice something is inefficient, but they don’t know what the fix is.

So they leave it alone.

You don’t have to know whether the answer is an automation, a better spreadsheet, a different workflow, or a completely different tool.

You just need to recognize that the process is costing more time than it should.

That’s the starting point.

Because the goal isn’t to add AI everywhere.

It’s to use it where it actually makes the business easier to run.

The bigger lesson

The most interesting part of this project wasn’t the spreadsheet.

It was seeing how easy it is for a business to live with a process that works well enough.

Nobody wakes up one morning and decides, “I’d like my team to spend part of every week copying information between spreadsheets.”

It happens gradually.

A form gets added here. A spreadsheet gets added there. Someone creates a workaround. The workaround becomes the process.

And eventually, no one questions it because that’s simply how the work gets done.

AI gives small businesses a new opportunity to question those systems.

You don’t need to start with some huge AI transformation.

Start by noticing one annoying process.

Especially the one everyone assumes has to be manual.

Where is someone copying information, updating multiple systems, chasing down the same details, or doing something manually simply because that’s how it has always been done?

You don’t have to know what the solution is yet.

Finding the right problem is usually the first step.

That’s also the kind of work I’m increasingly interested in: looking at the way a business actually operates, finding the places where unnecessary work has crept in, and figuring out where AI and automation can make the process better without making it more complicated.

Because the goal isn’t to add more AI to a business.

It’s to let technology handle the repetitive work so people can focus on the work that actually needs them.