Business Tools14 min read2026-11-16

How to Build a Customer Database with Google Sheets

A customer database turns one-time buyers into repeat customers. This guide shows Nigerian small businesses how to build one in Google Sheets for free, keep it organised, and use it to grow sales.

J

Igono Joel

Published 2026-11-16

How to Build a Customer Database with Google Sheets — featured image for Joetech blog article about tech skills and AI

Every Nigerian small business has the same problem. A customer buys from you once, on WhatsApp or at your shop in Lekki, and then disappears. You remember her face, maybe her first name, but you have no number saved and no way to reach her when new stock arrives.

A customer database fixes that. It is simply an organised record of everyone who has bought from you, what they bought, when they bought it, and how to reach them. Google Sheets is free, works on any phone, and saves automatically.

This guide shows you how to build a customer database with Google Sheets, step by step: what information to collect, how to set it up, how to keep it updated, and how to use it to bring customers back.

Why Your Business Needs a Customer Database

Most small businesses in Nigeria run on memory and WhatsApp chats. That works when you have twenty customers. It breaks when you have two hundred. You scroll through old chats looking for a number, you forget who ordered what, and you lose track of who owes you money. A database removes that stress because everything is in one place, searchable in seconds.

A database also helps you sell more to people who already trust you. When Ada, who sells skincare in Abuja, started keeping a simple sheet of her customers, she noticed that many of them bought the same cream every six weeks. She started sending a short WhatsApp message in week five, reminding them it was time to restock, and her repeat sales rose sharply.

Finally, a database helps you make better decisions. When you can see that most of your customers come from Surulere, or that December is your biggest month, you can plan your stock, your adverts, and your money properly instead of guessing.

What Information to Collect About Each Customer

A good database starts with the right columns. Collect too little and the sheet is useless. Collect too much and you will never fill it in. Start with the essentials and add more columns only when you actually need them.

The first columns are the basics: full name, phone number, and WhatsApp number if it is different. In Nigeria, the WhatsApp number is often more important than the email address, because that is where you will reach the customer. Ask for the name exactly as the customer gives it, and save the number with the country code, for example 234 for Nigeria, so you can message them even if you change phones.

Next, record what they bought: the product or service, the quantity, and the price they paid. This is the heart of your database. Without it, you only have a phone book.

Add the date of the purchase and the location or delivery address. The date lets you spot repeat buying patterns. The location helps you plan deliveries. If ten customers live in Ikeja and you deliver there every Saturday, you can group their orders and save on dispatch rider fees.

Then add a column for how they found you: Instagram, TikTok, referral, walk-in, or a Google search. This tells you which marketing actually works. If ninety percent of your customers come from referrals, you should reward referrals instead of spending more on adverts that bring nobody.

Finally, add a notes column. This is where you write the small human details: "Prefers brown, allergic to shea butter, birthday in March, pays on delivery, husband picks up orders." These details are what make a customer feel remembered, and a remembered customer comes back.

Do not collect information you do not need. Keep it simple, keep it useful, and always tell customers why you are saving their details.

Setting Up Your Google Sheet Step by Step

First, open Google Sheets on your phone or computer. If you use Gmail, you already have access. Create a new blank spreadsheet and name it clearly, for example "Customer Database — My Business Name". A clear name matters, because six months from now you will have many sheets and you need to find this one fast.

Second, set up your header row. Row one holds your column names. A good starter set is: Date, Full Name, Phone Number, WhatsApp Number, Email, Product Bought, Quantity, Amount Paid, Payment Method, Location, How They Found You, and Notes. You can rename, remove, or add columns later. Freeze this header row so it stays visible when you scroll down through hundreds of customers.

Third, format the sheet for easy reading. Make the header row bold with a coloured background, widen the Name and Notes columns, and narrow the Date and Quantity columns. Set the Amount Paid column to show numbers properly so your totals add up. These small touches make the sheet pleasant to use, which means you will actually use it.

Fourth, add data validation to the columns where mistakes are common. For the Payment Method column, create a dropdown with options like Cash, Transfer, POS, and Paystack. For the How They Found You column, use a dropdown with Instagram, TikTok, WhatsApp, Referral, Walk-in, and Google. Dropdowns stop typos like "Instgram" and "Instagram" appearing as two different sources in your reports.

