Answer
Yes — this is achievable by calling the StreamSubscriptions API's create-new-notification operation from within the workflow, which is the supported mechanism for generating that specific kind of in-application notification rather than only email-based alerts.