Advertisement
Guest User

Untitled

a guest
Sep 29th, 2016
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.40 KB | None | 0 0
  1. var ss = SpreadsheetApp.getActiveSpreadsheet();
  2. var sheet = ss.getActiveSheet();
  3.  
  4. var email = "xxx@gmail.com";
  5.  
  6. var timezone = ss.getSpreadsheetTimeZone();
  7.  
  8. var today = new Date();
  9. var oneDayAgo = new Date(today.getTime() - 1 * 24 * 60 * 60 * 1000);
  10. var startTime = oneDayAgo.toISOString();
  11.  
  12. var search = '(trashed = false or trashed = false) and (modifiedDate > "' + startTime + '")';
  13. var folder1 = DriveApp.getFoldersByName('SaveToPDF').next();
  14. var files1 = folder1.searchFiles(search);
  15.  
  16. var row = "", count=0;
  17.  
  18. while( files1.hasNext() ) {
  19.  
  20. var file1 = files1.next();
  21.  
  22. var fileName = file1.getName();
  23. var fileURL = file1.getUrl();
  24. var lastUpdated = Utilities.formatDate(file1.getLastUpdated(), timezone, "yyyy-MM-dd HH:mm");
  25. var dateCreated = Utilities.formatDate(file1.getDateCreated(), timezone, "yyyy-MM-dd HH:mm")
  26.  
  27. row += "<li>" + lastUpdated + " <a href='" + fileURL + "'>" + fileName + "</a></li>";
  28.  
  29. sheet.appendRow([dateCreated, lastUpdated, fileName, fileURL]);
  30.  
  31. count++;
  32. }
  33. if (row !== "") {
  34. row = "<p>" + count + " file(s) have changed in your Google Drive in the past 24 hours. Here's the list:</p><ol>" + row + "</ol>";
  35. row += "<br><small>To stop these notifications, please <a href='" + ss.getUrl() + "'>click here</a> and choose <em>Uninstall</em> from the Drive Activity menu.<br/></small>";
  36. MailApp.sendEmail(email, "Google Drive - File Activity Report", "", {htmlBody: row, cc: "xxx@gmail.com"} );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement