Cộng đồng Hỏi & Đáp của Inflearn

안녕하세요 정우님.

신규 입사자 코드 첨부합니다.

function myFunction() {
  const sheets = SpreadsheetApp.getActiveSpreadsheet();
  const list = sheets.getSheetByName('list');

  const lastRowNo = list.getLastRow();

  const folderId = '폴더 ID';
  const folder = DriveApp.getFolderById(folderId);
  const files = folder.getFiles();
  const fileMap = new Map();
  const inlineImages = {};
  while (files.hasNext()) {
    let file = files.next();
    const flieName = file.getName();
    fileMap.set(flieName, file);
    inlineImages[flieName] = file;
  }

  const imageFile = DriveApp.getFileById('파일 ID');
  inlineImages['megaphone'] = imageFile;

  let allMembers = [];
  for (let i = 2; i < lastRowNo + 1; i++) {
    const name = list.getRange(i, 1).getValue();
    const division = list.getRange(i, 2).getValue();
    const department = list.getRange(i, 3).getValue();
    const team = list.getRange(i, 4).getValue();
    const link = list.getRange(i, 5).getValue();
    const profile = list.getRange(i, 6).getValue();
    let memberInfo = { name, division, department, team, link };
    if (fileMap.has(profile) === true) {
      memberInfo.img = `cid:${profile}`;
    }
    allMembers.push(memberInfo);
  }

  const reduceMembers = allMembers.reduce((acc, cur)=> {
    const index = acc.findIndex(f => f.division === cur.division);
    if (index === -1) {
      // 기존에 없는 부문이므로 새로 추가
      const newDivision = {
        division: cur.division,
        members: [{...cur}],
      }
      return [...acc, newDivision];
    }
    // 이미 있는 부분
    const prevData = {...acc[index]};
    prevData.members.push({...cur});
    const updateArr = [...acc];
    updateArr[index] = prevData;
    return updateArr;
  }, []);

  const htmlFile = HtmlService.createTemplateFromFile('email');
  htmlFile.data = reduceMembers;
  const htmlBody = htmlFile.evaluate().getContent();

  MailApp.sendEmail({
    to: '본인 이메일 주소',
    subject: '신규입사자 소개합니다',
    htmlBody,
    inlineImages,
  });
}