I need someone who knows how to add a script in Google Sheets Script editor to perform the following:
When a submission is received to the google sheet from the connected google form with a selected answer and email is sent containing the answer (entire row date) to a specific email address. Here is more specific detail:
The google form is responded to and an answer is selected from a dropdown answer option which contained 5 options and 1 needs to be selected. Example, Hilton, Marriot, Best Western, Choice or IHG are the options. When the submission hits the form and contains the selected answer as "Marriott" and email is sent to and email address associate to Marriott containing the entire row of data.
Currently in Google Forms , responses submitted onto the correspoding Google Response sheet only can be set up to notify of a submission. This function is not what I need.