添加权限时通知人员

Question

我使用这个脚本来添加编辑器权限:

function addEditor1() {     
const check = "done";
const ss = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet1"); // replace sheet name
const rows = ss.getRange('A2:B').getValues();
const ranges = rows.map((row, i) => {
if (row[1] && row[3] != check) {
DriveApp.getFileById(row[0]).addEditor(row[1]);
return `E${i + 2}`;
}
return "";
}).filter(String);
if (ranges.length == 0) return;
ss.getRangeList(ranges).setValue(check);
}

我想通知每个人，这样他就可以从他的电子邮件中获得链接并打开它

Answer 1

像这样

function addEditor1() {     
const check = "done";
const ss = SpreadsheetApp.getActive();
const sh = ss.getSheetByName("Sheet1"); // replace sheet name
const rows = sh.getRange('A2:D' + sh.getLastRow()).getValues();
const ranges = rows.map((row, i) => {
if (row[1] && row[3] != check) {
DriveApp.getFileById(row[0]).addEditor(row[1]);
GmailApp.sendEmail(row[1],"Subject","message");
return `E${i + 2}`;
}
return "";
}).filter(String);
if (ranges.length == 0) return;
sh.getRangeList(ranges).setValue(check);
}