javascript
1function onEdit(e) {
2 const sheet = e.range.getSheet();
3 const c = e.range.getColumn();
4 const header = sheet.getRange(1,c).getValue();
5 const targetHeaders = ["入居日", "退去日"];
6 if(targetHeaders.indexOf(header) < 0) return;
7 const spreadsheet = e.source;
8 const spreadsheetName = spreadsheet.getName();
9 const sheetName = sheet.getName();
10 const r = e.range.getRow();
11 const value = e.value || ">>削除<<";
12 const oldValue = e.oldValue;
13 const to = "me@gmail.com";
14 const subject = spreadsheetName+"の"+sheetName+"シートの"+header+"が更新されました";
15 const body = [spreadsheet.getUrl(),r+"行目の"+header+"が更新されました", oldValue+"が"+value+"となりました"].join("¥n");
16 MailApp.sendMail(to, subject, body);
17}