🤖 LAURA v2.2 — Arquitetura Completa

183
Nós N8N
5
Workflows
11
AI Agents
11
Tabelas DB
3
Artigos/dia

🔄 Fluxo Principal

flowchart TB
    subgraph INPUTS["📥 COLETA"]
        DS["DataForSEO
Keywords + Volume"]
        NA["NewsAPI
Notícias mercado"]
        FC["Firecrawl
Scrape concorrentes"]
        CP["Competitors
Olist, Tiny, Bling"]
    end

    subgraph DB["🐘 POSTGRESQL"]
        NF["news_feed
207 rows"]
        KO["keyword_opportunities
65 rows"]
        CP2["competitor_posts
53 rows"]
        PP["content_pipeline
74 rows"]
        CA["cluster_articles
47 rows"]
        PUB["published_posts
185 rows"]
    end

    subgraph STRATEGIC["⚙️ STRATEGIC LOOP (JS)"]
        ICE["ICE Scoring
Impact 40% + Conf 35% + Ease 25%"]
        CLU["Content Clusters
Gaps + Topical Authority"]
        REF["Refresh Calendar
Posts antigos + Queda"]
    end

    subgraph N8N["🔄 N8N WORKFLOWS"]
        P1["PART 1
1min poll
Content Analyst
Master Research"]
        P2["PART 2
7 AI Agents
Content Architect
EEAT + Links
+ Imagem"]
        NP["NEWS PIPELINE
15min poll
News Architect
+ Imagem"]
        P4["PART 4
3x/dia
Publicador"]
    end

    subgraph OUTPUT["📤 SAÍDA"]
        WP["WordPress
blog.arco..."]
        CF["Cloudflare R2
HTMLs"]
        GM["Gmail
Notificações"]
    end

    DS --> KO
    NA --> NF
    FC --> CP2
    CP --> CP2

    NF --> PP
    KO --> PP
    CP2 --> PP

    PP --> ICE
    ICE --> CLU
    ICE --> REF

    PP -->|"pending
!news"| P1
    PP -->|"pending
source=refresh"| P1
    NF -->|"NULL status"| NP

    P1 -->|"webhook"| P2
    NP -->|"draft"| CA
    P2 -->|"draft"| CA
    P2 -->|"completed"| PP

    CA -->|"draft"| P4
    P4 -->|"publish"| WP
    P4 -->|"published"| CA
    P2 --> CF
    P2 --> GM

    style INPUTS fill:#1e3a5f,stroke:#38bdf8,color:#e2e8f0
    style DB fill:#1e3a2f,stroke:#4ade80,color:#e2e8f0
    style STRATEGIC fill:#3d1e5f,stroke:#a78bfa,color:#e2e8f0
    style N8N fill:#5f3d1e,stroke:#fb923c,color:#e2e8f0
    style OUTPUT fill:#5f1e3d,stroke:#f472b6,color:#e2e8f0

📊 Estados do Pipeline

stateDiagram-v2
    [*] --> pending : INSERT
    pending --> processing : Part 1 SELECT
retry_count +1
    processing --> completed : Part 2 OK
WordPress draft
    processing --> retry : Part 2 FAIL
ou timeout 30min
    retry --> processing : retry < 3
    retry --> failed : retry >= 3
    completed --> published : Part 4
publish
    published --> [*]
    failed --> [*]

    completed : INSERT cluster_articles
wordpress_id set
    published : published_at = NOW()

🤖 Agentes AI por Etapa

flowchart LR
    subgraph P1["PART 1"]
        CA["Content Analyst
Gemini Flash"]
        MR["Master Research
Gemini Pro"]
    end

    subgraph P2["PART 2"]
        COMP["Competitor Analyst
Gemini Pro"]
        KW["Keyword Analyst
Gemini Pro"]
        ARCH["Content Architect
Gemini Pro ⭐"]
        EEAT["EEAT Auditor
Gemini Pro"]
        EEATE["EEAT Editor
Gemini Pro"]
        IL["Internal Linking
Gemini Pro"]
        TAG["Tag & Blog ID
Gemini Flash"]
        HTML["HTML Checker
Gemini Flash"]
        IMG["Imagenator
Gemini Flash"]
        GEN["Generate Image
Gemini Imagen"]
    end

    subgraph NP["NEWS"]
        NCA["News Architect
Gemini Pro"]
        FIX["Flash AutoFix
Gemini Flash"]
        NI["Generate Image
Gemini Imagen"]
    end

    CA --> MR
    MR --> COMP
    COMP --> KW
    KW --> ARCH
    ARCH --> EEAT
    EEAT --> EEATE
    EEATE --> IL
    IL --> HTML
    HTML --> IMG
    IMG --> GEN
    ARCH --> TAG

    NCA --> FIX
    FIX --> NI

    style ARCH fill:#dc2626,stroke:#fca5a5,color:#fff
    style NCA fill:#dc2626,stroke:#fca5a5,color:#fff

⚠️ Problemas Críticos