How To Create Free Email Validator Tool using Google Apps Script

Опубликовано: 04 Октябрь 2024
на канале: Amarindaz
12,851
like

Try ➜ https://www.myfreshtools.com/misc/bul...

Get API Key ➜ https://bit.ly/getEmailValidatorAPIKey
Download Google Sheets ➜ https://gum.co/emailValidator
Learn Email validator API Docs ➜ https://bit.ly/EmailValidatorAPIDocs


Checkout how to build Email Marketing Tool on google sheets 👉    • Build Your Own email marketing tool |...  

In this video, you'll learn how to build your own email validator tool for free using Google apps script.

When you have a huge list of emails and wondering how to check if email addresses are valid or not then you can leverage these Google sheets to validate email addresses in the list before sending the email.

In this script, we actually verify email addresses without sending any email.

Let's see what are we extracting from the email validator tool

Email List - Just provide the test email addresses
Did you Mean - Any email exists in the same id with slightly misspelled
Domain - What domain the email lD Belongs to
Is in Valid Format - Do email address format validation
MX Found -Check mail server is active
SMTP Check - Simple Mail Transfer protocol check
Is it Free Email - Check is it a free or paid account
Email Score - Give score in the range of 0 to 1
Exception - Any exception in the script

I hope you like the email validator tool built on Google sheets.

TimeStamp

00:15 - Introduction to email validator tool
00:42 - What are the email validate headers
02:06 - Start writing script to validate email addresses
04:06 - Create a function to check email address
07:52 - Email address validation JSON object
10:23 - Create custom menu for verify email address in real-time
12:05 - Run the email validator function
13:08 - See the output for the given email list

********* Tutorial Playlists *********
Google apps script tutorial for beginners- https://bit.ly/google-apps-script-tut...
Automate internet explorer with VBA- https://goo.gl/Xmy8Af
Autoit tutorials for beginners- https://goo.gl/JHB1E2
Selenium Webdriver tutorials for beginners -https://goo.gl/QqxTrF

***** Contact me *******
Blog: http://www.amarindaz.com/contact/
FB page:   / amarindaz  

****** Books written by me *******
Autoit tutorials for beginners: http://amzn.to/2GjaDbD
Excel VBA for beginners: http://amzn.to/2nhI067

****** Productivity tool ********
My Favorite YouTube Tools ➜ https://goo.gl/MX9Z4p and ➜https://goo.gl/UW1uRX

****** Gear Used To Shoot This Video *****
_Audio & Microphone
http://amzn.to/2GibdGu

*******Learning partner*******
Video courses ➜https://click.linksynergy.com/fs-bin/...

Don't forget to subscribe! https://goo.gl/J2453w

💼 To Hire Me 👉 https://fwd.cx/WLGgpTiZW5HK

Checkout my app 👉 https://www.myfreshtools.com