Daily emails

function dailyEmail(){
  const ss = SpreadsheetApp.getActiveSpreadsheet()
  const sheet = ss.getSheetByName('Data')
  const values = sheet.getRange("A2:E2").getValues().flat()
  const date = Utilities.formatDate(new Date(values[0]), Session.getScriptTimeZone(), "dd-MM-yyyy")
  const body =
    `Hi, \n
    Here are the figures for yesterday, ${date}: \n
    Value 1 = ${values[1]}
    Value 2 = ${values[2]}
    Value 3 = ${values[3]}
    Value 4 = ${values[4]}

    Regards,
    RemcoE33`

  GmailApp.sendEmail('email@gmail.com', 'Yesterdays values', body)
}