n8n Workflow Patterns

Proven architectural patterns for building n8n workflows.

Purpose

Teaches architectural patterns for building n8n workflows. Provides structure, best practices, and proven approaches for common use cases.

Activates On

• build workflow
• workflow pattern
• workflow architecture
• workflow structure
• webhook processing
• http api
• api integration
• database sync
• ai agent
• chatbot
• scheduled task
• automation pattern

File Count

7 files, ~3,700 lines total

Priority

HIGH - Addresses 813 webhook searches (most common use case)

Dependencies

n8n-mcp tools:

• search_nodes (find nodes for patterns)
• get_node (understand node operations)
• search_templates (find example workflows)
• ai_agents_guide (AI pattern guidance)

Related skills:

• n8n MCP Tools Expert (find and configure nodes)
• n8n Expression Syntax (write expressions in patterns)
• n8n Node Configuration (configure pattern nodes)
• n8n Validation Expert (validate pattern implementations)

Coverage

The 5 Core Patterns

1. Webhook Processing (Most Common - 813 searches)

   • Receive HTTP requests → Process → Respond
   • Critical gotcha: Data under $json.body
   • Authentication, validation, error handling

2. HTTP API Integration (892 templates)

   • Fetch from REST APIs → Transform → Store/Use
   • Authentication methods, pagination, rate limiting
   • Error handling and retries

3. Database Operations (456 templates)

   • Read/Write/Sync database data
   • Batch processing, transactions, performance
   • Security: parameterized queries, read-only access

4. AI Agent Workflow (234 templates, 270 AI nodes)

   • AI agents with tool access and memory
   • 8 AI connection types
   • ANY node can be an AI tool

5. Scheduled Tasks (28% of all workflows)

   • Recurring automation workflows
   • Cron schedules, timezone handling
   • Monitoring and error handling

Cross-Cutting Concerns

• Data flow patterns (linear, branching, parallel, loops)
• Error handling strategies
• Performance optimization
• Security best practices
• Testing approaches
• Monitoring and logging

Evaluations

5 scenarios (100% coverage expected):

1. eval-001: Webhook workflow structure
2. eval-002: HTTP API integration pattern
3. eval-003: Database sync pattern
4. eval-004: AI agent workflow with tools
5. eval-005: Scheduled report generation

Key Features

✅ 5 Proven Patterns: Webhook, HTTP API, Database, AI Agent, Scheduled tasks ✅ Complete Examples: Working workflow configurations for each pattern ✅ Best Practices: Proven approaches from real-world n8n usage ✅ Common Gotchas: Documented mistakes and their fixes ✅ Integration Guide: How patterns work with other skills ✅ Template Examples: Real examples from 2,653+ n8n templates

Files

• SKILL.md (486 lines) - Pattern overview, selection guide, checklist
• webhook_processing.md (554 lines) - Webhook patterns, data structure, auth
• http_api_integration.md (763 lines) - REST APIs, pagination, rate limiting
• database_operations.md (854 lines) - DB operations, batch processing, security
• ai_agent_workflow.md (918 lines) - AI agents, tools, memory, 8 connection types
• scheduled_tasks.md (845 lines) - Cron schedules, timezone, monitoring
• README.md (this file) - Skill metadata

Success Metrics

Expected outcomes:

• Users select appropriate pattern for their use case
• Workflows follow proven structural patterns
• Common gotchas avoided (webhook $json.body, SQL injection, etc.)
• Proper error handling implemented
• Security best practices followed

Pattern Selection Stats

Common workflow composition:

Trigger Distribution:

• Webhook: 35% (most common)
• Schedule: 28%
• Manual: 22%
• Service triggers: 15%

Transformation Nodes:

• Set: 68%
• Code: 42%
• IF: 38%
• Switch: 18%

Output Channels:

• HTTP Request: 45%
• Slack: 32%
• Database: 28%
• Email: 24%

Complexity:

• Simple (3-5 nodes): 42%
• Medium (6-10 nodes): 38%
• Complex (11+ nodes): 20%

Critical Insights

Webhook Processing:

• 813 searches (most common use case!)
• #1 gotcha: Data under $json.body (not $json directly)
• Must choose response mode: onReceived vs lastNode

API Integration:

• Authentication via credentials (never hardcode!)
• Pagination essential for large datasets
• Rate limiting prevents API bans
• continueOnFail: true for error handling

Database Operations:

• Always use parameterized queries (SQL injection prevention)
• Batch processing for large datasets
• Read-only access for AI tools
• Transaction handling for multi-step operations

AI Agents:

• 8 AI connection types (ai_languageModel, ai_tool, ai_memory, etc.)
• ANY node can be an AI tool (connect to ai_tool port)
• Memory essential for conversations (Window Buffer recommended)
• Tool descriptions critical (AI uses them to decide when to call)

Scheduled Tasks:

• Set workflow timezone explicitly (DST handling)
• Prevent overlapping executions (use locks)
• Error Trigger workflow for alerts
• Batch processing for large data

Workflow Creation Checklist

Every pattern follows this checklist:

Planning Phase

• Identify the pattern (webhook, API, database, AI, scheduled)
• List required nodes (use search_nodes)
• Understand data flow (input → transform → output)
• Plan error handling strategy

Implementation Phase

• Create workflow with appropriate trigger
• Add data source nodes
• Configure authentication/credentials
• Add transformation nodes (Set, Code, IF)
• Add output/action nodes
• Configure error handling

Validation Phase

• Validate each node configuration
• Validate complete workflow
• Test with sample data
• Handle edge cases

Deployment Phase

• Review workflow settings
• Activate workflow
• Monitor first executions
• Document workflow

Real Template Examples

Weather to Slack (Template #2947):

Schedule (daily 8 AM) → HTTP Request (weather) → Set → Slack

Webhook Processing: 1,085 templates HTTP API Integration: 892 templates Database Operations: 456 templates AI Workflows: 234 templates

Use search_templates to find examples for your use case!

Integration with Other Skills

Pattern Selection (this skill):

1. Identify use case
2. Select appropriate pattern
3. Follow pattern structure

Node Discovery (n8n MCP Tools Expert): 4. Find nodes for pattern (search_nodes) 5. Understand node operations (get_node)

Implementation (n8n Expression Syntax + Node Configuration): 6. Write expressions ({{$json.body.field}}) 7. Configure nodes properly

Validation (n8n Validation Expert): 8. Validate workflow structure 9. Fix validation errors

Last Updated

2025-10-20

Part of: n8n-skills repository Conceived by: Romuald Członkowski - www.aiadvisors.pl/en