Google-sheets – How to automate find and replace link in Google Sheets from form photo submission

Here is how it could work. The script does the following:

1. Get the sheet with form responses
2. Get the last (nonempty) row there
3. Pick the entry from column B. To make matching more robust, it trims the entry (removing any whitespace left or right of text), and converts to lower case.
4. If the result is 'yes', an email is sent. The body is the content of the submitted form (I'm assuming here that it has at most 10 items; otherwise adjust the range).

function emailMe() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Form Responses 1');
  var height = sheet.getDataRange().getHeight();
  var lastEntry = sheet.getRange(height, 2).getValue().trim().toLowerCase();
  if (lastEntry == 'yes') {
    var subject = 'Someone said yes';
    var body = sheet.getRange(height, 1, 1, 10).getValues()[0].join('\n');
    GmailApp.sendEmail('youremail@gmail.com', subject, body);
  }
}

To cc: someone else, change the sending line to

GmailApp.sendEmail('youremail@gmail.com', subject, body, {cc: 'first@aol.com,second@yahoo.com'});

Form responses stored in the form can't be edited programmatically, so if you want that your students be able to edit the form response but do not have see the response items filled up by a teacher, then use two different forms, one for the student, another for the teacher.

You could use the student submitted responses to create a pre filled up form response for the teacher (see Pre-populated form answer) or create new responses programmatically by using the withItemResponse(response) method.