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.
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:
(217 kB)
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:
(38 kB)
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.