n8n The Ultimate Course

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 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.

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.

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.

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.

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.

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.

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.

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

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.

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.

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 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 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.

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.

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 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 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.

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.

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 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.

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.