Shapes

Reshape and enrich records

Normalize

Cleans up emails, phone numbers, countries and currency codes so records from different systems match.

Nodes › DataOpen in Neblex
Good for
Clean, matchable data
Role
Works on the records in a flow
Find it in
Nodes › Data

When to use it

  • Records from several systems should match on email, phone or country.
  • Phone numbers should be stored in one international format.
  • Values that cannot be cleaned should be tagged or routed for review.

Reach for something else when

Example

Normalize phone numbers to E.164 and countries to two-letter codes before loading contacts into the CRM.

  1. Poll for changes
  2. Normalize
  3. Remove duplicates
  4. HubSpot

How it works

Settings
Rules, each a Field and what to do with it: Email addresses (trimmed, the domain in lower case; the part before @ keeps its case, as mail servers may treat it so), Phone numbers (to E.164 such as +15551234567; a number without a country code is read in the rule's Region), Country (any name, in English, German or Spanish, or a two- or three-letter or numeric code, to its two-letter code), Currency code (a symbol or name to its three-letter code), Trim and collapse spaces, Unicode (NFC), Title case, Digits only. Mode: Repair [default], Tag or Route.
Output
Repair writes every value it can normalize and leaves the rest as they were. Tag adds _invalid, the fields that could not be normalized. Route adds _normalized (true or false) as well, and the node shows Valid and Invalid outputs.
More in the guide

Add it to a flow

  1. Open the flow from Build › Workflows.
  2. Open Nodes and find Normalize under Data, or search for it. Click it or drag it onto the canvas.
  3. Drag from the previous step's output handle to its input, then open its settings with ✎ Edit.
  4. Run the flow and click the step to see the records it received and produced.