Automate AI News with OpenRouter: RSS to Postgres Workflow

Automate AI News Digestion with OpenRouter: Streamlined RSS to Postgres Workflow

Effortlessly transform your daily news intake and analysis with the Automate AI News with OpenRouter: RSS to Postgres Workflow. Designed for seamless integration and efficiency, this cutting-edge workflow taps into the power of AI to ingest, analyze, and deliver news articles directly from your favorite RSS feeds into Postgres. With precise fact-checking using LangChain LLMs and streamlined newsletter delivery, stay informed and ahead in your field with minimal effort.

What this workflow does

• Runs on a schedule to query your Postgres database for active RSS feed sources and fetch the latest articles.
• Filters articles to retain only those published in the last 24 hours, enhances them with metadata, and stores them in Postgres after normalizing and deduplicating content.
• Hourly analysis locks in an article and processes it with LangChain LLMs (Ollama, with OpenRouter as fallback) for structured relevance and accuracy verification.
• Computes a composite score and ranks articles by tier, storing analysis results back in Postgres for potential newsletter inclusion.
• Daily, draws up to 20 eligible articles to craft an HTML newsletter complete with summaries and contextual importance, dispatching it via Resend.
• Logs successful deliveries or records failures in Postgres, ensuring accurate tracking and analysis.

Use cases

• News agencies looking to automate daily briefings and streamline editorial workflows with factual accuracy.
• Content creators and bloggers who want to automatically fetch, analyze, and include relevant news updates in their daily content or newsletters.
• Data-driven teams in need of a tool to succinctly present key sector trends in an engaging format.

Technical details

• Relies on a robust tech stack including nodes: if, set, code, form, filter, Postgres.
• Central to the workflow are the LangChain LLMs—Ollama and OpenRouter—for content analysis and validation.
• Utilizes Resend for reliable and stylish email newsletter dispatch.
• Integrates with Postgres to manage and store article data efficiently.