惯性聚合 高效追踪和阅读你感兴趣的博客、新闻、科技资讯
阅读原文 在惯性聚合中打开

推荐订阅源

G
Google Developers Blog
Jina AI
Jina AI
大猫的无限游戏
大猫的无限游戏
Martin Fowler
Martin Fowler
博客园 - 司徒正美
云风的 BLOG
云风的 BLOG
C
Cybersecurity and Infrastructure Security Agency CISA
CTFtime.org: upcoming CTF events
CTFtime.org: upcoming CTF events
S
Securelist
S
Security Affairs
freeCodeCamp Programming Tutorials: Python, JavaScript, Git & More
L
LINUX DO - 热门话题
博客园 - 三生石上(FineUI控件)
T
Threatpost
T
The Blog of Author Tim Ferriss
C
CERT Recently Published Vulnerability Notes
IT之家
IT之家
P
Palo Alto Networks Blog
Microsoft Azure Blog
Microsoft Azure Blog
Spread Privacy
Spread Privacy
Cyberwarzone
Cyberwarzone
腾讯CDC
L
LangChain Blog
Know Your Adversary
Know Your Adversary
C
CXSECURITY Database RSS Feed - CXSecurity.com
GbyAI
GbyAI
Threat Intelligence Blog | Flashpoint
Threat Intelligence Blog | Flashpoint
I
Intezer
T
Tor Project blog
AWS News Blog
AWS News Blog
T
Tenable Blog
NISL@THU
NISL@THU
Security Latest
Security Latest
cs.CL updates on arXiv.org
cs.CL updates on arXiv.org
H
Hackread – Cybersecurity News, Data Breaches, AI and More
人人都是产品经理
人人都是产品经理
MongoDB | Blog
MongoDB | Blog
MyScale Blog
MyScale Blog
D
DataBreaches.Net
Microsoft Security Blog
Microsoft Security Blog
钛媒体:引领未来商业与生活新知
钛媒体:引领未来商业与生活新知
量子位
美团技术团队
The Cloudflare Blog
酷 壳 – CoolShell
酷 壳 – CoolShell
罗磊的独立博客
The GitHub Blog
The GitHub Blog
阮一峰的网络日志
阮一峰的网络日志
OSCHINA 社区最新新闻
OSCHINA 社区最新新闻
Stack Overflow Blog
Stack Overflow Blog

DEV Community

