Verify emails in Google Sheets

Google

  1. 1. Open a spreadsheet and click on Extensions > Apps Script

    Open a spreadsheet and click on Extensions > Apps Script

Pastebin

  1. 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

Google

  1. 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

  2. 4. Click on Save project

    Click on Save project

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