Resources

Solo sales workflows

How to track deals from email threads (without spreadsheets)

A Gmail-first approach to tracking deals: simple stages, clear exit criteria, and next steps that keep your pipeline honest without manual spreadsheet updates.

Feb 16, 20268 min read

Why spreadsheets fail for deal tracking

Spreadsheets work until they do not. The moment you are busy, your spreadsheet becomes stale because updates are separate from the conversation.

That is the core problem: data entry happens after the fact. By the time you update a row, the thread has moved on and you are already behind on the next step.

Build a lightweight pipeline (stages you can actually maintain)

The best pipeline is the one you will keep updated. Start with stages that match real commitment:

  • Lead: initial conversation and qualification.
  • Meeting: discovery call scheduled or completed.
  • Proposal: proposal sent and decision pending.
  • Negotiation: objections, procurement, or final alignment.
  • Closed: won or lost (archive after you learn).

Define simple exit criteria for each stage

Stages become meaningful when you define what changes them. Keep it practical:

  • Lead -> Meeting: a time is scheduled.
  • Meeting -> Proposal: you have requirements and you committed to send a proposal.
  • Proposal -> Negotiation: they engaged with scope, pricing, or timeline.
  • Negotiation -> Closed: a clear yes or no.

Use the next-step rule to prevent stalls

A pipeline is not just a board. It is a focus tool. The next-step rule keeps it honest: every open deal has a next step task.

When you finish an email thread, decide the next action while the context is fresh. That is the moment your CRM stays updated.

The weekly pipeline review (10 to 20 minutes)

  1. 1
    Scan your Proposal and Negotiation stages first.
  2. 2
    Add a next step task to anything that feels quiet.
  3. 3
    Move deals that progressed. Archive deals that are truly dead.
  4. 4
    Pick the top follow-ups and do them before new outreach.

Use tracking signals as hints, not guarantees

Email tracking can help you time follow-ups, especially for proposals. But opens can be blocked, and clicks do not always mean intent.

Treat tracking like a signal that helps you prioritize, not a source of truth.

Want this workflow inside Gmail?

Donna CRM is a lightweight Gmail-native CRM for solo operators. Keep context next to threads, track work in simple pipelines, and capture next steps before they slip.

FAQs

Common questions about this workflow and how to keep it lightweight.

Do I need a complex sales CRM to track deals?
Not if you are selling solo and most work happens in Gmail. A lightweight pipeline plus next-step tasks is often enough to stay on top of follow-ups and avoid stale data.
How many deals should I keep active?
Only keep deals active if you are willing to take the next step. If a deal has no next step, it is a distraction. Move it to a Dormant stage or close it out.
Should I track every email as a deal?
No. Create pipeline items for real opportunities. If it is not an opportunity or a relationship you plan to nurture, keep it as email only.

Related pages

Keep exploring: these pages go deeper on the feature set and the core Gmail CRM workflow.