Sales & CRM

How to clean up stale deals in your pipeline as Professional Services Founders

Sales & CRMFor Professional Services Founders3 apps12 steps~24 min to set up

Your pipeline review happens when a client cancels a call and you suddenly have 45 minutes free. You open HubSpot or a Google Sheet, see 23 deals, and realize six of them haven't had a logged activity in 60-plus days. You're not sure if those are dead, dormant, or just undocumented — because follow-up emails lived in your inbox, not in the CRM. You close the tab and go back to delivery work. Stale deals sit there inflating your weighted pipeline number, making your revenue forecast useless and your retainer renewal timing invisible. For a 12-person consultancy, a bloated pipeline isn't just messy — it's a planning liability.

Build this on Starch → See the apps used

Sales & CRMFor Professional Services Founders3 apps12 steps~24 min to set up

Outcome

What you'll set up

A live deal-health view that flags any opportunity with no logged contact or email thread in the last 30, 45, or 60 days — pulled from your HubSpot deals and Gmail history in one place

An automated weekly digest that surfaces the specific stale deals you need to act on, ranked by last-touch date and deal size, delivered to your Slack or inbox every Monday morning

A cleanup workflow that lets you bulk-archive dead deals, update stage and close-date fields, and draft re-engagement emails — all from a single Starch interface without bouncing between tabs

The Starch recipe

Apps, data, and prompts

The combination of Starch apps, the data sources they pull from, and the prompts you use to drive them.

Apps used

CRM Email Agent Task Manager

Data sources & config

Starch syncs your HubSpot deals, contacts, and owners on a schedule — including deal stage, close date, and owner fields. Starch also syncs your Gmail messages on a schedule so the deal health dashboard can correlate email threads to deal contacts by domain and name. Slack is connected from Starch's integration catalog; the agent queries it live to deliver your Monday digest. Task Manager captures follow-up actions inside Starch so nothing sits only in your head.

Prompts to copy

Build me a deal health dashboard that shows every open opportunity, the date of the last email thread in Gmail, the last activity logged in HubSpot, and a status flag — Green if touched in the last 30 days, Yellow if 31–60 days, Red if over 60 days. Sort by last-touch date ascending.

Every Monday at 8am, pull my Red and Yellow deals from the deal health dashboard and send me a Slack message with the deal name, estimated value, last contact date, and a one-line suggested next action for each one.

For each Red deal on my list, draft a re-engagement email to the primary contact. Use context from the last Gmail thread to make it specific — not a generic check-in. Queue the drafts for my review before sending.

Add a task for each Red deal I decide to keep open: 'Follow up with [contact] on [deal name] by [date 7 days from now]', P1 priority.

Run these in Starch → or paste them into your favorite agent

Walkthrough

Step-by-step

1 Connect HubSpot: Starch syncs your deals, contacts, companies, and owners on a schedule. Every open opportunity in your pipeline is immediately visible in Starch with its current stage, value, and close date.

2 Connect Gmail: Starch syncs your messages on a schedule. The agent can now match email threads to deal contacts by name and company domain, giving you a real last-touch timestamp — not just 'last activity logged by a human in HubSpot.'

3 Connect Slack from Starch's integration catalog so the agent can deliver digests and alerts to whatever channel or DM you prefer.

4 Start with the CRM app and describe your pipeline: tell Starch your deal stages (e.g., Proposal Sent, SOW Review, Closed Won), the fields you track, and what a 'stale' deal means to you. Starch builds a schema around your process, not a default template.

5 Build the deal health dashboard using the prompt above. Starch cross-references HubSpot deal data with Gmail thread dates to produce a color-coded staleness flag for every open deal. No formulas, no VLOOKUP.

6 Scan the Red column first. For each deal flagged over 60 days, decide: archive it, re-engage, or reclassify. This is the actual pipeline cleanup — 20 minutes instead of an afternoon.

7 For deals you want to re-engage, use the Email Agent prompt to generate context-aware drafts. Because the agent has read the last Gmail thread on that deal, the draft will reference the actual conversation — not a blank-slate 'just checking in' message.

8 Review and send the drafts you like. Email Agent queues everything for your approval; nothing goes out without you touching it.

9 For deals you're keeping open but need to act on, the Task Manager prompt drops a P1 follow-up task with a due date. Your deal cleanup produces an actual to-do list, not just a prettier spreadsheet.

10 Bulk-archive deals you've decided are dead: tell Starch 'close and mark these six deals as Lost with reason: No response after 90 days.' Starch updates HubSpot via the scheduled sync connection and logs the change.

11 Set the Monday morning Slack automation. Every week, without opening HubSpot, you get a ranked list of deals that need attention — so pipeline review becomes a 10-minute scan rather than a tab-switching exercise.

12 Once your pipeline is clean, use the deal health dashboard as your standing pre-call prep: before any client or prospect meeting, pull their deal card to see last email, last stage change, and open tasks in one view.

See this running on Starch

Connect your tools, describe what you want, and the agent builds it. Closed beta is free.

Try it on Starch →

Worked example

April 2026 Pipeline Cleanup — Strand Advisory Group

Sample numbers from a real run

