function myFunction() {

  var ss = SpreadsheetApp.getActiveSpreadsheet();

  var RESPONSES_SHEET_NAME = "Requests"
  var MAPPING_SHEET_NAME = "Ward Map & Admins"
  var WARD_COLUMN_INDEX = 1;
  var EMAIL_COLUMN_INDEX = 4; // Change to 2 once testing is over

  var responses_sheet = ss.getSheetByName(RESPONSES_SHEET_NAME);
  var mapping_sheet = ss.getSheetByName(MAPPING_SHEET_NAME);

  // This logs the value in the very last cell of this sheet
  var lastRow = responses_sheet.getLastRow();
  var lastColumn = responses_sheet.getLastColumn();
  var ward = responses_sheet.getRange(lastRow, 12).getValue();


  var wards = mapping_sheet.getRange(2, WARD_COLUMN_INDEX, mapping_sheet.getLastRow()).getValues(); // 1st is header row
  wardIdx = -1;
  // Loop through all wards in ward column
  for (var i=0; i<wards.length; i++) {
    item = wards[i][0]
    // if current ward matches ward from form submit, save the index and exit the loop
    if (item == ward) {
      wardIdx = i+2;
      break;
    }
  }

  var urgency = responses_sheet.getRange(lastRow, 18).getValue(); // Urgent: Yes or No?

  if(wardIdx>0){
    email = mapping_sheet.getRange(wardIdx, EMAIL_COLUMN_INDEX).getValue() // look up the email column in the row of the ward
    Logger.log("Form response: " + ward)
    Logger.log("Row in mapping: " + wardIdx)
    MailApp.sendEmail(email,'Westminster Mutual Aid: New request submitted in ' + ward + '. Urgent: ' + urgency, 'This is a notification for Westminster Mutual Aid. A new request has been submitted in ' + ward + '. Please refer to the spreadsheet for more information.');
  }

  else {
    email = mapping_sheet.getRange(2, EMAIL_COLUMN_INDEX).getValue() // look up the email column in the row of the ward
    Logger.log("Form response: " + ward)
    Logger.log("Row in mapping: " + wardIdx)
    MailApp.sendEmail(email,'Westminster Mutual Aid: New request submitted in ' + ward + '. Urgent: ' + urgency, 'This is a notification for Westminster Mutual Aid. A new request has been submitted in ' + ward + '. Please refer to the spreadsheet for more information.');
  }
}