Laporan Otomatis & Kirim ke Diri Sendiri

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

  const total = data.reduce((sum, r) => sum + (r[2] || 0), 0);
  const count = data.length;

  const isi = 'Laporan Harian\n' +
              'Jumlah transaksi: ' + count + '\n' +
              'Total nilai: Rp ' + total.toLocaleString('id-ID');

  GmailApp.sendEmail(
    Session.getActiveUser().getEmail(),
    'Laporan Harian ' + new Date().toLocaleDateString('id-ID'),
    isi
  );
}

function pasangJadwal() {
  ScriptApp.newTrigger('kirimLaporanHarian')
    .timeBased()
    .everyDays(1)
    .atHour(8)
    .create();
}

const html = '<h2>Laporan Harian</h2>' +
             '<p>Transaksi: <b>' + count + '</b></p>';

GmailApp.sendEmail(email, subjek, '', { htmlBody: html });