Copy button to copy the code snippet.function sendEmailOnEdit(e) {
if (!e) return;
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. ";
// 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;
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 rowHtml = "<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>";
var footer = "</table>";
document.getElementById("output").innerHTML = header + rowHtml + footer;
}