Google Sheet logs new hires and sends notification emails when the final cell updates. ‘Undefined’ appears. Check the revised code snippet below:
function sendNewHireAlert() {
var book = SpreadsheetApp.getActiveSpreadsheet();
var activeSheet = book.getActiveSheet();
var cell = activeSheet.getActiveCell();
var rowIndex = cell.getRow();
var lastColumn = activeSheet.getLastColumn();
if (activeSheet.getName() === "EmployeeList" && cell.getColumn() === lastColumn) {
var entry = activeSheet.getRange(rowIndex, 1, 1, lastColumn).getValues()[0];
var recipient = "[email protected]";
var mailSubject = "New Employee: " + entry[0] + " " + entry[1];
var mailBody = "Title: " + entry[2] + "\nDept: " + entry[3] + "\nRow: " + rowIndex;
MailApp.sendEmail(recipient, mailSubject, mailBody);
}
}
In my experience, the undefined error can also be the result of using getActiveCell which sometimes returns a cell that isn’t part of the recently updated data range when the script is triggered by a programmatic change. I replaced it with a method to fetch the modified row directly, ensuring that I was referencing the correct cells. I also added explicit checks for cell content to verify that all required fields were populated before constructing the email. This approach proved more reliable and helped resolve similar issues I encountered.
In my experience, the undefined error you are seeing could be due to unexpected data not being fetched properly from the sheet. When I encountered a similar problem, I added a verification step immediately after retrieving the row data to ensure that each value was properly defined before it was used to build the email content. Adding logging allowed me to confirm that all expected data existed and revealed that some cells contained blank values. This extra check helped isolate the issue, and then I added conditional logic to handle incomplete rows robustly, thus ensuring that emails were sent only when complete information was available.
hey, i switched to using onEdit(e) and then checking if each cell is defined before sendin the mail. this approach stopped the undefined msg for me. maybe try using the event object instead of getActiveCell for more consistent results.
hey, i had the same issue. check if the active cell isn’t empty before sending the email. sometimes google sheets returns a blank value causing that undefined error. hope that helps