Google Script Downlod File

script-download-file.gs

# Script untuk download file dari URL yang terdapat di spreadsheet

# contoh spreadsheet

# Link   | Folder   | Status
# ...mp4 | Ultraman | {biarkan kosong} 

function downloadPrimary() {
  let sheet = SpreadsheetApp.openById("SPREAD_SHEET_ID_KALIAN").getActiveSheet();
  let lastRow = sheet.getLastRow();
  
  # format penyimpanan {parentFolder}/{newFolder}
  let parentFolder = DriveApp.getFolderById("FOLDER_ID_KALIAN"); # bisa gunakan getFolderByName
  
  # looping semua row yang terdapat pada sheet
  for (let i = 0; i < lastRow-1; i++) {
    if (sheet.getRange(2+i, 3).getValue() != "done") {
      # ambil nama folder dari row 2 column 2 dan seterusnya
      var saveFolder;
      let nameFolder = sheet.getRange(2+i, 2).getValue();
      
      # pengecekan jika folder sudah/belum ada
      try {
          saveFolder = parentFolder.getFoldersByName(nameFolder).next();
      } catch (e) {
          saveFolder = parentFolder.createFolder(nameFolder);
      }
      
      # save file ke folder
      let url = sheet.getRange(2+i, 1).getValue();
      let blob = UrlFetchApp.fetch(url).getBlob();
      saveFolder.createFile(blob);
      
      # update status menjadi done
      sheet.getRange(2+i, 3).setValue("done");
    }
  }
}