N8n Workflow Patterns

1---
2name: n8n-workflow-patterns
3description: Proven workflow architectural patterns from real n8n workflows. Use when building new workflows, designing workflow structure, choosing workflow patterns, planning workflow architecture, or asking about webhook processing, HTTP API integration, database operations, AI agent workflows, or scheduled tasks.
4---
5 
6# n8n Workflow Patterns
7 
8Proven architectural patterns for building n8n workflows.
9 
10---
11 
12## The 5 Core Patterns
13 
14Based on analysis of real workflow usage:
15 
161. **[Webhook Processing](webhook_processing.md)** (Most Common)
17   - Receive HTTP requests → Process → Output
18   - Pattern: Webhook → Validate → Transform → Respond/Notify
19 
202. **[HTTP API Integration](http_api_integration.md)**
21   - Fetch from REST APIs → Transform → Store/Use
22   - Pattern: Trigger → HTTP Request → Transform → Action → Error Handler
23 
243. **[Database Operations](database_operations.md)**
25   - Read/Write/Sync database data
26   - Pattern: Schedule → Query → Transform → Write → Verify
27 
284. **[AI Agent Workflow](ai_agent_workflow.md)**
29   - AI agents with tools and memory
30   - Pattern: Trigger → AI Agent (Model + Tools + Memory) → Output
31 
325. **[Scheduled Tasks](scheduled_tasks.md)**
33   - Recurring automation workflows
34   - Pattern: Schedule → Fetch → Process → Deliver → Log
35 
36---
37 
38## Pattern Selection Guide
39 
40### When to use each pattern:
41 
42**Webhook Processing** - Use when:
43- Receiving data from external systems
44- Building integrations (Slack commands, form submissions, GitHub webhooks)
45- Need instant response to events
46- Example: "Receive Stripe payment webhook → Update database → Send confirmation"
47 
48**HTTP API Integration** - Use when:
49- Fetching data from external APIs
50- Synchronizing with third-party services
51- Building data pipelines
52- Example: "Fetch GitHub issues → Transform → Create Jira tickets"
53 
54**Database Operations** - Use when:
55- Syncing between databases
56- Running database queries on schedule
57- ETL workflows
58- Example: "Read Postgres records → Transform → Write to MySQL"
59 
60**AI Agent Workflow** - Use when:
61- Building conversational AI
62- Need AI with tool access
63- Multi-step reasoning tasks
64- Example: "Chat with AI that can search docs, query database, send emails"
65 
66**Scheduled Tasks** - Use when:
67- Recurring reports or summaries
68- Periodic data fetching
69- Maintenance tasks
70- Example: "Daily: Fetch analytics → Generate report → Email team"
71 
72---
73 
74## Common Workflow Components
75 
76All patterns share these building blocks:
77 
78### 1. Triggers
79- **Webhook** - HTTP endpoint (instant)
80- **Schedule** - Cron-based timing (periodic)
81- **Manual** - Click to execute (testing)
82- **Polling** - Check for changes (intervals)
83 
84### 2. Data Sources
85- **HTTP Request** - REST APIs
86- **Database nodes** - Postgres, MySQL, MongoDB
87- **Service nodes** - Slack, Google Sheets, etc.
88- **Code** - Custom JavaScript/Python
89 
90### 3. Transformation
91- **Set** - Map/transform fields
92- **Code** - Complex logic
93- **IF/Switch** - Conditional routing
94- **Merge** - Combine data streams
95 
96### 4. Outputs
97- **HTTP Request** - Call APIs
98- **Database** - Write data
99- **Communication** - Email, Slack, Discord
100- **Storage** - Files, cloud storage
101 
102### 5. Error Handling
103- **Error Trigger** - Catch workflow errors
104- **IF** - Check for error conditions
105- **Stop and Error** - Explicit failure
106- **Continue On Fail** - Per-node setting
107 
108---
109 
110## Workflow Creation Checklist
111 
112When building ANY workflow, follow this checklist:
113 
114### Planning Phase
115- [ ] Identify the pattern (webhook, API, database, AI, scheduled)
116- [ ] List required nodes (use search_nodes)
117- [ ] Understand data flow (input → transform → output)
118- [ ] Plan error handling strategy
119 
120### Implementation Phase
121- [ ] Create workflow with appropriate trigger
122- [ ] Add data source nodes
123- [ ] Configure authentication/credentials
124- [ ] Add transformation nodes (Set, Code, IF)
125- [ ] Add output/action nodes
126- [ ] Configure error handling
127 
128### Validation Phase
129- [ ] Validate each node configuration (validate_node)
130- [ ] Validate complete workflow (validate_workflow)
131- [ ] Test with sample data
132- [ ] Handle edge cases (empty data, errors)
133 
134### Deployment Phase
135- [ ] Review workflow settings (execution order, timeout, error handling)
136- [ ] Activate workflow using `activateWorkflow` operation
137- [ ] Monitor first executions
138- [ ] Document workflow purpose and data flow
139 
140---
141 
142## Data Flow Patterns
143 
144### Linear Flow
145```
146Trigger → Transform → Action → End
147```
148**Use when**: Simple workflows with single path
149 
150### Branching Flow
151```
152Trigger → IF → [True Path]
153             └→ [False Path]
154```
155**Use when**: Different actions based on conditions
156 
157### Parallel Processing
158```
159Trigger → [Branch 1] → Merge
160       └→ [Branch 2] ↗
161```
162**Use when**: Independent operations that can run simultaneously
163 
164### Loop Pattern
165```
166Trigger → Split in Batches → Process → Loop (until done)
167```
168**Use when**: Processing large datasets in chunks
169 
170### Error Handler Pattern
171```
172Main Flow → [Success Path]
173         └→ [Error Trigger → Error Handler]
174```
175**Use when**: Need separate error handling workflow
176 
177---
178 
179## Common Gotchas
180 
181### 1. Webhook Data Structure
182**Problem**: Can't access webhook payload data
183 
184**Solution**: Data is nested under `$json.body`
185```javascript
186❌ {{$json.email}}
187✅ {{$json.body.email}}
188```
189See: n8n Expression Syntax skill
190 
191### 2. Multiple Input Items
192**Problem**: Node processes all input items, but I only want one
193 
194**Solution**: Use "Execute Once" mode or process first item only
195```javascript
196{{$json[0].field}}  // First item only
197```
198 
199### 3. Authentication Issues
200**Problem**: API calls failing with 401/403
201 
202**Solution**:
203- Configure credentials properly
204- Use the "Credentials" section, not parameters
205- Test credentials before workflow activation
206 
207### 4. Node Execution Order
208**Problem**: Nodes executing in unexpected order
209 
210**Solution**: Check workflow settings → Execution Order
211- v0: Top-to-bottom (legacy)
212- v1: Connection-based (recommended)
213 
214### 5. Expression Errors
215**Problem**: Expressions showing as literal text
216 
217**Solution**: Use {{}} around expressions
218- See n8n Expression Syntax skill for details
219 
220---
221 
222## Integration with Other Skills
223 
224These skills work together with Workflow Patterns:
225 
226**n8n MCP Tools Expert** - Use to:
227- Find nodes for your pattern (search_nodes)
228- Understand node operations (get_node)
229- Create workflows (n8n_create_workflow)
230- Deploy templates (n8n_deploy_template)
231- Use ai_agents_guide for AI pattern guidance
232 
233**n8n Expression Syntax** - Use to:
234- Write expressions in transformation nodes
235- Access webhook data correctly ({{$json.body.field}})
236- Reference previous nodes ({{$node["Node Name"].json.field}})
237 
238**n8n Node Configuration** - Use to:
239- Configure specific operations for pattern nodes
240- Understand node-specific requirements
241 
242**n8n Validation Expert** - Use to:
243- Validate workflow structure
244- Fix validation errors
245- Ensure workflow correctness before deployment
246 
247---
248 
249## Pattern Statistics
250 
251Common workflow patterns:
252 
253**Most Common Triggers**:
2541. Webhook - 35%
2552. Schedule (periodic tasks) - 28%
2563. Manual (testing/admin) - 22%
2574. Service triggers (Slack, email, etc.) - 15%
258 
259**Most Common Transformations**:
2601. Set (field mapping) - 68%
2612. Code (custom logic) - 42%
2623. IF (conditional routing) - 38%
2634. Switch (multi-condition) - 18%
264 
265**Most Common Outputs**:
2661. HTTP Request (APIs) - 45%
2672. Slack - 32%
2683. Database writes - 28%
2694. Email - 24%
270 
271**Average Workflow Complexity**:
272- Simple (3-5 nodes): 42%
273- Medium (6-10 nodes): 38%
274- Complex (11+ nodes): 20%
275 
276---
277 
278## Quick Start Examples
279 
280### Example 1: Simple Webhook → Slack
281```
2821. Webhook (path: "form-submit", POST)
2832. Set (map form fields)
2843. Slack (post message to #notifications)
285```
286 
287### Example 2: Scheduled Report
288```
2891. Schedule (daily at 9 AM)
2902. HTTP Request (fetch analytics)
2913. Code (aggregate data)
2924. Email (send formatted report)
2935. Error Trigger → Slack (notify on failure)
294```
295 
296### Example 3: Database Sync
297```
2981. Schedule (every 15 minutes)
2992. Postgres (query new records)
3003. IF (check if records exist)
3014. MySQL (insert records)
3025. Postgres (update sync timestamp)
303```
304 
305### Example 4: AI Assistant
306```
3071. Webhook (receive chat message)
3082. AI Agent
309   ├─ OpenAI Chat Model (ai_languageModel)
310   ├─ HTTP Request Tool (ai_tool)
311   ├─ Database Tool (ai_tool)
312   └─ Window Buffer Memory (ai_memory)
3133. Webhook Response (send AI reply)
314```
315 
316### Example 5: API Integration
317```
3181. Manual Trigger (for testing)
3192. HTTP Request (GET /api/users)
3203. Split In Batches (process 100 at a time)
3214. Set (transform user data)
3225. Postgres (upsert users)
3236. Loop (back to step 3 until done)
324```
325 
326---
327 
328## Detailed Pattern Files
329 
330For comprehensive guidance on each pattern:
331 
332- **[webhook_processing.md](webhook_processing.md)** - Webhook patterns, data structure, response handling
333- **[http_api_integration.md](http_api_integration.md)** - REST APIs, authentication, pagination, retries
334- **[database_operations.md](database_operations.md)** - Queries, sync, transactions, batch processing
335- **[ai_agent_workflow.md](ai_agent_workflow.md)** - AI agents, tools, memory, langchain nodes
336- **[scheduled_tasks.md](scheduled_tasks.md)** - Cron schedules, reports, maintenance tasks
337 
338---
339 
340## Real Template Examples
341 
342From n8n template library:
343 
344**Template #2947**: Weather to Slack
345- Pattern: Scheduled Task
346- Nodes: Schedule → HTTP Request (weather API) → Set → Slack
347- Complexity: Simple (4 nodes)
348 
349**Webhook Processing**: Most common pattern
350- Most common: Form submissions, payment webhooks, chat integrations
351 
352**HTTP API**: Common pattern
353- Most common: Data fetching, third-party integrations
354 
355**Database Operations**: Common pattern
356- Most common: ETL, data sync, backup workflows
357 
358**AI Agents**: Growing in usage
359- Most common: Chatbots, content generation, data analysis
360 
361Use `search_templates` and `get_template` from n8n-mcp tools to find examples!
362 
363---
364 
365## Best Practices
366 
367### ✅ Do
368 
369- Start with the simplest pattern that solves your problem
370- Plan your workflow structure before building
371- Use error handling on all workflows
372- Test with sample data before activation
373- Follow the workflow creation checklist
374- Use descriptive node names
375- Document complex workflows (notes field)
376- Monitor workflow executions after deployment
377 
378### ❌ Don't
379 
380- Build workflows in one shot (iterate! avg 56s between edits)
381- Skip validation before activation
382- Ignore error scenarios
383- Use complex patterns when simple ones suffice
384- Hardcode credentials in parameters
385- Forget to handle empty data cases
386- Mix multiple patterns without clear boundaries
387- Deploy without testing
388 
389---
390 
391## Summary
392 
393**Key Points**:
3941. **5 core patterns** cover 90%+ of workflow use cases
3952. **Webhook processing** is the most common pattern
3963. Use the **workflow creation checklist** for every workflow
3974. **Plan pattern** → **Select nodes** → **Build** → **Validate** → **Deploy**
3985. Integrate with other skills for complete workflow development
399 
400**Next Steps**:
4011. Identify your use case pattern
4022. Read the detailed pattern file
4033. Use n8n MCP Tools Expert to find nodes
4044. Follow the workflow creation checklist
4055. Use n8n Validation Expert to validate
406 
407**Related Skills**:
408- n8n MCP Tools Expert - Find and configure nodes
409- n8n Expression Syntax - Write expressions correctly
410- n8n Validation Expert - Validate and fix errors
411- n8n Node Configuration - Configure specific operations
412