CRM

Daily orphaned-opportunity sweep with manager Slack digest

Each morning this scans Salesforce for open opportunities owned by inactive users and posts a per-manager digest in Slack listing the orphaned deals that need a new owner.

CategoryCRM
Enginesim
Difficultybeginner
Triggerschedule
Steps5
Setup~5 min

How it runs

The automated pipeline, trigger to output.

  • TriggerDaily schedule (morning sweep)
  • ActionQuery open opps owned by inactive usersSalesforce
  • LogicDedupe and group orphaned opps by manager
  • ActionFormat per-manager deal digest
  • OutputPost orphaned-deal digest to each manager in SlackSlack

What it does

Runs a scheduled sweep that catches any open opportunity still pointing at a deactivated owner — even ones missed by real-time triggers — and routes a clear list to each manager so nothing rots silently in the pipeline.

When to use it

Use this as a safety net alongside event-based reassignment, or on its own if your org disables users in bulk. It surfaces stale ownership every morning before standup so managers can act.

How it works

  1. 1A daily schedule trigger kicks off the sweep.
  2. 2An action queries Salesforce for open opportunities where the owner's IsActive is false.
  3. 3A logic step filters out anything already flagged for reassignment and groups the remainder by reporting manager.
  4. 4For each manager the flow formats a digest with deal name, amount, stage, and close date.
  5. 5An output step posts the digest to each manager's Slack channel or DM, tagging them and linking each deal.

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.