When Your Business Outgrows Google Sheets, and What a Custom App Costs

Your orders, stock or invoices live in one Google Sheet. It's worked for years. Here's how to tell it now costs you more than an app would, what a first internal tool includes, and what we'd charge for it in hours and dollars.

6 min read
Cover for the guide to replacing Google Sheets with an app: a crowded spreadsheet with yellow and red cells turns into a clean order screen with statuses and team roles

Most small businesses run on a spreadsheet long after they meant to. Orders, stock, quality checks, invoices: one Google Sheet, a few tabs, and a person who knows which column not to touch.

That's not a mistake. A spreadsheet is free, everyone can open it, and it'll bend to whatever you need this week. The question is when it stops being the cheap option.

In a three-week slice of Upwork job posts we read this autumn, the same request kept coming back in different words. One business wanted a simple menu on top of their Google Sheet so staff would stop copying product codes by hand. Another wanted an order tracker with quality control. Four separate posts asked for the same thing: take invoices from PDFs and get them into QuickBooks without retyping. None of these people asked for an app. They asked for the spreadsheet to stop eating their week.

Signs the spreadsheet is costing you money

You don't need all of these. Two or three usually mean it's time to price the alternative.

  • The same data gets typed twice. From the sheet into the invoicing tool, from an email into the sheet, from one tab into another. Every copy is a chance for a typo, and somebody is paid to make it.
  • One person is the system. They built the formulas, they know why row 400 is yellow, and when they're on holiday nobody dares to change anything.
  • Everyone sees everything. A contractor who needs one column can read the whole sheet, prices and margins included, because sharing works on the file, not on the row.
  • Nobody knows who changed what. The version history exists, but finding out why a number moved last Tuesday takes an afternoon.
  • It's used on a phone in a warehouse or on a site. Tiny cells, accidental edits, a formula overwritten by a thumb.
  • Things that should happen automatically don't. A customer waits for a status update that someone has to remember to send.

When to keep the spreadsheet

If a handful of people use it, the data changes a few times a day, and nothing above sounds familiar, keep it. Spend the money on sales.

There are also cheaper steps before custom code. Protect the ranges people shouldn't edit. Put a Google Form in front of the sheet so data comes in one way. A no-code tool like Airtable or AppSheet can cover a lot, and it's the right choice while you're still working out how the process should run. We said the same about picking the tool for the stage you're in when building a product.

Custom code starts to pay off when the process has settled, the workarounds take more time than the work, and the monthly cost or the limits of the no-code tool begin to pinch.

What a first internal tool includes

An internal tool is a small web app that only your team uses. It doesn't need a marketing site, payments or a polished design. It just has to hold your data properly and let the right people do the right things with it, and that's a much smaller job.

  • The core. Your data laid out properly (orders, products, customers, whatever the tabs hold today), screens to add, find and update records, the import of what's in the sheet now, and an export back to a spreadsheet for the day someone wants one.
  • Accounts and roles. Everyone logs in as themselves, and each role sees only what it needs: staff their part of the work, a manager the totals.
  • An admin panel. Where you add people, change lists like product types or statuses, and fix a record without asking a developer.

It'll run in a browser on a laptop or a phone, so there's nothing to install.

What it costs

These are the hours behind our estimate calculator, at our rate of $40 an hour. The calculator shows a range of 15% either way, because estimates are estimates.

What you getHoursRange
Core internal tool only70$2,400 to $3,200
Core plus accounts and roles105$3,600 to $4,800
Core, accounts and an admin panel155$5,300 to $7,100
The same plus email notifications170$5,800 to $7,800
The same plus search and filters205$7,000 to $9,400

The third row is what the calculator suggests by default once you pick "Internal tool" in it. Add search and filters once there are thousands of records and scrolling stops working.

What the calculator doesn't price

Connections to other systems. Pulling invoices into QuickBooks, syncing stock with your store, sending orders to a carrier. Each one depends on the other system and on how clean your data is, so we'll price it separately once we've looked at both. Connections are also where things tend to break months later, for reasons we covered in what breaks in an API integration after launch.

Hosting. For a small team, budget roughly $20 to $100 a month for hosting, a database and email sending.

Changes after launch. Your team will find things the spreadsheet did that nobody wrote down. Keep part of the budget for the first month of real use; you'll need it. Later, small changes can run as a monthly block of hours at the same $40 rate.

How to move without stopping the business

  1. Write down what the sheet does, tab by tab. Who fills it in, who reads it, and what goes wrong. That list is your brief, and it's worth more than any feature wish list.
  2. Clean the data before the import. Duplicate customers, product codes typed three ways, dates as text. You'll pay less to fix them in the sheet than in code.
  3. Run both for a while. Keep the spreadsheet read-only next to the new tool until the team trusts the new numbers.
  4. Start with one process. Orders, or stock, or invoices. Not all three. The second one goes faster once the first is live.

If you're about to post the job and expect a pile of replies, how to choose a developer from 100 proposals covers what to ask.

The short version

A spreadsheet is the right tool until people start working around it. When the same data is typed twice, one person is the only one who understands the file, or the wrong people can see the margins, a first internal tool costs about $5,300 to $7,100 and takes 3 to 5 weeks by our calculator's numbers.

If you'd like to talk it through, book a free 20-minute call with us. Or send a description of your spreadsheet through the form and we'll answer within one business day.