Publish LinkedIn posts from RSS using Ollama, PostgreSQL and Telegram approval
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
Nodes used (12)
- Ollama Chat Model
@n8n/n8n-nodes-langchain.lmChatOllama - AI Agent
@n8n/n8n-nodes-langchain.agent - Postgres
n8n-nodes-base.postgres - Telegram Trigger
n8n-nodes-base.telegramTrigger - Code
n8n-nodes-base.code - No Operation, do nothing
n8n-nodes-base.noOp - LinkedIn
n8n-nodes-base.linkedIn - Telegram
n8n-nodes-base.telegram - RSS Read
n8n-nodes-base.rssFeedRead - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - If
n8n-nodes-base.if - RSS Feed Trigger
n8n-nodes-base.rssFeedReadTrigger
What it does
This workflow automatically converts incoming RSS/news articles into structured, AI-enriched content records. It uses a local AI model to summarize articles, extract metadata, and classify content before storing it in PostgreSQL. A human-in-the-loop approval step via Telegram ensures only validated content is published to LinkedIn, maintaining quality and brand safety. ⚙️ How it works Fetch RSS feed articles → AI summarizes content using Ollama → Extracts category, keywords, sentiment, and key points → Stores structured data in PostgreSQL → Sends content to Telegram for human approval → User approves or rejects → Approved content is marked in database → Automatically publishes approved posts to LinkedIn 📦 Requirements n8n (latest version) PostgreSQL database Telegram Bot API credentials LinkedIn Developer App (OAuth2) Ollama (local AI runtime) with model like qwen2.5:3b RSS feed source (e.g., Ars Technica or any news feed) 📊 Database Table Required: rssfeedarticles Stores AI-processed articles, metadata, and approval status for controlled publishing workflow.