Trigger google sheet export and email when cell value changed to equal a value

[Trent Magis]

I am trying to write a script that will automatically export the Google Sheet to a PDF and then email it when the user enters a specific value into a specific cell.  In this case, if the user enters "Yes" into cell G1, then I want the sheet to be exported as a PDF based on the name of the sheet (Jan, Feb, Mar, etc) into a Google Folder and also email the PDF.  

This is the script I have so far, but it is not exporting/emailing the Google Sheet - NOTE - I changed the actual Google Sheet and Folder ID to generic text to not share sensitive info, this is not the reason why it is not working.

Any help you can offer is greatly appreciated.

function onEdit(e){
    if(e.range.getA1Notation() == "G1") {
       return;
      var value = e.SpreadsheetApp.getActiveSpreadsheet().getActiveSheet().getRange('G1').getValue();  
     }
  if (e.value() == "Yes");
  exportAndSend ();
 
}
function exportAndSend () {
  var month = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet().getName();
  var coachName = " CoachName ";
  var pdfName = coachName + month + " 2022 Mileage";
 
  let mileage = DriveApp.getFileById('GoogleSheet ID');
  let blob = mileage.getAs('application/pdf');
  let pdf = DriveApp.getFolderById('CoachFolder ID')
  .createFile(blob)
  .setName(pdfName);
 
  sendEmail_(pdf);
  }
 
function sendEmail_(pdf) {
  var month = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet().getName();
  var coachName = " CoachName ";
  var pdfName = coachName + month + " 2022 Mileage";
  GmailApp.sendEmail('em...@gmail.com', coachName + month + " Mileage", "Mileage for " + month + "2022", {
                       attachments: [pdf]
                       });
  }

                       

[Laurie J. Nason]

I think that your if statement in the onEdit function below should be:

if (e.value() == "Yes”){
  exportAndSend ();

}

------ Original Message ------

From "Trent Magis" <trent...@qicreative.com>

To "Google Apps Script Community" <google-apps-sc...@googlegroups.com>

Date 17/06/2022 22:03:57

Subject [Apps-Script] Trigger google sheet export and email when cell value changed to equal a value

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/ceb05d13-090e-4c17-8412-49d5219b4984n%40googlegroups.com.

[Martin Molloy]

Line 3 of your onEdit function is a return. ie it stops at that point if the active cell is G1

--

[Laurie J. Nason]

Oh - yeah - that won’t help either! :-)

The KAUST School – Operational Analyst

Information Technology Support

Landline: +966-12-808-6853

Mobile: +966-54-564-3698

------ Original Message ------

From "Martin Molloy" <martin...@mtmomk.co.uk>

To google-apps-sc...@googlegroups.com

Date 19/06/2022 10:16:19

Subject Re: [Apps-Script] Trigger google sheet export and email when cell value changed to equal a value

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CAO8s2Ph6n54WbVJhu-ksoqaRJvmVDYUv%2BEUuzNMZza2WPgoRog%40mail.gmail.com.

[Витя Коледа]

вс, 19 июн. 2022 г., 18:25 Laurie J. Nason <laurie...@thekaustschool.org>:

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/embb4bc088-5f5b-4afe-bbf6-9040a5f13b6d%405ba8057e.com.