# Lead assignment by ZIP code **URL:** \ **Category:** Tips, Tricks & Best Practices\ **Created:** [January 3, 2023, 3:58pm UTC](https://community.hubspot.com/t/lead-assignment-by-zip-code/72119 "2023-01-03T15:58:25Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Benvenisti](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/benvenisti/32/62956_2.png) [@Benvenisti](https://community.hubspot.com/u/Benvenisti)\ **Post date:** [January 3, 2023, 3:58pm UTC](https://community.hubspot.com/t/lead-assignment-by-zip-code/72119/1 "2023-01-03T15:58:25Z")
One of our clients is assigning lead to salespeople according to the ZIP code of the lead. is there a way to create a workflow to manage these assignments withour having to create over 8000 if/then rulls (for each ZIP code). The ideal would be if we can upload somehow a batch of ZIP codes and assign each batch to a specific sales person. If this is not possible in HubSpot, is there any external tool that we can integrate to manage these assignments? Thanks Ron ---
**Author:** ![danmoyle](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/danmoyle/32/91166_2.png) [@danmoyle](https://community.hubspot.com/u/danmoyle)\ **Post date:** [January 3, 2023, 4:22pm UTC](https://community.hubspot.com/t/lead-assignment-by-zip-code/72119/2 "2023-01-03T16:22:32Z")
@Benvenisti if you create a list for regions based on ZIP codes, and included all values there, you could create a wrokflow that looks at list membership instead of individual ZIP codes. It’s still going to be a bit of a lift, as there isn’t a choice or ZIP code ranges, but you could certainly build a filter of multiple codes. That would be my first route. ---
**Author:** ![Benvenisti](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/benvenisti/32/62956_2.png) [@Benvenisti](https://community.hubspot.com/u/Benvenisti)\ **Post date:** [January 3, 2023, 4:52pm UTC](https://community.hubspot.com/t/lead-assignment-by-zip-code/72119/3 "2023-01-03T16:52:13Z")
Hi Dan, thanks so much for your quick respond. I’m looking into the solution you proposed and I have one question. while creating the list based on the filter - **ZIP code is equal to any of …,** is it possible to copy paste into the value field all the ZIP codes for a specific sales person? each sales man may have hundreds of ZIP codes and there are over 30 sales people so inserting each code separately is quite impossible. Thanks Ron ---
**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\ **Post date:** [January 3, 2023, 4:53pm UTC](https://community.hubspot.com/t/lead-assignment-by-zip-code/72119/4 "2023-01-03T16:53:41Z")
Hi @Benvenisti, If I may jump in here, yes, it is. I explained how here: [https://community.hubspot.com/t5/CRM/Filtering-a-view-with-a-comma-separated-list-of-company-IDs/m-p/381499/highlight/true#M122895](https://community.hubspot.com/t5/CRM/Filtering-a-view-with-a-comma-separated-list-of-company-IDs/m-p/381499/highlight/true#M122895) Best regards! ---
**Author:** ![danmoyle](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/danmoyle/32/91166_2.png) [@danmoyle](https://community.hubspot.com/u/danmoyle)\ **Post date:** [January 3, 2023, 4:55pm UTC](https://community.hubspot.com/t/lead-assignment-by-zip-code/72119/5 "2023-01-03T16:55:04Z")
Hey Ron. I believe you should be able to copy a list, [separated by semicolons](https://knowledge.hubspot.com/lists/lists-faq#:~:text=You%20can%20add%20multiple%20values,with%20a%20semicolon%20(%3B).), should work, yes. If it’s all in a spreadsheet, you should be able to find + replace commas with semicolons. Hopefully that makes a little easier. ---
**Author:** ![Benvenisti](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/benvenisti/32/62956_2.png) [@Benvenisti](https://community.hubspot.com/u/Benvenisti)\ **Post date:** [January 3, 2023, 5:02pm UTC](https://community.hubspot.com/t/lead-assignment-by-zip-code/72119/6 "2023-01-03T17:02:59Z")
Thanks Karsten and Dan, we’ve just tried your suggestion and it works perfectly. Problem resolved! ---
**Author:** ![JBigbee1](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jbigbee1/32/204222_2.png) [@JBigbee1](https://community.hubspot.com/u/JBigbee1)\ **Post date:** [October 17, 2025, 5:28pm UTC](https://community.hubspot.com/t/lead-assignment-by-zip-code/72119/7 "2025-10-17T17:28:27Z")
Check out my app [ZipCode AutoFill](https://app.hubspot.com/marketplace/47382331/listing/zipcode-autofill-3902521)! It autofills the city/state/county/country/timezone all from the 5-digit postal code and could be super useful here.