7 ms·
Can u share a dummy script? That would be nice.
by ant6n 4y ago
Can u share a dummy script? That would be nice.
- notRobot 4y agoSeconded, this sounds really handy!
- rahimnathwani 4y agoSure. Here's a view-only copy of the spreadsheet: https://docs.google.com/spreadsheets/d/1kJVja4xo6GG-SanHvqYjMGsfQ0V-InXJrwcsiluURAE/edit#gid=0 https://docs.google.com/spreadsheets/d/1kJVja4xo6GG-SanHvqYj... Note the formula in column H, which generates TRUE/FALSE. You can obviously replace this logic with whatever you want. I set a daily 8am trigger to run this script, which sends notifications for the rows that are marked TRUE: function sendReminderEmails() { var sheet = SpreadsheetApp.getActiveSheet(); sheet.getRange('B1').setValue(""); SpreadsheetApp.flush(); sheet.getRange('B1').setValue("=TODAY()"); SpreadsheetApp.flush(); var headerrows = 3; var numColumns = 8; var subjectColumn = 1; // one-based, i.e. column A is 1, B is 2 etc. var addressColumn = 2; var conditionColumn = 8; var startRow = 1 + headerrows; // First row of data to process var numRows = sheet.getLastRow()-headerrows; // Number of rows to process var dataRange = sheet.getRange(startRow, 1, numRows, numColumns); var data = dataRange.getValues(); for (var i in data) { var row = data[i]; if (row[conditionColumn-1]) { var emailAddress = row[addressColumn-1]; var message = 'Reminder: ' + row[subjectColumn-1]; var subject = message; MailApp.sendEmail(emailAddress, subject, message); } } }
- notRobot 4y agoThanks!