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

Description and use

An n8n workflow that daily fetches the newest blog post, uses an LLM to create platform‑native drafts for X, LinkedIn, and Facebook, parses the JSON output, and appends the drafts to Google Sheets for human review before posting.

Problem

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

Outcome

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.

Workflow

• 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

Evidence

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.

Source

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

Source

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.

Source