Automate RSS content to blog posts with GPT-4o, WordPress & LinkedIn publishing

Automated Blog Post Review and Multi-Platform Publishing Workflow with RSS Feeds  Description This workflow automates the process of generating, reviewing, and publishing blog posts across multiple platforms, now enhanced with support for RSS Feeds as a content source. It streamlines the management of blog posts by fetching content from RSS Feeds, formatting, storing, reviewing, templating, and publishing to platforms like LinkedIn and WordPress. The workflow is split into three key flows: - Initial Flow: Fetches content from RSS Feeds, prepares and stores blog post data, sends a review email with approval/rejection links. - Approval Flow: Handles review actions via a webhook to update the status in Google Sheets. - Status Update Flow: Monitors status changes and publishes approved posts.

Target Audience - Content creators, bloggers, and digital marketers. - Teams managing multi-platform content publishing. - Users familiar with n8n, Google Sheets, LinkedIn, and RSS Feeds.

Problem Solved

Manually managing blog posts, especially when sourcing content from RSS Feeds, can be time-consuming and error-prone This workflow addresses: - Content Sourcing: Fetches blog posts from RSS Feeds for automated processing - Content Formatting: Automatically formats and stores blog posts. - Review Process: Simplifies approval with email notifications and webhook triggers. - Multi-Platform Publishing: Publishes to LinkedIn, WordPress and optionally Medium) with delays to avoid rate limits - Status Tracking: Tracks approval and publishing status in Google Sheets.

Setup Instructions

Prerequisites - n8n Instance: Ensure you have an active n8n instance - RSS Feed URL: Identify an RSS Feed URL (e.g., a blog’s feed like https://example.com/feed) - Google Sheets: Create a spreadsheet with columns: Title, Blogpost, Publication Date, Keywords, Status, Published, Featured Image, articleUrl, Rendered Blog. - Sheet Name: Posts Initial - Add a dropdown for Status: Pending, Approved, Rejected. - Gmail Account: For sending review and notification emails. - LinkedIn Account: For publishing posts (OAuth credentials needed). - Optional: WordPress.com or Medium account for additional publishing.

Customization Guidance Below is a detailed breakdown of each flow and node, including setup instructions.

🔹 Initial Flow: Fetch from RSS Feeds, Prepare, and Send for Review.