I automated a news site with n8n: from 20 RSS feeds to WordPress drafts

Описание и применение

Автоматизированный поток n8n обрабатывает 20 RSS‑каналов, удаляет дубликаты, оценивает релевантность дешёвой LLM, переписывает выбранные статьи более мощной LLM, добавляет изображение и создаёт черновик в WordPress, отправляя уведомление в Telegram.

Задача

Manually reviewing dozens of RSS feeds, scoring relevance, rewriting stories, and creating WordPress drafts was time‑consuming and repetitive.

Результат

The pipeline reduces manual effort by automating feed ingestion, deduplication, relevance scoring, rewriting, image attachment, and draft creation, leaving only editorial review. It runs every three hours with minimal token spend by filtering early.

Рабочий процесс

• Schedule trigger every 3h
• Read list of RSS feeds
• Split feeds into individual items
• Cap to 3 items per feed (Code node)
• Hash each link (SHA256)
• Insert into Postgres with ON CONFLICT DO NOTHING to deduplicate
• If new, scrape article with Firecrawl
• Score relevance 0‑100 with cheap LLM
• If score ≥70, rewrite with tiered LLM (Claude if ≥85, else Gemini)
• Fetch cover image from Unsplash
• Create WordPress draft with cover image
• Mark as published in Postgres
• Send Telegram alert

Доказательства

Deduplicate before spending: hash the link and let Postgres reject repeats with ON CONFLICT DO NOTHING.

Источник

Use a cheap model to score relevance from 0 to 100 before rewriting: only what clears the threshold reaches the expensive model.

Источник