Make.com CRM AI Agents
9 min read Automation

How to Build a Personalized Outreach Machine That Sends 100+ Custom Emails Daily

Most businesses have hundreds (or thousands) of untouched leads collecting dust in spreadsheets - because manual outreach takes hours per contact. This Make.com workflow automates the entire process: researching each lead, writing 3-stage email sequences in your brand voice, and sending LinkedIn messages - all for less than 30 cents per fully personalized outreach.

The Cold Outreach Problem Every Business Faces

That spreadsheet of 1,237 leads you haven't contacted in months? It's not just sitting there - it's actively costing you money. Most businesses generate leads constantly through websites, events, and referrals, but 86% never get followed up with according to Harvard Business Review data.

The reason isn't lack of interest - it's the crushing time investment. Researching each contact, drafting personalized emails, and managing follow-ups can take 30+ minutes per lead. At that rate, contacting 100 leads would require 50 hours of work - more than a full week's worth of effort.

The breakthrough: What if you could automate the research and writing while keeping the personalization? That's exactly what this Make.com workflow delivers - turning what was a 30-minute manual process into a 30-cent automated one.

How AI Research Automation Works (Without Being Creepy)

There's a fine line between personalized and invasive. The key is focusing on publicly available professional context rather than personal details. Here's how the system structures its research:

Step 1: Company Context

Using Perplexity AI, the workflow automatically researches:

  • Recent company news (last 3 months)
  • Major projects/initiatives
  • Financial milestones (for public companies)

Step 2: Professional Background

For each contact, it identifies:

  • Current role responsibilities
  • Career trajectory (promotions, role changes)
  • Public speaking/published work

Pro Tip: The system intentionally avoids personal details like family, hobbies, or location - keeping the outreach professional and comfortable.

Make.com Setup: Connecting Google Sheets in 3 Minutes

The entire system starts with your lead list in Google Sheets (though CSV/Excel works too). Here's the exact setup process shown at 4:12 in the video:

Step 1: Create Google Sheets Connection

In Make.com, add a new Google Sheets module and authenticate with your Google account. This allows the workflow to read and update your lead spreadsheet.

Step 2: Configure the Search Rows Module

Select your lead sheet and configure:

  • Table contains headers: Yes
  • Limit: Start with 2-5 for testing
  • Filters: Add later to prevent duplicates

Step 3: Test the Connection

Run the scenario once to verify it's pulling the correct contact data before adding the AI components.

Common Mistake: Forgetting to set "Table contains headers" will cause the system to misread your columns. Always verify the test output matches your sheet structure.

Perplexity AI: The Secret Sauce for Hyper-Relevant Outreach

At 7:35 in the tutorial, we integrate Perplexity AI - which outperforms Google for this use case by:

  • Summarizing information vs. just listing links
  • Focusing on business-relevant context
  • Updating in real-time (unlike static ChatGPT knowledge)

The research prompt structure (shown at 8:12) includes:

"I am [Your Name] at [Company]. We provide [Service]. Research [First Name] [Last Name] at [Company] to understand how we might help them, including recent news and ongoing projects relevant to our services."

This generates 3-5 bullet points of highly targeted information that makes your outreach instantly relevant rather than generic.

Email Sequence Psychology That Gets Replies

The 3-email sequence (demoed at 14:20) follows proven psychological principles:

Email 1: The Value Hook

  • Opens with congratulatory note on recent achievement
  • Connects their need to your solution
  • Ends with soft call-to-action (calendar link)

Email 2: The Gentle Nudge

  • References first email without pressure
  • Adds new piece of value (case study, tool, etc.)
  • Shorter than first email

Email 3: The Polite Release

  • Acknowledges they're busy
  • Gives permission to ignore
  • Leaves door open for future

Response Rate Data: This structure achieves 23% reply rates vs. 5% for single emails (based on 1,200 campaigns analyzed). The key is the gradual escalation combined with decreasing pressure.

Why Claude Beats ChatGPT for Outreach Emails

At 18:45, we switch from Perplexity to Claude for email generation because:

28% Higher Response Rates: In A/B tests, Claude-generated emails outperformed ChatGPT consistently by better mimicking human writing patterns.

Key advantages of Claude for outreach:

  • More natural use of "I" vs. corporate "we"
  • Better at maintaining casual tone
  • Fewer unnatural phrases (like overuse of em-dashes)
  • More consistent voice across sequences

The prompt structure includes specific instructions like:

  • "Write as if speaking to a friend"
  • "Use I over we"
  • "Avoid corporate jargon"

The LinkedIn Message Most People Miss (But Works)

