This automation template turns any RSS feed into ready-to-publish social content using AI. It continuously ingests articles, scores their quality and relevance, crafts platform-native posts (Twitter/X threads and LinkedIn posts), routes items for review or archiving, logs everything to Google Sheets, and can publish automatically to X, Threads, and LinkedIn. Note: This workflow uses OpenAI models for analysis and content generation and integrates with Upload-Post f

This automation template turns any RSS feed into ready-to-publish social content using AI. It continuously ingests articles, scores their quality and relevance, crafts platform-native posts (Twitter/X threads and LinkedIn posts), routes items for review or archiving, logs everything to Google Sheets, and can publish automatically to X, Threads, and LinkedIn. Note: This workflow uses OpenAI models for analysis and content generation and integrates with Upload-Post for multi-platform publishing and Google Sheets for tracking. Costs depend on token usage and posting volume. Who Is This For? - Content Teams & Solo Creators: Ship consistent, high-signal posts without manual rewriting. - Newsletters & Media Brands: Turn breaking stories into shareable, platform-native content. - Agencies: Scale curation across clients with review and auto-publish paths. - Founders & PMMs: Maintain a steady public presence with minimal effort. What Problem Does This Workflow Solve? Manual curation and rewriting of news is slow and inconsistent. This workflow: - Scores Articles: Filters noise with AI quality/relevance scoring. - Auto-Writes Posts: Generates concise X threads and business-ready LinkedIn copy. - Routes Intelligently: Sends good items to publish/review and archives the rest. - Logs Everything: Keeps a structured history in Google Sheets for analytics. How It Works 1. RSS Polling: Monitors your chosen feed(s) on a schedule. 2. Scoring AI: Rates quality and relevance; extracts summary, key topics, and angle. 3. Parse & Enrich: Normalizes AI output and merges with article metadata. 4. Quality Gates: Directs items to “publish/review” or “archive.” 5. Content Generation: Produces an X thread and a LinkedIn post with clear hooks and insights. 6. Publishing: Uploads to X, Threads, and LinkedIn via Upload-Post (optional). 7. Sheets Logging: Writes summaries, scores, and outputs to Google Sheets. Setup 1. OpenAI API: Add your OpenAI credentials (models like gpt-4.1/gpt-4o). 2. Upload-Post Credentials: Connect the Upload-Post integration and target pages (e.g., LinkedIn org ID). 3. Google Sheets: Add OAuth credentials and point “Store Content”/“New for Review”/“Archive” to your sheets. 4. RSS Feed URL: Replace the sample feed with your preferred sources. 5. Thresholds & Routing: Adjust quality/relevance filters to your standards. 6. Publishing Mode: Toggle platforms (X, Threads, LinkedIn) and decide auto vs. review-first. Requirements - Accounts: n8n, OpenAI, Upload-Post, Google account (Sheets). - API Keys: OpenAI token, Upload-Post credentials, Google Sheets OAuth. - Feeds: One or more RSS URLs for your niche. Features - AI Triage: Quality/relevance scoring to prioritize high-value stories. - Platform-Native Output: Hooked X threads and professional LinkedIn posts. - Review or Auto-Publish: Safe gating before posting live. - Analytics-Ready Logs: Structured entries in Google Sheets. - Modular & Extensible: Swap feeds, add Slack/Discord alerts, or plug into CMS/Notion. Stay top-of-mind: convert fresh news into compelling, on-brand social content—automatically.
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.