In this tutorial, Helena Liu, an AI optimization expert, demonstrates a completely free, step‑by‑step workflow for generating thousands of high‑quality leads in any niche and automating outreach. She starts by crafting Google site‑specific search queries that combine a target domain (e.g., Instagram or LinkedIn), a niche keyword (e.g., "life coach"), and a list of common email‑hosting domains, allowing Google to return only profiles that publicly list an email address. The search results are copied into ChatGPT, where a concise prompt formats the raw text into a structured table containing full name, company, URL, email, and phone number. This table is then pasted into a new Google Sheet that serves as the lead database. Using make.com, Helena builds a scenario where the Google Sheet is the trigger: each time a new row appears, the scenario pauses for a configurable interval (e.g., one hour) and then sends a personalized outreach email via Gmail, pulling the email address and other fields from the sheet. She provides a short, three‑sentence email template that dynamically inserts the prospect’s company name and highlights her AI automation agency’s value proposition. Throughout, she emphasizes keeping emails brief to improve response rates and warns against sending too many emails at once to avoid spam flags. The video concludes with a call to like, subscribe, and enroll in her free AI automation course.
Chapters
Artificial intelligence is revolutionizing the way that we generate leads. And in today's video, I'm going to show you a free, simple, and easy method that you can start implementing right away to generate thousands of good, high-quality leads for your industry or niche. We're first going to look for those leads. And then I'm going to show you how to set up an automation system so that you can reach out to all of those leads on autopilot, even while you are sleeping. If you're new to this channel, hi, my name is Helena. I am an AI optimization expert. And on on this channel, you will learn all of the latest about AI and automation. So I really appreciate it if you can like and subscribe if you got any value out of today's training. I've also got a free AI course that you can sign up for below as well. Okay, so now let's dive in. So the first thing that we're going to do is actually look for our leads through Google. And we're going to use the following search query. There are 3 components to this search query. We're first going to tell Google the site that we want it to look through. And then secondly, we want to set the niche that we are targeting. This could be plumbers, electricians, doctors, lawyers, life coaches, etc. And then thirdly, we're going to tell Google only return the profiles with email addresses listed on it. And I have listed some popular email address domains here. If there is another one that you want to target, you just have to add in OR and plus the quote plus the@ symbol and then the name of the domain that you also want Google to look for as well. So let's say that we want to look for life coaches, and that's our target market. What we will do is do site:instagram, and then we would put in quotes, life coaches, followed by all of those most popular email domain senders. This search query will tell Google to look through instagram.com, find profiles that have life coaches listed, and Also, those profiles also has to have one of these email domains listed as well. This will allow us to look through Instagram for life coaches and only look for life coaches who have put their email address on their profile. Another example that I have here is for Google to look through linkedin.com and only to return those profiles that have surgeons listed and only surgeons who have email addresses listed on their profiles. Now let's try this out and see what we get. Let's do the the life coach one first. Let's put it into Google and see what we get here. Less than a second here, I get hundreds if not thousands of profiles that are of life coaches, and they all have email addresses specified on their profiles as well. Great, so this search query is working awesome. The next thing is to copy over all of this information onto ChatGPT. To do so, if you are on a Mac, just press Command+A or Control+A if you are on a PC. I'm going to copy all of this over to ChatGPT and paste everything in. And then I'm going to scroll to the top and use the following prompt, which I also have on this Google Doc right here. And the prompt is format the data below into a table with these columns: full name, company name, website URL, email, and phone number. And all I need to do is to press Enter, and ChatGPT will do all of the hard work for me. As you can see, it has created a table here with the full name of the account owner, the company name, Instagram URL, the email of that person, and if there is a phone number listed on their profile, it's going to scrape over the phone number as well. I can do the exact same thing for LinkedIn. So this method is great for generating leads through Instagram and LinkedIn without having to pay hundreds of dollars to Apollo or GetProspect or any other lead generation software. Next, what I'm going to do is actually copy this table right over here and then create my automation system to reach out to all of these leads on autopilot. So what I'm going to do is to copy this table, and I'm going to paste it in a brand new Google Sheet, and I'm going to call this, uh, Lead Outreach Test. What I'm going to do now is to use an automation tool, and my favorite one is make.com. Once I log into my make.com account, I can create a new scenario which will take me to a blank canvas, and the trigger is going to be Google Sheet. So whenever there are new rows added to my Google Sheet, this automation is going to be triggered. At the bottom here, I can also specify how often I want this automation to run. If you scrape, let's say, thousands of different leads, you don't want them to all get emailed at the same time, because that is actually going to flag your email address as spam to most of these email providers. You actually want to space them out. Let's suppose that we want to send one email out every single hour, which will not normally trigger any of the email providers and flag you as spam. So I'm going to change to 1 hour here down at the bottom. My trigger is going to be a new row in the Google Sheet. And let's just fill this out here. If this is your first time connecting your Google Sheet to your make.com account, what you'll need to do is press Add here at the top, then press Sign In with Google, fill in your Google username and password to connect your account. After you have done so, you will select My Drive and then put in the name of that spreadsheet that you have just created. And we called ours Lead Outreach Test, which is what I'm going to select here. There is only one sheet in this spreadsheet. So by default, I'm just going to select Sheet 1. The table contains headers, yes. How many results do we want to return at any given time? We want to do one at a time. So I change the limit here to 1. And that's it. I'm going to press OK. This is going to basically say whenever there is a new row in this spreadsheet, and this is— this system is going to check once every hour, it's going to take a new row from the spreadsheet and then do the following action, which is to send an email. And then we can send an email just from our Gmail account. And we can select send an email as our action. Again, if this is your first time logging into Gmail from your make.com account, then you need to press Add and then press Sign In with Google, put in your username and password again. I have already done so here. And after I have completed my connections, I just have to specify who this email address is going to. And I'm just going to click on the field right here. And we want to enter in the email address that we just scraped from Google, which is in column D in this case from the Google Sheet. So as you can see, all of the headers that we have in our Google Sheet has copied over and we want to take the value of column D in this case. Basically what this is saying is whenever there's a new row that's added to Google Sheet, and the first row is going to be these values. And what it's going to do in the second step is take the value of that row in column D, which is the email address, and use that as an email address to send out. Essentially, this email address is a variable that will change every single time this whole automation is run. The first run is going to be this email address, and the second run is going to be the second email address that we see here. The third one is going to be 3rd one here, etc., etc. Okay, so this is telling the system that we're going to send it from our Gmail account to this email address. And then here we can put in the subject line as well as the content. Here's an example of an outreach that you could say. I put in question about company name, and this is going to dynamically fill in the company name right over here. And here's the content I put in. I just want to know if you guys are still taking in new clients. I run an AI automation agency that can help improve your conversions by 60% in 90 days. Can I send this report over to you? Helena. Usually I find whenever you keep these outreach emails to less than 3 sentences, you're going to get a much better response rate. Remember that people are busy and they don't have time to read pages of information. So make sure your emails are short, sweet, and to the point. And when they reply, that's when you can give them more information. Once this is done, I just press OK, then make sure I save the whole automation and turn it on. And then I will have a whole email AI automation system that's going to run 24/7, even while I am sleeping. It's— it was really as simple as that. And if you got any value out of today's training video, I really hope you like and subscribe. Also remember that I have a free AI automation course that you can sign up for below as well. Thank you so much for joining me. I'll see you next time.
