google sheets – Test if text in a range of cells exists on a single cell

In Sheet 1 I have a list of emails and I would like to add a status (either Good or Bad / true or false) next to it if the email contains any of the substrings in the Sheet 2.

Sheet 2 has a list of substrings that constitute a “bad email” such as or noreply that are in a list of cells.

Here is the desired output

I’ve searched around and cannot find similar questions so I think this would be helpful for those searching for the same problem in the future.