WhatsApp Sales Funnel in Google Sheets: How to Track Every Lead From First Chat to Paid

A WhatsApp sales funnel in Google Sheets is one row per lead with a Stage dropdown — New, Quoted, Booked, Won, Lost — plus columns for source, value and next follow-up date. A few COUNTIF formulas then show how many leads sit in each stage and your conversion rate. It costs RM0 to build, and a chatbot can fill it automatically.

What is a WhatsApp sales funnel, and why track it in Google Sheets?

If you can’t see where your leads are, you can’t see where your sales are leaking.

A sales funnel is simply the path from “first message” to “paid”. On WhatsApp, that path is hidden inside hundreds of chats. Some customers asked for a price and vanished. Some booked a site visit. Some paid last week. Unless someone writes it down, nobody on the team knows how many leads are stuck at each step.

Google Sheets is a good first home for that information because it’s free, your team probably already knows it, it works on a phone, and the whole team can see the same list at the same time. You don’t need an expensive CRM on day one — you need a clear, shared list with a stage for every lead. A proper WhatsApp sales funnel Google Sheets layout gives you exactly that.

In this guide we use a fictional example: Kasa Aircond Services in Shah Alam, which gets most of its installation and servicing jobs from Facebook ads that open a WhatsApp chat.

Which stages should a WhatsApp sales funnel have?

Keep the stages few and clear. If your team argues about which stage a lead belongs in, you have too many. Five stages work for most service and retail businesses:

The Lost stage matters as much as Won. A short “lost reason” — too expensive, chose another shop, no reply — tells you what to fix. If the sheet shows that lost leads often had no follow-up at all, you have found your first fix.

How do you build a WhatsApp sales funnel Google Sheets template step by step?

You can build the whole thing in about 30 minutes. Here is how:

1. Create the columns. In row 1, type: Date, Customer, WhatsApp, Source, Need, Stage, RM Value, Next follow-up, Owner, Lost reason.
2. Add a Stage dropdown. Select column F, then Insert → Dropdown, and add New, Quoted, Booked, Won and Lost. Give each a colour. Google explains the options in its guide to creating an in-cell dropdown list.
3. Add a Source dropdown. Do the same for column D: Facebook ad, TikTok, Instagram, Google, Referral, Walk-in.
4. Freeze the header row (View → Freeze → 1 row) so the column names stay visible on a phone.
5. Create a “Summary” tab for the funnel formulas below.
6. Protect the columns that only managers should edit, such as RM Value and Owner (Data → Protect sheets and ranges).

Resist the urge to add twenty columns. Every extra field is one more thing a busy salesperson will leave blank. Start small and add a column only when you know you will use it.

Which Google Sheets formulas show your funnel at a glance?

On the Summary tab, a few formulas turn your lead list into a live funnel. Assuming your data is on a tab called Leads:

• Leads in each stage: =COUNTIF(Leads!F:F,"Quoted") — repeat for New, Booked, Won and Lost. See Google’s COUNTIF help page.
• Total leads: =COUNTA(Leads!B2:B)
• Conversion rate: Won ÷ Total leads, formatted as a percentage.
• Revenue won: =SUMIF(Leads!F:F,"Won",Leads!G:G)
• Leads by source: =COUNTIFS(Leads!D:D,"Facebook ad",Leads!F:F,"Won") shows how many paying jobs each channel produced.

Here is what that looks like with example numbers for one month at Kasa Aircond (illustrative only):

Note: COUNTIF counts the leads currently in each stage. To get “reached this stage” figures like the table above, add the later stages together (for example, Booked reached = Booked + Won), or add a Yes/No column such as “Quoted?” that stays ticked when the lead moves on.

The biggest drop in this example is between Quoted and Booked — so the first fix is a better follow-up after the quotation, not more ads.

How does a chatbot fill the Google Sheet automatically?

A manual sheet only works if staff update it — and after a busy Saturday, they won’t. This is where ChatsHero’s Record feature helps. When a customer messages your WhatsApp, the AI replies instantly, asks the qualifying questions you set (area, unit type, preferred date), and writes the answers into your Google Sheet as a new row. When the customer books a slot, the booking is recorded in the sheet. Payment is different: your team marks the lead Won after verifying the payment.

The result is a funnel that updates itself from real conversations:

• RecordEach new WhatsApp lead becomes a row with source and need.
• AssignLeads can be auto-assigned to a salesperson or technician.
• ReportA daily summary of new, booked and won leads goes to your WhatsApp group.

Because the questions are asked in the customer’s own language (English, Bahasa Melayu or Chinese), fewer rows end up with a blank area or unit type — a point we cover in our note on mixed-language chats.

How can you see which ads bring real sales?

It is tempting to judge ads by clicks or messages. The Source column lets you measure them by paid jobs. At the end of the month, compare what you spent on each channel with the revenue won from it.

For example (illustrative numbers): if Kasa Aircond spent RM1,500 on Facebook ads that produced 30 WhatsApp leads and 8 won jobs worth RM9,600 in total, the cost per won job is RM187.50. If TikTok produced more leads but fewer won jobs, the “cheaper” channel may actually be more expensive. Without a funnel sheet, you only see the lead count — and you optimise the wrong thing.

To fill the Source column, the chatbot can ask “How did you hear about us?” and record the answer, or your team can pick the source from the dropdown. Once the column is reliable, the Ads ROI tab shows which channel really pays for itself. You can compare plans on our pricing page.

How do you keep customer data in the sheet safe?

Your funnel sheet holds names and phone numbers, which is personal data under Malaysia’s Personal Data Protection Act 2010 (amended in 2024). A few habits keep it under control:

• Share the sheet with named staff accounts only — never with “anyone with the link”.
• Use protected ranges so only managers can change values and owners. Google notes that protection prevents accidental edits but is not a security feature on its own.
• Remove access when a staff member leaves.
• Collect only what you need to serve the customer — no IC numbers in a sales sheet.
• Honour requests to stop marketing and mark them clearly in the sheet.

When should you move from Google Sheets to a full CRM?

Google Sheets is enough for many SMEs for a long time, especially when a chatbot keeps it updated. Consider a dedicated CRM when you have several sales teams with different approval flows, need detailed permissions per record, or your sheet grows to tens of thousands of rows and becomes slow. Until then, a clean WhatsApp sales funnel Google Sheets setup gives you most of the benefit at a fraction of the cost — and your team already knows how to use it.

A good test: if your weekly sales meeting can be run from the Summary tab alone, the sheet is doing its job. When it can’t, that is the signal to look at a CRM. ChatsHero itself started from the same Sheets-first idea, and more setups like this one are collected on our blog.

Frequently Asked Questions