Blog Content Summarizer
n8n, OpenRouter, Apify, Google Drive API
Problem
Staying updated with engineering and product blogs from top tech companies was overwhelming. With too many sources to track and inbox subscriptions creating clutter, there was no efficient, curated way to consume content without wading through endless feeds.
The core issue wasn’t just volume—it was signal vs. noise. To extract value, content needed to be filtered for freshness, simplified for clarity, and organized by type. Automation could solve this by transforming scattered information into structured, digestible insights.
Project Structure
I built a custom workflow using n8n, integrating multiple tools to streamline the process:
Capture: Aggregate blog posts via RSS feeds (and generate feeds with Rss.app when missing).
Filter: Select only posts from the last 24 hours.
Simplify: Pass entries to an AI Agent (Claude Sonnet via OpenRouter) to rewrite jargon-heavy text into clear summaries.
Organize: Separate engineering vs. product content into Google Docs stored in Drive.
Automate: Schedule the pipeline to run daily at 10am. To handle edge cases, I used Apify webscrapers for partial feeds and built custom data-conversion logic to normalize inconsistent formats.
Result
The system transformed an overwhelming task into a seamless, daily routine. Instead of manually tracking dozens of blogs, I now receive clean, curated summaries every morning—organized, simplified, and ready for quick consumption. This not only saves time but ensures continuous learning and awareness of industry trends without distraction.