Master n8n JSON & Data Transformation in 30 Minutes (Most Valuable n8n Skill)

Key Concepts

• JSON data: Key-value pairs, human and machine-friendly data format.
• Key: Identifies the data (e.g., "name", "email").
• Value: The actual data being referenced (e.g., "John Doe", "[email protected]").
• Data types: Text, Number, Boolean, Date, Binary, Collection, Array.
• Array: A list of the same data type (e.g., a list of services: DJ, photography, videography). Represented by square brackets [].
• Object: An assortment of different data types (e.g., client with name, email, phone). Represented by curly braces {}.
• Boolean: True or False value.
• Index: The position of an item in an array, starting from 0.
• Iterator (Split Out): A function that processes each item in an array individually.
• Aggregator (Array Aggregator): A function that combines individual items back into an array.
• Functions: Executing code (e.g., join, split).
• Join: A function that turns an array into text, separating items with a specified delimiter.
• Split: A function that turns text into an array, splitting the text based on a specified delimiter.

JSON Data and Key-Value Pairs

• JSON data is organized into key-value pairs. The key identifies the data, and the value is the actual data.
• Example: {"name": "John Doe", "email": "[email protected]"}. "name" and "email" are keys, while "John Doe" and "[email protected]" are values.
• Keys should be consistent across all data entries for easy referencing. If a key is misspelled or changed, it will not be found.
• Keys can be changed, but consistency is crucial for workflows to function correctly.
• JSON data can be created manually using manual mapping or by importing JSON objects.
• Chat GPT can be used to generate JSON data quickly for testing purposes.
• Example: Using Chat GPT to create JSON data for a client with first name, last name, email, phone number, and services.

Data Types in JSON

• JSON supports various data types, including text (string), numbers, boolean (true/false), dates, binary (files/images), collections, and arrays.
• Text: Represents textual data, enclosed in quotation marks (e.g., "Jane Doe").
• Number: Represents numerical data (e.g., 5000).
• Boolean: Represents a true or false value (e.g., true, false).
• Date: Represents a date value (e.g., date of form submission).
• Binary: Represents files and images (e.g., PDF, PNG).
• Collection: An assortment of random things (e.g., Google Drive folder).
• Array: A list of the same data type (e.g., a list of services: DJ, photography, videography).
• Arrays are represented by square brackets [] in JSON.
• Objects are represented by curly braces {} in JSON.
• Data types interact differently, and it's important to understand these interactions to avoid errors.
• Example: Comparing text "true" with boolean true will result in an error because they are different data types.
• Data types can be converted using functions or built-in features in N8N.

Data Type Conversion and Functions

• Data types can be converted from one type to another (e.g., object to string, boolean to text).
• Example: Converting a boolean value true to text results in "true" (with quotation marks).
• Mathematical operations on strings can lead to unexpected results.
• Example: "2" + "2" results in "22" (string concatenation), not 4 (addition).
• JavaScript functions can be used within N8N using curly braces {{}}.
• Join Function: Converts an array into text, separating items with a specified delimiter.
  • Example: Joining an array ["content writing", "social media", "branding"] with a comma and space results in "content writing, social media, branding".
• Split Function: Converts text into an array, splitting the text based on a specified delimiter.
  • Example: Splitting the text "Jane Smith" with a space results in the array ["Jane", "Smith"].

Iterators and Aggregators (Split Out and Array Aggregator)

• Iterators (Split Out) process each item in an array individually.
• Aggregators (Array Aggregator) combine individual items back into an array.
• Example: Processing a list of clients to remove duplicates or filter based on status.
• The Split Out node converts a single array into multiple individual items.
• The Array Aggregator node combines multiple individual items back into a single array.
• Limiters can be used to restrict the number of items processed.
• Real-world application: Combining multiple leads into a single email instead of sending individual emails for each lead.

Conclusion

Understanding JSON data, key-value pairs, data types, and functions is crucial for effectively using N8N. Data types must be handled carefully, and conversions may be necessary to ensure compatibility. Iterators and aggregators are essential for processing arrays and manipulating data within workflows. By mastering these concepts, users can build powerful and efficient automation scenarios in N8N.