title: Can an automated apps script email notification link back to specific sheet?
body: <p>much to my surprise I've successfully made an apps scripts that sends me email notifications when a specific cell is changed to 'Submitted,' but I have no idea how to make this identify the sheet it came from - have linked a copy of the sheet below, there are going to be around 20 of these, each with 6 submission sheets, and I need to do a thing as soon as the sheet has been marked submitted, i.e. same day. I'd rather not hard code in separate messages for each sheet, can I do something around getting the URL and sheet with the get active sheet coding and insert it into the email message? I'm also aware currently I've hard coded in the sheet names and therefore need 6 different triggers, I'm working on that - tried loads of different coding pages and this is the only one that worked!
  <a href="https://docs.google.com/spreadsheets/d/1b0LOr9vhmFu4WtYy_RbS-1cvXncNOI_x3YT0f30fZgY/edit#gid=1979912158" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/1b0LOr9vhmFu4WtYy_RbS-1cvXncNOI_x3YT0f30fZgY/edit#gid=1979912158</a></p>
  <p>Cheers,
  Meg</p>
  <pre><code>    function emailSubmit() {
  MailApp.sendEmail(&quot;Testemail&quot;, &quot;Test&quot;, &quot;Test message&quot;);
  }
  function onEdit(e) {
    const specificSheet = &quot;Sub1&quot;
    const specificCell = &quot;C11&quot;
  
    let sheetCheck = (e.range.getSheet().getName() == specificSheet)
    let cellCheck = (e.range.getA1Notation() == specificCell)
    if (!(sheetCheck &amp;&amp; cellCheck) || e.value !== &quot;Submitted&quot;) {
      return;
    }
    else {
      emailSubmit()
    }
  }
  function onEdit2(e) {
    const specificSheet = &quot;Sub2&quot;
    const specificCell = &quot;C11&quot;
  
    let sheetCheck = (e.range.getSheet().getName() == specificSheet)
    let cellCheck = (e.range.getA1Notation() == specificCell)
  
    if (!(sheetCheck &amp;&amp; cellCheck)) {
      return
    }
    else {
      emailSubmit()
    }
  }
  </code></pre>