Function pullVariables

EndtoEndAutomatedDecks.js:30–72

()

}

function pullVariables() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheetByName("Input");
  
  if (!sheet) {
    throw new Error("Sheet 'Input' not found");
  }
  
  var values = sheet.getRange("C5:C11").getValues().flat();
  var validationRange = sheet.getRange("E5:E11");

  var validationValues = [];
  var validationBackgrounds = [];
  var errorMessage = "";
  
  for (var i = 0; i < 7; i++) {
    if (values[i]) {
      validationValues.push(["Valid input provided"]);
      validationBackgrounds.push(["#b6d7a8"]); // Light green
    } else {
      validationValues.push(["Error: Input not provided"]);
      validationBackgrounds.push(["#ea9999"]); // Light red
      errorMessage += `Input Field ${i + 1} is empty. `;
    }
  }
  
  validationRange.setValues(validationValues);
  validationRange.setBackgrounds(validationBackgrounds);
  
  if (errorMessage) {
    throw new Error(errorMessage);
  }
  
  return {
    var1: values[0],
    var2: values[1],
    var3: values[2],
    var4: values[3],
    var5: values[4],
    var6: values[5],
    var7: values[6]
  };
}


function fetchBigQueryData() {