Fifth, create a second tab in the same spreadsheet for your summary. Call it "Summary" or "Dashboard". This tab is where you will track your total number of customers, total sales, best-selling products, and best sources. You do not need to fill it in by hand. Simple formulas can count your customers and add up your sales automatically, and this guide covers that in a later section.

Sixth, set up sharing. Share the sheet with your own second email address as a backup, and give staff the right permission level. Google Sheets saves every change automatically, so there is no save button to forget.

How to Enter Customers Without Slowing Down Your Day

The biggest reason small business owners abandon their database is that entering data feels like extra work after a long day. The trick is to build the habit into your normal selling flow, not to treat it as a separate job.

The simplest method is to enter the customer at the moment of the sale. When a customer pays, before you pack the order, add one row to the sheet. On your phone, the Google Sheets app opens fast, and one row takes less than a minute. If you sell at a physical shop in Yaba or Onitsha, keep a small notebook at the counter for names and numbers during the rush, then transfer them to the sheet at the end of the day. The notebook is a backup, not the database.

For WhatsApp sellers, you can also collect details in the chat and copy them over in batches. Set aside fifteen minutes every evening to update the sheet with the day's orders. Do not let a week pass without updating it. A database that is a week behind is still useful. A database that is three months behind is a chore nobody wants to face.

If you have old customer records scattered in WhatsApp chats, notebooks, and old phones, do not try to move them all in one day. Start with your last thirty days of customers. A database with your most recent hundred customers is already powerful.

Using Formulas to Understand Your Customers

A sheet full of names is only the beginning. The real value comes when you use simple formulas to turn those rows into answers. You do not need to be a spreadsheet expert. Four or five basic formulas will do most of the work.

First, count your customers. A simple count formula on the Name column tells you how many people have bought from you. Watching that number grow month by month is motivating, and it tells you whether your marketing is bringing in new people or whether you are only selling to the same group.

Second, add up your sales. A sum formula on the Amount Paid column gives you your total revenue for any period. You can add up one month at a time by filtering the Date column, or keep a monthly summary on your Dashboard tab.

Third, find your best customers. Sort your sheet by Amount Paid or use a simple filter to see who has spent the most. These are the customers worth a personal thank-you message, an early look at new stock, or a small discount. A customer who has spent ₦200,000 with you over a year deserves more attention than a customer who bought once and never returned.

Fourth, find your best products. You can use a simple count or a pivot table to see which product appears most often in the Product Bought column. If one product brings half your sales, protect its stock. If a product has not sold in three months, consider dropping it or discounting it to free up your money.

You can learn each of these formulas in a few minutes by searching for the exact task, such as "how to sum a column in Google Sheets". You only need to learn a formula once, and it keeps working for you every day after that.

Keeping Your Database Clean and Safe

A database is only useful if the information in it is correct. Dirty data — duplicate names, wrong numbers, missing products — will mislead you. Spend a little time each week keeping the sheet clean, and it will serve you for years.

Check for duplicates regularly. The same customer often appears twice: once as "Adaeze Okafor" and once as "Ada Okafor". When you spot a duplicate, merge the two rows into one, keeping the most complete information. Google Sheets has a built-in tool that can help you find duplicates, and a quick sort by phone number makes them easy to spot, because the same number appearing twice is a clear sign.

Standardise how you write things. Decide once whether you write "Lagos" or "lagos", "Transfer" or "transfer", and stick to it. Dropdown lists help here, because they force everyone who enters data to pick from the same options. If you have staff entering data, agree on the format together and write it down on a small note near the till or in your staff group chat.

Protect customer privacy. Your database contains people's phone numbers and buying habits, and that information is valuable. Do not share the sheet publicly, do not send it to strangers, and be careful about who gets editing access. Use the sharing settings to give staff "viewer" access if they only need to look up a number, and "editor" access only to people you trust to change records. If a customer asks you to delete their details, do it promptly and tell them you have done so. Trust is part of your brand.

Using Your Database to Bring Customers Back

Collecting customer data is pointless if you never use it. The database earns its keep when you turn it into messages, offers, and service that bring people back.

