getAmazonPrice.gs

function getAmazonPrice() {
  var sheet = SpreadsheetApp.getActiveSheet();
  var date = new Date();
  var row = sheet.getLastRow()+1;
  
  sheet.getRange('A'+ row).setValue(date);
  
  sheet.getRange('B'+ row)
    .setFormula('=IMPORTXML(E1,"//td[@class=\'a-span12\']/span[@class=\'a-size-medium a-color-price\']")');
}