# CRM in Google Sheets: Template and Its Limits | Auspex

> Auspex

Source: https://auspex.company/en/blog/crm-google-sheets-template/

[Blog](/en/blog/) / Guide

# CRM in Google Sheets: a template for a team of up to 10 and three signs it is time to move on

By: Andrew Maryasov · Oct 29, 2026 · 8 min read

While you get dozens of inquiries a month and two or three people sell, you do not need a CRM system: one Google Sheet with contacts, deals by stage and a dashboard that calculates itself is enough. Auspex built that template: six tabs, room for 200 deals, a weighted pipeline and automatic highlighting of overdue next steps. Below: what is inside, how to set it up in 15 minutes, four rules without which a spreadsheet stops working within a month, and three signs it is no longer enough.

![Auspex CRM template in Google Sheets: six tabs (Start, Contacts, Deals, Activities, Dashboard, Lists), room for 200 deals, for a team of up to 10](/images/blog/crm-google-sheets-template-en.webp)

Six tabs of the template and the limit: a team of up to 10

## What is inside the template

The template opens without signing in to Google. To work in it, save a copy to your Drive: File → Make a copy. Dropdowns, formulas and highlighting travel with the copy. The template is in Ukrainian and has six tabs:

-   Start: how to use it and when a spreadsheet is no longer enough, on one page.
-   Contacts: company, contact person, phone, the channel the inquiry came from, status, owner, next contact date. An overdue date turns red on its own.
-   Deals: name, amount in hryvnias, stage from a list, probability and weighted amount calculated from the stage, expected close, next step and its date, loss reason for closed deals.
-   Activities: a log of calls, meetings and emails with the outcome and the next step.
-   Dashboard: open deals, pipeline value and weighted value, paid this month, win rate, overdue steps, contacts with no follow-up, deals with no next step, breakdown by stage and by inquiry channel. Nothing to type in.
-   Lists: stages with probabilities, statuses, channels, owners, loss reasons, activity types. Every dropdown reads from here.

Default stages: new inquiry 10 %, qualified 30 %, proposal sent 50 %, invoice issued 80 %, paid, lost. Change the probabilities to match your sales; keep the names "Paid" and "Lost" as they are, the dashboard depends on them.

## How to set it up in 15 minutes

-   Open Lists and type the team's names into the Owner column. If your pipeline is shorter or longer, adjust the stages and probabilities there as well.
-   Move contacts from your phone, mailbox and messengers into Contacts, one row per company or person. Next to each, note where the inquiry came from: within a month the Channel column shows which channel feeds your sales.
-   Enter open sales in Deals: amount, stage, expected close. Delete the examples set in grey italics.
-   Agree on one thing with the team: every open deal has a next step with a date. The spreadsheet does the rest.

## Four rules without which a spreadsheet stops working within a month

Spreadsheets do not die of volume. They die of missing discipline. The template rests on four agreements, and the same four later move into any CRM unchanged.

-   One row equals one deal. A customer with three orders has three rows in Deals and one in Contacts.
-   Every open deal has a next step and a date. A deal without a step stalls, and the dashboard counts such deals separately.
-   The stage is changed by the person who spoke to the customer, on the day of the conversation. Updating "retroactively before the meeting" turns the pipeline into a decoration.
-   Fifteen minutes every Friday on the dashboard: overdue steps, deals without a step, contacts with no follow-up. A team of up to 10 needs no more control than that.

## Where the limit is: three signs a spreadsheet is no longer enough

Template vendors name the ceiling themselves. HubSpot writes that its spreadsheet CRM is built for the first 25–50 customers and takes one to two hours a week, and that after 50 active relationships manual updates become time-consuming. Thefrontkit puts the limit at a few hundred active records and one or two users. The Devlly studio describes how edit conflicts start once four or five sales reps work in one shared file, and says that in its experience 10 to 20 percent of inquiries are lost in manual transfer, without describing how that was measured.

In the 10–200-employee companies Auspex works with, the limit runs through people and channels, not rows. Three signs it is time to move on:

-   Inquiries arrive from three or more channels and nobody transfers some of them into the sheet. An inquiry that was never written down does not get lost in plain sight. It simply does not exist.
-   Three or more people work in the file at the same time and you no longer know who changed a deal's stage and when. Version history exists on paper, but finding one edit for one customer in it is hopeless.
-   You need reminders, call recordings in the customer card and conversion by stage, not a list. A spreadsheet will not call the rep or resurface a forgotten deal three days later.

If one sign matches, the spreadsheet will last another six months. If two or three match, it is time to count the losses: that is where the Auspex course "CRM for the owner" (in Ukrainian) starts, with a map of channels and a one-page description of the sales process from three won deals, before choosing a system.

## What to migrate into a CRM when you are ready

The template is built so that the move is not a rewrite from scratch. Each tab maps to a CRM entity:

-   Contacts become contacts and companies. The Channel column becomes the lead source.
-   Deals become pipeline deals with the same stages. If the stages worked in the spreadsheet, they will work in the system; if they did not, no CRM will rescue them.
-   Activities become the history in the customer card: calls, emails, meetings.
-   Lists become dropdown fields, the Dashboard becomes the pipeline report.

