Skip to the content.

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

  1. Start on Clients and add the customers you already have, one row each, with a short Client ID.
  2. Log every new call or web form on Leads, pick the stage from the dropdown and set a follow-up date.
  3. When a lead becomes work, add the visit on Jobs and the bill on Invoices with the same Job ID.
  4. 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.

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.

All free templates