Automate ERP Email Processing & Data Integration

At present the staff is getting the scheduled auto emails with the Excel Zip file attachment as scheduled report from ERP.
The Zip files are downloaded on the desktop. Then the unzipped Excel data (Trial Balance) is manually pasted in the financial file on Google drive.
The further linkage is already there in Google file & the financials are getting ready.

We require a script / programme which will
1) read all the scheduled auto emails from ERP of the dedicated email id
2) rename the zip file based on the remark written on the auto email body by storing the same in My drive of the dedicated email id
3) unzip the Excel files & store in My drive of the dedicated email id
4) we have prepared the control panel which has info of which file data is to be pasted in which sheet of which file. Accordingly the data should get pasted in respective sheets.

We have a script in place which sends the email with respective data tables to various groups.

If you have any solution for the above mentioned process then we can discuss it.