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

Description

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
RSS Polling: Monitors your chosen feed(s) on a schedule.
Scoring AI: Rates quality and relevance; extracts summary, key topics, and angle.
Parse & Enrich: Normalizes AI output and merges with article metadata.
Quality Gates: Directs items to “publish/review” or “archive.”
Content Generation: Produces an X thread and a LinkedIn post with clear hooks and insights.
Publishing: Uploads to X, Threads, and LinkedIn via Upload-Post (optional).
Sheets Logging: Writes summaries, scores, and outputs to Google Sheets.

Setup
OpenAI API: Add your OpenAI credentials (models like gpt-4.1/gpt-4o).
Upload-Post Credentials: Connect the Upload-Post integration and target pages (e.g., LinkedIn org ID).
Google Sheets: Add OAuth credentials and point “Store Content”/“New for Review”/“Archive” to your sheets.
RSS Feed URL: Replace the sample feed with your preferred sources.
Thresholds & Routing: Adjust quality/relevance filters to your standards.
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.