CODEWITHSUNDEEP
google-apps-scriptgoogle-sheetsweb-applications
LoganM
LoganM

Reputation: 21

Converting local GmailApp.sendEmail (GAS) to Web App script

I have a working Google apps script set up to send an automated email (GmailApp.sendEmail) when I click a button in the workbook.

However, I am trying to convert the script to Google Web App so that any users within my organization will have authorization to run the script and trigger the automated email by pressing the button.

I'm a little lost on how to adapt the local code from getui(). I know that I need to add a function such as doget(e) and deploy as a web app, but I'm not well-versed enough in Web App to edit the code.

Here is my working local code:

// This constant is written in column E for rows for which an email
// has been sent successfully.
var EMAIL_SENT = 'E-MAIL SENT';
var ui = SpreadsheetApp.getUi();

/**
 * Sends non-duplicate emails with data from the current spreadsheet.
 */
function email(){
  var rng = SpreadsheetApp.getActiveSheet().getRange('A2:F2')
  var checkvalue = SpreadsheetApp.getActiveSheet().getRange('E2').getValue();
  var email = rng.getValues()[0];
  var data = rng.getValues();
  for (var i = 0; i < data.length; ++i) {
  var row = data[i];
  var emailSent = checkvalue; // emailSent confirmation cell
  if (emailSent != EMAIL_SENT) { // Prevents sending duplicates
  GmailApp.sendEmail(email[0], email[1], email[2]);
  SpreadsheetApp.getActiveSheet().getRange('E2').setValue(EMAIL_SENT);
      // Make sure the cell is updated right away in case the script is interrupted
      SpreadsheetApp.flush();
  }
 }
}

Any help is much appreciated!

Upvotes: 1

Views: 125

Answers (1)

Cooper
Cooper

Reputation: 64120

Try this:

Code.gs:

function email(){
  var ss=SpreadsheetApp.openById("SpreadsheetId");//need spreadsheet id
  var sh=ss.getSheetByName("SheetName");//when you open up a spreadsheet like this the active sheet is alway ss.getSheets()[0] the left most sheet so you should user get sheet by name instead.
  var rg=sh.getRange('A2:F2');
  var email=rg.getValues()[0];
  if (email[4]!="EMAIL_SENT") { 
  GmailApp.sendEmail(email[0], email[1], email[2]);
  sh.getRange('E2').setValue("EMAIL_SENT");
  }
}

function doGet() {
  return HtmlService.createHtmlOutputFromFile('html filename without extension');
}

html:

<!DOCTYPE html>
<html>
  <head>
  <base target="_top">
  </head>
<body>
  <input type="button" value="Send" onClick="google.script.run.email();" />
</body>
</html>

Client to Server Communication

Upvotes: 1

Related Questions