Online Store: CRM or Google Sheets - What to Choose
«A spreadsheet is enough for now» is the most common answer from a store owner, and often it is the right one. Google Sheets are free, flexible and familiar to everyone. But in e-commerce there comes a moment when a spreadsheet stops saving and starts costing - in lost orders, confusion over stock and hours spent consolidating. Let's look, specifically for an online store, at when a spreadsheet is still enough and when it is already slowing sales down.
When Google Sheets still work for a store
For a store at the start a spreadsheet is a smart choice. While you have up to 10-15 orders a day, one sales channel and one or two managers, a spreadsheet covers everything: the order list, contacts, simple accounting. You pay nothing, change the structure in a minute and don't depend on a developer. At this stage rolling out a CRM is premature - it's a cost with no real return.
A spreadsheet also handles simple analytics well: totalling monthly revenue, seeing top products, adding up costs. If the processes are simple and stable and the volume does not grow explosively, a store can run on a spreadsheet for years with no real problems. The key is to honestly see the line beyond which it stops coping, and not cling to it out of habit once it already hurts.
A spreadsheet has another strong side at the start - a zero entry threshold for the team. Any manager can work with rows and columns, there's no one to train and nothing to roll out. For a store that has just launched and is still searching for its model, this flexibility is worth more than any structure: one process today, another tomorrow, and the spreadsheet obediently adapts without reworking a system.
Where spreadsheets actually break in e-commerce
Problems in a store appear not from the number of rows but from the specifics. First - multiple sales channels. Orders from the website, Instagram, a marketplace and Telegram are merged into one spreadsheet by hand, and sooner or later something gets duplicated or lost. Second - stock. A spreadsheet does not reserve items: two managers sell the last unit at the same time, and one of the customers gets a refusal after they've already paid.
Third - statuses and deadlines. A spreadsheet does not show that an order has sat unprocessed for its third hour, nobody reminds about an unpaid reservation or nudges the customer to collect the parcel before storage expires - and that is a direct loss on redemption. Fourth - collaboration. When several people edit one file at once, you get overwritten rows, accidental deletions and the «but mine looked different» version. At volume each of these trifles costs money.
A telling sign that a spreadsheet no longer copes is when the team starts a «spreadsheet about spreadsheets»: separate files for statuses, another for stock, a third for returns, and someone spends half a day consolidating them. The moment a need arises to manually sync several files with each other, it is no longer accounting but a second job, and the cost of that job easily exceeds the price of a proper system.
What a CRM gives a store compared to a spreadsheet
A CRM closes exactly the places where a spreadsheet leaks. Orders from all channels land in one system automatically, the customer is merged into a single card with purchase history rather than scattered across files. Statuses have deadlines and owners, stock is reserved at the moment of an order, and notifications to the customer about the waybill and payment go out by themselves, with no manual mailing.
The second difference is control and analytics without manual consolidation. Instead of totalling revenue with formulas once a week, the owner sees live numbers on a dashboard: average check, redemption rate, repeat purchases, top products by margin. This is no longer an «order log» but a decision-making tool. But a CRM also costs more than a free spreadsheet, so it is worth moving over when there is genuinely something to scale.
There's an important difference in repeat sales too. A spreadsheet won't remind you on its own that a customer bought a month ago and it's time to offer a complementary product, while a CRM builds segments and launches such scenarios automatically. For a store this is direct revenue: bringing back an existing buyer costs several times less than acquiring a new one through ads, and this is exactly where a spreadsheet loses most visibly.
How much the switch costs and whether it's worth it
Moving from a spreadsheet to a CRM is not only the price of the system but also the time for data migration and retraining the team. Customer and order data is imported from the spreadsheet - the main thing is that it is reasonably structured. That is exactly why it's better to move earlier, while the volume is manageable, rather than when the spreadsheet is already chaos across tens of thousands of rows with half the fields filled in any which way.
Calculating the benefit is simple: estimate how many orders you lose to confusion across channels and stock, how many hours a week go into manual consolidation and how many parcels go unredeemed without reminders. If that is tangible money - a CRM will pay off quickly. If the store is small and stable, the honest answer is: too early, stay on the spreadsheet a while longer and come back to the question when the volume grows.
Don't forget the risk to the data itself. A spreadsheet kept by several people sooner or later loses part of the information: someone sorts by accident without selecting the whole range, someone overwrites a formula, someone deletes a row. In a CRM the data is protected by structure and access rights, there is a change history, and recovering who did what takes a minute. For a customer base you have built up over years, this is not a trifle but insurance against a costly loss.
A hybrid: a spreadsheet plus automation as a bridge
Between a «bare spreadsheet» and a «full CRM» there is an intermediate step that is often underrated. You can keep the spreadsheet as the familiar interface but remove the manual work from it: orders from channels land in it automatically, a bot sends notifications to customers, and tracking numbers and statuses are pulled in by themselves. This is cheaper than a full CRM and takes away the sharpest pain while you have not yet grown into a separate system.
Such a hybrid is a good way to test which automations actually make a difference before investing in a full CRM. At Devlly we often start exactly here: we look at the store's real process, automate the most painful part on top of the familiar spreadsheets, and when the volume justifies it, move everything into a custom system without losing data and without stopping sales.