Gianguyen1234

function sendPersonalizedEmails() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet2"); // Get "Sheet 2" by name
  var data = sheet.getDataRange().getValues();  // Get all data in the sheet
  
  var subject = "Your Personalized Message"; // Email subject
  
  // Loop through each row starting from row 2 (to skip the header)
  for (var i = 1; i < data.length; i++) {
    var name = data[i][0];      // Name (column A)
    var email = data[i][1];     // Email (column B)

Gianguyen1234

function createClassHiringForm() {
  // Create a new form
  var form = FormApp.create('English Class Hiring Form');

  // Add 'Full Name' (Short Answer)
  form.addTextItem().setTitle('Full Name').setRequired(true);

  // Add 'Email Address' (Short Answer with Email Validation)
  var emailItem = form.addTextItem().setTitle('Email Address').setRequired(true);