AutomationsNewsletterContent CurationAI Tools

The 100% Automated Newsletter Builder Using RSS → OpenAI → ConvertKit

3 min read

Curate content while you sleep. Automatically find top industry news, summarize it, and draft a newsletter for your review.

"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

  • Watch: Monitor RSS feeds of top blogs in your niche.
  • Filter: Only pick articles with specific keywords (e.g., "AI", "Strategy").
  • Summarize: AI reads the content and writes a 2-sentence "Why it matters" blurb.
  • Draft: It compiles these into a formatted email in your newsletter tool.
  • Step 1: The Sources (RSS)

    Find the RSS feeds of 5-10 high-quality blogs.

    * Make.com Trigger: RSS > Watch RSS Feed.

    Tip:* If you want to watch multiple feeds, you might need multiple scenarios or an RSS aggregator tool like Feedly (which also connects to Make).

    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.

  • Action: Make.com > Add Record (to a Data Store).
  • Store: Title, URL, AI_Summary.
  • Then, create a Second Scenario that runs every Friday at 9 AM.

  • Trigger: Scheduled.
  • Action: Get all records from Data Store.
  • Action: Text Aggregator (combine them into one HTML block).
  • Action: ConvertKit > Create a Broadcast.
  • * Subject: "Weekly Roundup: [Insert Dynamic Title]"

    * Body: "Hey! Here are the top links for this week:

    {{Aggregated_Text}}"

  • Action: Delete records from Data Store (so next week is fresh).
  • 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.

    Share this article

    Want more tips like this?

    Explore our blog for more guides on AI automation for solopreneurs.

    Browse All Articles