dat4 03

 MENCARI  FILE ID DAN NAMA FILE DI GOOGLE DRIVE

function MencariID() {

var ss=SpreadsheetApp.getActiveSpreadsheet(); var s=ss.getActiveSheet(); var c=s.getRange("a1"); var fldr=DriveApp.getFolderById("=== ID Folder ==="); var files=fldr.getFiles(); var names=[],f,str; while (files.hasNext()) { f=files.next(); str = f.getId(); names.push([str]); } s.getRange(c.getRow(),c.getColumn(),names.length).setFormulas(names); } function MencariNama() { var ss=SpreadsheetApp.getActiveSpreadsheet(); var s=ss.getActiveSheet(); var c=s.getRange("b1"); var fldr=DriveApp.getFolderById("=== ID Folder ==="); var files=fldr.getFiles(); var names=[],f,str; while (files.hasNext()) { f=files.next(); str = f.getName(); names.push([str]); } s.getRange(c.getRow(),c.getColumn(),names.length).setFormulas(names); } Auto Download = ##https://drive.google.com/uc?export=download&id=FILE_ID

ketik  berikut in ="https://drive.google.com/uc?export=download&id="&A2