Translate picklists between systems
Map values line by line when your ERP and HubSpot disagree on naming.
The challenge
Your CRM says United Kingdom and the downstream system expects GB. Every integration ends up carrying its own translation logic, or silently failing.
How AuPerate solves it
Transform and Map Data holds the mapping as readable lines you can edit without touching code, and applies it on the record.
How to build it
- 1Enrol records when the source property is set.
- 2Add Transform and Map Data and choose Map values.
- 3Enter one mapping per line as from = to, for example India = IN.
- 4Decide what happens when nothing matches: keep the original or leave the target untouched.
What the action gives you
- Value mapping with one from = to pair per line
- Concatenate with a live property multiselect
- Split one property into several, remainder preserved
- Regex extraction with capture groups
Related
Other patterns teams build
Convert a private PDF link into a public URL
The system snippet calls the HubSpot Files API for a signed URL and returns it as an output you can email or send onward.
Call an internal API with a signed JWT
Store the signing key as a secret, build the JWT in code with crypto, and post with axios.
Split full names, clean addresses, dedupe keys
Any string surgery HubSpot operators cannot do: regex, lookups, multi-step logic.
Build this in your own workflows
Install AuPerate once and every action appears in your HubSpot workflow editor.
Get Started