Check an inbound email list in Google Sheets with VALIDATE_EMAIL
Learn about the VALIDATE_EMAIL function by the spread_cheats community.
A Google Sheets custom function to validate a set of inputs as TRUE/FALSE valid emails. The function checks for format, the top-level-domain (e.g. .com, .org, etc.) and can help discard burner (throwaway) email providers like mailinator.com.
This video discusses getting started with the function.
Links:
⇒ view tutorial: https://sheets.guide/validate_email
⇒ copy tutorial: https://sheets.guide/validate_email/copy
⇒ code: https://sheets.guide/validate_email/code
⇒ spread_cheats post: https://sheets.guide/validate_email/post
+--------------------------------------------------------------+
❓Learn how to install a cheat yourself
⇒ https://www.spreadcheats.com/how-to-a...
+--------------------------------------------------------------+
spread_cheats:
find us at https://www.spreadcheats.com
join the community at https://bit.ly/spread_cheats
follow us / spread_cheats
╱╱╱╭╮╱╱╱╱╱╱╱╭╮
╱╱╱┃┃╱╱╱╱╱╱╭╯╰╮
╭━━┫╰━┳━━┳━┻╮╭╯
┃╭━┫╭╮┃┃━┫╭╮┃┃
┃╰━┫┃┃┃┃━┫╭╮┃╰╮
╰━━┻╯╰┻━━┻╯╰┻━╯