Hello, I read your project brief. I can write such a script that will do exactly what you wanted but I need some clarifications for step no. 2. If you kindly clarify all the manual steps you currently take to perform this task it will help me a lot to write a script for you that will automate this task.
About Me
========
I'm a Software Developer. I have experience in writing Google Apps Script for Google Sheets. Just last month I've written a script for a client that helps him to get words definitions, their synonyms and antonyms from Oxford Dictionaries API using custom functions.
Before that I've written a script for a client that will allow him to read incoming email messages from a specific domain, extract from those messages CSV files if present and extract contents from that CSV file, restructure them and insert them in Google Sheets.