Function pullVariables

Data to Narrative with Input.js:9–49

()

}

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:C9").getValues().flat();
  var validationRange = sheet.getRange("E5:E9");

  var validationValues = [];
  var validationBackgrounds = [];
  var errorMessage = "";
  
  for (var i = 0; i < 5; 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]
  };
}


function fetchBigQueryData() {