Unless you've set up and are using Azure Active directory, you're going to have a hard time automating this process from Azure. This is because it won't be able to see into your network to pull the files up. Instead, I'd schedule it using whatever you use locally for scheduling (SQL Agent?) and then use the tools you already outlined along with PowerShell to make the whole thing happen.