CRM
Rebalance Orphaned Accounts Using Airtable Territory Rules and Email Handoffs
Reassigns a departed rep's accounts by matching each account's ZIP or region against an Airtable territory map, updates Salesforce ownership.
How it runs
The automated pipeline, trigger to output.
- TriggerOperator runs with departing rep's user ID
- ActionPull orphaned accounts with ZIP/region/segmentSalesforce
- ActionResolve new owner via Airtable territory rulesAirtable
- LogicFlag unmatched accounts into exceptions list
- ActionUpdate OwnerId for matched accountsSalesforce
- ActionEmail each new owner a handoff briefGmail
- OutputReturn exceptions list for manual placement
What it does
Instead of round-robin, this routes each orphaned account to the right owner using a rules table in Airtable that maps regions, ZIP ranges, or industry segments to specific reps. It then writes the new owner back to Salesforce and sends each rep a tailored handoff email.
When to use it
Use this when territories are deliberately structured by geography or vertical and a fair-but-blind round-robin would break those boundaries. Ideal for field sales teams where the right rep is determined by where the account sits, not whoever is next in line.
How it works
- 1Trigger: an operator runs the workflow with the departing rep's Salesforce user ID.
- 2Pull all accounts still owned by that rep, including billing ZIP, region, and segment.
- 3Look up each account against the Airtable territory rules table to resolve the correct new owner.
- 4Logic step flags any account with no matching rule into an exceptions list for manual review.
- 5Update matched accounts' OwnerId in Salesforce.
- 6Email each receiving rep a Gmail handoff brief listing their newly assigned accounts and why each was routed to them.
- 7Output the exceptions list so sales ops can place the leftovers by hand.
Set it up
What you configure once, before turning it on.
- 1Connect SalesforceAccounts, opportunities, cases.
- 2Connect AirtableBases, tables, views, automations.
- 3Connect GmailRead, draft, send, label.
- 4Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
- 5Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
- 6Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.
More CRM workflows
Dormant Account Check-In Call Scheduler
On the anniversary of an account's last touch, books a tentative check-in call on the owner's Google Calendar and emails the contact a scheduling invite.
Weekly Dormant-Anniversary Cohort Digest
Every week, groups dormant Attio accounts by which last-touch anniversary they hit that week, builds a prioritized digest.
AI-Personalized Dormant Account Win-Back
On a dormancy anniversary, an agent researches the account's history and recent public signals, drafts a genuinely personalized win-back email.
Backfill Intercom conversation topics onto stale HubSpot contacts
Finds HubSpot contacts with no recent Intercom topic, pulls their conversation history from Intercom, classifies the dominant topic with OpenAI.
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.
Tag closed Intercom conversations onto Salesforce contacts in real time
On each Intercom conversation close, classifies the topic with OpenAI and appends it to the matching Salesforce contact's activity timeline so the topic never goes stale…
Run it inside a business
This workflow drops into a full company template. Import the org, and this is one of the playbooks its agents run.
Run this workflow in your colony.
14-day trial. No DevOps. No Sales call. Provisioned in under a minute.