Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- var ss = SpreadsheetApp.getActiveSpreadsheet();
- var sheet = ss.getActiveSheet();
- var email = "xxx@gmail.com";
- var timezone = ss.getSpreadsheetTimeZone();
- var today = new Date();
- var oneDayAgo = new Date(today.getTime() - 1 * 24 * 60 * 60 * 1000);
- var startTime = oneDayAgo.toISOString();
- var search = '(trashed = false or trashed = false) and (modifiedDate > "' + startTime + '")';
- var folder1 = DriveApp.getFoldersByName('SaveToPDF').next();
- var files1 = folder1.searchFiles(search);
- var row = "", count=0;
- while( files1.hasNext() ) {
- var file1 = files1.next();
- var fileName = file1.getName();
- var fileURL = file1.getUrl();
- var lastUpdated = Utilities.formatDate(file1.getLastUpdated(), timezone, "yyyy-MM-dd HH:mm");
- var dateCreated = Utilities.formatDate(file1.getDateCreated(), timezone, "yyyy-MM-dd HH:mm")
- row += "<li>" + lastUpdated + " <a href='" + fileURL + "'>" + fileName + "</a></li>";
- sheet.appendRow([dateCreated, lastUpdated, fileName, fileURL]);
- count++;
- }
- if (row !== "") {
- row = "<p>" + count + " file(s) have changed in your Google Drive in the past 24 hours. Here's the list:</p><ol>" + row + "</ol>";
- 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>";
- MailApp.sendEmail(email, "Google Drive - File Activity Report", "", {htmlBody: row, cc: "xxx@gmail.com"} );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement