title: Google form responses + additional data trigger an email
body: <p>Final Goal: Send an automatic email to a list of emails of the last row of data.</p>
  <p>I have Google form responses coming into a spreadsheet. I can easily add an email sending on the information to my team however I want to pull in some data from another sheet dependent on the form responses.</p>
  <p><a href="https://i.stack.imgur.com/5kRhx.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/5kRhx.png" alt="enter image description here" /></a></p>
  <p>In the next step I want to send the combined data in an email. I only want to send the last row of data. My question is if someone has an idea of how to trigger an email when the data has been pulled in from another spreadsheet and not just the form responses. I have been scratching my head trying to figure out what kind of trigger I could use as it needs to be delayed enough for the data to be pulled in.</p>
  <p><a href="https://i.stack.imgur.com/7yvkI.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/7yvkI.png" alt="enter image description here" /></a></p>
  <p>Spreadsheet <a href="https://docs.google.com/spreadsheets/d/1VzuyNwKRXfSx5qT1e5TEFC_cXVkbYKlaNc3rwE3jGwU/edit#gid=0" rel="nofollow noreferrer">here...</a></p>