For every digital marketer’s building, an audience for an email marketing campaign becomes of utmost importance. If you have done some research you could find several methods online like creating blogs, sign-up pages, and subscribe pages with the double opt-in option, incentivizing your service, social media inquiry forms, etc. Find anyone’s email address in google Sheets will be a kick tool for lead generation experts.

A successful campaign needs better research and patience.

Personally, from my experience, I didn’t get any better experience from email list vendors or data vendors. Instead, when you create from scratch makes sense. Building the list according to the niche makes the campaign more successful thus making an email marketing campaign potentially an excellent solution for massive outreach campaigns.

In this blog, I will share some simple techniques to create an email address list using a simple and effective technique by Finding Anyone’s Email Address using google sheets and email address validation API.

Building a targeted audience is an art

For marketers who generate new prospects, lead generation, or looking to get in touch with a CEO, finding email addresses is difficult and time-consuming. This tutorial helps you to find any email address for free through the trial-and-error method.

As a digital marketer each marketing niche there will be an online community. That is for sure you can figure it out in Facebook groups, LinkedIn groups, Reddit, etc. Scraping information like the name and URL of the company working will help a lot to guess anyone’s email address.

You can search for similar tools like Email lookup, Email Finder, Email Guessing tools, LinkedIn email finder, prospect finder, Sales Navigator for Gmail, Email Permutator, etc.

List of the tools involved to guess someone’s email address.

• Gamalogic Email validation API

• Google sheets

Let’s jump into the tutorial to find anyone’s email address in google sheets. and for better knowledge, we use some examples of Jessica Albert who works at Gamalogic.com.

Step 1

Open a new Google sheet. In the first-row Cell A1 adds First Name, Cell B1 adds Second Name, and Cell C1 Company URL last Cell D1 Email address.

In the first column i.e., column A list the first name of the person that you need to find the email address here we add Jessica. In the next column i.e. column B list the second name eg: Albert and in column C list the domain or URLs like yahoo.com, gmail.com, etc or the domain of the company that the person works like twitter.com or Microsoft.com. In this tutorial we keep gamalogic.com. These are the inputs that you need to give to a list of possible email addresses. You can go through the below image for reference

Listing the email address pattern here will be done by the script automatically which eliminates the work of manually inputting the common permutations for someone’s email. No external tools are needed here to figure out the email address pattern. These patterns are used mostly by the email administrator of the company. This helps us to guess the email address. This is a trial and error method. If we are lucky, we can find our prospect here. Let’s hope for the best.

We make our best guess using the following patterns. 

EMAIL ADDRESS PATTERN	SAMPLE ADDRESS
[First Name]@websiteaddress.com	jessica@gamalogic.com
[Last Name]@websiteaddress.com	albert@gamalogic.com
First Name].[Last Name]@websiteaddress.com	jessica.albert@gamalogic.com
[First Name][Last Name]@websiteaddress.com	jessicaalbert@gamalogic.com
[First Name]_[Last Name]@websiteaddress.com	jessica_albert@gamalogic.com
[First Name]-[Last Name]@websiteaddress.com	jessica-albert@gamalogic.com
[Last Name]_[First Name]@websiteaddress.com	albert_jessica@gamalogic.com
[Last Name]-[First Name]@websiteaddress.com	albert-jessica@gamalogic.com
[Last Name].[First Name]@websiteaddress.com	albert.jessica@gamalogic.com
[Last Name][First Name]@websiteaddress.com	albertjessica@gamalogic.com
[First Name]_[First letter of Last Name]@websiteaddress.com@websiteaddress.com	jessica_a@gamalogic.com
[First letter on first name]_[Last Name]@websiteaddress.com	j_albert@gamalogic.com
[First Name].[First letter of Last Name]@websiteaddress.com	jessica.a@gamalogic.com
[First letter on first name].[Last Name]@websiteaddress.com	j.albert@gamalogic.com
[First Name]-[First letter of Last Name]@websiteaddress.com	jessica-a@gamalogic.com
[First letter on first name]-[Last Name]@websiteaddress.com	j-albert@gamalogic.com
[First Name][First letter of Last Name]@websiteaddress.com	jessicaa@gamalogic.com
[First letter on first name][Last Name]@websiteaddress.com	jalbert@gamalogic.com
[First letter on first name].[ First letter of Last Name]@websiteaddress.com	j.a@gamalogic.com
[First letter on first name][ First letter of Last Name]@websiteaddress.com	ja@gamalogic.com

Step 2

Navigate to Tools from the menu bar and click Script Editor from the list. Then a new window opens up with a new file named code.gs where you need to write the script.

Step 3

As mentioned before now copy the below script and paste into code.gs which opened earlier and then save it.

