ETL
Data transfer: extract data from a source, transform it into a consistent format, and load it into a destination (such as a spreadsheet, warehouse, or CRM).
On this page
Source content checked . English translation published 2026-10-27.
In business automation
ETL separates data collection, transformation, and loading into a destination. It suits cases where data from different sources needs to be consolidated into a report or central system, with consistent rules for fields and timing.
Examples
These examples illustrate a possible workflow. Adapt the connections and rules to your own systems.
Business process example
Orders from the store and deals from the CRM are collected every night. Field names and currencies are normalized, invalid records are separated, and valid data is loaded into a reporting table with an update date.
Relevant tools
- n8n
- Collection, transformation, and loading steps can be built with nodes; large data workflows require checks for volume and operations.
What to check
- Save the progress marker and check repeated loads. Running the same day again should not double the revenue in the report.