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

说明与用途

一个 n8n 工作流，每天提取最新博客文章，使用 LLM 生成 X、LinkedIn 和 Facebook 的平台原生草稿，解析 JSON 输出，并将草稿追加到 Google 表格中供人工审核后发布。

问题

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.

来源