CRM

Nightly Stale-Deal Rot Sweep with Owner Nudges

Each night, scans Salesforce open opportunities for deals with no activity past their stage's freshness threshold and posts a per-owner Slack digest of what's rotting and what…

CategoryCRM
Enginesim
Difficultybeginner
Triggerschedule
Steps5
Setup~5 min

How it runs

The automated pipeline, trigger to output.

  • TriggerNightly schedule fires the sweep
  • ActionQuery open Salesforce opportunities with activity datesSalesforce
  • LogicFlag deals past their stage freshness threshold
  • LogicGroup stale deals by owner
  • OutputDM each owner a Slack digest with next actionsSlack

What it does

Runs every night and flags open Salesforce opportunities that have gone quiet — no logged calls, emails, or stage changes within the freshness window defined for their current stage. Instead of one giant report, it groups rotting deals by owner and sends each rep a personal Slack DM listing their at-risk deals, days since last touch, and amount.

When to use it

Use this when reps let mid-funnel deals drift and your pipeline review is full of surprises. It turns silent decay into a daily, owner-specific nudge so deals get worked or honestly closed.

How it works

  1. 1A nightly schedule fires the sweep.
  2. 2Query Salesforce for all open opportunities with last-activity date, stage, owner, and amount.
  3. 3A logic step compares each deal's days-since-activity against its stage's threshold (e.g. 7 days in Discovery, 21 in Negotiation) and keeps only the stale ones.
  4. 4Group the survivors by owner.
  5. 5Post each owner a Slack DM digest with their stale deals, age, and a suggested next action.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect SalesforceAccounts, opportunities, cases.
  2. 2
    Connect SlackChannels, DMs, threads, mentions.
  3. 3
    Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
  4. 4
    Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
  5. 5
    Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.

Run this workflow in your colony.

14-day trial. No DevOps. No Sales call. Provisioned in under a minute.