Skip to main content

Repurpose RSS blog posts into social content with OpenAI, Sheets, Gmail and Slack

Workflow preview

Workflow preview
100%
Repurpose RSS blog posts into social content with OpenAI, Sheets, Gmail and Slack preview
Open on n8n.io

1. Workflow Overview

Quick Overview This workflow runs daily, pulls the latest post from an RSS feed, and uses OpenAI to repurpose it into an SEO blog rewrite, a LinkedIn post, and an X/Twitter thread, then logs the dr...

Best for

  • Content Creation automation workflows
  • Multimodal AI automation workflows
  • advanced n8n builders looking for reusable templates

Tools used

n8n-nodes-base.stickynote, n8n-nodes-base.scheduletrigger, n8n-nodes-base.set, n8n-nodes-base.rssfeedread, n8n-nodes-base.limit, @n8n/n8n-nodes-langchain.chainllm, @n8n/n8n-nodes-langchain.lmchatopenai, @n8n/n8n-nodes-langchain.outputparserstructured

Source and attribution

This workflow is cataloged by N8N Workflows and links back to its original n8n.io source page by Abhishek Gawade.

Original n8n.io source

1.1 Workflow description

Title
Repurpose RSS blog posts into social content with OpenAI, Sheets, Gmail and Slack
Workflow name
Repurpose RSS blog posts into social content with OpenAI, Sheets, Gmail and Slack

Quick Overview

This workflow runs daily, pulls the latest post from an RSS feed, and uses OpenAI to repurpose it into an SEO blog rewrite, a LinkedIn post, and an X/Twitter thread, then logs the drafts to Google Sheets, creates a Gmail draft, and posts a preview to Slack.

How it works

  1. Runs every 24 hours on a schedule.
  2. Loads your RSS feed URL, audience, and brand voice settings and fetches the latest items from the RSS feed.
  3. Keeps only the newest feed item to avoid processing multiple posts in a single run.
  4. Sends the post title, snippet/content, and link to OpenAI to generate a structured JSON response containing an SEO title, meta description, rewritten blog post, LinkedIn post, X/Twitter thread, and hashtags.
  5. Appends the generated social drafts and source metadata to a Google Sheets content calendar.
  6. Creates a Gmail draft containing the SEO fields, blog rewrite, LinkedIn post, X/Twitter thread, and hashtags for review.
  7. Posts a Slack message with the new SEO title, source link, and LinkedIn draft to a выбранный channel.

Setup

  1. Add OpenAI API credentials for the Chat model used to generate the repurposed content.
  2. Add a Google Sheets OAuth credential, set the target spreadsheet ID, and ensure the sheet has columns matching Date, Status, SEO Title, Source Link, Source Title, LinkedIn Post, and Twitter Thread.
  3. Add a Gmail OAuth credential for creating email drafts in your account.
  4. Add a Slack OAuth credential and select the channel where the workflow posts review messages.
  5. Update the RSS feed URL, audience, and brand voice text in the “Set Brand & Source” step to match your content source and tone.

1.2 Logical Blocks

This catalog entry is organized from the workflow JSON. The node-level section below shows the executable blocks available for review before importing the template.

2. Block-by-Block Analysis

Block 1 - Overview

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 2 - Warning

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 3 - Section: Source

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 4 - Section: Repurpose

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 5 - Section: Distribute

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 6 - Every Day

Type / Role
n8n-nodes-base.scheduleTrigger - scheduleTrigger
Config choices
Version 1.2

Block 7 - Set Brand & Source

Type / Role
n8n-nodes-base.set - set
Config choices
Version 3.4

Block 8 - Get Latest Article

Type / Role
n8n-nodes-base.rssFeedRead - rssFeedRead
Config choices
Version 1.1

Block 9 - Take Newest Only

Type / Role
n8n-nodes-base.limit - limit
Config choices
Version 1

Block 10 - Repurpose into Content

Type / Role
@n8n/n8n-nodes-langchain.chainLlm - chainLlm
Config choices
Version 1.5

Block 11 - OpenAI Chat Model

Type / Role
@n8n/n8n-nodes-langchain.lmChatOpenAi - lmChatOpenAi
Config choices
Version 1.2

Block 12 - Parse Content (JSON)

Type / Role
@n8n/n8n-nodes-langchain.outputParserStructured - outputParserStructured
Config choices
Version 1.2

Block 13 - Save to Content Calendar

Type / Role
n8n-nodes-base.googleSheets - googleSheets
Config choices
Version 4.5

Block 14 - Draft for Review

Type / Role
n8n-nodes-base.gmail - gmail
Config choices
Version 2.1

Block 15 - Share in Slack

Type / Role
n8n-nodes-base.slack - slack
Config choices
Version 2.3

3. Summary Table

Workflow Repurpose RSS blog posts into social content with OpenAI, Sheets, Gmail and Slack
Complexity advanced
Nodes 15
Categories Content Creation, Multimodal AI
Author Abhishek Gawade
Published 07 Jun 2026

4. Reproducing the Workflow from Scratch

  1. 1. Download the workflow JSON

    Use the JSON export at /data/workflows/16158/16158.json as the source template for this automation.

  2. 2. Import the template into n8n

    Open n8n, import the downloaded JSON, and review each node before activating the workflow.

  3. 3. Configure credentials and variables

    Replace placeholder credentials, API keys, webhook URLs, account IDs, and environment-specific values with your own settings.

  4. 4. Test with sample data

    Run the workflow manually or in a staging workspace, inspect node output, and confirm downstream systems receive the expected data.

  5. 5. Activate and monitor

    Enable the workflow only after testing, then monitor executions, errors, and rate limits during the first production runs.

5. General Notes & Resources

Review imported nodes carefully before activation. This catalog entry is intended to help you inspect the workflow structure, understand required services, and find related templates faster.

Node names, credentials, schedules, webhook paths, and external service limits may need adjustment for your workspace.

Frequently asked questions

What does Repurpose RSS blog posts into social content with OpenAI, Sheets, Gmail and Slack do?

Quick Overview This workflow runs daily, pulls the latest post from an RSS feed, and uses OpenAI to repurpose it into an SEO blog rewrite, a LinkedIn post, and an X/Twitter thread, then logs the dr...

What do I need before importing this workflow?

Review the workflow JSON, configure any required credentials in n8n, and test the automation in a safe workspace before using it in production.

Can I customize this workflow?

Yes. Use the block-by-block analysis and the downloadable JSON to inspect each node, then adjust credentials, prompts, schedules, filters, or destinations for your Content Creation, Multimodal AI use case.