Receiving duplicate emails with sendEmail()

Vote count:

0

I tried both MailApp.sendEmail() and GmailApp.sendEmail() to send an email confirmation from onFormSubmit and ending up with multiple duplicate emails (as many as 6). The code looks like this:

function sendEmailConf_(ss, email, session) {
  Logger.log("sendEmailConf_ email: %s for session: %s", email, session);
  var formUrl = ss.getFormUrl();             // Use form attached to sheet
  var form = FormApp.openByUrl(formUrl);
  var formResponses = form.getResponses();
  Logger.log("Count of form responses: %s", formResponses.length);
  for (var i = 0; i < formResponses.length; i++) {
    if (formResponses[i].getRespondentEmail() == email) {
      Logger.log("Sending email to: %s for session: %s", email, session[0]);
      GmailApp.sendEmail(
        email,
        'Confirmation for registration of: ' + session[0] + ', ' + getSessionSchedStr(session),
        ('Thanks for registering!\n\n' + getResponseAsText(formResponses[i]) + '\n\n' +
               'You may change your response using this URL: ' + formResponses[i].getEditResponseUrl())
      );
    }
  }
}

Using script transcript and log statements, I confirmed that sendEmail() is getting called only once and that the email is a string with single email address in it. The emails I receive have exactly the same body and are received at the same time and they all have the same from and to addresses (both mine, since I am testing it). Anybody has a clue on what is going wrong here?

asked 28 secs ago

haridsv

1,591

Receiving duplicate emails with sendEmail()