Google Script help please!!
I have been studying google script and I am unable to complete the script I am looking to create. My goal is to have an email automatically sent once a Google form submission is received on Sheet 1, but the information from Sheet 3 will be sent (I have used "importrange" in order to transfer data from the form submission into automatic scoring sheet on Sheet 2 and then to sheet 3 to be sent back)
Any help would be greatly appreciated!!!
not sure if this can help, but here it goes...check this out: