IFTTTで行が挿入されたときに、最後の行の一列目の日付の文字列を、日付に変換する

google_script.js

var SPREADSHEET_ID = '****';

function onChange() {
  var sheet = SpreadsheetApp.openById(SPREADSHEET_ID).getSheetByName('logs');
  var currentRow = sheet.getLastRow();
  if (currentRow<1) {
    return;
  }
  var dateText = sheet.getRange(currentRow, 1).getValue();
  if (typeof dateText != "string") {
    //文字列以外はスルー
    return;
  }
  if (dateText == "") {
    return;
  }
  
  try {
    var date = convertDate(dateText);
    //日付の値を設定
    sheet.getRange('A' + currentRow).setValue(date);
  } catch(ex) {
    Logger.log(ex);
    return;
  }
}

function convertDate(rawDateString) {
  return Utilities.formatDate(parseDate(rawDateString), "JST", "yyyy/MM/dd HH:mm");
}

function parseDate(rawDateString) {
  // September 23, 2017 at 11:34PM
  matched = rawDateString.match(/(\w+) (\d+), (\d+) at (\d+:\d+)(.*$)/);
  // format for Aug 09 1995 00:00:00 PM GMT+0900
  return new Date(matched[1] + " " + matched[2] + " " + matched[3] + " " + matched[4] + " " + matched[5] + " GMT+0900");  
}

//Thanks: https://qiita.com/rechiba3/items/ef163b0fc21b37e869ef

note.md

Make IFTTT Date Format play nice with Google Spreadsheets

December 17, 2017 at 01:59PM

育児日記をDashボタンとAlexaでつける - Qiita

Google Homeに話しかけて娘のおむつ交換を記録する - Qiita

Google Spreadsheetのトリガーの「編集時」と「値の変更」の違いを検証してみた - まだ中学生のブログ