n8n The Ultimate Course

Explore n8n basics within a low-code/no-code framework, connect nodes, and manage data using JSON and SQL server or Postgres.

Explore data types as the foundation of programming and low-code tasks, covering text and characters, numbers including floats and decimals, booleans, and date-time.

Discover how variables act as memory boxes that hold values of a specific data type, with keys and values in JSON using quotes and colons, and why data types matter.

Explore conditions in programming by comparing real-world if-then logic to code, using examples like Gmail checks and switch statements to handle multiple cases.

Explore collections, including arrays and dictionaries, and learn how in-memory, non-persistent data is organized as tables with rows and columns, zero-based indexing, and JSON-ready structures.

Master looping and iteration in n8n by processing each list item, splitting full names into first and last names, and performing conditional outreach to past customers.

Explore how basic functions perform tasks, have a name, and may not return a value. See parameter passing personalizes output with a name, and N810 uses functions in expressions.

Explore advanced functions by building a get full name with initial function that combines first, middle, and last names; use dot notation, parameters, intellisense, and json expressions.

Explain the difference between persistent data stored on disk or a database and non-persistent data kept in memory, which disappears when power is off.

Explore JSON through a spreadsheet analogy, learning keys, values, and nested objects like address, plus arrays and zero-based indexing, with n8n and N810 drag-and-drop expressions.

Explore the four use cases of N810: ai and chat workflows, forms processing, and traditional workflow automations—framed for IT operations, security operations, and development operations.

Explore building AI-driven workflows in n8n's N810, using sentiment analysis, data transformation, and chat with agentic AI tooling via OpenAI and other backends.

Discover how to build branded forms in n8n, embed them on websites, secure them with built-in authentication, and handle data via webhooks using email, text, and file fields.

See how workflows drive n8n with manual, application, and schedule triggers, api webhooks, and parent workflows; explore templates, json nodes, and building complex loops.

Explore how webhooks and APIs form endpoints, implement get and post methods, and design back end processing with authentication, testing, and data flows to Google Sheets using n8n.

Navigate the n8n user interface from the overview to personal spaces and folders, then create workflows and manage templates, credentials, and executions with robust filtering.

Learn how triggers start your n8n workflows and how actions carry out tasks, with real-world examples using google sheets, sql server, and webhooks to move and manage data.

Master inputs and outputs in n8n by configuring nodes on the canvas, naming nodes clearly, and understanding table, JSON, and schema outputs.

Explore versioning in the free edition of n8n, including one-day version history limits, exporting flows via the command line interface, and restoring or cloning versions while copying individual nodes.

Navigate the 2.0 breaking changes in n8n, focusing on code node migration, pyodide python code, task runners, docker challenges, and how to use the migration report and environment variable.

Explore the core nodes in n8n, the essential actions powering workflows. Learn practical use cases for code, http requests, webhooks, and sub workflows.

Learn how the code node lets you run JavaScript or beta Python to extract the sixth row’s customer_email from a SQL query, even for no-code users.

Make and manage API endpoints in n8n by wiring inbound webhooks, responding to webhooks, and issuing outbound HTTP requests as a core three-node workflow.

Learn how to use the http request node in n8n to call external APIs, send json payloads, manage authentication, and test with swagger and postman.

Execute a command on the host from a container and understand why, using Docker Desktop on Windows 11 with Linux fundamentals and commands like pwd and ls.

Discover how the execution data node captures extra metadata for each workflow execution, stores it as custom metadata, and enables focused reporting and queries in SQLite or Postgres.

Explore the FTP node in n8n, learn to list, download, upload, rename, or move a file, and compare FTP with SFTP while testing credentials on a sample site.

Explore how to manage the n8n core node and the N810 node, with the video placed in the administrative section as a placeholder while covering all nodes.

execute a child workflow from a parent workflow, passing a numeric input and waiting for the child's result, while learning input parameters, data typing, and triggers vs. sub workflow.

Explore the forms node in n8n, its role alongside respond to webhook, and recognize its place among core nodes in this course.

Explore the no operation node and learn how to explicitly model a path that does nothing when conditions aren’t met, using path a and path b for clear communication.

