HOW-TO GUIDE

Customer Follow-Up Tracker in Google Sheets: Step-by-Step Guide

A practical Google Sheets customer follow-up tracker can show which inquiries need attention, without requiring a paid CRM.

Published by Ferneding Business Services · November 6, 2026 · Practical examples reviewed for clarity

When a potential customer asks for a quote, it is easy to lose the message among invoices and appointment requests. A customer follow-up tracker in Google Sheets gives every inquiry a next step and makes overdue follow-ups visible. This guide shows you how to set one up using a real formula—not just a list of ideas.

What your customer follow-up spreadsheet needs

Open a new Google Sheet and put these seven labels in row 1. Each new customer inquiry belongs on its own row.

Tip: Format columns A and E as dates. Use fictional records while testing. Store only information your team needs and limit access to the sheet.

Step 1: Create a status dropdown

1. Select F2:F so the status choices apply to future entries.
2. Choose Insert → Dropdown (or Data → Data validation, depending on the interface).
3. Add choices such as New, Replied, Waiting on customer, Booked, and Closed.
4. Save the rule and try selecting a status on a sample row.

Consistent statuses help you filter the tracker and avoid confusion between an open request and a completed booking.

Step 2: Automatically highlight overdue follow-ups

1. Select A2:G (all data columns, excluding the heading row).
2. Choose Format → Conditional formatting.
3. Under Format cells if, choose Custom formula is.
4. Paste the formula below, choose a light-red background and click Done.

=AND(ISNUMBER($E2),$E2<TODAY(),$F2<>"Booked",$F2<>"Closed",$F2<>"")

This rule colors rows when the follow-up date in column E is earlier than today and the status in F is neither Booked nor Closed. It ignores blank statuses and dates that are not recognized as dates. If your spreadsheet locale expects semicolons, replace formula commas with semicolons.

Test it: Enter yesterday's date in E2 and select Waiting on customer in F2. The row should turn red. Change the status to Booked; the highlight should disappear.

Step 3: Review what needs attention today

Turn on Data → Create a filter and sort column E oldest first, or create a filtered view for outstanding requests. Check the sheet once a day, update the status after responding, and enter the next follow-up date if another action is needed.

Conditional formatting does not send emails or reminders. It only highlights rows. If you later want actual notifications or automatic confirmation messages, that is a separate workflow requiring appropriate permissions, testing, and opt-out safeguards.

Step 4: Write a follow-up customers will appreciate

Hi! Just checking whether you had any questions about the estimate I sent over. If you're ready to move forward, I'm happy to help with the next step.

Use a follow-up only when it fits the actual customer relationship. Do not send repeated messages to someone who has declined or opted out.

Should you use Google Sheets or a CRM?

A shared tracker may work well when you have a manageable number of requests and a small team. Consider a dedicated CRM if you need several users to coordinate a high volume of interactions, complex permissions, or comprehensive customer history. The goal is a reliable process—not buying a larger tool than you need.

Frequently asked questions

Can Google Sheets automatically remind me to follow up?

A sheet can flag due dates visually. Sending email or calendar reminders requires an additional tool or configured automation; test that workflow before using it with customers.

Why isn't the overdue formula highlighting my row?

Check that the date in E is a real spreadsheet date (not plain text), the rule begins at row 2, the selected range is A2:G, and the status is not Booked or Closed.

Can I use this tracker for appointment requests?

Yes. Add an appointment-date column if helpful, but distinguish a requested appointment from a confirmed booking.