My spreadsheet import tool in the Exchange can create OPC UA connections non-interactively, from a Perspective session. The only caveat is that certificates can only be auto-accepted if your IT is managing all of them under a single certificate authority.
More info here:
You will need to customize the tool's requirement for gateway admin authentication to fit your requirement.