Turn Your Blog RSS into a Week of Social Posts with n8n and Any LLM API

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

Автоматический рабочий процесс n8n, который ежедневно извлекает новую запись блога, генерирует черновики для X, LinkedIn и Facebook с помощью LLM, сохраняет их в Google Sheets для проверки и публикации.

Задача

Consistently repurposing blog content into social media drafts while maintaining brand voice and minimizing manual effort.

Результат

The workflow reduces daily manual effort to about 10 minutes, generates platform‑native drafts in a single JSON object, and keeps brand consistency by requiring human review before posting.

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

• Schedule a daily trigger
• Read the blog RSS feed
• Select the newest post
• Call an LLM chat completion endpoint with a system prompt to produce JSON drafts
• Parse the LLM JSON response
• Shape a clean item with date, source title, source URL, drafts, and status 'draft'
• Append the item to a Google Sheets tab

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

Posting consistently is a distribution problem, not a writing problem. You already wrote the thinking (the blog post). This workflow turns each new post into platform-native drafts automatically, and a human reviews before anything goes out.

Источник

Schedule (daily) -> Read Blog RSS -> Take newest post -> LLM draft -> Parse -> Save to Google Sheets.

Источник

AI drafts are 80% there and 20% off-brand. The sheet is the review queue. This keeps your voice intact and avoids the classic automation embarrassment of a bot posting nonsense at 3am. Total human time: 10 minutes a day.

Источник