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.

Deal Stage Tracker: Build an Automated Sales Pipeline in Google Sheets | Noushad Bhuiyan