K12 Conference

Creating Self Correcting Quiz Using Google Forms

Steps before watching this video.
1) Create A Google Account
3) Create A New Spreadsheet
4) Follow Steps In Video To Create Your Test.

(Note: you must be logged into you Google Account.)
Link to the Template



Copy The Following Code

function sendEmails() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheets()[5];
  var startRow = 1;  // First row of data to process
  var numRows = 1;   // Number of rows to process
  // Fetch the range of cells A1:D1
  var dataRange = sheet.getRange(startRow, 1, numRows, 5)
  // Fetch values for each row in the Range.
  var data = dataRange.getValues();
  for (i in data) {
    var row = data[i];
    var emailAddress = row[1];  // First column
    var subject = row[2];         // Second column
    var message = row[3];       // Third column
    MailApp.sendEmail(emailAddress, subject, message);
  }
}