💎Join my Community for Exclusive Resources & Support: https://www.skool.com/ai-marketing-automation-lab
Templates for this automation are available in my Skool
In this comprehensive tutorial, I’ll guide you through building a seamless AI automation system that generates 12 newsletter issues with descriptions, allows you to select and customize your preferred draft, and then automatically creates a formatted Mailchimp campaign ready to send, all using the powerful combination of Airtable for data management and Make for workflow automation with Perplexity AI and ChatGPT.
⚡ What You’ll Learn:
How to generate 12 newsletter issues with descriptions using AI
Selecting and customizing your preferred newsletter draft
Automating the creation of Mailchimp campaigns with formatted newsletters
Advanced automation techniques for streamlining your newsletter production
💎 Perfect Solution For:
Marketers looking to automate their email campaigns
Business owners need efficient newsletter creation
Content creators seeking to enhance their email marketing
Digital agencies managing multiple client newsletters
🔧 Tech Stack:
Airtable
Make
Cloudinary
Mailchimp
ChatGPT
Perplexity
Chapters:
00:00 - Introduction & Demo Preview
Overview of the AI newsletter automation
Brief mention of tools: Make, MailChimp, and Airtable
Promise of a full tutorial
03:04 - Building the Airtable Base Structure
Creating a newsletter base with two tables
Setting up the Newsletter Info table (name, description, header image)
Creating the Newsletters table (for issue content and status)
Configuring field types and formatting options
07:17 - Setting Up the Newsletter Issue Creator Automation
Creating the first Make automation
Connecting to Airtable for newsletter information
Using ChatGPT to generate 12 newsletter topics
Setting up JSON parsing for organized output
Returning data to the Newsletters table
12:12 - Building the Newsletter Writer Automation (Part 1)
Creating the second Make automation
Setting up Airtable watch module with filters
Configuring the router for draft creation
Creating the Perplexity AI prompt for newsletter content
Updating Airtable with AI-generated content
18:16 - Integrating MailChimp (Part 2 of Automation)
Setting up the second branch of the automation
Creating a template in MailChimp
Configuring the MailChimp campaign module
Using Cloudinary to fix image hosting issues
Updating template content with newsletter data
26:56 - Final Demo & Use Case Ideas
Running the complete automation
Reviewing the final MailChimp newsletter
Discussing personal use cases (like daily recipe newsletters)
Closing thoughts and channel information
🔔 Subscribe and hit the bell to never miss my latest AI automation tutorials!
🔗My Links:
Join my Skool and get access to my complete AI Marketing Automation Template Library! 🧪The AI Marketing Automation Lab https://www.skool.com/ai-marketing-automation-lab
Connect with me on LinkedIn: https://www.linkedin.com/in/kellykranz/
🙋🏻♀️Who Is She?
What's up?! I'm Kelly Kranz, a digital marketing veteran with 15 years of experience. Welcome to AI Marketing Automation, where I turn complex AI concepts into practical, revenue-generating strategies for people like you!
#Mailchimp #AIAutomation #MarketingTutorial #EmailMarketing #Automation