gasでpostで受け取ったjsonをパース
function doPost(e) { var reqJson = e.postData.getDataAsString() var jsonObj = JSON.parse(reqJson) var newRow = getUserData(jsonObj) var sheet = SpreadsheetApp.getActive().getActiveSheet() sheet.appendRow(newRow) } function getUserData(obj){ // gasじゃこの記法は未対応 //let {id, 'user':{name,age,email,result}} = obj var id = obj.id; var name = obj.user.name; var age = obj.user.age; var email = obj.user.email; var result = obj.user.result; var newRow = [id,name,age,email,result] return newRow }