n8n Automation
Learning and running n8n: triggers, data handling, integrations, AI agent workflows, self-hosting with Docker and production operations.
Topics in n8n Automation
Learning series
Articles in n8n Automation (page 1 of 6)
- Google Sheets as a Database for AI Automation: Limits and How to Migrate — A spreadsheet is the perfect prototype database and a poor production one. This guide shows where Google Sheets breaks under automation, how to make it safer while you stay, the signals to move, and a staged migration plan.
- Dates, Times and Time Zones in AI Automation: Bugs and Fixes — Reports that are off by a day, reminders at the wrong hour and duplicates at daylight-saving changes all come from the same handful of mistakes. This guide shows how to store, convert, parse and test dates and time zones correctly.
- SQL for Automation Builders: Joins, Aggregates and Safe Writes — Automation builders hit databases constantly, often with just enough SQL to be dangerous. This guide covers the queries you actually need: joins, aggregates, upserts, transactions and the habits that stop a bad write from becoming an incident.
- JSON, JSONPath and jq for Automation Builders — Nearly everything an automation touches is JSON, and most silent failures are a missing key, a null or an array of the wrong length. This guide teaches the reading, reshaping and validating skills with jq and JSONPath recipes.
- OAuth for Automation Builders: Scopes, Refresh Tokens and Why Connections Break — Workflows that worked for weeks suddenly fail with 401 errors, and the cause is usually an OAuth detail nobody explained. This guide covers flows, scopes, refresh tokens, expiry and revocation, plus how to build automations that survive them.
- API Pagination Patterns for Automation Builders: Offset, Cursor and Beyond — Most APIs return data in pages, and most automation bugs here are silent: missed rows, duplicates, or a loop that never ends. This guide covers each pagination style, safe loop design, rate limits, checkpoints and how to test.
- Webhook Security for AI Automations: Signatures, Replay Protection and Safe Payloads — A webhook is a public door into your automation, and most tutorials leave it unlocked. This guide maps threats to controls: authentication options and their strength, correct HMAC verification, replay protection, secrets, and what changes when the payload feeds a language model.
- Idempotent AI Automation: How to Stop Duplicates, Retries and Replays from Doing Damage — A retry creates two CRM records and two welcome emails, and nothing was technically a bug. Idempotency is the design idea that prevents it. This guide covers where duplicates come from and the concrete patterns, code and tests that make workflows safe to repeat.
- A 30-Day AI Automation Learning Plan That Ends in a Portfolio Project — Most learning plans list topics and leave you to guess what to do on Tuesday. This one assigns a concrete deliverable to every one of thirty days and ends with a measured, documented automation you can show to clients or employers.
- AI Won't Replace You. But People Who Know How to Automate With AI Might. — AI is not only about generating text. The bigger opportunity is AI plus data, tools, APIs, automation and human oversight. This flagship guide explains the difference between using AI and building AI automation, what agents and RAG really are, and how to start.
- How to Become an AI Automation Engineer: Skills, Roadmap and First-Year Plan — The title is loose and the job descriptions vary, so this guide defines the work, orders the skills by dependency instead of hype, and lays out what a realistic first year of learning and building looks like.
- Turning Sales Call Notes into Clean CRM Fields with AI Automation — A call summary is easy for an LLM to produce. Getting deal stage, next step, and budget into the right CRM picklist fields without silently corrupting the record is the actual engineering problem.
- Running an Automation Agency on n8n: Multi-Client Workflows Without the Chaos — The workflow that works cleanly for one client becomes a maintenance liability the moment you've copy-pasted it for the tenth time, each with slightly different tweaks nobody documented. Agencies that scale past a handful of clients on n8n solve this deliberately, not by accident.
- n8n Stripe Node: Automating Payment Events Without Custom Webhook Code — Stripe fires a webhook for nearly everything that happens to a payment -- succeeded, failed, disputed, refunded. The n8n Stripe node and Stripe Trigger turn those events into automation without you writing and securing a custom webhook endpoint by hand.
- n8n for Teams: RBAC, Audit Logs, and Environments at Scale — A single person running n8n needs almost none of this. A team of ten building and depending on dozens of production workflows needs all of it -- who can edit what, who touched a workflow before it broke, and a clean boundary between what's being tested and what's actually running the business.
- n8n Paired Items (Item Linking) Explained: Why .item Breaks and How to Fix It — How n8n links each output item to the input that produced it, the exact cases where automatic linking fails, the three item-linking errors (missing info, multiple matches, another branch) and their fixes, pairedItem and itemMatching in the Code node, and how to avoid the problem.
- n8n Chat Trigger Explained: Giving Your AI Agent a Ready-Made Chat Interface — Building a chat UI from scratch just to test an AI Agent node is wasted effort n8n already solved -- the Chat Trigger node gives a workflow a ready-made chat window, embeddable widget, or API endpoint without writing a single line of frontend code.
- n8n Aggregate Node: Combine Many Items Into One (Without Misaligned Lists) — The Aggregate node's two operations, the default that drops null values and misaligns parallel arrays, its other options, when Summarize, Merge, Split Out or a Code node fits better, what Aggregate does to item linking, and a worked one-Slack-message example.
- n8n Postgres Node: A Complete Guide to Database Workflows — Most n8n automations eventually need to read or write to a real database rather than a spreadsheet or a third-party app -- deduplication checks, state tracking, or a system of record the rest of a workflow depends on. The Postgres node is how that happens without a custom backend.
- n8n Vector Store Nodes: Building a RAG Pipeline Without Leaving n8n — n8n's LangChain-based nodes cover the full RAG loop -- document loading, chunking, embedding, and storage in a vector index -- as native nodes, which means a basic retrieval-augmented generation pipeline can be built entirely inside n8n without a separate application layer.
- n8n and MCP: Connecting Workflows to Model Context Protocol Servers — MCP standardizes how an AI agent discovers and calls tools. n8n now speaks both sides of that protocol -- it can act as an MCP client, calling tools exposed by an external MCP server, and expose its own workflows as MCP tools for other agents to call.
- Klaviyo AI Automation for Email and SMS Marketing: A Practical Guide — Klaviyo's own AI features draft subject lines and suggest segments. The bigger opportunity is upstream and downstream of that -- flows triggered by real behavioral signals, content genuinely personalized per segment, and send-time and channel decisions grounded in what actually gets a specific customer to open and buy.
- Zoho CRM and AI: A Practical Automation Guide for Growing Teams — Zoho CRM ships with Zia, its built-in AI assistant, covering a defined set of predictions and suggestions. Everything past that -- automation tied to your specific pipeline logic, your own scoring criteria, your own multi-app Zoho ecosystem -- has to be built on top, through Zoho's API and the broader automation layer around it.
- Automating Intercom with AI: Beyond the Built-In Fin Chatbot — Fin, Intercom's native AI agent, handles conversational deflection well. What it does not handle is everything upstream and downstream of a conversation -- routing logic tuned to your specific team structure, proactive outreach based on product usage, and QA across every conversation Fin and your human agents both handle.