Hi Clay team, if i have 3 columns that im using to get an email how do I add all 3 to the campaing? I only see I can add one, but not all the columns have the email so I need to use a diffrent column
When adding leads to a campaign in Clay, you can only map one column as the email field. However, there's a solution for your situation where emails are spread across multiple columns:
1. Create a new formula column that combines your email columns
2. Use conditional logic in the formula to check each column and return the first valid email
For example, your formula might look like: LBKSIF(NOT(ISBLANK([Email Column 1])), [Email Column 1], IF(NOT(ISBLANK([Email Column 2])), [Email Column 2], [Email Column 3]))LBKSThis creates a "waterfall" effect that checks each column in order and returns the first non-blank email. Then use this new column when setting up your campaign enrichment.
If you encounter a "missing input" error, double-check that you're using the correct column names in your formula.