Do you want to know how this works, or do you want somebody to write the tool?
I’ve been assuming the former. Automator is a scripting tool. It’s one of many scripting tools present on macOS. Automator has a nice GUI, and can encapsulate all sorts of activities. One of the many activities that Automator can invoke is a bash shell script. One type of script, calling another. A PowerShell calling a DOS batch script, for a Windows analog.
Bash and a couple of other Unix shells are the command line interface for macOS.
These command line interfaces are what are active when you launch the Terminal.app window. Term8nal.app opens up access to the Unix underpinnings. It’s a more advanced version of the traditional DOS box on Windows, and much closer to what Windows 10 with Services for Linux installed can provide, or Windows with cygwin installed.
Windows uses the DOS box or PowerShell for similar activities a macOS user might use a shell script. It’s these DOS commands that you’re seeking to mimic here with either Automator or a shell script, too.
Windows didn’t have a lot of scripting capabilities when last I was using that platform, other than cygwin, with PowerShell and SfL being more recent additions. macOS, being a different approach, can have scripts written in bash or zsh or another command shell, or in Perl or Python or various other languages.
Here, I’d write a shell script and use that. That’s the analog to The Unix batch file approach, though I’m not trying to mess around with thr file mounts and the rest, and would just access the remote server through scp. I’m also assuming thr remote system supports ssh/scp/sftp, as most now do. Windows 10 has been integrating remote-access capabilities here.
Windows was never good at logging into other systems and HyperTerminal was kind of a mess, though that’s being updated. macOS extensive support for logging into the command line of other systems, usually by ssh. That is, you can issue commands on one system, then ssh info another, and issue commands there. This entirely independent of the GUI. The ssh tool also provides for file transfers, using scp and sftp. Which is what I’d use here.
Perl, Python and other available scripting choices can also work.
Some doc on invoking a shell script from Automator:
https://www.macosxautomation.com/automator/shellacaction/index.html
An Apple primer doc on shell scripting:
https://developer.apple.com/library/archive/documentation/OpenSource/Conceptual/ ShellScripting/Introduction/Introduction.html
A basic file copy:
https://www.podfeet.com/blog/tutorials-5/how-to-create-an-automator-script-to-ba ck-up-to-dropbox/
How to run a shell script from the GUI:
https://stackoverflow.com/questions/5125907/how-to-run-a-shell-script-in-os-x-by -double-clicking#5126052
If there’s no other reply here, I’ll scrounge up a little time tomorrow to write the code as a shell script and as an Automator script, as I’m away from the Mac right now, and (unfortunately) the ASC forum forum software is doing some really weird stuff with the text wrapping right now, too.