Find emails in Google Sheets

Jason Miller

Created Apr 28, 2022

Find emails in Google Sheets

1640
    d

Google

4 Steps
1

Open a spreadsheet and click on Extensions > Apps Script

Open a spreadsheet and click on Extensions > Apps Script
2

Go to https://pastebin.com/raw/QD1MPpTv and copy/paste the script in Code.gs

IMPORTANT: Remove everything else that was present in the file before pasting Findymail's code.

Go to https://pastebin.com/raw/QD1MPpTv and copy/paste the script in Code.gs
3

Replace "APIKEY" by your Findymail API key

If you don't have a key yet you can create one at https://app.findymail.com/user/api-tokens

Replace "APIKEY" by your Findymail API key
4

Click on Save project

Make sure there isn't other lines than the one you copied eg. remove any "myFunction()" line etc.

Click on Save project
    p

Pastebin

1 Step
5

You can now use the GETEMAIL formula as any other Gsheets formula

First parameter is the person's name & the second parameter is the company website (or company name)

You can now use the GETEMAIL formula as any other Gsheets formula
    s

Google

1 Step
6

Select the right cells for the parameters and press enter to get the email

Select the right cells for the parameters and press enter to get the email
Well done!
Create how-to guides like this in a snap. Get Tango now.