CRM

Weekly Deal-Rot Digest for Sales Managers

Compiles all stale opportunities across the team into a single ranked weekly digest grouped by rep and stage.

CategoryCRM
Enginesim
Difficultyintermediate
Triggerschedule
Steps5
Setup~15 min

How it runs

The automated pipeline, trigger to output.

  • TriggerWeekly pre-review schedule
  • ActionPull all open opportunitiesSalesforce
  • LogicFlag, rank, group stale deals
  • ActionGenerate digest narrativeOpenAI
  • OutputEmail digest to managersOutlook

What it does

Aggregates every aging opportunity across the whole team into one weekly leadership digest, ranked by deal value and grouped by rep and stage, then emails it to sales managers so they can coach where pipeline is rotting.

When to use it

Use it when managers need a top-down view of staleness rather than per-rep nudges. Good for weekly pipeline reviews where leadership wants to spot patterns, biggest at-risk deals, and reps with the most neglected opportunities.

How it works

  1. 1A weekly schedule fires before the pipeline review meeting.
  2. 2A Salesforce action pulls all open opportunities and their last activity dates.
  3. 3A logic step flags deals past the stale threshold, then ranks them by amount and groups them by owner and stage with rollup counts.
  4. 4An OpenAI step turns the grouped data into a readable digest with a short narrative on where attention is needed most.
  5. 5An Outlook action emails the formatted digest to the sales management distribution list, ready for the review.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect SalesforceAccounts, opportunities, cases.
  2. 2
    Connect OpenAIModels, embeddings, files.
  3. 3
    Connect OutlookMail, calendar, contacts.
  4. 4
    Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
  5. 5
    Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
  6. 6
    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.