Authentication Security Deep Dive: From Brute Force to Salted Hashing (With Java Examples) Why AI Systems Don’t Fail — They Drift Spilling beans for how i learn for exam😁"Reinforcement Learning Cheat Sheet" I Replaced Chrome with Safari for AI Browser Automation. Here's What Broke (and What Finally Worked) How Python Borrows Other People's Work The $40 Architecture: Processing 1 Billion API Requests with 99.99% Uptime Vibe Coding: A Workflow Guide (From Zero to SaaS) Most webhook security guides protect the wrong side. The scary part is delivery. Headless CMS for TanStack Start: Build a Blog with Cosmic EU Age Verification App "Hacked in 2 Minutes" — What Actually Happened Comfy Cloud’s delete function does not actually remove files Running AI Models on GPU Cloud Servers: A Beginner Guide Event-driven media intelligence with AWS Step Functions and Bedrock I scored 500 AI prompts across 8 quality dimensions — here's what broke How to Call Google Gemini API from Next.js (Free Tier, No Backend Needed) The Portal Protocol: Reclaiming Human Connection in the Age of AI How to Fix Your Team's Scattered Knowledge Problem With a Self-Hosted Forum Intro to tc Cloud Functors: A Graph-First Mental Model for the Modern Cloud Designing Multi-Tenant Backends With Both Ownership and Team Access I Built a Neumorphic CSS Library with 77+ Components — Here's What I Learned PostgreSQL Performance Optimization: Why Connection Pooling Is Critical at Scale Cómo construí un SaaS multi-rubro para gestionar expensas en Argentina con FastAPI + Vue 3 🚀 I Built an Ethical Hacking Scanner Tool – Open Source Project I Replaced /usage and /context in Claude Code With a Single Statusline A Pythonic Way to Handle Emails (IMAP/SMTP) with Auto-Discovery and AI-Ready Design I Collected 8.9 Million Polymarket Price Points — Here's What I Found About How Markets Really Move EcoTrack AI — Carbon Footprint Tracker & Dashboard Everyone's Using AI. No One Agrees How. 5 self-hosted ebook managers worth trying in 2026 Building Your First AI Agent with LangChain: From Chatbot to Autonomous Assistant Common SOC 2 Failures (Real World) Stop Vibe-Checking Your AI App: A Practical Guide to Evals How to Use SonarQube and SonarScanner Locally to Level Up Your Code Quality Your Next To-Do App Is Dead — I Replaced Mine with an OpenClaw AI Sign a Nostr event in 60 lines of Python using coincurve — no nostr-sdk, no nbxplorer, no rust toolchain ITGC Audit Explained Like You’re in Big 4 Patch Tuesday abril 2026: Microsoft parcha 163 vulnerabilidades y un zero-day en SharePoint Stop scraping everything: a better way to track competitor price changes Listing on MCPize + the Official MCP Registry while routing payments OUTSIDE the marketplace — how I kept 100% of my x402 revenue Building an AI-Powered Risk Intelligence System Using Serverless Architecture Why We Ripped Function Overloading Out of Our AI Toolchain Testing AI-Generated Code: How to Actually Know If It Works SaaS Churn Is Killing Your Business. Here Is What to Do About It (Without a Support Team) The Speed of AI Is No Longer Linear - And Self-Improving Models Are Why How to Implement RBAC for MCP Tools: A Practical Guide for Engineering Teams From Standard Quote to Persuasive Proposal: AI Automation for Arborists I built a CLI that scaffolds complete multi-tenant SaaS apps Axios CVE-2025–62718: The Silent SSRF Bug That Could Be Hiding in Your Node.js App Right Now The dashboard that ended our friendship Data Pipelines Explained Simply (and How to Build Them with Python) The Hidden Cost of AI Systems Nobody Talks About. undefined vs undeclared, and how typeof behaves Switching from file-based jobs to NATS/Kafka in Rust without changing code io_uring Adventures: Rust Servers That Love Syscalls Why Agentic AI is Killing the Traditional Database The POUR principles of web accessibility for developers and designers Quantum Neural Network 3D — A Deep Dive into Interactive WebGL Visualization How To Install Caveman In Codex On macOS And Windows Automation Pipeline Reliability: Why Your Workflow Breaks When Nobody Is Watching I Built an 'Open World' AI Coding Agent — It Works From ANY Folder From Freelancing to Product: A Tech Service Company's SaaS Transformation China's AI Giants: Adding Tencent Hunyuan & ByteDance Doubao to AI University (74 Providers) On the Vibe Coders and Their Lies clerk: Auto-Summarize Your Claude Code Sessions AI Weekly — 2026/04/10–04/17 | The Model Lockdown Is Here, but the Toolchain Is the Real Battleground AI 週報 — 2026/04/10–2026/04/17 模型封鎖潮來了,但工具鏈才是真戰場 Maybe this is how Open-Source apps are born... 🚀 Fine-Tune LLMs with LoRA and QLoRA: 2026 Guide tRPC v11 + Next.js App Router: End-to-End Type Safety Without the Boilerplate ShadCN UI in 2026: Why I Stopped Installing Component Libraries and Started Owning My Components SaaS Billing in React Server Components: Stripe + Supabase Without a Single `useEffect` Join our DEV Weekend Challenge — $1,000 in Prizes Across TEN winners! Submissions Due April 20 at 6:59 AM UTC. Implementing FSRS Spaced Repetition in Flutter + Supabase — Adding Memory Science to an AI Learning App "I Texted My Localhost From the Train — Claude Code Fixed the Bug Before I Got Home" I Built a Sales Prep AI and It Went Deeper Than Expected Design to Code #2: One JSON, Eleven Outputs Solving the 100M-Row Problem: A Summary Table Pattern for High-Volume Push Notification Logs Flutter Web With Wasm: What Actually Changes For Developers I Built 50 Royalty-Free Soundtracks for My Side Project in a Weekend Using AI Music Generation The Vibe Coding Security Checklist: 7 Things to Check Before You Ship Stop Letting Googlebot Guess Fix Your React App's SEO Right Desconstruindo o Streaming do LinkedIn: Como Criar um Engine de Extração de Vídeo de Alta Performance com HLS e FFmpeg (EDA Part-1) EDA (Exploratory Data Analysis) Explained With Real Life — Why Looking at Your Data Is the Most Important Step in Machine Learning Brand Relationship Management at Scale: Our 4-Touch Outreach System for 200+ Brands Why String.fromEnvironment() Might Return an Empty String in Dart JGuardrails 1.0.0 — Hardening Java LLM Apps Against Jailbreaks, Toxicity, and Prompt Injection Plan and Schedule a Full Week of Threads Content From One Claude Conversation Coding Cat Oran Ep3, Five Tables Changed Everything Updated: BFF Pattern I'm done watching freelancers get buried by 200 proposals. So I'm building the alternative. This is my first post BFS Algorithm in Java Step by Step Tutorial with Examples Tracking LLM Pricing Monthly: An Open Dataset for 22 AI Models How We Measure Content ROI on a Comparison Site: Revenue Attribution Without Perfect Data Introducing Nova AI Ops: The AI-Native Operating System for SRE Teams I built a free desktop video downloader for Windows — Grabbit How Talkie OCR Helps Vision-Impaired & Dyslexic Users Read the World Around Them VRCFaceTracking安装和iPhone面捕配置教程,有bug Even CrowdStrike Can't See Your Agents The Automation Gold Rush: What n8n Workflows and Claude Are Opening Up for Developers Right Now
Industrial SEO at 100 Pages/Week: My n8n + Claude Code + RAG Stack
Stéphane Jam · 2026-05-27 · via DEV Community

