filipenevola

// spreadsheet attached as csv just for example
var sheet = SpreadsheetApp.getActiveSheet(),
    startRow = 2,  // skips header line
    lastRow = sheet.getLastRow() -1, // get last line with data
    dataRange = sheet.getRange(startRow, 1, lastRow, 6), // first value is the row, second is the column in number
    data = dataRange.getValues(); // get data of every cell within the range

var FOOTER = "<br/><br/><a href=\"https://script.google.com/macros/d/MlurQVKrLcdi-mMWhhh3KoQL0bBO3PCUx/edit?uiv=2&mid=ACjPJvGlhxliD17ZP1feshkqGxfbplgytbuk6ZUR4bCV3Wt2ChtUk_rI3XArfC1JTrz4lhUmJpwICfja09S1tR1YRkS03LIgjPNmk7d7sjI1PUibdnPY_BNZr6E5Z_mJ1LWVam3p0lX9xps\">editar script</a>";
function checkAllSites() {
  var nao = "NÃO";