Record history on Google Spreadsheet

app.js

// Add a trigger to run everyday
function appendHistoryRow() {
  var app = SpreadsheetApp.getActive();
  app.setSpreadsheetTimeZone('Asia/Tokyo');
  var historyRow = app.getRangeByName('history_row');
  var values = historyRow.getValues();
  values[0][0] = new Date();
  historyRow.getSheet().appendRow(values[0]);
}