Rules condition for comment status
What you need is a rule that is fired when the comment is first published and that seems very straight forward to me. If you need any further help on that, please let us know.