Automatic latest installer download

Is there a way to download the latest installer automatically? I am trying to automate as much as possible the tasks I have to do when a new employee is hired. I did part of it, now I want to automate local software/apps installation with Intune.

It seems there might be a way to work with a combination of PowerAutomate Cloud and Desktop (or script) to interract with the download page. But it relies on having a local computer to run the desktop automation.

If anybody has a solution that would not require a local machine to be used that would be great.