diff --git a/googleSpreadSheetWrite.json b/googleSpreadSheetWrite.json new file mode 100644 index 0000000..a5a44b8 --- /dev/null +++ b/googleSpreadSheetWrite.json @@ -0,0 +1,23 @@ +function doGet(e) { + var spreadsheet = SpreadsheetApp.getActiveSpreadsheet(); + var sheet = spreadsheet.getSheetByName('シート1'); + var now = new Date(); + var array = []; + array.push(now); + + for(var k in e['parameter']) { + array.push(k); + array.push(e['parameter'][k]); + } + + sheet.appendRow( array ); + + + var lastRow = sheet.getLastRow(); + + + var output = ContentService.createTextOutput(sheet.getRange(1,3).getValue()+" "+lastRow); + + output.setMimeType(ContentService.MimeType.TEXT); + return output; +} \ No newline at end of file