Advertisement
Guest User

Untitled

a guest
Mar 28th, 2017
51
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.02 KB | None | 0 0
  1. function sendEmail() {
  2. var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
  3. var currentsheet = spreadsheet.getSheetByName('Sheet1');
  4.  
  5. var data = currentsheet.getDataRange().getValues();
  6. var html = HtmlService.createTemplateFromFile('TEMPLATE'); // create a html file, named template case sentitive
  7.  
  8. var date = new Date();
  9.  
  10. //loop over each line
  11. for(var i = 1; i < data.length; i += 1) {
  12.  
  13. var status = data[i][1];
  14.  
  15. if(status != 'sent') {
  16.  
  17. html.message = data[i][0]; // Variable <?= message ?> on template
  18.  
  19. var template = html.evaluate().getContent();
  20.  
  21. MailApp.sendEmail({
  22. to: 'to_email@email.com',
  23. subject: 'Phrase here',
  24. htmlBody: template
  25. });
  26.  
  27. currentsheet.getRange(i+1, 2).setValue('sent');
  28. currentsheet.getRange(i+1, 3).setValue(date);
  29. break;
  30. }
  31. }
  32. }
  33. function onOpen() {
  34. var ss = SpreadsheetApp.getActiveSpreadsheet();
  35. ss.addMenu('Send email', [
  36. {name: 'Process emails', functionName: 'sendEmail'}
  37. ]);
  38.  
  39. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement