Generate leads through LinkedIn

#1

Hi fellow dashdashers,

How about combining two integrations to build a simple but effective lead generation tool? We will use the Google Custom Search and Hunter.io integrations to build a contact and email finder app :muscle:

  1. Connect to Google Custom Search Engine
  2. Connect to Hunter.io
  3. Find contacts within a company
  4. Get email addresses for contacts

:one: Connect to Google Custom Search Engine :one:

Follow our guides on how to get an API key for the Google Cloud Platform and subsequently set up your own Google Custom Search Engine. Finally navigate to the integrations dashboard and connect to GCSE

:two: Connect to Hunter.io :two:

Go to Hunter.io and create an account. Then find your API key and use it to connect to the Hunter.io integration… setup, done

:three: Find contacts within a company :three:

On to the fun parts! Let’s start by finding contacts within a desired company. For this, we are using the restricted site CSE that is only searching on LinkedIn :mag:

A2 = microsoft.com
C2 = CEO
D2 = SEARCH_LINKEDIN_PERSON_GOOGLE(A2&" "&C2)

Amazing; we just got our search results back in D2. We will PARSE for the title (i.e. LinkedIn title) and then filter out the name. It’s quite simple, check it out

E2 = PARSE(D2,"['items'][0].['title']")

This, however, returns the full title. We are looking for first and last name only. So let’s do some spreadsheet magic adjust our function in E2

E2 = LEFT(PARSE(D2,"['items'][0].['title']"),FIND("-",PARSE(D2,"['items'][0].['title']"))-2)

If done correctly, your spreadsheet will thank you with the following

how-to_GCSE%20hunter%201

:four: Get email addresses for contacts :four:

Now it’s time to utilize the Hunter.io integration to find email addresses for the contacts you just identified. Follow these instruction and you’ll have those emails in no time :wink:

B2 = microsoft.com
E2 = Satya Nadella
F2 = LEFT(E2,FIND(" ",E2))
G2 = RIGHT(E2,(LEN(E2)-FIND(" ",E2)))
H2 = FIND_EMAIL_HUNTER(B2,F2,G2)
I2 = PARSE(H2,"['data'].['email']")," ")

Et voilà, you just got an email from Hunter.io

how-to_GCSE%20hunter%202

You can now programmatically identify right contacts in a company and then find their email addresses

Happy building :building_construction:

4 Likes
How to get your API Key for any Google Service