Logs into a host via SSH, runs a command and dumps the file to local machine via SFTP.

host_scripting.sh

#!/bin/bash

# User to enter the host
USER=username

# Script to run in host
# In this case, we will be dumping the process my memory usage order
SCRIPT="ps aux --sort -%mem"

# List of hosts
HOSTS="host@host.com"

# For every host in the list
for HOST in ${HOSTS};
do
    # Access the host with SSH and runs the script, producing an output file
    ssh -l ${USER} ${HOST} "${SCRIPT} > ${HOST}.txt"

    # Acess the host with SFTP
    sftp ${USER}@${HOST} <<EOF

    get ${HOST}.txt
EOF
done