function addemail() {
var sheet = SpreadsheetApp.getActiveSheet();
var firstRow = 2;
var lastRow = sheet.getLastRow();
for (i=firstRow; i<=lastRow; i++) {
if (sheet.getRange(i,6).getValue() == ''){
var email = sheet.getRange(i, 1).getValue();
var firstname = sheet.getRange(i, 2).getValue();
var lastname = sheet.getRange(i, 3).getValue();
var ou = sheet.getRange(i, 4).getValue();
var password = sheet.getRange(i, 5).getValue();
var user = {
primaryEmail: email,
name:{givenName: firstname, familyName: lastname},
password: password,
orgUnitPath: ou
};
user = AdminDirectory.Users.insert(user);
var timestamp = new Date();
sheet.getRange(i, 6).setValue(timestamp);
}
}
}