Auto-repurpose RSS blog posts into multi-platform social content with n8n

RSS feed → AI rewrite (SEO blog / LinkedIn / X thread) → Google Sheets calendar + Gmail draft + Slack notification

Who

Content operators, founders, and marketing teams who need to auto-distribute blog/newsletter content to social channels

You get

Daily auto-fetch of the latest RSS article, generating an SEO title, blog rewrite, LinkedIn post, and X thread, logged to a spreadsheet, emailed as a draft, and notified in Slack

You need

n8n · google-sheets · gmail · slack

Steps

1. Configure trigger and content source

   After importing the template into n8n, set up credentials for OpenAI, Google Sheets, Gmail, and Slack. Then edit the 'Set Brand & Source' node: enter your RSS feed URL, audience description, and brand voice. The remaining nodes (Every Day schedule trigger, Get Latest Article RSS read, Take Newest Only limit to 1 item) stay connected by default.

2. AI rewrite into structured multi-platform content

   The 'Repurpose into Content' node sends the latest article title, snippet, and link to the OpenAI Chat Model (gpt-4o-mini), with a Structured Output Parser enforcing JSON. The node contains a built-in system prompt defining output fields and format requirements.

   Execution prompt · Source text。n8n node 'Repurpose into Content' text parameter (Basic LLM Chain custom prompt)

   Copy prompt

   =You are a senior content strategist. Repurpose the source content below for the brand.
   
   Audience: {{ $('Set Brand & Source').item.json.audience }}
   Brand voice: {{ $('Set Brand & Source').item.json.brand_voice }}
   
   Source title:
   {{ $json.title }}
   
   Source content:
   {{ $json.contentSnippet || $json.content }}
   
   Source link: {{ $json.link }}
   
   Return:
   - seo_title: a punchy, search-friendly title (<= 60 chars).
   - meta_description: a 150-160 char summary for SEO.
   - blog_post: a rewritten, original blog post in markdown (~400-600 words) in the brand voice. Do not copy sentences verbatim.
   - linkedin_post: a LinkedIn post (hook + value + soft CTA), no more than 1300 chars.
   - twitter_thread: an X/Twitter thread as an array of tweets, each <= 270 chars.
   - hashtags: 3-5 relevant hashtags as a single string.

3. Distribute to spreadsheet, email, and Slack

   The parsed JSON is sent in parallel to three nodes: Save to Content Calendar appends to Google Sheets (with date, status, SEO title, source link, LinkedIn post, and Twitter thread); Draft for Review creates a Gmail draft containing all generated content; Share in Slack posts a channel message with the SEO title, source link, and LinkedIn draft preview.

   Execution prompt · Source text。n8n node 'Share in Slack' text parameter

   Copy prompt

   =:memo: *New content ready to review:* {{ $json.output.seo_title }}
   From: {{ $('Take Newest Only').item.json.link }}
   
   *LinkedIn draft:*
   {{ $json.output.linkedin_post }}

You are setting up an n8n workflow that auto-fetches a blog from RSS and rewrites it into an SEO blog post, LinkedIn post, and X thread. Check in this order: 1) Confirm OAuth credentials are added for OpenAI, Google Sheets, Gmail, and Slack; 2) In the 'Set Brand & Source' node, enter your RSS URL, audience, and brand voice; 3) In the Google Sheets node, replace YOUR_GOOGLE_SHEET_ID with your sheet ID and verify columns: Date, Status, SEO Title, Source Link, Source Title, LinkedIn Post, Twitter Thread; 4) In the Slack node, select the target channel; 5) Activate the workflow and inspect the first run output.