Hi @alexagatiss,
Yes, this is publicly available info – but it’s not stored in HubSpot. If you wanted to access a public database about this (or simply a table), this would require a custom coded action: Workflows | Custom Code Actions - HubSpot docs
It’s not super complicated and you’ll get that to work with the help of generative AI but it requires an Operations Hub Professional or Enterprise subscription.
Without that, you’ll need to set up a your workflow that enrolls records where ‘Postal code is known’. After enrollment you’ll add a branch where each path corresponds to the postal codes of one state (the filter of one such branch would be “Postal code is any of” and then you’ll list the postal codes of the state for this first branch. In each branch, you can then use the ‘Edit record’ workflow action to update the state property.
- Postal code is A, B, or C → Edit record to update state to be X
- Postal code is D, E, or F → Edit record to udpate state to be Y
etc
If you do this all manually, it’s quite a bit of work, unfortunately. Custom code makes it a lot easier.
Let me know if you have any follow-up questions or if I should specify anything.