IssueTracker

Before opening a new issue, please search for other related issues, click the ★ to subscribe to updates, and click +1 to vote.

Description

I am getting the following error on my "on edit" trigger: We're sorry, a server error occurred while reading from storage. Error code INTERNAL.

Code

function newClient() { var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); var dataRange = sheet.getDataRange(); var data = dataRange.getValues(); var sheetUrl = SpreadsheetApp.getActiveSpreadsheet().getUrl();

for (var i = 3; i < data.length; i++) { // Start from row 4 to skip headers var status = data[i][9]; // Column J (index 9) var emailSent = data[i][10]; // Column K (index 10) - Check if email has been sent for this row

if (status === true && emailSent !== "SENT") {
  var columnAValue = data[i][0]; // Column A (index 0)
  var columnBValue = data[i][1]; // Column B (index 1)
  var recipient = "support@oneswitchboard.com"; // specifically send it to us
  var subject = "New Email Account Requested: " + columnAValue;
  var message = "The following organization has indicated they want to setup a new email account: \n\n";
  message += "Domain: " + columnAValue + " (Email - " + columnBValue + ") \n";
  message += "Link to Onboarding Sheet: " + sheetUrl
  // Send the email
  MailApp.sendEmail(recipient, subject, message);
  
  sheet.getRange(i + 1, 11).setValue("SENT"); // Row i+1, Column N (index 16)
}
// No need for an else block, you can add other conditions or code here if necessary

} }

Output

It should send me an email with information from my spreadsheet whenever certin columns are edited

Steps