My email waterfall occasionally doesn't populate the merged column.
This issue typically occurs when the merge formula assumes there's a response for every row, but some rows don't have data. The formula fails when it tries to process non-existent responses. To fix this: Add conditional logic to your formula by including "if {{response}} exists..." before the main formula logic. This ensures the formula only processes rows that actually have response data. Additional context: Email waterfalls continue running even after finding an email if that email fails validation. The waterfall stops only when a valid email is found or all providers are exhausted. Multiple providers may run because each operates independently, and the process continues until a valid email is discovered.
Hi Brandon, thank you for reaching out. This is likely due to the fact that the emails found are invalid.
While you don’t see it right now, there is a validator column that checks the validity of each email after it’s found. To view these columns, go to the top right, click on "Columns," and then toggle on the following options:
By selecting this, you'll be able to see that while some emails were initially found, they were later validated and marked as invalid, as shown in the example below:
This indicates that the email was not returned, not because of a bug, but because it is invalid. Let me know if this clarifies things.
Thanks, Stefano
happy to help!