Self Correcting Quiz
Steps before watching this video.
3) Create A New Spreadsheet
4) Follow Steps In Video To Create Your Test.
Click this LINK for a copy of the template.
(Note: you must be logged into you Google Account.)
Link to the Template
For more help: Google Spreadsheet Function List
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);
}
}