Skip to content
Contact us
  • There are no suggestions because the search field is empty.

How to use Map Lookup in Property Transformer

The Map Lookup action lets you map a property value to a new value using a configurable lookup table. This is useful for mapping country codes to regions, industry codes to segments, standardizing messy data, or any scenario where you need to translate one value to another.

This action works on all object types, including Contacts, Companies, Deals, and Custom Objects.

Supported property types:
- Single-line text
- Dropdown select
- Radio select

How to set it up

  1. In your HubSpot workflow, add a new action

  2. Under "Integrated Apps", find "Brave Tools"

  3. Select "Map Lookup"

  4. Configure the input fields (see below)

  5. Map the output values to the properties you want to update

Input fields

Source value (required)
The property value to look up in the mapping table. Select any text, dropdown, or radio property.

Mapping configuration (required)
Your lookup table defined as key:value pairs separated by commas.

Examples:
- "SE:Nordics,NO:Nordics,FI:Nordics,DE:DACH,AT:DACH"
- "technology:Tech,software:Tech,finance:Financial Services,banking:Financial Services"
- "new:Lead,open:MQL,qualified:SQL,closed:Customer"

Default value
The value to use when no match is found in the mapping table. If left empty, the output will be empty when there is no match.

Case sensitive
Whether matching should be case sensitive. Options:
- No (default) - "se" matches "SE"
- Yes - Only exact case matches

Output fields

Mapped value - The looked-up result from the mapping table.
Was matched - true or false, indicating whether a match was found.

Example
You want to map country codes to sales regions.

Configuration: Mapping = "SE:Nordics,NO:Nordics,FI:Nordics,DE:DACH,AT:DACH,US:Americas"
Input: Country = "SE"
Output: Mapped value = "Nordics", Was matched = true

Good to know

  • The "Was matched" output is useful for branching logic in your workflow. You can use it to handle unmatched values differently.

  • By default, matching is case insensitive, so "se" will match a mapping for "SE".

  • You can map multiple source values to the same target value, which is great for consolidating data.

  • If the source value is empty, the output fields will be left empty and the workflow will continue.

  • Property Transformer is available on paid plans. Trial users do not have access to this feature.