FREE email validator for Google Sheets | Google script to validate emails
A FREE ’email validator’ Google Sheets template
Check for valid email address syntax using our simple and free to use Google Sheets template.
PLEASE NOTE – this is an email validator, as in ‘we check to see if the email syntax is valid‘. We do not check to see if the email is a real live email address, to do this, use a tool like Emailable.
First up, paste in your email in the sign up form
Now create a copy of the Google Sheet
Now run the Google Apps Script
Pop out to full screen, so you get an uncluttered view of your email.
Click on Triggers in the left side menu
Know exactly how wide and long your email is on desktop and mobile screens.
Create a new Trigger, using the default settings
Refresh the sheet, the paste in your emails
Click on Validation, and then Check Validation
Hey presto, you’ve successfully validated some emails!
What we check for…
A valid email address has 3 parts: A local part, an @ symbol, and a domain name.
The local-part or username may be up to 64 characters long and contain:
Domain names may be a maximum of 253 characters and consist of:
- Uppercase and lowercase letters in English (A-Z, a-z)
- Numeric values (from 0 to 9), on condition that domains can’t be all numeric
- A period (.) (used to identify a sub-domain; for example, email.domainsample)
- A hyphen (-), on condition that it is not placed at the beginning or end of the domain