发送由Google工作表填充的电子邮件

Our Engineering Department has a request form on Google that our company uses to notify us of projects and other issues that need attending. The requests are assigned a project lead in our weekly meeting. I'm trying to write a script that will populate an email using data from the spreadsheet the form is driving to notify both the requester and the project lead so that they can contact each other directly instead of email everyone in the Engineering Group for updates. I tried splicing two different codes to achieve this as I was unable to find code I could easily adapt to fit our goal. I have listed the links below to the codes I used to write what I have.Our Engineering Department has a request form o