Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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);
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement