Write some Software

Main Skills: Google Drive or Google Sheets scripting. Project Requirements: Build a custom Google Apps script to pull data automatically from a Google Sheet, add a column with date/time, then add the data to a master spreadsheet that will contain all data from each day. Details: I am building a custom reporting dashboard to display marketing system data. The data is exported from the marketing system by sending an email each night. The report is attached to the email in .XLS format. I am using [login to view URL] to receive the report file with the "upload by email" function. Then I use Zapier to automatically upload the new file from Box to Google Drive. The marketing system does not have the option to include date information with the report export. I would like to write a script that copies the data from the daily report file, then adds the data to a master report spreadsheet and also adds a date record for each new row of data. Screenshots are attached that show a basic examples: 1-original-report: this is an example of what the original report data looks like for each day the report is sent 2-new-report-add-data: this is an example of the master spreadsheet that has combined data from each day with a field for the date. Some links to research that I have done: Upload data from file into google sheets: [login to view URL] Convert XLS file to Sheets [login to view URL] IMPORTDATA function [login to view URL] Please reply if you have worked on something like this previously