I run a French SEO agency from Siem Reap, Cambodia. We've shipped 1,300+ semantic content clusters for 650+ brands — typically at 50 to 100 pages per project per week.

That cadence is impossible with a traditional content team. It's also impossible with raw LLM generation: the output looks fine in isolation and rots when you read three pages in a row.

What works is a three-layer pipeline that treats content like a production line, not a creative process. Here's the actual stack.

The problem with "AI content" as people usually do it

Most "industrial AI content" implementations look like this:

keyword list → ChatGPT prompt → publish

Enter fullscreen mode Exit fullscreen mode

It produces 50 pages in an hour. It also produces 50 pages that:

  • Repeat the same five intros across the whole cluster
  • Hallucinate stats no one can audit
  • Drift away from the actual cluster theme by page 30
  • Use no internal linking strategy
  • Read like LinkedIn boilerplate

Google's May 2024 leak confirmed what experienced SEOs already knew: the algorithm scores the cluster, not just the page. siteFocusScore, siteAuthority, and the compressed quality signals don't care that page 23 is well-written if pages 1 through 22 read like the same prompt with different keywords.

So the question isn't "how do I generate content fast?" It's "how do I generate content fast AND keep it coherent across the whole cluster?"

The three layers

┌────────────────────────────────────────────────────┐
│  Layer 1 — RAG knowledge base (per-client)         │
│  - Client brief, brand voice, product corpus       │
│  - Existing pages (what's already said)            │
│  - Topic graph (what each page must cover)         │
└────────────────────────────────────────────────────┘
                       ▼
┌────────────────────────────────────────────────────┐
│  Layer 2 — n8n orchestration                       │
│  - Pull next page brief from Google Sheet          │
│  - Inject RAG context + brief                      │
│  - Call LLM (Claude/DeepSeek depending on tier)    │
│  - Save draft to Sheet column                      │
│  - Trigger QA round                                │
└────────────────────────────────────────────────────┘
                       ▼
┌────────────────────────────────────────────────────┐
│  Layer 3 — Claude Code QA loop                     │
│  - Read draft + cluster context                    │
│  - Check coherence, internal links, brand voice    │
│  - Either approve or write structured feedback     │
│  - Loop until pass or human escalation             │
└────────────────────────────────────────────────────┘

Enter fullscreen mode Exit fullscreen mode

The trick is that Layer 1 is what makes Layer 2's output not boring, and Layer 3 is what catches Layer 2's mistakes before a human ever reads them.

Layer 1: the RAG knowledge base

One per client. Indexed and re-indexed on every brief update. Stored as a local vector DB (we use qdrant for production, chromadb for prototyping) with three collections:

# Pseudo-structure (sanitized from production)
collections = {
    "client_brief": {
        "docs": ["positioning.md", "tone_of_voice.md", "products/*.md"],
        "chunk_size": 512,
    },
    "existing_pages": {
        "docs": ["site_pages/*.html"],  # cleaned + extracted
        "chunk_size": 1024,
    },
    "topic_graph": {
        "docs": ["cluster_map.json"],   # which page covers which subtopic
        "chunk_size": 256,
    },
}

Enter fullscreen mode Exit fullscreen mode

The retrieval at generation time pulls top-k from each collection, with weights tuned per cluster. Typical pull for one page:

  • 3 chunks from client_brief (voice + positioning)
  • 5 chunks from existing_pages (so we don't repeat what's already said)
  • 1 chunk from topic_graph (what THIS page must cover that others don't)

That last one is what kills cluster drift. Without it, page 30 will accidentally rewrite page 4.

Layer 2: the n8n workflow

n8n is the right tool because the loop has too many side effects to keep in a Python script: Google Sheets read/write, LLM API calls with retry logic, conditional branching on tier, webhook callbacks from Layer 3, Slack notifications when something stalls.

The core loop, simplified:

[Trigger: cron every 10min]
    │
    ▼
[Google Sheets: get next row WHERE status = "to_write"]
    │
    ▼
[HTTP: call RAG service, get context]
    │
    ▼
[Switch by tier]
    ├─ premium → Claude Sonnet
    ├─ standard → DeepSeek Pro
    └─ longtail → DeepSeek Flash
    │
    ▼
[LLM call with composed prompt]
    │
    ▼
[Google Sheets: update row with draft + status = "to_qa"]
    │
    ▼
[Webhook: trigger Layer 3]

Enter fullscreen mode Exit fullscreen mode

The Switch node by tier is what makes the unit economics work. A premium page costs ~$0.40 in API spend; a long-tail page costs ~$0.02. You can't ship 100 pages/week on premium pricing for every page.

n8n's other quiet superpower: error workflows. Every node in the production graph has an error handler that writes to a "stuck" sheet with the error message and stack. A human reads that sheet once a day. Anything not in the sheet just worked.

Layer 3: the Claude Code QA loop

This is the layer most people don't have, and it's the one that decides whether the cluster is shippable or another low-quality generative blob.

I use Claude Code (the CLI, not the API directly) because the agentic loop is built in. The QA agent runs against each draft:

claude --model claude-sonnet-4-6 --dangerously-skip-permissions \
  "Read the draft at $DRAFT_PATH. Read the cluster context at $CONTEXT_PATH.
   Run the checks defined in qa-rules.md.
   For each failed check, write structured feedback to $FEEDBACK_PATH.
   If all checks pass, write APPROVED to $STATUS_PATH and exit.
   If 3+ checks fail, write ESCALATE to $STATUS_PATH and exit."

Enter fullscreen mode Exit fullscreen mode

The qa-rules.md file is the contract. It includes things like:

- Voice: matches the tone defined in client_brief/tone_of_voice.md
- Repetition: no intro paragraph that mirrors another page in this cluster
- Internal links: 3-5 contextual links to sibling pages in the cluster
- Claims: every statistic must trace to a source in client_brief/ or be removed
- Hooks: opening sentence must not be a generic platitude
- Tail: closing sentence must not be a CTA — that's the layout's job

Enter fullscreen mode Exit fullscreen mode

When the agent writes structured feedback, n8n picks it up via webhook and routes the draft back to Layer 2 with the feedback injected into the next prompt. Three rounds, then human review.

The economics: ~70% of drafts pass on round 1, ~25% on round 2, ~5% need human eyes. That last 5% is where the real attention goes.

What I'd do differently if starting over

A few things that cost us months to learn:

1. Don't index the entire client site into the RAG store on day 1. Index the brief + 10 hand-picked pages first. When generation starts producing "voice drift," then add more pages. Indexing too early means the retrieval pulls in stale content as "the voice."

2. Don't put cluster theme detection in the LLM. Encode it in the topic graph as structured metadata. The LLM is bad at remembering "this page is about X, not Y" across 50 turns; the topic graph never forgets.

3. Add a fingerprint check on intros. Cheap: hash the first 50 words of every published page in the cluster. New drafts get compared. If hamming distance is below threshold, regenerate the intro. This single check killed the repetition problem in one afternoon.

4. Don't trust the LLM's self-evaluation in the same call. Two-call evaluation (generate, then a fresh model instance evaluates) catches things a single call misses. Same model, fresh context, no anchoring bias.

5. Keep a kill switch on every workflow. A single Sheet cell named pipeline.enabled. If it's FALSE, every n8n trigger short-circuits. You will need it.

Honest trade-offs

This pipeline is not "AI writing the content." It's a content production line where:

  • The brief is human (a real SEO strategist's work)
  • The cluster map is human (someone decided what each page covers)
  • The voice corpus is human (a real client brand)
  • The QA contract is human (the rules we ship by)
  • The LLM does the typing

You can't skip those four human inputs and expect this to work. The pipeline ships 100 pages/week because the upstream work is done. Without it, you ship 100 pages of slop.

The other trade-off: this is a system, not a tool. It needs maintenance — RAG re-indexing as the client's catalog evolves, prompt tuning as Claude/DeepSeek versions change, kill switch monitoring. Budget roughly 1 senior engineer day per week per active project.

What's next

I'm publishing the topic graph schema, the QA rules template, and a sanitized version of the n8n workflow as a separate repo. Drop a comment if you'd find that useful.

The same pipeline, with a different QA layer that checks LLM citability instead of cluster coherence, is what we use for GEO (Generative Engine Optimization). That's the next post in this series.


Stéphane Jambu — SEO engineer building topical authority at scale. 1,300+ semantic clusters for 650+ brands. Speaking on industrial SEO at stephane-jambu.com.