Automated AI Newsletter System
Content Automation
Email Marketing
The Problem
Newsletter writers and founders spent hours curating links, writing intros, and formatting each send manually.
Automated Solution
Content is sourced, filtered, summarized, written, and delivered automatically every week, without touching a thing.
Built with Make.com, Apify, OpenAI, Google Sheets, and MailChimp. Set it once - runs forever.
How It Works?
- Apify scrapes Reddit posts from curated AI subreddits - GPT-4o filters out junk, flags relevant posts - New posts are saved to Google Sheets - A second scenario uses GPT-4o to summarize content, write snippets, and generate the newsletter title + intro - HTML is generated and pushed to MailChimp (or any other sender) to send automatically - Used posts are archived; campaign data is logged
The Benefit
✅ Zero manual hours spent per newsletter ✅ Runs 100% autonomously - content to inbox ✅ ~$30/week average cost (including AI + scraping + setup) ✅ Consistent weekly content without burnout or blockers