Northfield Capital — M&A readiness retainer	48,000
Praxis Group — interim CFO engagement	36,000
Lodestar Logistics — process audit proposal	14,500
Hensley & Co — org design scoping	9,000
Meridian Partners — annual strategy retainer renewal	60,000

At the start of April, Strand Advisory's pipeline showed $167,500 in weighted open deals across 11 opportunities. After Starch's deal health dashboard ran against HubSpot and Gmail, the picture changed fast. Three deals went Red immediately: Lodestar Logistics had no email thread since January 18 (74 days), Hensley & Co's last logged activity was a HubSpot note from February that never turned into an email, and Praxis Group's engagement had actually closed verbally in March but never been marked Won. The Praxis deal alone was distorting the forecast by $36,000. Starch drafted a re-engagement email to Lodestar referencing the specific proposal items from the January thread — not a generic follow-up — which the founder reviewed and sent in under two minutes. The Hensley deal was archived. The Meridian retainer renewal, flagged Yellow at 38 days since last touch, got a P1 task: 'Send renewal SOW draft by April 11.' Total time: 28 minutes. Weighted pipeline dropped to $122,000 — still meaningful, now accurate.

Measurement

How you'll know it's working

Weighted pipeline accuracy: dollar value of open deals that have had real contact in the last 45 days versus total open pipeline

Average deal age at close: how long proposals sit from send to signature, so you can spot which service lines close fast and which stall

Retainer renewal rate: percentage of active retainers renewed at expiration — stale-deal cleanup is what makes this number visible before renewals lapse

Days since last client touch: a per-account metric that surfaces neglected relationships before they become churn, not after

Pipeline-to-revenue conversion by stage: what percentage of deals that reach 'SOW Sent' actually close, so you know where to spend your BD time

Comparison

What this replaces

The other ways teams handle this today, and how the Starch version compares.

HubSpot Sales Hub (paid tiers)

HubSpot has deal activity tracking built in, but correlating it with actual Gmail thread history requires manual logging or a paid Conversations inbox; it won't automatically flag deals as stale based on real email activity without custom workflows that take hours to configure and a Sales Hub Professional seat.

Google Sheets pipeline tracker

Free and flexible, but last-touch dates are whatever you remembered to type; there's no way to pull in Gmail thread timestamps automatically, so your 'staleness' flag is only as good as your data hygiene — which is the whole problem.

Salesforce + Einstein

Salesforce can surface stale deals with AI scoring, but for a 12-person consultancy the licensing cost, admin overhead, and implementation timeline are sized for a company four times larger.

Notion CRM template

Easy to set up and free to customize, but it has no native Gmail sync and no way to automate a Monday-morning digest without a separate automation tool stitched on top.

On Starch RECOMMENDED

One platform — crm, email agent, task manager all running on connected data. Setup in plain English; numbers stay current via scheduled syncs and live agent queries.

Try it on Starch →

FAQ

Frequently asked questions

We use HubSpot as our system of record. Does Starch replace it or sit on top of it?

Starch sits on top. Starch syncs your HubSpot deals, contacts, and owners on a schedule and can write changes back — like updating a deal stage or marking a deal Lost — but your team keeps logging calls and notes in HubSpot the way they always have. You're not migrating data or retraining anyone. Starch adds the cross-reference layer that HubSpot alone doesn't give you: correlating deal contacts to actual Gmail threads to produce a real last-touch date.

Will the Email Agent actually know what was discussed in a previous proposal thread, or will it write a generic follow-up?

Because Starch syncs your Gmail messages on a schedule, the agent reads the actual thread before drafting. If the last email discussed a specific deliverable scope or a sticking point on pricing, the draft will reflect that. It's not guaranteed to be perfect — you should always review before sending — but it's not starting from zero either. Every draft goes to your review queue; nothing sends automatically.

What if some of our pipeline lives in a Google Sheet, not HubSpot?

Google Sheets is available from Starch's integration catalog; the agent can query it live. You can describe a deal health view that pulls from your Sheet and Gmail together. If you want to migrate to the Starch CRM app instead, you can tell Starch to import the sheet and build a proper deal schema from your column headers — it'll clean up the formatting and infer the fields.

Is Starch SOC 2 certified? We sometimes handle sensitive client data.

Not yet — Starch is not currently SOC 2 Type II certified. If your clients require certified vendors for any data you'd pull in, that's a real constraint worth weighing. For deal metadata, email subject lines, and contact names, most consultancies find this acceptable; for engagements involving financial records or PII under strict contractual terms, check with your clients first.

How fresh is the HubSpot and Gmail data Starch is working with?

Both sync on a schedule — typically every few hours depending on your plan. This is not a live real-time feed. For a weekly pipeline cleanup workflow, scheduled sync is more than sufficient. If you close a deal at 2pm and run the dashboard at 2:05pm, you may see a short lag. For anything time-critical, you can trigger a manual refresh.

We track utilization and project health alongside pipeline. Can Starch handle that too, or is it just for deals?

Deals are the focus of this workflow, but the same platform handles utilization dashboards, client status reports, and retainer renewal tracking. Harvest and Float aren't in the scheduled-sync provider list, but both are reachable from Starch's integration catalog or via browser automation. You'd describe a separate app — 'show me a utilization dashboard by consultant, pulling hours from Harvest against booked capacity in Float' — and Starch builds it alongside your deal health view.