Free Google Sheets CRM Template
For an owner who answers the phone, quotes the job and sends the bill, and wants every client, lead and unpaid invoice in one workbook instead of a notebook and three apps.
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 Clients, Leads, Jobs, Invoices and 2 more, no typing needed. |
| Clients | Columns Client ID, Name, Company, Email, Phone, City, State, ZIP, Customer type and 10 more. |
| Leads | Columns Lead ID, Client ID, Client name, Phone, Created date, Service, Source, Owner, Stage and 12 more. |
| Jobs | Columns Job ID, Client ID, Client name, Lead ID (optional), Service, Job type, Scheduled date, Start time, Team ID and 8 more. |
| Invoices | Columns Invoice ID, Job ID, Client name, Issued date, Due date, Invoice status, Subtotal (USD), Tax amount (USD), Discount (USD) and 7 more. |
| Activities | Columns Activity ID, Lead ID, Client name, Activity date, Type, Owner, Summary / next step, Task due date, Status and 1 more. |
| Team | Columns Team ID, Name, Role, Phone, Email, Team status, Notes, Open jobs and Completed jobs. |
| Settings | Your own dropdown lists (stage, win probability, lead source, owner and service), so the choices match how you work. |
How to fill it in
- Start on Clients and add the customers you already have, one row each, with a short Client ID.
- Log every new call or web form on Leads, pick the stage from the dropdown and set a follow-up date.
- When a lead becomes work, add the visit on Jobs and the bill on Invoices with the same Job ID.
- Open Dashboard each Monday to see open value by stage and who is waiting for a call back.
A tip from the field
Keep IDs short, like C-001 and L-001. Every tab looks clients up by ID, so a misspelled name never breaks a total.
Starter files
Each tab with sample rows comes as a CSV file, handy for importing into another tool or starting fresh.
- Clients (20 sample rows)
- Leads (36 sample rows)
- Jobs (6 sample rows)
- Invoices (4 sample rows)
- Activities (45 sample rows)
- Team (3 sample rows)
Related templates
When you outgrow it
Smarfle does the same job as an app, with every text, email, job and invoice on the client’s page. See how it works on smarfle.com.