AI-Powered News Monitoring & Social Post Generator with OpenAI and Upload-Post

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.