Before importing, copy the file, fix a cut-off date and give every row a unique number: the template already numbers rows for you. After the move you can then compare counts before and after and not lose customers on the way.

## Why a Google Sheet and not an Excel file

An Excel file lives on one computer, and the "latest" version is always on someone else's. A Google Sheet is one for everyone, changes are visible at once, version history lets you undo an accidental deletion, and the formulas and dropdowns are the same. For a team that is not ready for a CRM, it is the only sensible answer to the "CRM in Excel" request.

## What next

The template covers the first step: seeing inquiries, deals and overdue steps in one place. When two or three of the signs match, Auspex suggests taking the next step with numbers rather than gut feeling: a CRM audit over 2–3 days shows which processes, data and channels to move into the system and in what order.

Template: Simple CRM in Google Sheets (in Ukrainian)

-   [Open the template (view, no sign-in)](https://docs.google.com/spreadsheets/d/1ct_W1IzJdnTNE3qem_1j9e8BYP_aLtjdzaYh_TRg2zE/edit)
-   [Make a copy to your Drive](https://docs.google.com/spreadsheets/d/1ct_W1IzJdnTNE3qem_1j9e8BYP_aLtjdzaYh_TRg2zE/copy)

Read next

-   [CRM vs Excel: a comparison for a 10–200-person company](/en/blog/crm-vs-excel/)
-   [How to choose a CRM for a 10–200-person company](/en/blog/how-to-choose-a-crm-for-smb/)
-   [CRM audit: portal, processes and data reviewed in 2–3 days](/en/services/crm-audit/)

## Sources

-   [HubSpot. Free CRM Spreadsheet Template for Excel and Google Sheets: built for the first 25–50 customers, 1–2 hours a week (their estimate)](https://www.hubspot.com/resources/templates/customer-relationship-management)
-   [Thefrontkit, 2026. Free CRM Template for Excel and Google Sheets: a ceiling of a few hundred active records and one or two users](https://thefrontkit.com/free-crm-template)
-   [Devlly, 2026. CRM vs Google Sheets for managing customers: edit conflicts with 4–5 sales reps](https://devlly.dev/blog/crm-vs-google-sheets)
-   [Devlly, 2026. When to move from spreadsheets to a CRM: five signs and inquiries lost in manual transfer (their experience)](https://devlly.dev/blog/spreadsheets-to-crm)
-   [CRM.org, 2026. Top 7 Google Sheets CRM Templates: how the templates are built — contacts, deals, dashboard, lookup lists](https://crm.org/crmland/google-sheets-crm-template)

Author: Andrew Maryasov, founder of Auspex. Auspex has implemented CRM since 2015: 1,500+ projects for 1,200+ companies; in Ukraine it works with Uspacy.

Andrew Maryasov Founder, Auspex

Founder of Auspex. Implementing CRM and automating business processes since 2015 — 1,500+ projects for 1,200+ companies.

[amaryasov.expert →](https://amaryasov.expert)

## Frequently asked

How many customers and deals can a CRM in Google Sheets handle?

The template is formatted for 200 contacts and 200 deals; formats and dropdowns can be dragged further down. The practical limit is people: HubSpot names 25–50 active customers, Thefrontkit a few hundred records and one or two users. Once three or more people work in the file at the same time, edit conflicts begin.

Can I use the template from a phone?

Yes, in the Google Sheets app: dropdowns, dates and highlighting work and the dashboard calculates. Long notes are easier to type on a computer.

How is the weighted deal amount calculated?

The deal amount is multiplied by the probability of its stage from the Lists tab: a proposal sent at 50 % with an amount of 20 000 ₴ adds 10 000 ₴ to the weighted pipeline. It is a more realistic forecast than the sum of all open deals.

Can I change the pipeline stages in the template?

Yes, on the Lists tab: names and probabilities are editable, and the dropdowns on the Deals tab pick up the changes. Keep the names "Paid" and "Lost", the dashboard formulas depend on them.

Does the template work for services rather than goods?

Yes. A deal in the template is any sale with an amount and stages: installation, consulting, a subscription, a batch of goods. For a product business with stock the spreadsheet runs out sooner, because inventory appears.

Is it safe to keep a customer base in a Google Sheet?

Access in a spreadsheet is granted to the whole file: whoever sees deals sees every contact, amount and note. For two or three people that is tolerable, for a team with turnover it is a risk. With the base comes responsibility for customers' personal data: on what basis you store it, who sees it, whether a backup exists.

## Business automation digest

2–3 emails a month — what actually works in CRM and automation.

No spam. Unsubscribe in one click.

[Free CRM audit →](/en/contact/)

↳ FREE AUDIT 30 min · free · ↓

## Ready to Get Your Sales Under Control?

Free process audit — 30 minutes, and you'll receive:

1,200+ companies since 2015 · 30-day median go-live

01 A map of where you're losing leads

02 Priorities: what to automate first

03 An implementation plan with stages and timelines

We'll call within 24 hours. The plan is yours, even if we don't work together.
