How can I create a workflow in HubSpot so that when a new Deal is created, it gets automatically assigned to sales reps in a specific location, using either active deal count, rotate-to-owner, or a round-robin assignment method?
Hi @mRamees1,
This requires deal based workflows - you would branch by location, then leverage this feature: Assign ownership of records
Best regards!
hey, can you please be a bit more clear, when creating a deal in a workflow there is an option to assign it ---
Are you refering to that?
When a deal is created, it is automatically assigned to sales reps from the location-based team (I’ve created teams for specific locations with sets of sales reps in each). The assignment is supposed to happen either based on the sales reps’ active deal count or by using the ‘Rotate record to owner’ method.
The problem is that when I create multiple deals, all of them get assigned to the first sales rep in the team. Instead, I need the deals to be assigned to the sales rep who currently has the lowest deal count.
Hi @mRamees1,
You can absolutely automate this in HubSpot using Workflows. Here’s how you can set it up:
1. Start with a Deal-based workflow
Go to Automation → Workflows.
Create a new Deal-based workflow.
Enrollment trigger: Deal stage is known (or specifically “Deal stage = New Deal”).
Add a filter for Location property (make sure your Deal or associated Company/Contact has a property for location).
2. Assign by location
Use an If/Then branch based on the deal’s location.
Example: “If Location = East Coast → go down this branch.”
3. Rotate or round-robin assignment
Inside each location branch, add the action “Rotate record to owner.”
Select the group of sales reps that should cover that region.
HubSpot will automatically rotate deals evenly among those reps.
Hope this help!
Hi @mRamees1,
You can do this with a Deal-based workflow. A quick outline you can follow:
-
Set enrollment trigger → e.g. Deal stage = New Deal
-
Check for location → Use an If/Then branch based on the deal’s Location property
-
Assign in round robin → Inside each branch, add Rotate record to owner and select the pool of reps covering that region. HubSpot will then distribute deals evenly.
-
Best practices:
- Add a fallback branch for No Location so deals don’t get stuck.
- If you want to balance workload instead of just rotation, you can also filter based on -Active deal count.
- Keep your rep lists updated so the right people are always included in the round robin.
That way, you’ll have both location-based routing and fair distribution across your team.
Regards,