Hey Bpearce,
One option to avoid having the password stored in the cloud is to call a .txt file online.
1. Save the password to a location you like as a .txt file
2. You can save this to a secure location such as a google drive
3. Fetch the password by downloading the .txt file
4. Use "Read text from File" and read the password and store as %Password%
5. Enter the password as %Password%
6. Delete the local copy of the password.
Encryption
1. You can encrypt this if you like using a pgp keypair.
2. To decrypt either call the vault you're using or you can parse the private key yourself
3. The limitation is for A grade security you'd need to store the private key on the local machine rather than storing on the google drive. Parsing a private key over the internet introduces risk.