Membaca dan Menulis Cell dengan SpreadsheetApp

function bacaSatuCell() {
  const sheet = SpreadsheetApp.getActiveSheet();
  const nilai = sheet.getRange('A1').getValue();
  Logger.log('Isi A1: ' + nilai);
}

function bacaBlok() {
  const sheet = SpreadsheetApp.getActiveSheet();
  const data = sheet.getRange('A2:C10').getValues(); // array 2D
  data.forEach(function (baris, i) {
    Logger.log('Baris ' + (i + 1) + ': ' + baris.join(' | '));
  });
}

function tulisBalik() {
  const sheet = SpreadsheetApp.getActiveSheet();
  sheet.getRange('D1').setValue('Total');

  const hasil = [
    ['Budi', 100],
    ['Sari', 150]
  ];
  sheet.getRange('D2:E3').setValues(hasil);
}