Delve into the wait node in n8n, examining time-based resume, webhook triggers, and form submission workflows, including runtime execution data, dynamically generated URLs, and suffix behaviors.

Explore the flow nodes in n8n, starting with a trigger node, then the filter node, as you learn about branch, loop, and merge concepts and preview core nodes.

Learn how to filter lists in n8n using the filter node, with exact-match versus contains logic in Google Sheets, including cascading filters and limitations on complex groupings.

Explore how the if node can filter data and trigger actions in one step, nest conditions, and cascade and/or logic to control true and false paths.

Master looping in n8n: process items from an RSS feed, extract URLs, and convert articles to markdown, while on error continue to keep the loop running.

Learn how the flow merge node combines up to ten data streams into a single dataset, using inputs like customers and orders and optional SQL joins.

Use the compare data sets node in an n8n flow to compare two data sources, identify differences, and loop over items to synchronize CRM and accounting data.

Explore how the execute sub workflow is delivered as a facade video that points to the core video, with a duplicate item under the flow in section four.

Explore how the stop and error node handles failed workflows, switch to an error output, and route errors to a system error handler or error workflow with alerts.

Explore how the switch item simplifies complex branching in n8n, replacing nested ifs with multiple outputs and a fallback option. Learn use cases like weekday-based routing and LinkedIn post automation.

Explore the weight concept in the core section and watch the core nodes video, where weight is covered in great detail and surprising insights await on this node.

Explore data transformation in n8n, focusing on core workflow concepts, data manipulation, and extract, transform, load techniques, with practical tips on nodes, variables, and filters.

Watch the facade video for the code node and follow the linked sections to access the full-length video detailing the code node.

Learn how to use the n8n date time node to get the current date, format dates, adjust date values, and handle time zones.

Explore edit field set to create variables as key-value pairs, name and value, with data types like string and date time, and format or convert dates using expressions.

Explore the filter concept through a placeholder video that directs you to the official full length video in the description.

Limit data by requesting only a top x number of items, as shown with select top ten, to avoid extra work and enable batch processing.

Learn how to remove duplicates in n8n using the remove duplicates and compare data sets nodes, with a focus on deduplicating by email, keeping new items, and handling fields.

Learn how the split out data transformation extracts just the customer name and email from a dataset and splits results into separate lists, using sql and no-code methods.

Learn how aggregate groups data into objects and arrays, turning Google Sheets table rows into a customers object with fields like ID, email, and phone number for data transformations.

Explore the merge concept through a placeholder video, refer to the previous section for the full-length content, and check the description for the link to the right video.

Master data transformations in n8n by summarizing with sum, average, and concatenate, and generate outputs such as comma-separated emails and appended aggregates from a joined SQL query.

Master compression and decompression in n8n data transformation, including zip and unzip operations. Learn to configure input binary fields and output naming for reliable disk read/write.

Convert any data to a file using the convert to file option, exporting tabular data to csv, html, or json. Explore working with base64 images and attachments.

Learn to wire crypto in data transformation, generate unique ids, passwords, and keys, and apply hash types like md5 and sha256 with hex, base64, ascii encodings for binary data.

Explore the data transformation edit image in n8n, including blur, crop, resize, and text edits, while noting metadata, aspect ratio, and the importance of consulting the documentation.

Explore the extract from file operation in n8n, ensuring input is binary data from a file, and compare how HTML and PDF inputs are parsed via HTTP requests.

Explore how the HTML node enables templating, table-to-html conversion, and HTML extraction in n8n, including CSS selectors, JSON-to-table workflows, and cross-site scripting considerations.

Explore how the markdown node converts HTML to markdown, producing minimal output for retrieval augmented generation and stripping HTML noise. Use an I node or AI styling to improve formatting.

learn how to transform data with xml and json in n8n, converting sql query json into xml per record and back, using data transformations and code node as a fallback.

Rename keys in the data transformation node to map customer name, customer email, customer phone number, and ID, with data untouched and noting SQL alternatives.

