I see you’ve read about implementing the code in Blue Prism, Blue Prism is clearly a great tool to work with but the problem with Blue Prism is the fact that its completely paid, like not even a trial version is available. Seeing your needs I would recommend you to learn Automation Anywhere or UiPath.
Looking for RPA material from basics! Refer to this video on RPA provided by Intellipaat:
Both the tools are amazing and fairly easy to use, each has its pros and cons it really comes down to personal preference in my opinion. Both of these tools have community edition so you can download it for free and get working :).