Home

›

›

Simple CRM Template for Google Sheets

,

Simple CRM Template for Google Sheets

This simple CRM template for Google Sheets tracks contacts and deals with their stage, value, last contact, next step and follow-up date. Each stage carries a probability, so the sheet shows a weighted pipeline value, and follow-ups that are due or overdue turn red so no lead goes quiet by accident.

We only use your email to send you this link. Privacy

Format
Excel, Google Sheets
Opens in
Excel, Google Sheets, LibreOffice and Numbers
Topic
Sales & Marketing
Publisher
ProTemplates
Price
Free
Simple crm sales pipeline follow ups

What’s inside

  • Pipeline tab for up to 100 deals
  • Stage dropdown linked to closing probabilities
  • Weighted value per deal and in total
  • Follow-up dates highlighted when due
  • Stages tab with deals and value per stage

How to use it

  1. Add each company or deal with contact details, stage and value.
  2. Log the last contact, next step and follow-up date.
  3. Adjust stage probabilities on the Stages tab to match your sales history.
  4. Start each day with the follow-ups in red.

FAQ

What is a weighted pipeline?

Each deal’s value multiplied by its chance of closing. It gives a more realistic forecast than adding up every open deal.

When should I move to a dedicated CRM?

When several people sell at once, or you need email tracking and automation. Until then, a sheet is quick and free.

Can I change the stages?

Yes. Edit the names on the Stages tab and update the dropdown list on the Pipeline tab.