What's new

Welcome to CreatexDigital.com - The community for creators by creators

Join us now to get access to all our features. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, and so, so much more. It's also quick and totally free, so what are you waiting for?
xentr_blue_bg_color
xentr_red_bg_color
xentr_green_bg_color
xentr_orange_bg_color
xentr_voilet_bg_color
xentr_slate_bg_color
xentr_dark_bg_color
Master

Education How to Validate Emails in Google Sheets 2023

Master

Well-Know Member
Administrator
Pro Member
Joined
Sep 15, 2021
Messages
84
Reaction score
19
Cx
C273.20
Us Dollars
$7.90

Here's how to do it.​

Open your lead list (that must contain all emails as one of its column) in Google sheets and do the following:

1: Copy the email column (let's say D) and paste it in an empty column (let's say H)
Lov9Mg5mt4a2vjPDBdlNu-K839HyA--M8ISwh7GUMBKqUo0UeuUdof6zC1Rc5T_25omVRxq1fD9Z71DYStBaTJwO3BcPvEA6MkOTi4ffqOjM4e_jaYhEDrUsw-XrRToZRUYh2-PY_MjoL0LSbjEc34m8XzdvsPKC2BfobH2FwBgFWlWoUXnF5NdPoMT6xQ


2: Select the D column > Right click > Choose “Smart Chips” > "Convert to People Chip"

Now you have a D column with all the valid emails in chips and non-valid or non G Suite emails in text.
It's time to filter out the valid emails from D columns.


3: Select the D column > Choose "Data" from top navigation > Choose "Create a Filter" > Choose "Filter by Condition" >
then scroll down to "Custom Formula is" > Now write "=NOT(D2=H2)" > Click on Ok and that's how you just filtered out all valid G Suite emails.

97tVQ0X3IyVQBUWuqKuQrXs4TrvJR6rlmcuviCwvjW50dkSPxU8cpKfsP-hjf9gx8wuJidsSOQ_8Go34ipvuHm-pgVnhMmk2U-7WATolzehM5QMxs95t5Owv-SJ_o1Ant9NRW2HQaAIHr92rZ0rfZyIN5fUVxQExn2VrVb2tD4ngVBoe83TaKZogTgml-g



4: Now remove the H column and copy all the rows to your valid email list.


This works for G Suite emails
 
Top Bottom