Automate task with a live dashboard

Hello people,

I’m a newbie so I apologise in advance if I’m asking a newb question. I am trying to automate tasks so that it doesn’t require me to manually do it everytime.

This task involve, Downloading CSV or XLXS data from an FTP source or an API source (here’s the website just in case- Converting the downloaded file into the same file but with different excel formula and layout. Then lastly uploading it to a live dashboard. Any advice or the right step to handle this would be highly appreciated.

Thank you and have a great day.

Kind Regards,