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

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.
Download the workflow JSON file after purchase.
Open n8n → click the menu → Import from File.
Select the downloaded JSON and import.
Set up credentials for each node that requires them.
Click Execute Workflow to test, then activate.
Setup guide included
Purchase to unlock the full step-by-step guide
No reviews yet
Be the first to buy and share your experience.
Leave a review
Sign in to share your experience with this workflow.
Create a free account to purchase workflows.
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.