The Drive Activity Report tracks changes to the files and documents in your Google Drive and send the list in an email every midnight. It also logs the changes in a Google Sheet.
It internally uses the DriveApp.search() method to find these files that have the modifiedDate property greater than the 24 hour period.
function driveActivityReport() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getActiveSheet();
// Get the spreadsheet time zone
var timezone = ss.getSpreadsheetTimeZone();
// Find files modified in the last 24 hours
var today = new Date();
var oneDayAgo = new Date(today.getTime() - 1 * 24 * 60 * 60 * 1000);
var startTime = oneDayAgo.toISOString();
// The magic search expression
var search = '(trashed = true or trashed = false) and (modifiedDate > "' + startTime + '")';
var files = DriveApp.searchFiles(search);
// Loop through all the files in the search results
while (files.hasNext()) {
var file = files.next();
var fileName = file.getName();
var fileURL = file.getUrl();
var dateCreated = Utilities.formatDate(file.getDateCreated(), timezone, 'yyyy-MM-dd HH:mm');
sheet.appendRow([dateCreated, fileName, fileURL]);
}
}