Troubleshooting Email Validation and New Contact Identification Issues

Hey!

1.
I'm trying to validate emails using new records I've written to the table using find people. I have checked neverbounce API and its connected and working.

The problem comes when trying to get the existing column to work, i can't run it again as it has a "Formula contains missing input". I have tried a workaround where I've created a new column for validate email using neverbounce, but this wants one column source to validate from which then becomes problematic as I've run a waterfall so the correct emails come from multiple columns. I'm sure there's something simple here I'm doing wrong? 2. I exported the list before I imported the new contacts, is there a way of identifying the new contacts so I can run a filter in a new view to then only export these and avoid having duplicates come up on instantly?

6 comments

Channeled
APP
·
·
For the email validation issue with multiple columns, here's how to resolve it: 1. Instead of trying to validate multiple columns at once, set up a conditional run for the NeverBounce validation: • Add a new NeverBounce email validation • Click "Run Settings" then "Conditional Run" • Use the AI to create a formula that checks for the presence of an email in your waterfall's final output columnFor identifying and filtering new contacts: 1. You can use the table filters to identify new records: • Click "Filter" above the table • Select relevant columns that can help identify new contacts • Use options like "is not empty" for newly added data fields, or create a filter based on when the records were addedNote that when running email waterfalls, validation columns may be hidden by default but still exist in the background. You can unhide these columns to better track the validation process. Sources: Neverbounce integration overview | Documentation | Clay University AI Formulas + Conditional Runs [Clay 101] - Clay University Enrich People (Waterfalls) [Clay 101] - Clay University Hide, Re-order, Sort, Filter, Merge Columns
Channeled
APP
·
·
Hi Mark C.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:
Channeled
APP
·
·
Looks like you're still looking for help. We're escalating this over to our support team and someone should be in touch soon. In the meantime, feel free to include any other information that may be helpful in solving your issue!
Mark C.
·
·
"Use options like "is not empty" for newly added data fields, or create a filter based on when the records were added" I'm not sure how to do this and find the filter by date added as it doesn't seem to be a record for it?
Mark C.
·
·
I've reviewed your advice about changing the settings but it looks like the main problem before I validate the emails using a new neverbounce column is to get the email waterfall working more effectively. Currently the different email tool columns like Icypeas and Datagma use a domain as a source. I have two columns with google serp results using Serper which seems to be the problem as it doesn't always find the right domain e.g wikipedia, instagram, find-and-update company etc.
Tanvi R.
·
·
Hi Mark, thanks for reaching out! Do you mind sending the link (url) to the table so we can take a look? https://downloads.intercomcdn.com/i/o/w28k1kwz/1347419411/65baf32e1d2a789ffba395c6d35c/CleanShot+2025-01-22+at+_42I1FzxXHf%402x.png?expires=1738343700&signature=832c1f57fcb9f5d9a9887cbe730d33118064026562669176b20008d7439356c3&req=dSMjEc1%2FlIVeWPMW1HO4zVws4pk0CVevgvYjA82bedC6SA%3D%3D%0A

Troubleshooting Email Validation and New Contact Identification Issues | Clay