Gmailを条件検索して、その情報をSSに書き出してmailでお知らせ

function getMessages() {

  const ss = SpreadsheetApp.getActiveSpreadsheet();

  const sheet = ss.getSheetByName('シート1');

  sheet.clear();

  //maxスレッドまでconditionを探す

  const condition = 'pdf';   //検索文字

  const start = 0;

  const max = 100;

  let threads = GmailApp.search(condition,start,max);

  let messages =GmailApp.getMessagesForThreads(threads);

  //シートに日時、送信元、件名、本文を書きだす

  for (let i = 0; i < threads.length; i++) {

    messages = threads[i].getMessages();

    message = messages[0];

    console.log(message.getFrom());

    rowNumber = i + 2;

    sheet.getRange(rowNumber, 1).setValue(message.getDate());

    sheet.getRange(rowNumber, 3).setValue(message.getFrom());

    sheet.getRange(rowNumber, 5).setValue(message.getSubject());

    sheet.getRange(rowNumber, 4).setValue(message.getPlainBody());

  }

  //行の高さを揃えるsetRowHeightsForced(startRow, numRows, height)

  sheet.setRowHeightsForced(2,threads.length, 50);

  sendEmail();

}

function sendEmail() {

  let to = "@gmail.com";

  let subject = "テスト件名";

  let body = "メール一覧が更新されました。";

  let options = {from: "@gmail.com"};

  GmailApp.sendEmail(to, subject, body, options);

}