Free Lead Follow Up Spreadsheet
For owners who suspect they lose jobs by calling back too late, and want each lead’s next attempt scheduled the moment it arrives.
Open the template · Make a copy · Google Sheet, free, no sign-up
What is inside
| Tab | What it holds |
|---|---|
| Dashboard | Totals and views built from Leads and Attempts, no typing needed. |
| Leads | Columns Lead ID, Received date and time, Name, Phone, Email, Service wanted, Source, Owner ID, Estimated value and 5 more. |
| Attempts | Columns Attempt ID, Lead ID, Date and time, Channel, Outcome and Notes. |
| Today | Totals and views built from Leads and Attempts, no typing needed. |
| Settings | Your own dropdown lists (next attempt number, days after receipt, service, source and owner id), so the choices match how you work. |
How to fill it in
- Log each new lead on Leads with the time it arrived, the service and the source.
- Record every call, text or email on Attempts with its outcome.
- Open Today each morning for the leads due a follow-up.
- Close each lead as won or lost and pick a lost reason.
A tip from the field
Keep an eye on Minutes to first contact. The Speed alert column shows leads that waited too long for a first call.
Starter files
Each tab with sample rows comes as a CSV file, handy for importing into another tool or starting fresh.
Related templates
When you outgrow it
Smarfle puts every call, text, web form and booking in one inbox and can text back missed callers. See how it works on smarfle.com.