Guest User

onEdit sendEmail script

a guest
Apr 12th, 2021
902
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.80 KB | None | 0 0
  1. function sendEmail() {
  2. var checkboxRange = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet1").getRange("A1");
  3. var checkbox = checkboxRange.getValue();
  4. // Check checkbox is checked
  5. if (checkboxRange.isChecked()){
  6. // Fetch the email address
  7. var emailRange = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet1").getRange("B1");
  8. var emailAddress = emailRange.getValue();
  9. // Send Alert Email.
  10. var message = 'ENTER YOUR EMAIL MESSAGE HERE'; // Second column
  11. var subject = 'ENTER YOUR EMAIL SUBJECT HERE';
  12. MailApp.sendEmail(emailAddress, subject, message);
  13. }
  14. };
  15.  
  16. function onEdit(e) {
  17.  
  18. var ss = SpreadsheetApp.getActiveSheet();
  19. var r = ss.getActiveCell();
  20. if(r.getColumn() == 1 && ss.getName() == 'Sheet1') {
  21. sendEmail();
  22. }
  23. };
Advertisement
Add Comment
Please, Sign In to add comment