1
0 Comments

Can anyone turn this Google Sheet email generator into a product

I do a lot of cold outreach and my process works despite being really ugly.

Here's what it is:

  1. Find person on LinkedIn
  2. Add First name to cell in google sheet
  3. Add last name to cell in google sheet
  4. Add company domain name to cell in google sheet

Then, I formulated cells to generate the 8 most commons emails at a company:

firstname@domain.com
firstnamelastname@domain.com
firstnamelastnamefirstinitial@domain.com
firstnamefirstinitiallastname@domain.com
firstname.lastname@domain.com
firstnamefirstitnitial@domain.com
firstnamefirstitnitiallastnamefirstinitial@domain.com
lastname@domain.com

You can see how I break it down above.

I then take these 8 emails and use Yet Another Mail Merge to send an email to them all.

7 bounce, 1 is delivered - boom. Inbox access.

Hunter.io kinda has something like this but it's not 100% accurate. I've used this google sheet system for a few years and it's how I've accomplished everything from job searches, to investor outreach, and even influencer campaigns.

I imagine it could have a landing page where you enter a person's first name, last name, and company and then the system does the rest, including sending an email to the inboxes OR some other way to verify which email is real or not.

Any ideas how to build this?

on August 9, 2023