Lampiran & Draf Email Otomatis

function kirimDenganLampiran() {
  const file = DriveApp.getFileById('ID_FILE_DRIVE');
  GmailApp.sendEmail(
    'orang@contoh.com',
    'Dokumen penting',
    'Berikut lampirannya.',
    { attachments: [file.getAs(MimeType.PDF)] }
  );
}

const files = ['ID1', 'ID2'].map((id) => DriveApp.getFileById(id));
GmailApp.sendEmail(email, subjek, isi, { attachments: files });

function buatDrafMassal() {
  const sheet = SpreadsheetApp.getActiveSheet();
  const data = sheet.getDataRange().getValues().slice(1);

  data.forEach(([nama, email]) => {
    if (!email) return;
    GmailApp.createDraft(
      email,
      'Follow-up untuk ' + nama,
      'Hai ' + nama + ', ada kelanjutan dari diskusi kita.'
    );
  });
}

const file = DriveApp.getFileById('ID_FILE');
GmailApp.createDraft(email, subjek, isi, { attachments: [file] });