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 launchspace.net. 

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

Blog

40+ SaaS Statistics You Must Know In 2024

Software-as-a-service (SaaS) has become an integral part of the technology landscape in recent years. To get your head around the SaaS industry, you need to

Blog

How to Become a B2B SaaS Content Writer

A B2B SaaS content writer focuses on crafting specialized content for businesses that offer cloud-based software solutions to other businesses. This role requires a unique