function start() {
var apikey = ‘API_KEY’
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getActiveSheet();
var row_list = ss.getDataRange().getValues()
if (row_list.length <51){
email_list = email_address_bulider(row_list)
}
else{
Browser.msgBox(“Maximum 50 list only allowed”)
return}
payload = create_payload(email_list)
result_list = verify_list(payload,apikey)
if (result_list.getResponseCode() == 200) {
var params = JSON.parse(result_list.getContentText());
var result = params.gamalogic_emailid_vrfy; 
var list_result = grid_result(result)
var list_ = list_result[0];
colors_list = list_result[1];
sheet.getRange(2,4,list_.length,20).setValues(list_).setBackgroundColors(colors_list);
sheet.insertRowBefore(1) 
sheet.getRange(1,1).setValue([‘Credits Balance’]).setFontWeight(“bold”);
getBalance(apikey);
}
else{
Browser.msgBox(“Error in you response”)
return
}}
function email_address_bulider(row_list) {
var email_list = [];
for(i=1;i< row_list.length;i++)
{
FN=row_list[i][0].split(” “).join(“”).toLowerCase();
LN=row_list[i][1].split(” “).join(“”).toLowerCase();
URL=row_list[i][2].split(” “).join(“”).toLowerCase().
replace(‘http://’,”).replace(‘https://’,”).
replace(‘www.’,”).split(/[/?#]/)[0];;
email_list.push(FN.concat(LN.concat(“@”.concat(URL))))
email_list.push(LN.concat(FN.concat(“@”.concat(URL))))
email_list.push(FN.concat(“@”.concat(URL)))
email_list.push(LN.concat(“@”.concat(URL)))
email_list.push(FN.concat(“_”.concat(LN.concat(“@”.concat(URL)))))
email_list.push(FN.concat(“.”.concat(LN.concat(“@”.concat(URL)))))
email_list.push(FN.concat(“-“.concat(LN.concat(“@”.concat(URL)))))
email_list.push(LN.concat(“_”.concat(FN.concat(“@”.concat(URL)))))
email_list.push(LN.concat(“.”.concat(FN.concat(“@”.concat(URL)))))
email_list.push(LN.concat(“-“.concat(FN.concat(“@”.concat(URL)))))
email_list.push(FN.charAt(0).concat(LN.concat(“@”.concat(URL))))
email_list.push(FN.concat(LN.charAt(0).concat(“@”.concat(URL))))
email_list.push(FN.charAt(0).concat(“_”.concat(LN.concat(“@”.concat(URL)))))
email_list.push(FN.charAt(0).concat(“.”.concat(LN.concat(“@”.concat(URL)))))
email_list.push(FN.charAt(0).concat(“-“.concat(LN.concat(“@”.concat(URL)))))
email_list.push(FN.concat(“_”.concat(LN.charAt(0).concat(“@”.concat(URL)))))
email_list.push(FN.concat(“.”.concat(LN.charAt(0).concat(“@”.concat(URL)))))
email_list.push(FN.concat(“-“.concat(LN.charAt(0).concat(“@”.concat(URL)))))
email_list.push(FN.charAt(0).concat(LN.charAt(0).concat(“@”.concat(URL))))
email_list.push(FN.charAt(0).concat(“.”.concat(LN.charAt(0).concat(“@”.concat(URL)))))
}
return email_list
}
function create_payload(email_list) {
var payload = {“gamalogic_emailid_vrfy”: []}
for (var i =0; i < email_list.length ; i++)
{ 
payload[“gamalogic_emailid_vrfy”].push({“emailid” : email_list[i] });
}
payload =JSON.stringify(payload) 
return payload 
}
function verify_list(payload,apikey) {
var url = “https://gamalogic.com/bulkemailvrf/?apikey=”+apikey 
var options = 
{ 
“method” : “GET”, 
“payload” : payload, 
‘contentType’: ‘application/json’ 
}; 
var result = UrlFetchApp.fetch(url, options); 
return result 
}
function grid_result(result) {
no_of_list = result.length/20
array_result = new Array(no_of_list);
var color = [];
for (var k=0; k< no_of_list; k++){
array_result[k] = new Array(20).fill(null);
color[k] = new Array(20).fill(null);
for (var i =0,j=0; i< 20; i++)
{ 
if (result[i+(k*20)][“is_valid”] && !(result[i+(k*20)]
[“is_duplicate”]) && !(result[i+(k*20)]
[“is_disposable”]) && !(result[i+(k*20)][“is_unknown”]) )
{
array_result[k][j]= result[i+(k*20)][“emailid”]
if (result[i+(k*20)][“is_catchall”])
{color[k][j] = “yellow”;}
else{color[k][j] = “green”;}
j++
} } }
return [array_result, color];
}
function getBalance(apikey) {
var response = UrlFetchApp.fetch(“https://gamalogic.com/creditbalance/?apikey=”+apikey);
var json = response.getContentText();
var data = JSON.parse(json);
var sheet = SpreadsheetApp.getActiveSheet();
sheet.getRange(1,2).setValue(data[‘Credit_Balance’])
}

Step 4

You will need to change the API key from line 2. Copy the Gamalogic API key from the dashboard (You will need to register with gamalogic.com to get an API Key) and replace it with APIKEY in the script. Before running the script make sure the function about to run is “start()”. Then run the script. You will need to allow your google account to give access to the google script for further.

For best results use an email validator to remove the invalid address from the list

Why do we use email validation to guess someone’s email contact?

In the script, the list of the permuted email list is sent for email validation or email verification this is to remove the invalid email address thus preventing from email sending the spam box or getting bounced. Know more about why we should validate email address list

You will see the script will start and wait for results to be listed. And the results are shown in the sheets within a few minutes. Cells in green are Valid addresses, and Yellow catch-all, or accept all emails. In the header, the balance credits will be displayed. 50 individuals’ email addresses will be guessed at the time.

You can have 500 email address guesses for free if you register with us now. Grab this offer now to find anyone’s email address in google sheets.

Below we have our video tutorial and comment on your suggestions. Happy Successful Email Hunting