Back to Templates
Overview
This workflow automates the process of converting RSS feed articles into ready-to-publish social media posts using OpenAI, NocoDB, and Telegram. It's ideal for content teams, marketing managers, or news portals seeking to automate content curation while maintaining control through a human approval system.
Features
RSS Feed Monitoring
Polls a specified RSS feed every 20 minutes.
Detects new articles automatically.
AI-Powered Content Processing
Summarizes the full article using OpenAI's Assistant API.
Creates an image prompt based on the article summary.
Generates a platform-specific post for Facebook and LinkedIn using AI.
Image Generation
Leverages OpenAI's image model to generate a relevant image from the prompt.
Retrieves and stores the featured image from the original article (via custom code node).
Post Management with NocoDB
Stores all content in NocoDB including:
Article URL
AI-generated summary
Image prompt
Post content per platform
Generated image URL
Post status (Pending, Approved, Declined)
Human Approval via Telegram
Sends post preview to a Telegram group or channel with inline buttons:
✅ Approve
❌ Decline
On approval: Posts to Facebook, LinkedIn, and optionally Twitter.
On rejection: Marks the NocoDB record as "Declined".
Conditional Twitter (X) Posting
Asks user whether to post with or without a link.
Posts accordingly based on user’s Telegram response.
No-Code Backend
NocoDB acts as a lightweight CMS to manage, edit, and review AI-generated content before publishing.
Setup Instructions
Clone the workflow in your n8n instance.
Configure the following credentials under Credentials > New:
OpenAI API Key
Facebook Graph API
LinkedIn Access Token
Twitter (X) OAuth credentials
Telegram Bot Token and Chat ID
NocoDB API Token and Base URL
Set the RSS feed URL in the trigger node to your preferred news source.
Adjust the NocoDB API node with your table and field names (see below).
Deploy the workflow on an interval trigger (20-minute polling recommended).
NocoDB Database Structure
Column Name Description
url Original article URL
summary AI-generated summary
image_prompt Prompt used for generating image
image_url Final image URL (from OpenAI)
post_content Formatted social media post
platform Social platform (Facebook, LinkedIn, etc.)
status Current status (Pending, Approved, Declined)
date_created Date article was fetched
Requirements
An active n8n instance (cloud or self-hosted).
API credentials for:
OpenAI
Telegram Bot
Facebook Graph API
LinkedIn Developer App
Twitter/X Developer App
NocoDB (self-hosted or cloud)
A Telegram chat (group or user) where the bot is added.
Customization Guidance
Add more platforms: Extend the logic to other platforms like Instagram, Threads, or Mastodon.
Customize AI tone: Adjust the prompt to OpenAI for a specific writing style (e.g., formal, casual, humorous).
Adjust scheduling: Modify interval time or RSS feed frequency as needed.
Add post delay: Schedule posts using a delay node to spread them over time.
Use Cases
Auto-publish summarized news articles to multiple social platforms.
Reduce effort for social teams by automating draft creation and media.
Maintain editorial control using the Telegram approval step.
Repurpose blog or article content into engaging posts with minimal effort.
Integrations Used
OpenAI (Assistants & DALL·E Image Generation)
Telegram Bot (Inline approval workflow)
Facebook Graph API (Post publishing)
LinkedIn API (Company or personal posts)
Twitter/X API (Optional conditional post publishing)
RSS Feed Reader (Article fetching)
NocoDB (Content repository and status manager)