Hi there,
I’ve stumbled upon a seemingly simple task and I can’t seem to solve it. I have an automation that reads emails and based on the content, writes an auto-response. The problem is when filtering. I have many options to do basic filtering in Make: within and between modules. But what I need is an option to search through a google sheet where all the blacklisted emails are, and do continue the scenario only with the ones that are not listed. But this is the part, where I got stuck:
- If I use a search rows module, it starts an iteration, so if I have 20 incoming emails to process and 30 row blacklisted emails, then it will produce 600 bundles.
- I can use an array/text aggregator, but that doesn’t help either, because if it encounters a blacklisted email, it will still force through the other 29 bundles and the scenario runs.
- I can’t find a way to use the iteration and the filter option at the same time, in one scenario without triggering hundreds of bundles or losing the ability to filter out the blacklisted emails.
To make things more complicated: I must be able to filter out not just emails as a whole, but emails that contains a certain domain (i.e.: @example.com). So I have two columns: column A contains whole emailes, column B contains domain endings.
@samliew or any pros out there, if you can lend me a hand with this, I would really appreciate it!
.
Wow guys, you are great, thanks for the help! 
The solution was indeed using a textjoin function in GSheet, then map it with a “Get a cell” module, then finally use the “Text operators: Does not match pattern” as filter.
To be honest, I’m still not sure, how it works, but it managed to filter out fully and partially matching email addresses while passing through those that needed to be passed through. I’m just amazed. Is there somewhere to read more about this operation?