script is a basically collection of commands that you give it to a interpretor with some special routines and brilliant methods to make it easy to use.

how do you manually establish sftp connection to the server ?
that is the starting point, add that command to a script file and execute that