The 100% Automated Newsletter Builder Using RSS → OpenAI → ConvertKit
Curate content while you sleep. Automatically find top industry news, summarize it, and draft a newsletter for your review.
Table of Contents
"I need to send a newsletter, but I don't know what to write."
This is the #1 reason creators quit.
But you don't always have to write original essays. Curation is valuable.
Your audience is busy. They will love you if you filter the noise and send them "The 3 Best Articles on [Topic] This Week."
The Problem: Finding, reading, and summarizing those articles takes hours. The Solution: An AI Research Assistant that does it for you.The Workflow
Step 1: The Sources (RSS)
Find the RSS feeds of 5-10 high-quality blogs.
* Make.com Trigger: RSS > Watch RSS Feed.
Step 2: The Filter
You don't want to share everything.
* Filter: Title contains "Tutorial" OR "Guide" OR "News".
* Filter: Description does NOT contain "Sponsored".
Step 3: The AI Curator
* Module: OpenAI > Create a Completion.
* Prompt:
> "I am writing a newsletter for [Target Audience].
> Here is an article:
> Title: {{Title}}
> Link: {{URL}}
> Content: {{Description}}
>
> Task: Write a short, punchy summary (max 50 words). Focus on the 'Key Takeaway'.
> Tone: Casual, insightful."
This small adjustment can have a significant impact on your overall workflow efficiency. It turns a manual, error-prone process into a reliable, set-it-and-forget-it system.
Step 4: The Compiler (Data Store)
This is the tricky part.RSS feeds update randomly. You want to send one email on Friday.
Add Record (to a Data Store).Then, create a Second Scenario that runs every Friday at 9 AM.
Create a Broadcast.* Subject: "Weekly Roundup: [Insert Dynamic Title]"
* Body: "Hey! Here are the top links for this week:
{{Aggregated_Text}}"
Step 5: The Human Touch
Friday morning, you wake up.
You log into ConvertKit.
There is a draft waiting: "Weekly Roundup".
It has 5 great links with summaries.
You add a personal intro: "Hey guys, crazy week. I'm currently in Tokyo..."
You hit Send.
Total time spent: 5 minutes.
Conclusion
Consistency builds trust.
This system ensures you always have a newsletter ready to go, even if you had zero time to write that week.
Next Step: Set up the RSS watcher today. Even if you just have it email you the summaries, it's a great way to stay informed.* Start automating with Make.com
Want to grow that newsletter? Learn how to Auto-DM New Instagram Followers to get them on your list.
Frequently Asked Questions
Can I review it before it sends?
Yes! We strongly recommend setting the final step to 'Create Draft' in ConvertKit (or your email tool). Never let AI send a newsletter completely unsupervised. You want to add your personal intro and check for hallucinations.
What if an RSS feed has no new posts?
The automation just won't trigger for that feed. If you are aggregating multiple feeds into one email, you can use a 'Data Store' in Make.com to collect links throughout the week and then compile them on Friday.
Can I use this for social media too?
Absolutely. You can fork the automation: Path A -> Newsletter Draft. Path B -> Tweet Draft. It's the same source content.
Does this work with Substack?
Substack doesn't have a public API for *creating* drafts easily via Make.com yet. You might need to have the AI email the draft to you, and then you copy-paste it into Substack.
Related Automations
The AI Assistant That Tracks Your Entire Business: Sales, Tasks, Emails, Clients
The ultimate solopreneur dashboard. Aggregate data from every tool you use into a single daily report generated by AI.
Read Guide →A Dead-Simple AI Daily Planner That Texts You Your Tasks Each Morning
Start your day with clarity. Get a text message every morning with your top 3 priorities, weather, and schedule.
Read Guide →Want more tips like this?
Explore our blog for more guides on AI automation for solopreneurs.
Browse All Articles