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_IDketik berikut in ="https://drive.google.com/uc?export=download&id="&A2