How to Use Google Sheets to Find Email Addresses

Link prospecting can be an expensive affair. You need to pay for a bunch of tools for different reasons. Here’s a clever way to find emails without paying for any tools (step-by-step instructions for a Google Sheet included).

First, you need the editor’s first and last name and their domain name. So, for example, the name is Timothy Muisyo, and the domain is 

Note; you only need the domain name and extension.

Next, we need to generate a list of potential email addresses. Use an email permutator for this. I’ll use Metricsparrow here.

Click Permutate. 

You’ll get several potential email addresses, as shown below.

Now here’s how you validate the email addresses. Copy and paste those emails on a Google sheet.

Here’s where the magic happens. 

Go to Insert, then Smart Chips, and click Convert to people chip. 

This is what happens next.

Boom! That’s your valid email address. Go ahead and send that email pitch.

Share This Post

Get a Fortnightly SaaS Marketing Newsletter That Makes You Smarter

Our newsletter is like Miracle Grow for marketers. We comb social media and the web for smart marketing ideas. The emails cover topics like SEO, UX design, copywriting, and social media marketing. It’s short and to the point (less than five minutes to read).

You’ll love it I promise. Sign up below.

More To Explore