How to set contact properties in a workflow when data set is long

SOLVE
Occasional Contributor

For our business we have 216 markets mapped against 40,000 postal codes.  When a lead indicates their postal code, I would like to automatically assign the market.  We do this now manually using Excel's Vlookup, but it requires us to touch every record.  When I go to set up the workflow, I cannot assign a batch of postal codes; instead, I have to enter each one individually, otherwise it will read as one long numerical strand.  The only way I can see to set it up is to enter each postal code as an "is any" input.  I could do "starts with," but Hubspot does not allow for a from/to entry to assign a range.  Any thoughts?

Reply
0 Upvotes
1 Accepted solution

Accepted Solutions
Community Thought Leader | Diamond Partner

Hi @Dramaboy 

 

This sounds like something you would probably have to use the API to achieve. Or perhaps Zapier - have you tried that?

 

Hope this helps.

Phil Vallender | Inbound marketing for B2B technology companies
Reply
0 Upvotes
3 Replies 3
Community Thought Leader | Diamond Partner

Hi @Dramaboy 

 

This sounds like something you would probably have to use the API to achieve. Or perhaps Zapier - have you tried that?

 

Hope this helps.

Phil Vallender | Inbound marketing for B2B technology companies
Reply
0 Upvotes
Highlighted
Occasional Contributor

Hey Phil,

Many thanks for the reply.  Your suggestion got me on the right track.  We are going to use a webhook to accomplish this.

Thanks!

Community Thought Leader | Diamond Partner

Awesome - sounds like a good solution.

Phil Vallender | Inbound marketing for B2B technology companies
Reply
0 Upvotes