Validate an inbound email list in Google Sheets with VALIDATE_EMAILType ValidationCyrus Radfar
The VALIDATE_EMAIL function can help any marketer or sales rep clean up a messy inbound list. This tool doesn't do deliverability testing; rather, it validates the format of an email, that the top-level domain (TLD) is valid, e.g. .com, .net, .etc., and validates that the email domain isn't from a known "burner" domain.
[range] emails; required - range of text to evaluate as emails (TRUE) or not (FALSE). If string or number is passed, the function attempts to convert to a date.
[boolean] validate_tld - Validate Top Level Domain (e.g. ".com") as valid against an ICANN list. It's possible that very new TLDs aren't added so this can be turned off.
[boolean] check_bad_list - If true, it checks against a list of throwaway (burner) email domains and will return FALSE even if the email is a valid format.
Use the CheatHow to Add a Cheat to a Google Sheet
Click the Code Box to Copy