Advertisement
Rusfatal

google script for google drive files

Jan 28th, 2022
85
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.57 KB | None | 0 0
  1. function onLoad() {
  2. var ss=SpreadsheetApp.getActiveSpreadsheet();
  3. var s=ss.getActiveSheet();
  4. var c=s.getActiveCell();
  5. var fldr=DriveApp.getFolderById("1111_your_googledrive_folder_id_11111");
  6. var files=fldr.getFiles();
  7. var data=[],f,str;
  8. var ss = SpreadsheetApp.getActiveSheet();
  9. ss.clear();
  10. ss.appendRow(["Name", "Date", "Id","MimeType","Owner","Size","Url","Viewers"]);
  11. while (files.hasNext()) {
  12. f=files.next();
  13. data = [
  14. f.getName(),
  15. f.getDateCreated(),
  16. f.getId(),
  17. f.getMimeType(),
  18. f.getOwner(),
  19. f.getSize(),
  20. f.getUrl(),
  21. f.getViewers()
  22. ];
  23. ss.appendRow(data);
  24. }
  25. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement