Google Apps Script Note Generator from Sheets

makeNotes.js

function createNotesDoc() {
  var sheet = SpreadsheetApp.getActiveSheet();
  var data = sheet.getDataRange().getValues();
  var lastrow = data.length - 1;

  // Static data
  var date = data[lastrow][0];
  var name = data[lastrow][1];
  var attendees = data[lastrow][2];
  var zoomLink = data[lastrow][3];
  var zoomID = data[lastrow][4];
  var zoomPass = data[lastrow][5];

  var doc = DocumentApp.create(name.toString());
  var body = doc.getBody();
  var style = {};
  style[DocumentApp.Attribute.FONT_SIZE] = 16;

  body.appendParagraph('Date: ' + date).setAttributes(style);

  body.insertParagraph(0, doc.getName())
      .setHeading(DocumentApp.ParagraphHeading.HEADING1);

  //Static data
  body.appendParagraph('Attendees: ' + attendees).setAttributes(style);
  body.appendPageBreak();
  body.appendParagraph('Zoom Link: ' + zoomLink).setAttributes(style);
  body.appendPageBreak();
  body.appendParagraph('Zoom ID: ' + zoomID).setAttributes(style);
  body.appendPageBreak();
  body.appendParagraph('Zoom Pass: ' + zoomPass).setAttributes(style);

  var files = DriveApp.getFilesByName(doc.getName());
  while (files.hasNext()) {
    // Static
    var folders = DriveApp.getFoldersByName('Folder Name');
    while (folders.hasNext()) {
      var folder = folders.next();
      var file = files.next();
      file.moveTo(folder);
      var lr = lastrow + 1;
      // Static data
      sheet.getRange('g' + lr).setValue(file.getUrl());

    }
  }
} 

function onOpen() { 
  var ui = SpreadsheetApp.getUi();
  
  ui.createMenu("Auto Trigger")
    .addItem("Run","createNotesDoc")
    .addToUi();
}