title: Templated email using Apps Script based on data in Google Sheets
body: <p>I'm new to scripting so I hope someone can help me create one.</p>
  <p>I'm trying to create a script for a sheet that can send an email when a custom menu is pressed.</p>
  <p>Here's a file to work on.
  <a href="https://docs.google.com/spreadsheets/d/1Ea-3eZoclHrAkZLwRmWWFbmbnn4dESNWvK_6pn1DCbE/edit?usp=sharing" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/1Ea-3eZoclHrAkZLwRmWWFbmbnn4dESNWvK_6pn1DCbE/edit?usp=sharing</a></p>
  <p>Also, it should only send it if a column (ex. Column I) has a specific Value like 'Approved'</p>
  <p>Email content should look like:</p>
  <blockquote>
  <p>Subject: Leave Application # 'ColumnC'</p>
  <p>Hi 'ColumnA',</p>
  <p>We received your 'ColumnB' request for 'ColumnE'</p>
  <p>Status: 'ColumnG'</p>
  <p>More Details: 'ColumnH'</p>
  <p>-Admin</p>
  </blockquote>
  <p>Email should be sent to Column E and F.</p>
  <p>The script must also update the spreadsheet to avoid duplicate emails.</p>