Skip to content

n8n - Workflow Automation

n8n is a fair-code workflow automation platform that connects your apps and data.

Quick Facts

  • Version: Latest (via Coolify)
  • URL: https://n8n.collabrains.eu
  • Stack: PostgreSQL 16 + Redis 6
  • Components: Main + Worker + Task Runner
  • Status: ✅ Running

Features

  • 🔗 Connect 400+ integrations
  • ⚙️ Workflow automation
  • 🔄 Scheduled tasks
  • 🪝 Webhooks
  • 📊 Data transformation
  • 💾 Execution history

Quick Start

Access Interface

  • URL: https://n8n.collabrains.eu
  • Create account or login with SSO (if configured)

Create Workflow

  1. Click "Create New"
  2. Add trigger node (webhook, schedule, etc.)
  3. Add action nodes
  4. Set up connections to services
  5. Test and activate

Configuration

Environment Variables

Check /data/coolify/services/N8N_ID/.env for: - DB_TYPE=postgres - DB_HOST=postgres-N8N_ID - REDIS_URL=redis://redis-N8N_ID:6379 - Webhook and execution settings

Service Connections

  • OAuth2 credentials stored in PostgreSQL
  • Encrypted with N8N_ENCRYPTION_KEY

Components

Component Purpose
Main Web interface, workflow editor, API
Worker Executes workflows in parallel
Task Runner Handles long-running tasks

Common Operations

View Logs

docker logs n8n-main -f
docker logs n8n-worker --tail 50
docker logs n8n-task-runner --tail 50

Restart Service

cd /data/coolify/services/N8N_ID
docker compose restart

Database Access

docker exec -it postgres-N8N_ID psql -U n8n -d n8n

Check Execution History

  • Via web UI: Executions tab
  • Via database: SELECT COUNT(*) FROM execution;

Troubleshooting

Workflows Not Triggering

# 1. Check webhook receiver
docker logs webhook-receiver-webhook-1 --tail 20

# 2. Check n8n logs
docker logs n8n-main -f

# 3. Test webhook
curl -X POST https://n8n.collabrains.eu/webhook/TEST_PATH \
  -H "Content-Type: application/json" \
  -d '{"test": "data"}'

Execution Errors

  1. Check workflow logs in web UI
  2. Verify service credentials
  3. Check Redis: docker exec redis-N8N_ID redis-cli ping
  4. Restart workers: docker restart n8n-worker

High Memory Usage

  • OCR/AI processing is memory-intensive
  • Check execution list for stuck jobs
  • Limit concurrent executions in settings

Backup

# Database backup
docker exec postgres-N8N_ID pg_dump -U n8n n8n > n8n-backup.sql

# Restore
docker exec -i postgres-N8N_ID psql -U n8n n8n < n8n-backup.sql