How To Automate Personalized Email Outreach Using Google Sheets, Dumpling AI, and Make.com

Automation can significantly improve efficiency in digital marketing and client outreach. In this tutorial, we will guide you through setting up an automation in Make.com that extracts business details from Google Sheets, enriches the data with Dumpling AI, generates personalized cold emails using OpenAI, and sends them via Gmail.

By the end of this guide, you will have an automated system that seamlessly creates and sends personalized emails to potential clients, saving you time and effort while improving engagement rates.

Benefits of This Automation

• Saves Time: No more manually crafting emails for each client.
• Enhances Accuracy: AI extracts accurate details, reducing human errors.
• Personalization at Scale: Each email is uniquely tailored to the recipient.
• Seamless Integration: Combines Google Sheets, Dumpling AI, OpenAI, and Gmail without coding.
• Increased Response Rates: Well-targeted, personalized emails have a higher chance of conversion.

Step 1: Setting Up Google Sheets for Data Input

Configure the Google Sheets Module in Make.com

This module acts as the trigger for your automation, ensuring that every new row added to the sheet starts the process.

1. Add the Google Sheets – Watch Rows module.
2. Connect your Google account.
3. Select your spreadsheet and the worksheet (e.g., Sheet1).
4. Set the trigger to watch new rows.
5. Ensure headers are included to map fields correctly.

Step 2: Extracting Business Information with Dumpling AI

Dumpling AI helps extract structured data from websites based on the URLs provided in Google Sheets. This enriches the available data, ensuring more detailed and personalized outreach.

1. Add the Dumpling AI – Extract Data from URL with AI module.
2. Connect your Dumpling AI account.
3. Map the URL field from Google Sheets so that Dumpling AI knows which websites to analyze.
4. Define extraction fields:
   • Phone Number
   • Business Name
   • Email Address
   • Address
   • Industry
   • About Website
   • Contact Name

This step ensures your automation gathers additional valuable information about each business, making outreach more effective.

Step 3: Structuring the Extracted Data

The extracted data from Dumpling AI is stored in an Array  format. The iterator module loops through this array , which is easier for subsequent modules to process.

1. Add the iterator module.
2. Pass the extracted information from Dumpling AI.

This step ensures that the AI-generated data is formatted correctly before being processed further.

Step 4: Generating Personalized Cold Emails with OpenAI

The OpenAI module is responsible for crafting personalized emails based on the extracted data. This makes outreach feel natural and engaging rather than robotic.

1. Add the OpenAI – Create Chat Completion module.
2. Select ChatGPT-4o as the model.
3. Set max tokens to 2048 to allow detailed responses.
4. Configure the prompt:
   • Introduce the marketing agency.
   • Highlight how your services (SEO, lead generation, social media management) can help the business.
   • Personalize using extracted data (Business Name, Industry, Contact Name).
   • End with a strong call to action (e.g., schedule a call, visit the website).

This step ensures that each email is tailored to the recipient, increasing the likelihood of engagement.

Step 5: Sending the Generated Email via Gmail

Once the email has been created, the Gmail module is used to send it directly to the potential client.

1. Add the Google Email – Send Email module.
2. Connect your Gmail account.
3. Map the extracted email address from Dumpling AI as the recipient.
4. Use the OpenAI-generated subject line and body.
5. Set content format to HTML for better formatting.

This step automates the final outreach, ensuring emails are sent without manual intervention.

Pro Tips for Optimization

• Set Error Handling: Add filters and error handlers to avoid sending incomplete emails.
• Schedule Regular Runs: Automate batch processing for multiple rows at once.
• Test Before Deploying: Send test emails to verify formatting and personalization.
• Track Email Performance: Use an email tracking tool to measure open and response rates.

Conclusion

By following this tutorial, you’ve built a fully automated system that streamlines cold email outreach. This workflow not only saves time but also ensures that each email is relevant and personalized, increasing the likelihood of engagement.

Take advantage of automation to boost productivity and focus on what truly matters—growing your business!

Get the Blueprint Featured in This Guide

Access the blueprint here! Whether you’re new to AI automation or aiming to sharpen your skills, our community is ready with the resources and support to help you thrive.