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

Overview

This 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.

Template

• n8n: Open workflow

Who is this for?

• Content Teams & Solo Creators
• Newsletters & Media Brands
• Agencies
• Founders & PMMs

Key benefits

• Scores Articles: Filters noise with AI quality/relevance scoring.
• Auto-Writes Posts: Generates X threads and LinkedIn copy.
• Routes Intelligently: Review or auto-publish paths.
• Logs Everything: Structured history in Google Sheets.

Detailed flow

1. RSS Polling: Monitors feeds.
2. Scoring AI: Rates quality/relevance.
3. Quality Gates: Directs to publish/review/archive.
4. Content Gen: Produces platform-native hooks and insights.
5. Publish: Uploads to X, Threads, LinkedIn via Upload-Post.

Setup (step-by-step)

1. Add OpenAI and Upload-Post credentials.
2. Connect Google Sheets for logging.
3. Replace RSS Feed URL.
4. Adjust scoring thresholds and publishing mode (Review vs Auto).