Get Any Email Address in a Few Seconds

Nadja Beneš
Apr 10 · 4 min read

You’ve successfully created your custom lead generation app in dashdash, and now want to proceed to enrichment of your new leads? Let’s do it!

By connecting to our Hunter.io integration, you can find the email address of any professional based on their full name and domain name of the email address. You have 100 searches per month for free!

Step 1: Connect to the Hunter.io integration

If you don’t have one already, head to Hunter.io and create an account. Get your API key here and use it to connect to our Hunter.io integration from the Integrations menu.

Step 2: Set up your app

2.1. Find the email address of a list of prospects

Create an app in dashdash. Set up three columns for

  • A1:Company Domain
  • B1:First Name
  • C1:Last Name

Caution: Domains are not URLs!
Example: For Spotify, the domain name is “spotify.com”, and not www.spotify.com" or “https://www.spotify.com”.

Import your list of prospects in the dashdash app. Then, use the next column to make your request:

A2=spotify.com
B2=Amy
C2=Ferris
D2=FIND_EMAIL_HUNTER(A2,B2,C2)

Parse the email address:

E2=PARSE(D2,"['data'].['email']"
Find any email with our Hunter.io integration

To get the email address for your full contact list, simply copy-paste the formulas in D2 and E2 down.

2.2 Find the email address of generated leads in another app view

In case you’ve built your custom lead generation app in dashdash, here's how you automatically send your qualified leads to Hunter from another app view.

Let’s create a new App View by clicking on the "+" icon at the top left of the sidebar. Name the view "Emails".

Note: You can rename any app view by opening the dropdown menu on hover over a view.

Make sure the column headers of the new "Emails" app view match the column headers of those data objects that you’d like to insert into the view. In this example, we’d like to import all names and titles, and therefore create a column with the title "Name" and one with the title "Title" in our Hunter app.

Back in your original LinkedIn lead generation app, go ahead and add an additional column to specify which of your generated leads qualify. Then, create a new column to manage your data (f.ex. "Send to Emails"). From this column, you'll automatically send the names and titles of all your qualified leads to the new "Emails" app view you’ve just created:

E9=IF(D9="yes",INSERT(A$8:B$8,A9:B9,'Emails'!B$1:C$1))

Note: The INSERT()formula only sends those data objects from one table to another for which the column headers are identical (in this example, only names are sent to the "Emails" app view).

In the "Emails" view, add the organization’s domain (not URL!) in column A.

Since we need first and last name to find your prospects’ email address, let’s filter those out into two separate columns using the following formula in D2 (first name):

D2=IF(B2<>"",LEFT(B2,FIND(" ",B2)-1),"")

And the one below in E2 (last name):

E2=IF(B2<>"",RIGHT(B2,LEN(B2)-SEARCH(" ",B2)),"")

To get the first and last names filtered out for all your search results, simply copy-paste the formulas from D2 and E2 and drag down.

Repeat Step 2.1. above to find the email address of your qualified leads:

Can’t get enough of automation?

Now that you got plenty of new email addresses, it’s time to target! You can do this in dashdash as well! 💪 Connect to one of our email integrations such as Gmail, SendGrid, and email by dashdash to send out targeted emails, or simply subscribe the new leads to your Mailchimp list!

You can also connect your CRM to dashdash and automatically add your new leads to your CRM! We currently integrate with HubSpot, Pipedrive, and Zoho — and we'll add more soon! Learn how this works with HubSpot here.

Happy targeting! 🚀

We hope you enjoyed this how-to guide. For more, check out our forum, create your own guide and share it with the community, or let us know which use case you’d like to see featured next! ✌️

dashdash

The best business data and APIs, all in a spreadsheet.

Nadja Beneš

Written by

Content Strategy @dashdash

dashdash

dashdash

The best business data and APIs, all in a spreadsheet.

Welcome to a place where words matter. On Medium, smart voices and original ideas take center stage - with no ads in sight. Watch
Follow all the topics you care about, and we’ll deliver the best stories for you to your homepage and inbox. Explore
Get unlimited access to the best stories on Medium — and support writers while you’re at it. Just $5/month. Upgrade