Suppose that there is an e-commerce website that generates PDF invoices for the customers. These files must be transferred to accounting department hourly. When synchronization is finished, an email report must be sent containing information about work done.
The Synchronize remote directories Action automatically scans for new, modified and deleted files, and detects which files must be transferred, thus reducing the time and data amount needed for automatic sync. The job is launched by built-in Task scheduler Trigger, that must be added to the Task.
How to setup the automated file transfer? Add Connect to SFTP Action, and enter your server DNS name or IP address, along with a username and password. Then add Synchronize directories Action, and set the local and remote server directories. The Transfer mode must be set to Download, as we want our invoice files to be transferred from the remote server to the local machine.
The last step is to add Send email Action. Using Variable Wizard feature, we add current date and time to the email subject, and two dynamic variables containing the count and the list of files transferred. Each time the email is sent, the message body contains data from the last download session.
The task is ready and running. Task scheduler Trigger starts the task every hour. Synchronize directories Action automatically looks for new files on the remote server (similarly like WinSCP or robocopy command, but for SFTP), and when found, transfers them securely to the local computer or server. Send email Action sends messages to accounting department with information about invoices from the last hour.
Task scheduler Trigger can be configured to not send emails during night-time or on weekends, to prevent clutter in the inbox.
If you have any questions, please do not hesitate to contact our support team.
Video · Monitor an FTP server & send invoice via email
Automation Workshop is an awesome piece of software. It will save us thousands of man hours this year alone!—Chuck W.