Clay Icon
Join the Community
02 Support

Troubleshooting Email Validation and New Contact Identification Issues

Avatar of Mark C.Mark C.
·
·

Hey!

  1. 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

  • Avatar of Channeled
    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

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Hi Mark C.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:

  • Avatar of Channeled
    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!

  • Avatar of Mark C.
    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?

  • Avatar of Mark C.
    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.