Transform and validate webhook records with configurable type conversion

Description

A self-contained data transformation workflow that runs entirely inside n8n. No external APIs, no credentials, no third-party services required. Send records via webhook, get transformed and validated data back.

Unlike CRM-specific import workflows, this template is a standalone data transformer you can place in front of any system: ERP, CRM, database, or API.

Who is this for?
Teams that regularly import data from external sources (suppliers, partners, legacy systems) and need to normalize field names, convert types, and validate records before loading into any target system.

How it works
Receive Data: A webhook accepts a POST request with an array of records (JSON) or a single record
Configure Mapping: A Set node defines the field mapping rules, source field, target field, data type, default value, and whether the field is required
Transform Records: A Code node applies all mappings: renames fields, converts types (string, number, boolean, date with locale support), fills in defaults, and validates required fields
Return Result: The webhook responds with transformed records and a validation report listing any errors per row

Key features
Zero dependencies**: No credentials, no external services needed
Locale-aware type conversion**: Handles comma decimals (12,50), German dates (DD.MM.YYYY), and ja/nein booleans
Validation report**: Returns per-row errors for required fields and failed type conversions
Flexible input**: Accepts { records: [...] } arrays or single objects

Setup
Activate the workflow
Edit the Configure Field Mapping node to define your mappings
POST your data to the webhook URL

How to customize
Add or remove field mappings in the Set node
Set removeUnmappedFields to true to strip fields not in the mapping
Set trimStrings to true to auto-trim whitespace
Set emptyStringToNull to convert empty strings to null values
Adjust dateInputFormat, dateOutputFormat, and decimalSeparator for your locale
Connect downstream nodes (database, API, email) after the response to process the output