The answer
Partly. Finding deals with no activity, nudging reps, sending a final check-in and moving lost deals into nurture are automatable today. In our model about 60% of clean-up time can go to software. What stays human is the rep's honest call on whether a deal is alive and the manager's review of what it does to the forecast.
The tasks, and how much of each is automatable today
Six tasks make up stale deal clean-up. Finding stale deals and moving lost ones to nurture are 95 to 100% automatable. Closing deals as lost with a reason is about 75% automatable. Nudging reps and sending final check-ins are about 60% automatable. Reviewing the forecast impact stays mostly human, because it is a judgement about the business.
| Task | Min / week | Automatable |
|---|---|---|
| Find deals with no recent activityA saved filter or scheduled query does this completely. | 45 | |
| Ask reps for the real statusAutomated Slack prompts with one-tap answers get most responses. Reps who ignore them need a manager. | 60 | |
| Send a final check-in to the prospectA short 'should I close your file?' email can go automatically. High-value deals deserve a personal note. | 90 | |
| Close lost deals with a reasonClosing is automatic after no response. The reason field is only useful if a rep picks it. | 60 | |
| Review what clean-up does to the forecastSoftware can show before and after numbers. Deciding what to tell leadership is human. | 60 | |
| Move closed-lost contacts into nurtureA stage change triggers enrolment in a nurture sequence. Exclude anyone who asked not to be contacted. | 30 | |
| Whole process | 345 |
Hours saved per week
For a six-rep B2B sales team with about 400 open deals, many untouched for a month, clean-up takes around 6 hours a week across the team. Automating the tasks above returns about 3.5 hours a week. The rest goes on honest pipeline review, which is the point of the exercise.
Modelled on: A six-rep B2B sales team with about 400 open deals, where a large share have had no logged activity for over a month.
- About 40 deals a week cross the stale threshold.
- About 45 minutes a week to find stale deals in reports, and an hour asking reps for status.
- About 90 minutes a week writing final check-in emails to prospects.
- About an hour a week closing deals with reasons, and an hour in pipeline review.
Tools that do the job
You need a CRM that records last activity per deal, a rule for what counts as stale, and a way to prompt reps. HubSpot, Pipedrive and Salesforce all track activity dates. n8n or Make runs the weekly check, messages reps in Slack and sends a final email to the prospect.
- HubSpot
- Tracks last activity and time in stage per deal; workflows can act on both.
- Pipedrive
- Rotting deal settings highlight deals idle longer than a set number of days per stage.
- Salesforce
- Reports on stage duration for larger teams, with flows for automated actions.
- n8n
- Weekly job that applies stage-specific thresholds and sends reps their list.
- Slack
- Rep prompts with one-tap buttons: keep, close lost, or send final check-in.
- Gmail
- Sends the final check-in from the rep's own address so replies go to them.
A simple workflow
The workflow runs weekly. It flags deals that have sat in a stage longer than the usual time for that stage. Each rep gets a Slack list with one-tap options: keep with a next step, close lost, or send a final check-in. Deals with no answer in a week are closed lost and moved to nurture.
- DefineSet a stale threshold per stage from your own data, such as twice the median days in that stage.
- FindWeekly query lists deals over the threshold with no future task scheduled.
- PromptEach rep gets their list in Slack with options: add a next step, close lost, or send a final email.
- ActFinal check-in emails go from the rep's address. No reply and no rep action in seven days closes the deal.
- RecycleClosed-lost contacts join a long-term nurture sequence, unless they opted out.
Keep these human
- The rep's honest call. Only they know whether the buyer said 'next quarter' and meant it.
- Forecast review. Removing dead deals changes the number leadership sees, and that conversation needs context.
Where it goes wrong
- One threshold for every stage. Thirty days is normal in a long negotiation and fatal at first contact. Use per-stage thresholds.
- Reps adding fake next steps to dodge the prompt. Check that future tasks actually get completed.
- Closing deals the rep was working outside the CRM. Ask before closing; never close silently.
What most guides miss
Most guides set one 'no activity in 30 days' rule. That flags healthy late-stage deals and misses early ones that died in a week. Set the threshold per stage from your own pipeline, such as twice the median days in that stage. Then send a short 'should I close your file?' email; it often gets a reply.
The evidence
- Sales reps spend 70% of their time on non-selling tasks, including updating the CRM.Salesforce, State of Sales, 6th edition (2024)
- Managing others has a technical automation potential of only 9%, which is why getting honest status from reps stays human.McKinsey Global Institute, A future that works: Automation, employment, and productivity (2017)
“There is surely nothing quite so useless as doing with great efficiency what should not be done at all.”