'Google App Script, highlight new users since last month
I made a little function to retrieve the users we have on Google Workspace, and made a cron for this list to be refreshed once a month.
What I'd like to do now is to highlight cells of the new users created last month, but I didn't find a proper way to do it yet.
ie. next execution planned will be the 1st of June, I would need all accounts created in May to be highlighted
Any hint ?
My current code looks like this :
function listAllUsers() {
var sh = '-- my sheet id --';
var sheet = SpreadsheetApp.openById(sh);
var sheet1 = sheet.getSheetByName('sheet title');
var sheet1range = sheet.getRange("A:H")
sheet1range.clear()
var data = [];
data.push(['Email' ,'First Name', 'Last Name', 'Suspended', 'Last Login Time','Creation', '2FA Active', 'Is admin']);
var pageToken, page;
do {
page = AdminDirectory.Users.list({
domain: '-- my domain --',
pageToken: pageToken
});
var users = page.users;
if (users) {
for (var i = 0; i < users.length; i++) {
var user = users[i];
data.push([user.primaryEmail, user.name.givenName, user.name.familyName, user.suspended, user.lastLoginTime , user.creationTime, user.isEnrolledIn2Sv, user.isAdmin ]);
}
} else {
Logger.log('No users found.');
}
pageToken = page.nextPageToken;
} while (pageToken);
sheet1.getRange(1,1,data.length,data[0].length).setValues(data);
var dated = sheet.getRange("P1")
dated.setValue(Utilities.formatDate(new Date(),Session.getScriptTimeZone(),'dd-MMM-yyy'));
}
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
