How to Validate Email Addresses and Create Verified Status in Excel

Hi there, I have created a column to validate email addresses via Zerobounce which is returning the result Valid email OR Invalid email - I then want to create a final column which has the Email status as verified or unverified. I have tried using the AI formula generator but I've been unable to - can you provide some assistance.

2 comments

Channeled
APP
·
·
You can create a final column using an AI formula based on the Zerobounce validation results. Here's how to interpret the results: 1. Zerobounce provides a "Status" output field that indicates whether an email is valid or invalid. 2. By default, catch-all emails are returned as valid. However, if you've enabled the "only mark safe to send" option, catch-all emails will be excluded from valid emails.To create your final column, you can use an AI formula that checks the Status field from Zerobounce and maps it to "verified" or "unverified" based on your requirements. The validation columns may be hidden by default, but they exist behind the scenes and can be referenced in your formula. Sources: Enrich People (Waterfalls) [Clay 101] - Clay University Validate Email with Zero Bounce
Channeled
APP
·
·
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.