I want to schedule a single send delivery via a workflow and once that delivery completes, I am looking for getting an email notification with the delivery details, like total delivered, total bounces etc.
is this possible?
Are you using workflow supervisors group? Can you verify "Alert group" under "General" tab on delivery alerting dashboard to make that's configured properly.
Once you setup delivery alerting criteria follow below to configure the delivery alerting dashboard and this will help to send the notifications when you meet the criteria defined.
Documentation link: Delivery Alerting Dashboard
You could solve this via a workflow: