Google sheets, auto email by script

This script might get you started.

As it is this will run when the sheet is open, you could add some conditions in the onOpen function to have it only run on certain days - not sure if there are timed triggers.

function onOpen() {
  sendEmails();
}

function sendEmails() {
  var sheet = SpreadsheetApp.getActiveSheet();
  var lastRow = sheet.getLastRow();   // Number of rows to process
 
  var dataRange = sheet.getRange("A2:G" + lastRow)

  var data = dataRange.getValues();
  
  for (i in data) {
    var row = data[i];
    if(row[6] == "Send Email"){
      var emailAddress = row[5];  
      var message = row.join(",");       
      var subject = row[0];
      MailApp.sendEmail(emailAddress, subject, message);
    }
  }
}

PS You'll also have to adjust the subject/message - wasn't really sure what to use there so for the message I create a comma separated list from all the data in the row and took the subject from column A.

i can set a trigger on the sheet it self, so i can make it call a script at a set time, it does not need to be scripted into the code itself, thanks for this i will have a look and see if i can get it working, thanks for fast reply.

Also how would i go around picking for example row B F H to send that data in the email as appose to all of the row?

Thanks Ditch