End-to-End Reporting & Content Automation
An automated pipeline that turns live RSS feeds into branded, platform-ready content using n8n, Gemini API, Supabase, and Telegram.
How the automation works
The n8n workflows behind this project. Select any node to read what it does.
News to branded post
One Telegram command picks a fresh article, writes the caption, generates and watermarks the image, and sends it back ready to post.
Step by step
Start from Telegram
A message to the team's Telegram bot starts the workflow, so no one has to open n8n.
Choose the news source
The command decides which outlet to report for: CNZ, Blockchain, or NCN.
Read the news feeds
Pulls the latest articles from the matching Google News RSS feed.
Keep only fresh news
Filters out anything published before yesterday.
Label and shape the article
Tags each article with its outlet and logo, then keeps just the title, link, and description.
Never post twice
Checks Supabase for links that were already posted and drops them.
Pick one story
Takes a single article so each command produces exactly one post.
Write and illustrate with AI
Gemini writes the caption and generates a matching image at the same time.
Brand the image
Downloads the outlet's logo, resizes it, and stamps it in the corner of the generated image.
Deliver to Telegram
Sends the finished image and caption back to the chat, ready to publish.
Remember what was posted
Saves the article's link to Supabase so it is skipped next time.
Error alerts
A separate safety net: if any connected workflow fails, the team is told right away.
Step by step
Catch any failure
n8n runs this workflow automatically whenever a connected workflow stops with an error.
Send an alert
Posts the workflow name, the node that failed, and the time to the team's Telegram chat.
Overview
An autonomous system that transforms live RSS feeds into branded, platform-ready content. Telegram triggers the workflow, AI writes the captions, and logos are watermarked automatically.
News selection, captioning, and visual branding run in one pipeline instead of separate manual steps.
Business problem
Selecting news, writing captions, and branding visuals by hand for every post is slow and repetitive.
Solution approach
An n8n pipeline that pulls RSS feeds, uses the Gemini API to write captions, stores data in Supabase, and is controlled through a Telegram bot.
