Sends emails with data from Google sheet

data.csv

send-emails.gs

const SPREADSHEET = getSheet('send-emals')

function sendEmails() {
  try{
    const emailsCount = getCell(1)
    const emails = getRowCells(2, emailsCount)
    const emailTitle = getFileName()
    const emailBody = getCell(3)

    for (const email of emails) {
      MailApp.sendEmail(email[0], emailTitle, emailBody)
    }
  }
  catch(error){
    Logger.log(error)
  }
}

function getSheet(name) {
  return SpreadsheetApp
    .getActiveSpreadsheet()
    .getSheetByName(name)
}

function getFileName() {
  return SPREADSHEET.getParent().getName()
}

function getRowCells(row, cellsCount = 1, offset = 1) {
  return SPREADSHEET
    .getRange(row, offset, 1, cellsCount)
    .getValues()
}

function getCell(row, column = 1) {
  return SPREADSHEET
    .getRange(row, column)
    .getValue()
}