Verify emails in Google Sheets
Make how-to guides like this one in a snap.

Jason Miller

Created Jul 14, 2022

Verify emails in Google Sheets

1499
    docs.google.com

Google

1 Step
1

Open a spreadsheet and click on Extensions > Apps Script

Open a spreadsheet and click on Extensions > Apps Script
    pastebin.com

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
    script.google.com

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.