function doPost(e) {

  var ss = SpreadsheetApp.getActive()
  //下の2行はどっちでもOK　2つ目はシート一枚目という意味
  //de.kore.naniyo
  //var sheet = ss.getActiveSheet();
  var sheet1 = ss.getSheets()[0];
  var sheet2 = ss.getSheets()[1];
   
  
  var jsonString = e.postData.contents;
  //jsonString = jsonString.replace('\\','');
  //jsonString = jsonString.replace(/\}\"/,'\}');
  var data = JSON.parse(jsonString).toString();
//  sheet.appendRow(["そのまま",jsonString]);
//  sheet.appendRow([data]);
//  sheet.appendRow(["パース",typeof(data)]);
  var data2 = JSON.parse(data);
// var last=sheet.getRange("A:A").getLastRow();
  if (data2.key1){
    sheet1.appendRow([data2.key1.nowtime,data2.key1.bio_data,data2.key1.camera]);
    sheet1.appendRow([data2.key2.nowtime,data2.key2.bio_data,data2.key2.camera]);
    sheet1.appendRow([data2.key3.nowtime,data2.key3.bio_data,data2.key3.camera]);
    sheet1.appendRow([data2.key4.nowtime,data2.key4.bio_data,data2.key4.camera]);
    sheet1.appendRow([data2.key5.nowtime,data2.key5.bio_data,data2.key5.camera]);
    sheet1.appendRow([data2.key6.nowtime,data2.key6.bio_data,data2.key6.camera]);
    sheet1.appendRow([data2.key7.nowtime,data2.key7.bio_data,data2.key7.camera]);
    sheet1.appendRow([data2.key8.nowtime,data2.key8.bio_data,data2.key8.camera]);
    sheet1.appendRow([data2.key9.nowtime,data2.key9.bio_data,data2.key9.camera]);
    sheet1.appendRow([data2.key10.nowtime,data2.key10.bio_data,data2.key10.camera]);
    sheet1.appendRow([data2.key11.nowtime,data2.key11.bio_data,data2.key11.camera]);
    sheet1.appendRow([data2.key12.nowtime,data2.key12.bio_data,data2.key12.camera]);
    sheet1.appendRow([data2.key13.nowtime,data2.key13.bio_data,data2.key13.camera]);
    sheet1.appendRow([data2.key14.nowtime,data2.key14.bio_data,data2.key14.camera]);
    sheet1.appendRow([data2.key15.nowtime,data2.key15.bio_data,data2.key15.camera]);
    sheet1.appendRow([data2.key16.nowtime,data2.key16.bio_data,data2.key16.camera]);
    sheet1.appendRow([data2.key17.nowtime,data2.key17.bio_data,data2.key17.camera]);
    sheet1.appendRow([data2.key18.nowtime,data2.key18.bio_data,data2.key18.camera]);
    sheet1.appendRow([data2.key19.nowtime,data2.key19.bio_data,data2.key19.camera]);
    sheet1.appendRow([data2.key20.nowtime,data2.key20.bio_data,data2.key20.camera]);
    sheet1.appendRow([data2.key21.nowtime,data2.key21.bio_data,data2.key21.camera]);
    sheet1.appendRow([data2.key22.nowtime,data2.key22.bio_data,data2.key22.camera]);
    sheet1.appendRow([data2.key23.nowtime,data2.key23.bio_data,data2.key23.camera]);
    sheet1.appendRow([data2.key24.nowtime,data2.key24.bio_data,data2.key24.camera]);
    sheet1.appendRow([data2.key25.nowtime,data2.key25.bio_data,data2.key25.camera]);
    sheet1.appendRow([data2.key26.nowtime,data2.key26.bio_data,data2.key26.camera]);
    sheet1.appendRow([data2.key27.nowtime,data2.key27.bio_data,data2.key27.camera]);
    sheet1.appendRow([data2.key28.nowtime,data2.key28.bio_data,data2.key28.camera]);
    sheet1.appendRow([data2.key29.nowtime,data2.key29.bio_data,data2.key29.camera]);
    sheet1.appendRow([data2.key30.nowtime,data2.key30.bio_data,data2.key30.camera]);
  }
  if(data2.mickey){
    sheet2.appendRow([data2.mickey.nowtime,data2.mickey.mic]);
  }
}