For any outreach expert, email validation is one of those things that you can’t skip out on. Your outreach campaign could fall on deaf ears if you don’t weed out the bad contacts from the good. Every email address has an attached reputation, and having a spotless record is the cornerstone of outreach success. This raises an important question: how would one check the reputations of their contacts? The solution is none other than Google Sheets email validation.

Most people solve this problem by running their list through a validation app, usually a paid one. But what if you could validate emails for free from the comforts of your all-too-familiar Google Sheet? Well, There’s a neat little feature in Google Sheets to help you easily validate emails right in the spreadsheet. Simply put all the emails in a separate cell and then hover over each. Near instantly, the full contact card will [hopefully] pop up on your screen.

If nothing comes up, that means Google doesn’t have any info tied to that address. While that doesn’t necessarily make it an invalid address, any populated information suggests that the contact is an actual human being. From phone number to workplace, you can get a surprisingly good amount of details from Google Sheets email validation.

Email Validation can get quite tedious, so don’t bother with those third party applications if you’re already in a Google Sheet.

Noel Cocca

CEO/Founder RecruitingDaily and avid skier, coach and avid father of two trying to keep up with my altruistic wife. Producing at the sweet spot talent acquisition to create great content for the living breathing human beings in recruiting and hiring. I try to ease the biggest to smallest problems from start-ups to enterprise. Founder of RecruitingDaily and our merry band of rabble-rousers.

Dean Da Costa

Dean Da Costa is a highly experienced and decorated staffing professional, recruiter, sourcer and manager, who also boasts outstanding experience and skills in Human Resources, Project Management, Training, and Process Improvement. He is best known for his work in the highly difficult security and mobile arena's, and the gold star winning numbers he produced. His keen insight and creation of ground breaking tools and processes, to enhance and change staffing as we know it, have proven he is a true "Staffing Thought Leader". Despite all this he remains first and foremost one of the top sourcers, staffing managers and full cycle recruiters in the industry and a true "Search Authority"