Normalisation (data)
Reformatting incoming data into a consistent standard. Example: phone numbers arrive as "+44 7700 900123", "07700900123", and "0044-7700-900123" from different forms normalisation converts all three to E.164 format before storing.
Expert insight
Normalising data (converting "NY", "New York", and "N.Y." to one consistent value) before it enters a workflow's decision logic prevents a whole class of bugs where a conditional check fails simply because the incoming value doesn't exactly match what the condition expected, not because the underlying business logic was wrong.
In a real workflow
Country names like "UK", "United Kingdom" and "GB" are normalised to the ISO code "GB".
Common mistakes
- Normalising differently in each workflow.
- Losing the original value.
Complexity level
Requires some familiarity with automation concepts.
Related terms
See it in action
Want Normalisation (data) built into your automation?
Book a free audit and we'll show you exactly how this applies to your business.
Get my free automation plan →Who we build for
Run a firm, an agency or an online store? We automate the work behind it.
Done-for-you n8n workflows and Claude AI agents, fixed price, maintained for you.
- Professional firms Onboarding, documents, billing and reporting run on their own. See what we automate →
- Agencies and SaaS teams Custom n8n and Claude builds, client reporting and internal tools. See what we automate →
- E-commerce brands Orders, support, returns and stock handled without the busywork. See what we automate →
More in Data
Keep exploring
OCR (Optical Character Recognition)
Technology that converts images or scanned documents into machine-read…
Output schema
The defined structure of data produced by a workflow step field names,…
Parse
Converting raw data (JSON text, CSV, XML) into a structured format tha…
Pipeline (data)
A connected sequence of automated steps that data flows through from s…
Query (database)
A request for specific data from a database. Automation workflows ofte…
Serialisation
Converting a data object into a format that can be transmitted or stor…
Go deeper
Guides that cover Normalisation
n8n LinkedIn Job Automation: Auto-Apply, Track, and Follow Up on Jobs
Manual job hunting on LinkedIn consumes 2-4 hours daily between searching, tailoring applications, and tracking responses. An n8n workflow automates the entire pipeline from new job alerts to personalised applications to follow-up sequences.
Lead generation automation: build a 24/7 prospecting machine in 2026
Most businesses generate leads manually attending events, posting content, sending cold emails one by one. Here is how to build an automated prospecting system that generates, enriches, scores, and routes qualified leads around the clock.
How a 12-person real estate agency could automate 80% of its admin in 8 weeks
An illustrative scenario: a 12-person estate agency in South West London was losing hours every day to manual listing updates, lead routing, and follow-up. Eight weeks and seven automations later, they reclaimed 34 hours a week and increased viewing-to-offer conversion by 22%.