A multi-messenger view of the transient sky