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 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.
By Juan Carlos Cavero GraciaCreates a time tracking project from Syncro to Clockify
This workflow creates a project in Clockify that any user can track time against. Syncro should be setup with a webhook via Notification Set for Ticket - created (for anyone). > This workflow is part of an MSP collection, The original can be found here: https://github.com/bionemesis/n8nsyncro
By Jonathan