Stop tracking deals in a spreadsheet next to Gmail

A Google Sheet named “Pipeline 2026” feels like adulthood. Columns for company, contact, stage, amount, next action. Conditional formatting. A SUM at the bottom that looked real last Sunday. Then you sell all week in Gmail, and the sheet waits in another tab like a plant you forgot to water.

This is not a rant against spreadsheets. They are excellent at lists you update in one place. A sales pipeline is not that list. The source of truth is the thread. Every time you copy the sender into column A and the stage into column D, you create a second object that can disagree with the email. Disagreement is how deals die in silence: the sheet says “Waiting on them,” the thread says they asked for a proposal on Monday, and nobody looks at both on the same screen.

If you close in Gmail, the tracker has to live next to the mail — not in a sibling tab you open when you feel organised.

The tax of copying sender and stage

Count the gestures. Open the thread. Skim to remember where it stands. Switch to Sheets. Find the row (or create one). Paste the email. Type a stage that is already a guess. Type a next step you will not see tomorrow because you start in the inbox, not in the sheet. Repeat for every live deal, or — more honestly — for the deals you remember.

The deals you forget to copy are the ones that needed the row. That is selection bias: the sheet describes the pipeline you already have in your head. It does not catch the thread you starred three days ago and buried under a newsletter.

There is also a social cost if you share the sheet. A partner asks “what is happening with Acme?” You search Gmail because you do not trust the row. They learn not to trust the sheet either. Shared fiction is worse than a private mess: now two people maintain a document nobody believes.

Why the Sunday update does not survive the week

Spreadsheets reward batch work. Gmail is a stream. You can reconcile them once a week if nothing moves. Sales mail moves every day. A close date that slipped, a “let’s revisit in October,” a second deal with the same client — all of that happens in the thread. The row stays at last week’s snapshot unless you pay the copy tax again.

People then add more columns to feel in control: last contact, temperature, probability, source. The more columns, the less you fill. Empty cells look like a failed CRM, so you avoid the tab. The simple four-column sheet you started with was closer to the truth. Complexity was a coping mechanism for the real problem: the data entry is in the wrong window.

Zapier and “email to sheet” add-ons try to close the gap. They dump every message or every labelled thread into rows. You get a log, not a pipeline. Logs grow. Pipelines should stay small enough to scan in twenty seconds.

What the sheet is actually good at

Be fair. A spreadsheet is the right tool when you are modelling, not operating. Annual forecast for the accountant. A one-off list of conference leads you will not email until next month. A commission split with formulas. Exporting a snapshot for a board deck.

It is also a decent CRM for people who do not live in Gmail — phone-heavy sales, a warehouse, a shop. If the conversation is not the email, you are not paying the copy tax; you are logging from the start.

The failure mode is specific: you already work the deal in Gmail, then you retype it into cells so you can “see it.” Seeing it should not require a second representation. The board should be a view of the same conversations, with a few fields Gmail will not show: value, close date, next step, notes, company.

A pipeline that does not need a second tab

Minimum that works:

• One card per conversation you refuse to lose — not one row per sender, and not one row per email.
• A stage you drag (Lead, Contacted, Negotiation, Won, Lost) instead of a dropdown you forget to change.
• Value and expected close, so the month has a number you can distrust usefully.
• A next step written as a verb: “send revised quote,” not “follow up.”
• A link back to the thread, so the sheet-that-is-not-a-sheet never holds a stale paste of the last message.

Fill the board from the last 30 days of mail you actually care about. Skip the five-year import. Going forward, when a thread becomes a deal, put it on the board the same day. That habit is cheaper than a weekly reconciliation ritual.

Do not auto-ingest the mailbox. Spreadsheet add-ons love volume. You want the opposite: a short list of cards you chose. Tools that scan the whole inbox to “build your CRM” recreate the noisy sheet, just with a prettier UI.

If you must keep a sheet

Use it as an export, not as the operating system. Once a month, dump values for finance. Do not live there. If a colleague only has Sheets access, they are not on the pipeline with you; they are reading a report. That can be fine. Do not pretend the report is the working board.

Kill columns you have not filled in two weeks. If probability is always 50%, delete it. If “next step” is always “follow up,” you do not have a next step; you have a shrug.

And stop colouring rows by mood. Red/yellow/green without a date and an owner is interior decoration. A missed close date on a card is more honest than a red cell you painted on Sunday.

How KanbanMail avoids the copy tax

KanbanMail is a free Chrome extension that puts a Kanban board inside Gmail, plus a Gmail add-on for the message you have open. You pick the email. It becomes a card with company, value, close date, next step and notes, and a link back to the thread. We do not scan your mailbox. We do not call the Gmail API from our server to read your mail. You choose what is a deal.

That is not a slight at Sheets, Streak, or HubSpot. Streak is a real CRM in Gmail if you want pipelines, mail merge and a team that will actually use it. HubSpot is right when marketing and sales already share a database. Salesforce is right when you have RevOps. A spreadsheet is right for a model. If the job is “see my ten live threads without retyping them,” the tracker should be a board on the same screen as the inbox.

For the method without the product pitch, use Gmail as a CRM. If you are choosing among tools, the 2026 Gmail CRM comparison is the honest map — including when the sheet still wins.