Much of this is the type of thing we might automate if we were passing information between enterprise applications and cloud ... a Power Automate flow, you should find working with the Desktop ...