Export Additional Report to Email

I am having no success in exporting an additional report via email from HTML.

I follow the instructions on the tutorial https://atomisystems.com/elearning/send-quiz-report-google-sheets-email/ - but i don’t receive anything after simulating the course.

Hi Stephen,

Please go to Script editor then change my email to your own:
var TO_ADDRESS = "namnt@atomisystems.com"; // Email to receive the report data

Regards,

Hi Nam
I have done that several times with no success.
The course ends aand I dont get the email.

Hi,

After change the email, you need to publish the app again. To summarize, you need:

  1. Clone my Google Sheet documents.
  2. Go to Script editor, then change the email.
  3. Publish the app.

Regards,

Thanks Nam
It is working.
Kind regards

Hi Nam
One more thing.
Can I use the same script for XML format?
Or do I need to change it?

Hi Stephen,

Yes, you can use that scripts for XML format. However, you have to remove the code that inserting data into Google Sheet document, just only keep the code that sending email. So, please remove the following code in the scripts:

// Insert report data to Google Sheets
var doc     = SpreadsheetApp.getActiveSpreadsheet();
var sheet   = doc.getSheets()[0]; // get the first sheet
var headers = sheet.getRange(1, 1, 1, sheet.getLastColumn()).getValues()[0];
var nextRow = sheet.getLastRow()+1; // get next row
var row     = [ new Date() ];
// loop through the header columns
for (var i = 1; i < headers.length; i++) { // start at 1 to avoid Timestamp column
  if(headers[i].length > 0) {
    row.push(JSON.stringify(report[headers[i]])); // add data to row
  }
}

You need to re-publish the app after that.

Regards,

Hi Nam
Thanks again for your help
Regards

1 Like