title: Google Sheets Form Response Conditional Responses
body: <p>I'm relatively new to coding, especially in Javascript. I'm working on a google form that links to a google sheet and I want a conditional notification that when they answer a certain response it will notify that departments manager via email.</p>
  <p>Essentially, I need my script to search for the value of a cell that contains the email to send.</p>
  <p>I'm using a VLOOKUP chart to automatically input the email of that department based on the the department question they answer.</p>
  <p>Additionally I need a way to trigger this function to run when a new response is entered. Making sure that only an email is sent for the new response and not any of the older ones.</p>
  <p><a href="https://i.stack.imgur.com/sd1cD.png" rel="nofollow noreferrer">enter image description here</a></p>
  <p>My email will have the message line and subject using this code below:</p>
  <pre><code>var recipient = emailAddress
  var message = ''
  var subject = 'Department Alert';
  MailApp.sendEmail(emailAddress, subject, message);
  </code></pre>
  <p>Any thoughts on how to achieve this?</p>