In a message about a new comment, how to tell if the comment needs approval or not? 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.
There is a great tutorial on Rules with a similar use case.