Automate RSS Curation with NocoDB & n8n for Telegram Alerts

Automate RSS Curation with NocoDB & n8n for Telegram Alerts

Revolutionize your content curation process with our automated workflow solution. This dynamic n8n automation leverages NocoDB, Google Gemini, and Telegram to consistently deliver high-quality, relevant RSS content updates directly to your Telegram chat, empowering you to stay ahead in content dissemination.

What this workflow does

Effortlessly manage and curate RSS feeds with a robust, twice-daily automated workflow that optimizes your content delivery strategy.

• Scheduled Pulling: Automatically activates at 06:00 and 18:00 Europe/London time.
• Source Retrieval: Gathers curated RSS/Atom feed sources and metadata from your NocoDB table.
• Content Parsing: Scans each feed to compile a list of articles from the past five days, complete with titles, URLs, excerpts, authors, and sources.
• Duplicate Filtering: Checks for duplicate URLs in the NocoDB queue and filters them out to ensure only new entries proceed.
• Scoring with Google Gemini: Evaluates up to 10 articles for relevance and quality, suggesting commentary angles for those achieving a score of 7/10 or higher.
• Queue Management: Sends high-scoring articles to your NocoDB queue for approval and expires outdated entries.
• Telegram Notifications: Updates your Telegram chat with an interactive list of articles, offering easy approve/skip options, or informs you if no new articles are available.

Use cases

• Content Creators: Streamline the RSS content curation, approval, and publication process, ensuring you only focus on top-quality feeds.
• News Aggregators: Automate the selection process, fetching and filtering articles to maintain a consistent, high-standard news flow.
• Community Managers: Efficiently distribute curated content to Telegram groups, enhancing community engagement with timely and relevant information.

Technical details

• Integrations/N8n Nodes Used: Schedule Trigger, NocoDB, Google Gemini (PaLM), and Telegram.
• Required Credentials: NocoDB API token and Google Gemini API credential set up within n8n.
• Primary Platforms: This workflow operates within n8n’s ecosystem, interacting closely with NocoDB for data storage and integration.

Maximize your productivity and ensure superior content curation with the 'Automate RSS Curation with NocoDB & n8n for Telegram Alerts' workflow. Optimize how you manage, score, and share content updates today!