I want to send leads to LaGrowthMachine through Clay. But I’ve 2 possibility : if the “pro email” is valid, I put this email. If the “pro email” is invalid, I want to put the generic email that is in an other column - how can I do that
To set up this workflow in Clay, you can use conditional runs and the LaGrowthMachine integration. Here's how:
1. Add an enrichment to validate the "pro email" column.
2. Create a new column for the final email using an AI formula:
IF(ISBLANK([Validated Pro Email]), [Generic Email Column], [Validated Pro Email])
3. Add the "Create or Update Lead" action for LaGrowthMachine.
4. In the email field, use the new column you created in step 2.
This ensures you're using the pro email when valid, and falling back to the generic email when needed.
If you need more assistance, please ask for human support in this chat.
Hi Pierre, thank you for reaching out. For this case, we should use a merge function. Say I want to merge two columns, Column 1 and Column 2. To do so, go to "Add Column"> "Merge Columns", as shown below:
Then, in the menu that appears, press on the blue "Use AI" button in the "First Try" prompt box.
In the new menu, under "Describe the formula you want", hit "/" and select the column you want to input. Also tell it that it should only add the pro email if it is valid. Then, press on "Generate Formula". If what you see matches the content of your first column, then press on "output it correct. Save formula".
Repeat the same process for the other columns, but now under the "Then try" box, where you will be able to insert the generic email column. The menu should then look as follows once you are done. Then, press on "Save settings" to merge the columns. Let me know if this helps.