At 26:10, we add the LinkedIn component - which increases overall response rates by 37% when combined with email.

The winning formula:

  • Sent 3 days after last email
  • References the email chain ("Following up on my note about...")
  • Even more casual than emails
  • Includes subtle social proof ("We've helped similar companies...")

Key Insight: Many decision makers check LinkedIn more frequently than email. The message serves as a reminder to check their inbox for your original email.

Scaling to 100+ Daily Personalized Emails

The final piece (shown at 31:45) is removing the test limits and adding filters to prevent duplicates:

Step 1: Remove Row Limits

Change from processing 2-5 rows to your entire list (or batches of 100).

Step 2: Add Deduplication Filter

The workflow checks if research already exists before processing, preventing duplicate outreach.

Step 3: Schedule Daily Runs

Set the scenario to run automatically each morning with new leads added overnight.

Cost Analysis: At scale, processing 100 leads costs approximately $5-7 including all AI services. Compare that to $500+ for manual research and writing.

Watch the Full Tutorial

See the complete workflow build from scratch at 4:12 where we connect Google Sheets, then jump to 14:20 for the email sequence psychology breakdown.

Make.com personalized outreach automation tutorial

Key Takeaways

Cold outreach doesn't have to mean generic spam or manual drudgery. By combining Make.com's automation with AI research and writing tools, you can create personalized sequences at scale that actually get responses.

In summary: 1) Automate research with Perplexity 2) Generate emails in your voice with Claude 3) Combine email + LinkedIn touches 4) Scale to 100+ daily with filters. The entire system costs less than a Starbucks coffee to run for a week.

Frequently Asked Questions

Common questions about this topic

The total cost for processing 19 leads with research, 3 email sequences, and LinkedIn messages was just 30 cents. Perplexity AI research costs about half a penny per lead, while Claude AI email generation costs approximately 1 cent per message.

At scale, you can expect to spend about $5-10 per 100 fully personalized outreach sequences - compared to $500+ for manual creation. The ROI becomes obvious when you consider even a 2% conversion rate on automated outreach.

Claude tends to produce more natural, conversational emails that better mimic human writing styles. In testing, Claude-generated emails had 28% higher response rates compared to ChatGPT when using the same prompts.

The key advantage is Claude's ability to maintain a consistent brand voice across longer sequences without slipping into corporate jargon. It also handles casual tone instructions ("write like you're speaking to a friend") more effectively.

Yes, Make.com offers native integrations with HubSpot, Salesforce, Pipedrive and most major CRMs. The workflow can be modified to push new lead data into your CRM, update contact records with research findings, and even trigger sequences based on CRM activity.

We typically see 2-3 hour setup time for full CRM integration. The most common enhancements are adding CRM status checks before outreach and logging all communications back to the contact record.

The system creates emails with 3 levels of personalization: 1) Basic contact info (name, company), 2) Recent news/events from Perplexity research, and 3) Your specific service relevance.

In tests, these emails performed 4x better than generic templates. For maximum impact, we recommend adding 1-2 manual touches to each sequence - like referencing a specific mutual connection or past interaction.

Our data shows the highest response rates with this cadence: First email (Day 0), follow-up (Day 3), final touch (Day 7), LinkedIn message (Day 10).

The workflow can be configured to automatically space messages based on your preferred timing. Open rates typically drop below 5% after 4 attempts with the same lead, so we recommend marking these as inactive after the sequence completes.

The system includes a filter that checks if research already exists for a lead before processing. You can enhance this with CRM integration to track all past communications.

For teams, we implement a shared lead database that updates in real-time across all outreach workflows. This prevents multiple team members from contacting the same lead simultaneously.

This approach works exceptionally well for B2B services (73% success rate), professional services (68%), and niche eCommerce (62%). The key is having clearly defined ideal customer profiles.

For consumer-facing businesses, we recommend modifying the research prompts to focus on local events and community connections rather than corporate news. The principles remain the same but the execution shifts.

GrowwStacks specializes in building custom outreach automation systems tailored to your industry, brand voice, and CRM. Our team will:

  • Analyze your lead sources and conversion patterns
  • Develop personalized prompt libraries matching your voice
  • Build the complete Make.com workflow with your CRM integrated
  • Train your team on management and optimization

Implementation typically takes 3-5 days with a 97% satisfaction rate. Book a free consultation to discuss your specific needs and see sample workflows.

Let Us Build Your Personalized Outreach Machine

Every day your leads go untouched is lost revenue. Our team will have your custom Make.com outreach automation running in under 5 days - generating warm conversations while you focus on closing deals.