AutomationMart
Home/Browse/Repurpose RSS blog posts into social content with OpenAI, Sheets, Gmail and Slack
n8n

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

n8nn8n10 modulesv1.0
GmailSlackGoogle SheetsOpenAILinkedIn

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 p

At a glance

Repurpose RSS blog posts into social content with OpenAI, Sheets, Gmail and Slack is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Gmail, Slack, Google Sheets, OpenAI. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
Gmail, Slack, Google Sheets, OpenAI, LinkedIn
Modules
10
Price
Free
Version
v1.0
Repurpose RSS blog posts into social content with OpenAI, Sheets, Gmail and Slack workflow diagram

About this workflow

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.

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 5

    Click Execute Workflow to test, then activate.

Setup guide

Setup guide included

Purchase to unlock the full step-by-step guide

Related N8n workflows

Generate content with ChatGPT from Google Sheets range values and update the row

Automatically generate content using ChatGPT from Google Sheets range values and update the rows. Streamline data processing and content creation with this powerful integration.

Free

Generate LinkedIn posts and AI images from web pages with Airtop and GPT-4

Use Case Turn any web page into a compelling LinkedIn post — complete with an AI-generated image. This automation is ideal for sharing content like blog posts, case studies, or product updates in a polished and engaging format. What This Automation Does Given a page URL and optional user instructions, this automation: - Scrapes the content of the webpage - Uses AI to write a clear, educational, and LinkedIn-optimized post - Generates a brand-aligned visual that matches the content - Send

Free

Send a notification to Slack about new Paperform submissions

Whenever you receive a new submission for your Paperform, you will receive a custom notification in the Slack channel of your choice.

Free

Send new tickets from Zendesk as Slack messages.

Use this automation to notify your team on Slack whenever new tickets are created in Zendesk. Make will automatically retrieve the URLs of the tickets and send it as Slack messages.

Free

Create OpenAI-compatible API using GitHub models for free AI access

This n8n template shows you how to connect Github's Free Models to your existing n8n AI workflows. Whilst it is possible to use HTTP nodes to access Github Models, The aim of this template is to use it with existing n8n LLM nodes - saves the trouble of refactoring! Please note, Github states their model APIs are not intended for production usage! If you need higher rate limits, you'll need to use a paid service. How it works The approach builds a custom OpenAI compatible API around the Github M

Free

Post a daily reminder to a selected Slack channel

This scenario will automatically send a daily reminder to a selected channel in Slack.

Free

Evaluation metric example: String similarity

AI evaluation in n8n This is a template for n8n's evaluation feature. Evaluation is a technique for getting confidence that your AI workflow performs reliably, by running a test dataset containing different inputs through the workflow. By calculating a metric (score) for each input, you can see where the workflow is performing well and where it isn't. How it works This template shows how to calculate a workflow evaluation metric: text similarity, measured character-by-character. The workflow ta

Free

AI auto-save Gmail receipts to Google Sheets + Google Drive

Who is this for? This workflow is ideal for: - For freelancers, business owners, and finance teams who receive receipts via Gmail - Automatically logs expenses for tax, - bookkeeping and year-end audits What problem is this workflow solving? When tax season hits, missing receipts create panic. This workflow keeps everything in one place. It uses AI to extract details from Gmail attachments, logs them in a Google Sheet, and stores the PDFs in Google Drive. No digging. No copying. Just everythin

Free

Reviews

No reviews yet

Be the first to buy and share your experience.

Leave a review

Sign in to share your experience with this workflow.

Log in to review
Free
No ratings yet

Create a free account to purchase workflows.

  • JSON blueprint — instant download
  • Setup guide PDF included
  • 5 downloads · valid 30 days
  • Works with n8n

Need help setting this up?

Book a 3-hour live setup session with an Agility consultant.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free