function replacePending(){
var flag = 0;
var range = SpreadsheetApp.getActiveSheet().getRange("F:F");
var values = range.getValues();
for (var i = 0; i < values.length; i++) {
if (values[i][0] === "PendingForSend" && values[i][0]!="") {
values[i][0] = 'Sent';
flag = 1;
}
}
range.setValues(values);
return flag;
}
function createTable(data){
var cells = [];
var table = '
| Page Name | Page Link | Edited By | Date & Time |
|---|
';
for (var i = 0; i < data.length; i++){
cells = data[i];
table = table + "";
for (var u = 0; u < cells.length; u++){
table = table + "| "+ cells[u] +" | ";
}
table = table + "
"
}
table=table+"
";
return table;
}
function send(data){
const admins = ""; /*Don't forget to specify an email id here. Emails will be sent on these mail id. You can set multiple comma-seperated values like ->
youradmin@domain.com, yoursecondadmin@domain.com
*/
var today = new Date();
var dd = String(today.getDate()).padStart(2, '0');
var mm = String(today.getMonth() + 1).padStart(2, '0'); //January is 0!
var yyyy = today.getFullYear();
today = dd + '/' + mm + '/' + yyyy;
GmailApp.sendEmail(admins, 'WordPress Sites Page Updates - '+today,'',{ htmlBody: createTable(data)});
}
function create_logs() {
var rows = SpreadsheetApp.getActiveSheet().getDataRange().getValues();
const data = new Array();
rows.forEach(function(row, index) {
if (row[5]=="PendingForSend") {
row.splice(2,1);
row.pop();
data.push(row);
}
});
if(replacePending() == 1){
send(data);
}
}
create_logs();