In a message about a new comment, how to tell if the comment needs approval or not?

Question

I am currently using Triggers + Actions to send the node author an email when a new comment is added.

Some of the commentators on my site do not require approval (registered users and repeat commentators).

I would like to indicate in the mail whether the comment requires approval - or send a different message all together in this case. I didn't find any way to configure this.

Answers to a related question suggested the Rules module, but I didn't find a way to make a condition based on whether the comment needs approval.

Edit: I think that the relevant conditions is about comment:status. This field doesn't appear as a data selector in Rules, for some reason.

Answer 1

There is a great tutorial on Rules with a similar use case.