Back to Home
shawnmcrowley icon

n8n_workflows

by shawnmcrowley

Overview

A comprehensive collection of N8N workflows for automating tasks with AI agents, web scraping, data processing, ETL, content marketing, and multi-platform integrations, leveraging PostgreSQL with pgvector for vector storage and offering enterprise-grade monitoring and automated backups.

Installation

Run Command
docker-compose up -d

Environment Variables

  • DB_TYPE
  • DB_POSTGRESDB_HOST
  • DB_POSTGRESDB_PORT
  • DB_POSTGRESDB_DATABASE
  • DB_POSTGRESDB_SCHEMA
  • DB_POSTGRESDB_USER
  • DB_POSTGRESDB_PASSWORD
  • PGADMIN_DEFAULT_EMAIL
  • PGADMIN_DEFAULT_PASSWORD
  • N8N_HOST
  • N8N_PROTOCOL
  • N8N_WEBHOOK_URL
  • GENERIC_TIMEZONE
  • N8N_RESTRICT_FILE_ACCESS_TO
  • N8N_API_KEY
  • FIRECRAWL_API_KEY
  • OPENWEATHER_KEY
  • ALPHA_VANTAGE_KEY

Security Notes

CRITICAL: Multiple workflows contain hardcoded API keys (e.g., for EODHD, Brave Search, BuzzSumo, NYT Article Search, Firecrawl). These should always be stored securely as environment variables or N8N credentials, not directly in workflow JSONs or code. CRITICAL: The 'chat-with-a-database-using-ai-.json' workflow passes AI-generated SQL directly to a PostgreSQL query, creating a severe SQL injection vulnerability if the AI agent's output can be manipulated by malicious user input. HIGH: The Docker Compose configuration uses default, weak credentials ('admin@admin.com'/'admin') for PgAdmin, which is unsuitable for any non-local development environment. MEDIUM: Extensive use of 'jsCode' nodes, while necessary for complex logic in N8N, increases the attack surface for potential vulnerabilities if not meticulously reviewed and secured, especially when processing external or AI-generated inputs. MEDIUM: The 'generate-swagger-specs-for-workflows-with-webhooks-.json' writes files to a mounted directory (`/swagger-html`), which, despite the `N8N_RESTRICT_FILE_ACCESS_TO` environment variable, introduces a file system write risk.

Similar Servers

Stats

Interest Score30
Security Score2
Cost ClassHigh
Avg Tokens2500
Stars1
Forks0
Last Update2026-01-16

Tags

AI AutomationWeb ScrapingETLN8N WorkflowsData Processing