Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function onLoad() {
- var ss=SpreadsheetApp.getActiveSpreadsheet();
- var s=ss.getActiveSheet();
- var c=s.getActiveCell();
- var fldr=DriveApp.getFolderById("1111_your_googledrive_folder_id_11111");
- var files=fldr.getFiles();
- var data=[],f,str;
- var ss = SpreadsheetApp.getActiveSheet();
- ss.clear();
- ss.appendRow(["Name", "Date", "Id","MimeType","Owner","Size","Url","Viewers"]);
- while (files.hasNext()) {
- f=files.next();
- data = [
- f.getName(),
- f.getDateCreated(),
- f.getId(),
- f.getMimeType(),
- f.getOwner(),
- f.getSize(),
- f.getUrl(),
- f.getViewers()
- ];
- ss.appendRow(data);
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement