AI-Powered RSS Newsletter Automation with Gmail & Postgres

This n8n workflow transforms RSS feeds into polished HTML newsletters by leveraging AI for intelligent curation. It fetches articles from specified RSS sources, evaluates them using an AI model like QWEN 14B for relevance, quality, and tagging, then summarizes top-rated ones with Gemma3 4B for concise reading. Duplicates are checked against a Postgres database to ensure fresh content, and the best articles are formatted and dispatched via Gmail with OAuth2 authentication.

Key benefits include significant time savings for content curators and marketers, eliminating manual article selection and summarization. It ensures high-quality, relevant newsletters that boost engagement without repetition. Ideal for bloggers, newsletters like Substack, or team updates, it scales effortlessly with local n8n and Ollama for privacy-focused AI processing.

Use cases span email marketing campaigns, industry news digests, or personalized learning feeds. Requirements are minimal: Postgres DB, RSS URLs, Google OAuth, and local AI models. For cloud, swap Ollama nodes. Enhances productivity by automating end-to-end from feed to inbox, with full tracking of sent articles and ratings for ongoing optimization.