How to Automatically Find a Country from an Address in HubSpot Workflows (Using Custome Workflow Starter)

Purpose

The primary purpose of this workflow action is to automatically find or estimate the country to which an address belongs, based on an address string (like city, state, and street) stored in a HubSpot property.

As the action description notes, it will output "Japan" from a Japanese address like "7-5-1 Hakusan, Toride City, Ibaraki Prefecture," or "Canada" from a Canadian address like "Nelson Ave, Burnaby, BC."

The result is returned as an output value called "result." This value can be used in subsequent workflow actions. Please use it for updating properties or for branching conditions.

Use Cases

This feature is very effective for cleaning up address information that is missing country data.

• Data Cleansing and Enrichment: Automatically populate the "Country/Region" property when a form is submitted with only city and street-level address data.
• Global Customer Segmentation: Automatically create lists by sorting customers by country based on their address information.
• Data Normalization: Run this workflow on existing contact data that only has partial addresses to batch-append country data and clean up the database.

Setup and Execution Steps (As seen in the video)

The video shows the setup and execution of a workflow that finds the country ("Canada") from a Canadian address string ("Nelson Ave, Burnaby, BC").

Step 1: Check Workflow and Trigger

• The process begins in the workflow editor.
• The trigger (enrollment criteria) is set to activate when the "Event Date" property value is changed.

Step 2: Add the Custom Action

• Click the "+" icon in the workflow to add a new action.
• From the action selection panel, choose "Custome Workflow Starter" from the "Integrated apps" section.

Step 3: Select the Action

• From the list of custom actions that appears, select "Country output from address."

Step 4: Specify the Address for Lookup

• The configuration screen for "Country output from address" opens.
• Input data format: Select the format of the incoming address data (e.g., jp, en, japan, etc.).
• Input address value: Enter the address data you want to find the country for. Typically, you would insert a HubSpot property token here (e.g., the contact's "Street Address" property).
• For demonstration purposes, the video enters the fixed value "Nelson Ave, Burnaby, BC".
• After configuring, click "Save."

Step 5: Activate the Workflow and Confirm Execution

• The "1. Country output from address" action is added to the workflow.
• Activate the workflow ("Workflow is On") and perform the action that meets the trigger criteria.
• Navigate to the "Enrollment history" tab and click on the execution history for the "test@gmail.com" contact.

Step 6: Verify the Final Result

• The execution "Event details" will appear on the right side.
• You can see that the action executed successfully ("Successful").
• In the "Action outputs" section, the LABEL is result and the VALUE is Canada.
• This confirms that the country was correctly found from the specified address string and returned as an output.

This output value (Canada) can then be used in a subsequent "Set property value" action to save it to the contact's "Country/Region" property.

‍