Best Practice in Handling External File in APEX (Auto Load)

Hi,

I have an external csv received via sftp that needs to be loaded into our Oracle database.

I know I can use the SQL Workshop Utilities - Data Workshop - Data Load but I would like to load the data automatically.

I know this can be achieved by using an external table handled by a package. Or, the good old sql loader driven from a shell script and then package to process the data.

Using APEX, there's the convenient Data Load wizard but the user still has to at least load the file manually.

I am curious to know if there is another way to do this by just using an APEX page or maybe directly from the package.