function pullColumns() { var sheetID = "1C-TqfI989-D-VWFe6Xdvc0LQoqAX2T2C9zUFbkPQSXw"; var formID = "1E5RS0XI5zaSVrRmeKhjhuZ6fTbe9ORCvsbHQsvuD4-s"; var sheet = SpreadsheetApp.openById(sheetID); var form = FormApp.openById(formID); var colors = ["red", "blue", "green", "black", "orange", "purple"]; colors.forEach(logElement); function logElement(element) { Logger.log(element); } var data = sheet.getSheetByName("data"); var foo = "bar"; for (var i = 1; i < 9; i++) { foo = data.getRange(1, i).getValue(); Logger.log(foo); }