Copy button to copy the code snippet.
function sendEmailOnEdit(e) {
if (!e) return; // add this line to check if "e" is undefined
var sheet = e.source.getActiveSheet();
var sheetName = sheet.getName();
var recipients = "sharma.mohit@outrightcrm.com";
var subject = "Someone Edited a Google Sheet";
var body = "The Google Sheet named '" + sheetName + "' was edited.<br><br>";
// Get the user who made the edit
var user = Session.getActiveUser().getEmail();
// Get the range of the edited cell
var range = e.range;
var row = range.getRow();
var column = range.getColumn();
// Get the new value of the edited cell
var newValue = e.value;
// Construct the table header
var header = "<table style='border-collapse: collapse;'><tr><th style='border: 1px solid black; padding: 5px;'>User</th><th style='border: 1px solid black; padding: 5px;'>Row</th><th style='border: 1px solid black; padding: 5px;'>Column</th><th style='border: 1px solid black; padding: 5px;'>Value</th><th style='border: 1px solid black; padding: 5px;'>Date/Time</th></tr>";
// Construct the table row
var row = "<tr><td style='border: 1px solid black; padding: 5px;'>" + user + "</td><td style='border: 1px solid black; padding: 5px;'>" + row + "</td><td style='border: 1px solid black; padding: 5px;'>" + column + "</td><td style='border: 1px solid black; padding: 5px;'>" + newValue + "</td><td style='border: 1px solid black; padding: 5px;'>" + new Date().toLocaleString() + "</td></tr>";
// Close the table
var footer = "</table>";
// Combine the header, row, and footer to create the body of the email
body += "The following change was made to the sheet:<br><br>" + header + row + footer;
// Send the email
MailApp.sendEmail(recipients, subject, "", {htmlBody: body});
}