easier way to update countries by their cities

Xiawanbai — Wed, 12 Mar 2025 14:40:18 GMT

We have many emty properties for countries due to wrong set up of the system and the forms from before. Now we are trying to update many of the properties e.g. countries.
I started to create this workflow but do you know about any easier/ more efficient way to update countries based on their cities?

Re: easier way to update countries by their cities

karstenkoehler — Wed, 12 Mar 2025 14:43:31 GMT

Hi @Xiawanbai,

I see three options here:

Filter for specific values, like in your screenshot (not feasible, doesn't scale)
Use a custom code action and look up a public data base: https://developers.hubspot.com/docs/reference/api/automation/custom-code-actions (requires help of a developer and an Operations Hub Professional or Enterprise subscription)
Use the new beta for Breeze workflow actions: https://knowledge.hubspot.com/workflows/use-ai-to-manage-data-in-workflows (the prompt would be for the Breeze AI to make it's best guess about the correct country)

This beta should show up under Settings > Product updates under ''Ask Breeze' action in workflows' in your portal.

Best regards

topic Re: easier way to update countries by their cities in Tips, Tricks & Best Practices

easier way to update countries by their cities

Re: easier way to update countries by their cities