Get Started

Transform and Map Data

Map values, reshape text and mine JSON, in one action. Six record-level transformations behind one selector: map values between picklists, concatenate or split properties, extract with regular expressions, normalize domains, and pull values out of JSON payloads.

Get StartedDocumentation
Transform and Map Data
What you get

Map values, reshape text and mine JSON, in one action

  • 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
  • JSON dot-path extraction from stored payloads
How it works

Operations inside this action

Pick an operation and the form shows only the fields that operation needs.

Map values

Translate country names to codes, legacy stages to new ones, anything enumerable.

Concatenate and split

Build display names, or break a combined field apart.

Regex extract

Pull an invoice number or order id out of free text.

Extract from JSON

Read data.items.0.id out of an API response stored on the record.

Use cases

What teams build with Transform and Map Data

Translate picklists between systems

Map values line by line when your ERP and HubSpot disagree on naming.

integrationsdata cleanup

Mine an API response stored on a record

A webhook writes raw JSON to a property; extract the fields you need with dot paths.

integrations

Pull reference numbers from notes

Regex-extract structured ids out of unstructured text fields.

data cleanup
Browse every use case
Keep exploring

Pairs well with

Run Custom Code

Write JavaScript inside HubSpot workflows

Learn more

Send Webhook

Call any API from a workflow, with retries

Learn more

Format Data

Clean, convert and compute values, including phone numbers

Learn more
FAQ

Transform and Map Data questions

Everything teams ask before putting this action into production.

Transform and Map Data reads and writes record properties directly, using live property pickers. Format Data works on values you pass in and returns a result as an output. Use Transform when the record itself should change.
Choose Map values and enter one mapping per line as from equals to, for example India = IN. Unmapped values can keep the original or leave the target untouched.
Yes. Choose Extract a value from JSON and give a dot path such as data.items.0.id. The JSON can come from a property that a webhook response was written into.
Go deeper

Documentation and related reading

Transform and Map Data reference Every use case Plans and pricing All ten actions

Add Transform and Map Data to your workflows today

Install AuPerate once and every action appears in your HubSpot workflow editor.

Get Started