How to Automate Personalized Email Campaigns with Make.com and AI
Most businesses know personalized emails get better responses - but who has time to research each lead and craft custom messages? This Make.com automation pulls lead data, researches personalized details with AI, generates tailored emails, and sends them automatically - saving you 8+ hours per 100 emails sent.
The Email Automation Problem
Every sales team and business owner knows the frustration: personalized emails get 3-5x better response rates than generic templates, but crafting truly custom messages for each lead takes hours of research and writing. At 5-10 minutes per email, a 100-lead campaign becomes an all-day project.
Most automation tools solve the wrong problem - they help you send more emails faster, but still sound robotic and impersonal. The breakthrough comes when you combine Make.com's automation power with AI's ability to research and write personalized content at scale.
Key stat: Businesses using this automated personalization approach report 42% higher open rates and 28% more replies compared to template-based email automation.
How the Workflow Works
The automation follows a simple but powerful sequence: research → personalize → send. For each lead in your spreadsheet, the system first gathers relevant information about their location and industry, then uses those details to craft a genuinely personalized email.
Here's the complete flow:
- Pull lead data from your Google Sheet (name, industry, location)
- Research interesting facts about their location/industry using Perplexity AI
- Generate a personalized email incorporating these details with GPT
- Format the email as HTML and send via Gmail
- Log all activity back to your spreadsheet
The magic happens in steps 2 and 3 - where AI does the heavy lifting of personalization that would normally take you hours per lead.
Step 1: Set Up Your Lead Data
Your automation starts with a simple Google Sheet containing lead information. At minimum, you'll want:
- First name (essential for personalization)
- Industry (for relevant messaging)
- Location (city/state/country for local references)
- Email address (for sending)
In Make.com, you'll create a "Search Rows" module connected to this spreadsheet. This pulls one lead at a time for processing (you can adjust batch size later). The module extracts key variables like first name, industry, and location to use in subsequent steps.
Pro tip: Start with a small test batch of 5-10 leads to refine your workflow before scaling up. This helps catch any formatting issues early.
Step 2: Research with Perplexity AI
This is where the personalization magic begins. The workflow sends the lead's location and industry to Perplexity AI with a prompt like:
"Research some interesting facts about [location] and appreciated facts about the [industry] industry."
Perplexity returns 3-5 relevant facts that make your email stand out. For example, for a software executive in Ireland, it might find:
- Ireland's nickname as the "Emerald Isle"
- Notable software companies based in Dublin
- Recent tech industry growth statistics
These authentic details transform your email from generic to genuinely personalized - without you spending hours on research.
Step 3: Generate Personalized Emails
With research complete, the workflow passes all details to GPT with instructions to craft a friendly, personalized email. A well-structured prompt ensures natural-sounding output:
"Create a cold email for [first name]. After greeting, include 1-2 interesting facts about [location] and appreciate their work in [industry]. Keep tone conversational like a friend, not too formal. Use only the best facts from this research: [Perplexity output]."
The AI generates emails like this example:
"Hi [Name], hope you're doing great! I've always been fascinated by Ireland - did you know it's called the Emerald Isle because of its lush green landscapes? As someone in software, you're part of an industry that's grown 40% in Dublin just last year. I'd love to connect and learn more about..."
This approach creates emails that feel hand-written, not automated.
Step 4: Automate Email Sending
The final steps format and send the email automatically:
- Convert to HTML: A second GPT module transforms the plain text email into properly formatted HTML (preserving line breaks and structure)
- Send via Gmail: The Make.com Gmail module sends the email with your chosen subject line (e.g., "Hi [First Name] - Quick Question")
- Log activity: The system records sent emails back to your spreadsheet for tracking
At 1:45 in the tutorial video, you can see the exact moment an automated test email arrives in the inbox - looking completely natural while taking zero manual effort.
Scaling and Monetization
This automation becomes incredibly valuable at scale. Consider these numbers:
- Cost: Just $0.02 per email (including AI research and generation)
- Time saved: 8-10 hours per 100 emails compared to manual writing
- Business potential: Charge clients $1,000+/month to manage their automated campaigns
The workflow uses about 8 Make.com operations per email (searching, AI calls, sending). At 1,000 emails/month, that's 8,000 operations - costing just $9 on Make.com's $9/10,000 operations plan. The AI costs are similarly minimal at scale.
Service opportunity: Agencies can offer this as a managed service - charging $1,000/month to handle a client's 1,000-email campaign while keeping costs under $50. The value isn't in the tech, but in the time saved and improved response rates.
Watch the Full Tutorial
See the complete workflow in action at 3:20 in the video, where the AI researches Ireland facts for a test lead and generates a perfectly personalized email automatically. The tutorial shows every step from spreadsheet setup to final email delivery.
Key Takeaways
This Make.com + AI workflow solves the personalization-at-scale challenge that most email tools miss. By automating both the research and writing process, it delivers genuinely custom emails without the manual effort.
In summary: 1) Start with clean lead data, 2) Use AI to research personal details, 3) Generate friendly emails incorporating those specifics, 4) Send automatically while tracking everything. The system pays for itself in time saved after just one campaign.
Frequently Asked Questions
Common questions about this topic
Any business sending more than 50 personalized emails per week benefits from automation. Sales teams, agencies, and ecommerce stores see the biggest time savings.
The system works particularly well for B2B outreach where personalization increases response rates. Industries like real estate, SaaS, and professional services get exceptional results.
- Best for businesses with repeat outreach needs
- Ideal when personalization improves conversion
- Perfect for teams lacking dedicated copywriters
For a campaign sending 100 emails, this automation saves approximately 8-10 hours of manual work. The system handles research, personalization, and sending automatically.
At scale, businesses report saving 30+ hours per month on outreach. The time savings compound as you run more campaigns through the same automated system.
- 5-10 minutes saved per email
- 8-10 hours per 100 emails
- 30+ hours monthly at scale
You need a Google Sheet with lead data (names, industries, locations) and a Gmail account. The automation can work with as little as first name and industry, though more data enables better personalization.
No technical skills are required to set up the workflow. The Make.com interface guides you through connecting your spreadsheet and email account.
- Minimum: First name + industry
- Ideal: Add location and email
- Bonus: Company name, job title
The AI produces highly accurate content when given clear instructions. The workflow first researches facts about the lead's location and industry before generating emails.
Most users find the output requires minimal editing, with 85-90% accuracy on first draft. You can review sample outputs and refine the prompts during setup to match your preferred tone.
- 85-90% accuracy initially
- Improves with prompt refinement
- Research step ensures factual accuracy
Yes, you can fully customize the email templates in the Make.com workflow. The system allows you to adjust tone, length, and content structure.
Many businesses create multiple templates for different campaign types or industries. You control all aspects of the email structure and can A/B test different approaches.
- Full control over email structure
- Multiple templates for different needs
- A/B testing capabilities
The automation costs approximately $0.02 per email sent when using Make.com's basic plan. This includes AI research and email generation.
At scale (1,000 emails/month), costs drop to about $0.015 per email due to bulk operation discounts. The system becomes more cost-effective as volume increases.
- $0.02 per email initially
- Drops to $0.015 at scale
- Far cheaper than manual creation
You can integrate email tracking tools like Mailtrack or Yesware with the workflow. These show open rates, clicks, and replies directly in your inbox.
The automation can also log responses back to your Google Sheet for easy performance analysis across campaigns. This creates a complete record of which emails generated replies.
- Integrate Mailtrack or Yesware
- Log replies to spreadsheet
- Track opens, clicks, responses
GrowwStacks builds custom email automation workflows tailored to your lead data and campaign goals. We handle the Make.com setup, AI prompt engineering, and Gmail integration.
Our team typically delivers a working system in 3-5 business days. We also provide training and ongoing optimization to improve response rates over time.
- Custom workflow setup in 3-5 days
- AI prompt engineering for your industry
- Ongoing optimization and support
Ready to Automate Your Email Outreach?
Every day you manually write emails is a day wasted on research and formatting. Let GrowwStacks build your custom email automation system - typically delivering a working solution in under 5 business days.