Koleksi File

 

https://lookerstudio.google.com/reporting/9818712a-4253-4bc3-b3cd-71295fcacac9

https://docs.google.com/spreadsheets/d/1J9HHF8RZVOa25y7gU8FQbVRXIFgSXI6nNYGfVNyFrxc/edit?gid=0#gid=0

Code.gs

function getlinkfile() {
var ss=SpreadsheetApp.getActiveSpreadsheet();
var s=ss.getActiveSheet();
var c=s.getRange("a1");
var fldr=DriveApp.getFolderById("<idfolder>");
var files=fldr.getFiles();
var names=[],f,str; 
while (files.hasNext()) {
f=files.next();
str=f.getUrl();
names.push([str]);
}
s.getRange(c.getRow(),c.getColumn(),names.length).setFormulas(names); }

function getnamefile() {
var ss=SpreadsheetApp.getActiveSpreadsheet();
var s=ss.getActiveSheet();
var c=s.getRange("b1");
var fldr=DriveApp.getFolderById("<idfolder>");
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); }