Activepieces: Die echte Open-Source-Alternative zu n8n für SaaS-Entwickler

services:
activepieces:
  image: activepieces/activepieces:latest
  container_name: activepieces
  restart: always
  ports:
    - "8080:80"
  environment:
    # --- System & Edition ---
    - AP_ENVIRONMENT=prod           # Wichtig: Prod erzwingt korrekte Flags
    - AP_EDITION=ce                 # Community Editon
    - AP_SIGN_UP_TERMINATED=false   # Erlaubt Registrierung (Fix Invitation-Bug)
    - AP_NODE_EXECUTABLE_PATH=/usr/local/bin/node

    # --- URLs ---
    - AP_FRONTEND_URL=http://localhost:8080
    - AP_WEBHOOK_URL=http://localhost:8080

    # --- Security ---
    - AP_JWT_SECRET=super_secret_jwt_token_fuer_local_dev_12345
    - AP_ENCRYPTION_KEY=00112233445566778899aabbccddeeff

    # --- Database (PostgreSQL) ---
    - AP_POSTGRES_HOST=postgres
    - AP_POSTGRES_PORT=5432
    - AP_POSTGRES_DATABASE=activepieces
    - AP_POSTGRES_USERNAME=activepieces
    - AP_POSTGRES_PASSWORD=password

    # --- Redis & Queue ---
    - AP_REDIS_HOST=redis
    - AP_REDIS_PORT=6379
    - AP_QUEUE_MODE=REDIS

    # --- Execution ---
    - AP_ENGINE_EXECUTOR=SANDBOXED # isoliert Code für die Sicherheit
  depends_on:
    - postgres
    - redis

postgres:
  image: postgres:15-alpine
  container_name: postgres
  environment:
    - POSTGRES_USER=activepieces
    - POSTGRES_PASSWORD=password
    - POSTGRES_DB=activepieces
  volumes:
    - postgres_data:/var/lib/postgresql/data

redis:
  image: redis:7-alpine
  container_name: redis
  volumes:
    - redis_data:/data

# --- browserless optional, für das Tutorial
browserless:
  image: browserless/chrome:latest
  container_name: browserless
  restart: always
  ports:
    - "3000:3000"
  environment:
    - MAX_CONCURRENT_SESSIONS=10

volumes:
postgres_data:
redis_data:

import puppeteer from 'puppeteer-core';

export const code = async (inputs) => {
// Verbindung zum Sidecar-Container
// Im Docker-Netzwerk heißt der Host 'browserless'
const browser = await puppeteer.connect({
  browserWSEndpoint: 'ws://browserless:3000' 
});

try {
  const page = await browser.newPage();
  
  // Wir faken einen echten User-Agent
  await page.setUserAgent('Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36');

  await page.goto('https://promptbard.de/blog/', {
    waitUntil: 'networkidle2',
    timeout: 60000
  });

  // Warten, bis die Badges im DOM sind (wichtig für JS-Rendering!)
  await page.waitForSelector('.font-black.tracking-widest', { timeout: 10000 });

  const stats = await page.evaluate(() => {
    // Wir selektieren nach Struktur, nicht nach Farbe (Tailwind-Best-Practice)
    const badges = Array.from(document.querySelectorAll('span.font-black.tracking-widest'));
    const counts: Record<string, number> = {};
    
    badges.forEach(badge => {
      const text = badge.textContent?.trim() || 'Unkategorisiert';
      counts[text] = (counts[text] || 0) + 1;
    });

    return {
      total_categories: Object.keys(counts).length,
      total_articles: badges.length,
      breakdown: counts
    };
  });

  await browser.close();

  // --- Transformation für Google Sheets ---
  // Wir flachen das Objekt hier direkt ab, um Mapping-Chaos zu vermeiden
  const d = new Date();
  const dateStr = `${d.getDate().toString().padStart(2, '0')}.${(d.getMonth() + 1).toString().padStart(2, '0')}.${d.getFullYear()}`;

  return {
    datum: dateStr,
    gesamt: stats.total_articles,
    kategorien_anzahl: stats.total_categories,
    // Mapping der spezifischen Kategorien
    development: stats.breakdown['Development'] || 0,
    ki_ressourcen: stats.breakdown['Künstliche Intelligenz'] || 0,
    saas_tipps: stats.breakdown['SaaS-Marketing'] || 0
  };

} catch (error) {
  if (browser) await browser.close();
  return { error: error.message };
}
};