CRM

Reassign a departed rep's open pipeline by territory

When a Salesforce user is deactivated, this finds all of their open opportunities and reassigns each one to the active rep who owns its territory, then logs the moves.

CategoryCRM
Enginesim
Difficultyintermediate
Triggerevent
Steps6
Setup~15 min

How it runs

The automated pipeline, trigger to output.

  • TriggerSalesforce User deactivated (IsActive = false)Salesforce
  • ActionQuery open opportunities owned by that userSalesforce
  • LogicGroup opportunities by territory
  • ActionResolve active rep per territorySalesforce
  • ActionUpdate OwnerId on each opportunitySalesforce
  • OutputLog reassignment summary to SalesforceSalesforce

What it does

Detects when a Salesforce user record flips to inactive and immediately rehomes every open opportunity they owned. Each deal is routed to the active rep mapped to its territory, so pipeline never sits ownerless when someone leaves.

When to use it

Run this the moment a sales rep is offboarded — a resignation, a termination, or a role change that revokes Salesforce access. It closes the window where deals would otherwise stall with no owner and no follow-up.

How it works

  1. 1A Salesforce trigger fires when a User record's IsActive field changes to false.
  2. 2The flow queries all Opportunities owned by that user where StageName is not Closed.
  3. 3A logic step groups the opportunities by territory or region field.
  4. 4For each group it looks up the active rep assigned to that territory from a Salesforce ownership table.
  5. 5An action step updates OwnerId on each opportunity to the new rep.
  6. 6A final action writes a reassignment summary row to Salesforce (or a chatter post) recording old owner, new owner, and deal count for the audit trail.

Set it up

What you configure once, before turning it on.

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