LEAD MANAGEMENT
Managing Leads in Google Sheets Without a CRM
Many growing schools, clinics and agencies run their whole lead pipeline in a Google Sheet. Here is how to set one up properly and keep it working as you grow.
QUICK ANSWER
You can manage leads well in Google Sheets by using one shared sheet with fixed columns (date, name, mobile, source, interest, status, owner, next follow-up, notes), a short list of status values, a dropdown for each, filters per counsellor and automatic lead entry from your forms, ads, WhatsApp and voice campaigns. Move to a CRM when volume or team size outgrows it.
01
Free and familiar
Everyone already knows Google Sheets, so your team can start the same day without training or licence costs.
02
One place for every lead
Leads from calls, WhatsApp, RCS, forms and ads land in one sheet instead of scattered phones and notebooks.
03
Easy to share and filter
Counsellors filter their own leads, and owners see the whole pipeline at a glance.
Can you really run leads without a CRM?
Yes, for many small and mid-sized teams. A well-structured Google Sheet can handle thousands of leads, multiple counsellors and daily follow-ups. The trick is discipline: fixed columns, fixed status values and leads entering automatically so nobody has to copy-paste.
The columns you need
- Date and time the lead came in
- Name and, for education, parent name
- Mobile number
- City
- Course, product or service interest
- Source: voice call, WhatsApp, RCS, website form, Meta lead ad, walk-in
- Interest level: hot, high, partial
- Listen duration and button pressed, if from a voice campaign
- Owner: the counsellor or salesperson assigned
- Status
- Next follow-up date
- Notes
Freeze the header row and keep one lead per row. Do not merge cells.
Keep status values short and fixed
Use data validation to create a dropdown, for example:
- New
- Contacted
- Interested
- Visit or demo booked
- Applied or quoted
- Won
- Lost
- Not reachable
Fixed values make it easy to count leads by stage with a simple pivot table or COUNTIF.
Sharing with your team
- Share the sheet with edit access only to people who need it.
- Use filter views so each counsellor sees only their leads without changing what others see.
- Add conditional formatting: red when the follow-up date has passed, green when won.
- Protect key columns, such as date and source, so they are not edited by mistake.
- Check version history if something goes missing.
How it works with automatic lead entry
The biggest time-waster is manual entry. Connect your sources so new leads appear as new rows:
- Website and WhatsApp forms can post to your sheet through a webhook or form API.
- Meta lead ads can sync new leads into the sheet.
- WhatsApp chatbot conversations can add the details collected in chat.
- Voice campaigns can add people who pressed 1 or listened long, with their listen duration.
Smart Growth AI offers a free Google Sheets integration where every lead from voice, WhatsApp, RCS, SMS, forms and Meta ads lands in one custom sheet the owner chooses.
A simple daily routine
- Morning: each counsellor filters for "New" and "follow-up due today".
- During the day: update status and next follow-up date after every call.
- Evening: the manager checks overdue follow-ups and hot leads not yet contacted.
- Weekly: count leads and wins by source to see which channel is working.
Protecting the data
Lead sheets hold personal data. Limit sharing, avoid downloading copies onto personal devices, remove access when someone leaves and keep an opt-out column so people who asked not to be contacted are not called again.
When to move to a CRM
Google Sheets starts to struggle when you have many counsellors editing at once, need call logging and automated tasks, or have tens of thousands of rows with heavy formulas. At that point a CRM such as Zoho, HubSpot, LeadSquared or TeleCRM may suit you better. Leads can still flow in automatically through a webhook or API, and you can keep the sheet as a backup.
Useful formulas and views
- COUNTIFS to count leads by source and status, for example how many voice-campaign leads reached "Visit booked".
- A "Due today" filter view using the next follow-up date column.
- A pivot table showing leads and wins by owner, so you can balance workload between counsellors.
- A duplicate check with conditional formatting on the mobile number column, so the same person is not called by two counsellors.
Keep formulas on a separate summary tab rather than inside the main lead tab. This keeps the lead list fast and avoids accidental edits.
A small owner dashboard on that summary tab, showing new leads today, overdue follow-ups, hot leads not yet called and wins this week, gives the owner a clear picture in under a minute without scrolling through thousands of rows.
Common mistakes
- Several sheets for different sources instead of one master sheet
- Free-text statuses that cannot be counted
- No owner column, so leads fall between counsellors
- Deleting lost leads instead of marking them, which hides useful history
Feeding the sheet from a smart campaign
The Smart Growth AI Campaign sends every lead into one Google Sheet with name, parent name, mobile, city, course interest, listen duration, button pressed and interest level, so counsellors can start with the hottest leads. If you would like help structuring your sheet, book a short call.
FAQ
Questions people ask
Is Google Sheets good enough for lead management?
For many small and mid-sized teams, yes. With fixed columns, dropdown statuses, filter views and automatic lead entry, a Google Sheet can handle daily follow-ups for several counsellors. Larger teams with complex workflows may later need a CRM.
What columns should a lead tracking sheet have?
At minimum: date, name, mobile, city, interest, source, interest level, owner, status, next follow-up date and notes. Education teams often add parent name, and voice campaigns can add listen duration and button pressed.
How can leads be added to Google Sheets automatically?
Forms and chatbots can post data to the sheet through a webhook or form API, Meta lead ads can sync new leads, and campaign platforms can push leads directly. Smart Growth AI's free Google Sheets integration does this for its channels.
How do multiple counsellors use one lead sheet without confusion?
Assign each lead an owner and give each counsellor a filter view showing only their leads. Use dropdown statuses, protect key columns and colour overdue follow-ups so the manager can spot problems quickly.
When should I move from Google Sheets to a CRM?
Consider a CRM when many people edit at the same time, you need call logging or automated tasks, or the sheet becomes slow with large data. Leads can still flow into the CRM through a webhook or API.
TALK TO A REAL PERSON