SALES
Reassign Accounts When a Rep Exceeds Capacity
Watches each rep's open pipeline and active account count in Snowflake, and when a rep crosses their capacity threshold it reassigns their newest unworked accounts…
How it runs
The automated pipeline, trigger to output.
- TriggerNightly schedule
- ActionRead per-rep capacity metrics from SnowflakeSnowflake
- LogicFlag overloaded reps with idle accounts
- ActionFind lowest-loaded eligible rep in territorySnowflake
- ActionReassign account OwnerId in SalesforceSalesforce
- OutputPost rebalancing summary to SlackSlack
What it does
Keeps individual rep workload inside a healthy band. It reads per-rep capacity metrics from Snowflake, finds reps who are overloaded, and rebalances their unworked accounts to teammates who have room — then records every reassignment back in Salesforce so the audit trail is clean.
When to use it
Run it when inbound volume is uneven and a few reps are drowning while others sit idle. Ideal for inside-sales teams where territory is loose and accounts can move between reps in the same segment.
How it works
- 1A nightly schedule kicks off the run.
- 2Query Snowflake for each rep's open-opp count, total pipeline value, and active accounts.
- 3Branch: flag reps whose load exceeds their tier threshold and have at least one account with no activity in 14 days.
- 4For each overloaded rep, query Snowflake for the lowest-loaded eligible rep in the same territory and segment.
- 5Update the OwnerId on the selected accounts in Salesforce and stamp a reassignment note.
- 6Post a per-rep summary of who gained and lost accounts to the sales-ops Slack channel.
Set it up
What you configure once, before turning it on.
- 1Connect SnowflakeWarehouses, queries, shares.
- 2Connect SalesforceAccounts, opportunities, cases.
- 3Connect SlackChannels, DMs, threads, mentions.
- 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 Sales workflows
Power-Feature Adoption Expansion Digest
Each Monday, finds accounts that started heavily using a premium or add-on feature in BigQuery, ranks them by expansion potential.
Send buyers a weekly mutual action plan health recap
Each week it reads the MAP Trello board, computes completed, on-track, and overdue steps, and emails the buyer champion a clean recap of progress and what is due next.
MEDDIC Gap Sync to HubSpot Deal Properties
Transcribes a finished Zoom discovery call, extracts MEDDIC details, and writes structured values into custom HubSpot deal properties while logging the call as a timeline note.
Enrich new MAP steps with Salesforce deal context on creation
When a new card is added to the mutual action plan Trello board, it looks up the linked Salesforce opportunity and writes deal owner, amount, and close date onto the card…
Seat-Limit Approaching Upsell Alert
Fires the moment an account's active-seat count crosses 90% of its contracted limit in the product database.
API-Usage Surge PQL Router
When an account's API call volume surges past a rolling baseline in the product DB, it qualifies the account as a product-qualified expansion lead.
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.