How to Create a 100% Automated Newsletter That Delivers Value on Autopilot

Written By avalonnmedia .

Are you struggling to consistently engage with your email subscribers? Let me show you how to create a fully automated newsletter that delivers value on autopilot.

The $1 Per Month Opportunity 💰

According to marketing expert Russell Brunson, each email subscriber is worth approximately $1 per month. This means that even a modest list of 1,000 subscribers represents $1,000 in monthly potential revenue just waiting to be unlocked!

The key to accessing this revenue lies in consistently delivering value to your audience through email marketing, keeping you top of mind when they're ready to make a purchase decision.

But let's face it - writing and formatting newsletters is time-consuming, and most solopreneurs simply can't maintain the consistency needed for long-term success.


What if Your Newsletter Wrote Itself? ✨

Imagine having a 100% automated newsletter that:

  • Pulls the latest news and insights in your niche


  • Adds AI-generated images and helpful tips


  • Includes your latest blog posts or YouTube videos


  • Sends itself to your growing list without you lifting a finger

This isn't science fiction - it's completely possible using the tools and step-by-step process I'm about to share with you.


The Main Tool: Brevo 📧

Brevo is the core platform we'll use to create and send our fully customizable automated newsletter. Think of it as the canvas that brings all our dynamic content together.

Here's how the process works:

  1. Create a template in Brevo with variables for content you want to dynamically swap out


  2. Use a no-code automation tool to fill in those sections with automatically generated content


Step 1: Create Your Free Brevo Account

Start by signing up for a free Brevo account. The free plan allows you to:

  • Send 300 emails per day


  • Access their API (necessary for our automation)


  • Use customizable templates and the drag-and-drop editor

No credit card is required to sign up. If you later decide to upgrade to send more emails, you can use their paid plans.


Step 2: Create Your First Contact List

Once you've signed up:

  1. Go to Contacts → Lists → Create a List


  2. Name your list (something like "Test List Automation")


  3. Add some test contacts (10-20 is fine for testing)

You can either manually add contacts or import them via CSV if you already have a list.


Step 3: Create Your Email Template

Next, we'll create the template that will hold all our dynamic content:

  1. Go to Campaigns → Template → Create Template


  2. Select "Email Template"


  3. Name your template (e.g., "Test Automation Example")


  4. Enter a temporary subject line (we'll override this through automation)


  5. Complete your "from" information


  6. Choose "Start from Scratch" for maximum customization


Building Your Dynamic Newsletter Template 🔄

The drag-and-drop editor makes it easy to create a professional-looking newsletter. Here's how to add dynamic sections:


Adding a News Section

  1. Drag in a section element from the "Sections" panel


  2. Add an image, heading, text, and button element


  3. For each element you want to make dynamic, use the variable format:

    Copy

    {{params.your_variable_name}}


For example:

  • Image: {{params.article_image_URL}}


  • Title: {{params.article_title}}


  • Summary: {{params.article_summary}}


  • Button URL: {{params.article_URL}}


Adding a Quote of the Day

  1. Add a divider element


  2. Add a text section


  3. Title it "Quote of the Day"


  4. Use the variable: {{params.quote}}


Adding Your YouTube Content

Create a section with:

  • YouTube video title: {{params.youtube_title}}


  • YouTube thumbnail: {{params.youtube_thumbnail}}


  • Watch URL: {{params.youtube_URL}}


Adding Static Sections

You can also include sections that don't change with each newsletter:

  • Contact information

  • Book a call buttons

  • Social media links

  • Company info

Remember to save and activate your template when finished! 💾


Automating Content Generation with Make.com 🤖

Now for the magic part - automating all the content that will populate our template:

  1. Create a free account on Make.com

  2. Create a new scenario

  3. Start with an RSS module to pull industry news

Setting Up RSS Feed Sources

  1. Sign up for RSS.app


  2. Create a new feed by entering relevant keywords for your niche


  3. Save and copy the XML feed URL


  4. Paste this into your Make RSS module


Using ChatGPT to Summarize Articles

  1. Set up a ChatGPT API connection in Make

    • Get your API key from platform.openai.com

    • Add $5-10 credit (it will last a long time)


  2. Create a prompt that tells ChatGPT to:

    • Summarize the article for a newsletter

    • Write a compelling title

    • Include the URL to read the full article


  3. Format the output as JSON with title, summary, and URL variables

Generating Images with DALL-E

  1. Add a DALL-E module to create an image based on the article summary


  2. Specify that you don't want text in the image


  3. The image URL will be passed to your newsletter template


Creating Dynamic Newsletter Titles

Use another ChatGPT module to:

  1. Write a compelling subject line based on all newsletter content


  2. This will override the temporary subject in your Brevo template

Connecting Everything to Brevo 🔗

The final step is connecting all these dynamic elements to your Brevo template:

  1. Add a Brevo module in Make


  2. Select your sender name


  3. Choose your template


  4. Set the subject line to use the AI-generated subject


  5. Schedule it to send immediately when the automation runs


  6. Select your recipient list


  7. Enable Advanced Settings


  8. Map each variable to its corresponding data source:

    • article_title → ChatGPT title output

    • article_summary → ChatGPT summary output

    • article_image_URL → DALL-E image URL

    • article_URL → Article URL from RSS

    • etc.


Scheduling Your Automated Newsletter ⏰

Once everything is set up and tested, you can schedule your newsletter to go out automatically:

  1. Configure your Make scenario to run on a schedule


  2. Select days of the week and specific times


  3. Weekly or even daily schedules work well depending on your content type


Advanced Options for Multiple Content Sources 🔍

If you want to include multiple content sources (like both RSS articles and YouTube videos):


  1. Create additional scenarios to gather different content types


  2. Store the content in a database


  3. Pull from the database to fill in your template variables

This is a more advanced approach but allows for greater flexibility in your newsletter content.


Final Thoughts 💭

Setting up an automated newsletter takes some initial work, but once it's running, you'll have a powerful system that:

  • Consistently delivers value to your subscribers

  • Keeps you top of mind with your audience

  • Helps you unlock the revenue potential of your email list

  • Saves you hours of time each week

The best part? Once you've set it up once, it continues working for you without any additional effort. That's the power of automation for solopreneurs!

avalonnmedia .
Previous

5 Powerful Make.com Shortcuts: From Beginner to Automation Pro Fast
Next

How to Create & Post Viral Videos on Autopilot with Vadoo: The Ultimate Automation Guide