And to answer the question: you would need to do this yourself. Maybe you could have a lambda inspecting the topic, and doing something with CloudWatch after?

Alarms are for sending notifications. CloudWatch is a database of events, not a notification-sending service. You cannot do what you've described natively, it's not what the services were designed for.