The simplest use is the restock reminder. Look at your sheet for customers who bought a product that runs out regularly — cream, foodstuff, hair, phone accessories — and message them shortly before they are likely to run out. A short message like "Hello Adaeze, your cream should be running low by now. We have new stock, and delivery to Ikeja is free this week" is helpful, not spammy, because it is based on what she actually bought and when.

The second use is the new stock announcement. When a new product arrives, do not broadcast it to everyone. Filter your sheet for customers who bought something similar and message only them.

The third use is the birthday or anniversary message. If you recorded a birthday in the Notes column, a short greeting with a small discount costs you almost nothing and makes a strong impression. People remember businesses that remember them, and they tell their friends about it.

The fourth use is the win-back message. Filter for customers who have not bought in three months and send them a friendly check-in with a small offer, such as ten percent off their next order. Some will return. Even if only one in five returns, that is sales you would have lost completely without the database.

Keep your messages short, personal, and useful. Use the customer's name, mention the product they bought, and give them one clear reason to reply. Never send the same broadcast to your whole list every day. That is how you get blocked. A few well-targeted messages each week will bring more sales than daily broadcasts ever will.

Common Mistakes

The first mistake is building a complicated sheet you never use. Some people create thirty columns, five tabs, and colour-coded rules before they have entered a single customer. Start with ten or twelve simple columns. You can add more later, once the habit is in place.

The second mistake is collecting numbers and never messaging anyone. A database that sits untouched is just a list. Set a weekly reminder, even thirty minutes on a Saturday morning, to send follow-ups, check for customers who are due a restock reminder, and update the sheet.

The third mistake is entering data in a rush with errors. A wrong phone number means you cannot reach the customer at all. Take the extra ten seconds to confirm the number with the customer, especially when you write it by hand from a phone call. Read it back to them before you save it.

The fourth mistake is giving every staff member full editing access. One careless delete can wipe out a hundred rows. Google Sheets keeps a version history, so you can recover deleted data, but it is better to limit editing access to one or two trusted people and let everyone else view the sheet.

Frequently Asked Questions

Is Google Sheets really free for a customer database?

Yes. Google Sheets is free with a Google account, and it can hold thousands of rows, which is more than enough for most small businesses. You only need to pay if you want extra Google storage for very large files, which a customer database rarely needs.

How many customers can I store in Google Sheets?

A single Google Sheet can hold up to ten million cells, which means thousands of customers with many columns each. In practice, most Nigerian small businesses will not come close to that limit. If your sheet ever grows that large, you can split it by year or move to a dedicated tool.

Do I need to ask customers before saving their details?

Yes, it is good practice and good business. Tell the customer you are saving their name and number so you can serve them faster and let them know about new stock. Most customers agree happily. If someone says no, respect that and do not save their details.

Can my staff and I use the same sheet at the same time?

Yes. Google Sheets allows several people to view and edit the same sheet at once, and changes appear in real time. This is useful if one person takes orders on WhatsApp while another packs orders in the shop. Just make sure everyone knows who updates which rows, so two people do not edit the same customer at the same time.

What to Do Next

  1. Open Google Sheets and create a new spreadsheet named after your business and the words "Customer Database".
  2. Set up your header row with the twelve starter columns: Date, Full Name, Phone Number, WhatsApp Number, Email, Product Bought, Quantity, Amount Paid, Payment Method, Location, How They Found You, and Notes.
  3. Freeze the header row, add dropdown lists for Payment Method and How They Found You, and format the header so it is easy to read.
  4. Add your last thirty days of customers, starting with the most recent orders, and fill in as much detail as you can from your WhatsApp chats and receipts.
  5. Create a second tab called "Summary" and add simple formulas to count your customers and add up your total sales.
  6. Set a daily habit: add every new customer to the sheet at the moment of sale, or in a fifteen-minute evening update.
  7. Once a week, send restock reminders or new stock messages to a small, targeted group of customers from the sheet, and record the results in the Notes column.
  8. At the end of the month, back up the sheet as an Excel file, check for duplicates, and review which products and channels brought you the most sales.

Get weekly tech insights

Join our newsletter for practical guides on web dev, AI tools, and digital marketing — sent every Monday.

No spam. Unsubscribe anytime.