CIRSLife Document Studio

Am trying to get my spreadsheet CIRSLife Research Survey (Responses) located at; [login to view URL] to work with a Google compatible Add-On called Document Studio that will take specific data received from a Google Form CIRSLifeResearchSurvey2; [login to view URL] I used another consultant who disappeared to set up the Google Form to dump the data into row 2 of the Spreadsheet, then insert a blank row above row 2 (new row 2) and copy the formulas and formatting from row 3 (old row 2) up to row 2 and extract the data from row 3 in order to move it to another spreadsheet CIRSLifeResearchSurveyArchives Tab Archive2; https://docs.google.com/spreadsheets/d/171KddZYhE4w54nsE_BZ44g6Hoc7Ptwf8V29ut_q_WOU/edit#gid=175189797 The ultimate end-desired effect is that data will be collected to the "Archive2" tab of the CIRSLifeResearchSurveyArchives that can be analyzed later. The difficulty that I face is that although the Macro is working in the sense that it moves the data around, the goal was for Document Studio to create and send an EMail to the individual who completed Google Form CIRSLifeResearchSurvey2; [login to view URL] The last consultant I used has ghosted me after promising to have the project done within 6 days (2 weeks ago). He indicated that he'd probably just write the solution using JavaScript and not use the Document Studio software at all. I am NOT "married" to Document Studio--they provide no support despite numerous requests. I don't really care how the project is done. I just want it done, ideally within 7 days. Feel free to contact me regarding any further questions.