Deal Stage Tracker: Build an Automated Sales Pipeline in Google Sheets
"Deal stage tracker" searches are made by founders watching pipeline rot happen in real time — deals sitting in a stage so long everyone forgot them. You don't need a $99/seat CRM to fix it. You need a Google Sheet with a spine. Here's the exact system I build for clients, and the automation that makes it self-maintaining.
The sheet structure that beats a CRM for small teams
- Deals tab — one row per deal: company, value, owner, stage, last-touched date, next step. Nothing else. The temptation to add 30 columns is how spreadsheets die.
- Stage history tab — appended automatically on every change. This is your velocity data six months from now.
- Config tab — stage names, SLA days per stage, owner list. Formulas read from here so renaming a stage isn't a find-and-replace nightmare.
The automation layer
The manual version dies because updates depend on memory. Apps Script removes the memory dependency:
function onEdit(e) {
const sheet = e.range.getSheet();
if (sheet.getName() !== 'Deals') return;
const stageCol = 5, touchedCol = 6;
if (e.range.getColumn() === stageCol) {
const row = e.range.getRow();
sheet.getRange(row, touchedCol).setValue(new Date());
logStageChange(row, e.oldValue, e.value); // append to history
if (stageAllowsMove(e.oldValue, e.value) === false) {
e.range.setValue(e.oldValue); // guard illegal jumps
}
}
}
On top of that: a daily trigger that flags every deal whose last-touched date exceeds the stage's SLA, colors it, and emails the owner a Monday-morning rot report. That single email is what makes the tracker work — stage data nobody reviews is decoration.
The formulas that make it feel like software
- Weighted forecast:
SUMPRODUCT(values, stage_probabilities)from the config tab — your pipeline value becomes honest instead of hopeful. - Stage velocity:
AVERAGEIF(history!stage, "Proposal", history!days)— when proposal velocity stretches from 9 to 16 days, you know before revenue does. - Conversion by stage: count stage transitions in the history tab — the leak funnel, computed free.
When you outgrow it: the same schema lifts into Airtable or a real CRM without re-architecting, because the discipline — stages, history, SLAs — was the hard part, not the tool. The full production version of this system, with deal-stage progression automation, is documented in this case study.
A pipeline tracker's job isn't recording where deals are. It's shouting where they're stuck.
FAQ
What is a deal stage tracker?
A system that records which stage every deal sits in, how long it's been there, and flags stalled ones. A spreadsheet with stage history and SLA alerts does this better than most teams' underused CRMs.
How do I track sales pipeline stages in Google Sheets?
Deals tab + stage history tab + config tab, with an onEdit trigger maintaining timestamps and history. The code above is the whole skeleton — most teams are live in a day.
How do I stop deals from going stale?
SLA days per stage plus a daily stale-check that emails owners. Rot is a notification problem, not a discipline problem.
Want the tracker built, wired to your real stages, and emailing by Friday? Book the free audit and bring your current pipeline export.