SteamDeployPublic is a simple node app that you can deploy anywhere that will listen for build events from Unity Cloud Build, download the build, then upload to Steam. This will give yo a simple but working full pipeline.
Documentation:
https://github.com/alanlawrance/steam-deploy-public/wiki