How to Restrict Data to Email Addresses in Google Sheets
If you’re using Google Sheets for email addresses, maybe for clients, customers, or employees, you’ll want to make sure the data is entered correctly. One way to do this is to validate the format to confirm it’s an email address.
Source: howtogeek.com