I have read through the requirements and I have a very good idea how to complete all of it. There is only a couple of things I have not attempted before, such as using python to automate downloading files from google. I'm thinking maybe to get around it by clicking the "choose this option for files of this type" in the browser dialog box when downloading csv files. And then of course, there is the issue of how to know the file name which is kinda hidden until you actually download it. I prefer to work with Chrome, so let me know if it is okay with you. I will need to know your operating system and which download directory you are using, so that I can program that in.
The rest I understand and have a good idea how to proceed.
Thanks,
Warren