Sort data in n8n using order by to arrange by customer id or customer name in descending order, and compare sort node with the code node for flexible transformations.

Explore expressions in n8n, demystify built-in methods and variables, and learn how functions use parameters to return results, with a beginner-friendly pace and optional skipping for advanced users.

Explore data types in JavaScript-like expressions used in n8n, including strings, numbers, booleans, big integers, objects, undefined, null, and symbols, and learn to cast strings to numbers to avoid concatenation.

Explore jmespath in n8n to extract lists and fields from JSON data with expressions, covering objects, arrays, and the star wildcard to build dynamic flows.

Master string manipulation in n8n with replace all, split, trim, base64, and URL encoding to clean and extract URLs from RSS feeds and Google Alerts.

Learn how to create an RSS feed from Google Alerts in n8n, cast the publish date from string to date time, and compute the difference with diff two in days.

Explore how the from AI function and the sparkle tool automate email tasks by using context, memory, and prompts, while noting AI pitfalls like hallucinations.

Explore AI-driven workflow automation patterns, from traditional automation to AI routing and tool-based agents. Learn about retrieval augmented generation, MCP servers, system prompts, and agentic AI for smarter autonomous workflows.

Build and test an n8n chatbot using a chat message trigger and developer mode, then deploy publicly, exploring AI agents, a basic LM chain, and memory context for conversations.

Learn how retrieval augmented generation (RAG) powers an AI agent using ephemeral memory, Postgres memory, and a pinecone vector store with embeddings, namespaces, and upsert for enhanced context.

Explore upserting with retrieval augmented generation by wiring Google Drive triggers to a Pinecone vector store using OpenAI embeddings, recursive text splitting, and namespace N810.

Publish and customize a chatbot in n8n by activating the webhook, configuring environment variables, and embedding via hosted or embedded modes; adjust authentication, memory, and styling.

Explore building AI-powered, behind-the-scenes workflows in n8n that integrate google alerts, rss feeds, and article summarization to classify insights into eight business topics with prompt engineering.

Learn how the model context protocol (MCP) works as a server and client toolbox of tools and workflows, from calculators to AI components, with security considerations for production.

Explore hugging face as the model and data hub for open source models, with private cloud hosting options and vendors like Google, AWS, and Azure.

Understand model quantization, parameters, and context lengths, and learn how memory and gpu constraints shape loading 17b or 70b models, with Q4, K, and M quantization notes.

Connect Light LM and Lang Fuse to a single gateway, configure endpoints and fallbacks for OpenAI and alternatives, and enable governance, cost visibility, and usage-based billing for your AI applications.

Explore ai assisted coding with vibe coding to build a front end that consumes a simple n8n webhook back end, using parameterized queries and practical tooling.

Explore the guardrails node in n8n to detect text violations and sanitize output, using pass/fail checks, keyword scanning, and redaction, including not safe for work examples and threshold concepts.

Install node with brew on mac or MSI on Windows, then install n8n via npm. Run in docker for use, or Windows service with NSSM, or mac launch agent.

Install and run a docker container from an image. Map a local folder into the container for easy database access and enable port and restart configuration.

Install easy panel on Linode, deploy containers via Docker or repos, configure domain with https and Let's Encrypt, and manage continuous integration and delivery for scalable hosting.

Learn to securely expose a home n8n instance running inside a virtual machine using a free Cloudflare tunnel, zero trust access, and domain configuration for 24/7 availability.

Explore the hidden feature of estimated time saved in n8n, and learn to compute and report total time savings from workflow executions using SQLite or Postgres.

Use the n8n CLI to export credentials and workflows from the local SQLite database and import them to another server, enabling simple, separate export and import steps for migration.

Discover how to locate and configure environment variables in n8n, including Postgres and SQLite considerations, hosting with easy panel and Supabase, and key notes on endpoints, logs, and deployments.

Explore n8n system settings, from version checks and community edition options to upgrading plans, application programming interface access, external secrets, environments, single sign-on, log streaming, and community nodes.

Navigate licensing and privacy basics for n8n, including sustainable use license guidelines, hosting options, and compliance considerations for self-hosted and hosted deployments.