title: Attach file from PC in Gmail Draft using Google App Script
body: <p>Currently, I m using Google App script to create Gmail Draft from Spreadsheet, The last thing that is missing is I want to attach the file in &quot;Gmail draft&quot; directly from the computer instead of uploading G-Drive.</p>
  <p>below is my current code.</p>
  <p>here I want to add a column named &quot;File Path&quot; where I will enter the path of the file which I need to attach in said Email. then GS should automatically pick the file from my pc said path and attach it in Gmail Draft.</p>
  <p>Thanks in Advance.</p>
  <p><div class="snippet" data-lang="js" data-hide="false" data-console="true" data-babel="false">
  <div class="snippet-code">
  <pre class="snippet-code-js lang-js prettyprint-override"><code>function Loop_Email_Drafts_with_Signature() {
  
  const signature = Gmail.Users.Settings.SendAs.list("me").sendAs.filter(function(account){if(account.isDefault){return true}})[0].signature;
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getActiveSheet();
  var index = 2;
  var lastRow = sheet.getLastRow();
  
  for (;index &lt;= lastRow; index++){
  var emailAddress = sheet.getRange(index, 1, 1, 1).getValue();
  var ccmail = sheet.getRange(index, 2, 1, 1).getValue();
  var subject = sheet.getRange(index, 3, 1, 1).getValue();
  var message = sheet.getRange(index, 4, 1, 1).getValue();
  
    
  const html = "&lt;div&gt; &lt;/div&gt;&lt;br&gt;" + signature;
  const options = {
    htmlBody: message + html,
    cc: ccmail
  }  
  GmailApp.createDraft(emailAddress, subject, '', options);
  
  
  
  }// End of For Loop
  }// End of Function</code></pre>
  </div>
  </div>
  </p>
  <p>PS: I'm new to Google App Script / Java script. so please help in detail by writing / amending my current code.</p>