■
function myFunction(e) {
//
var itemResponses = e.response.getItemResponses();
var ss = SpreadsheetApp.openById('');
var sheets = ss.getSheets();
var sheet = sheets[1];
// var sheet = sheets.getSheetByName('テスト');
var lastrow = get_last_row(sheet,2);
for (var i =0;i<itemResponses.length;i++){
sheet.getRange(lastrow+1, 2+i).setValue(itemResponses[i].getResponse());
}
}
function get_last_row(sheet,col) {
//指定列の、データが入った一番下の行を選択
var values = sheet.getRange(1,col,1000).getValues();
//Logger.log(values);
//Logger.log(values.length);
for(var i = values.length-1; i >= 0; i--){
if(values[i] != "" ){
break;
}
}
var last_row = i+1;
//sheet.getRange(last_row, col).activate();
return last_row
debugger
}