Verify emails in Google Sheets

Jason Miller

Created Jul 14, 2022

Verify emails in Google Sheets

1790
    d

Google

1 Step
1

Open a spreadsheet and click on Extensions > Apps Script

Open a spreadsheet and click on Extensions > Apps Script
    p

Pastebin

1 Step
2

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

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

Google

3 Steps
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

Click on Save project
5

Go back to your spreadsheet. You can now use the VERIFYEMAIL formula as any other Gsheets formula

The parameter is the email address

Go back to your spreadsheet. You can now use the VERIFYEMAIL formula as any other Gsheets formula
Well done!
Create how-to guides like this in a snap. Get Tango now.