recalculateSheet

function recalculateSheet() {

// The code below opens a spreadsheet using its ID
// Note that the spreadsheet is NOT physically opened on the client side.
// It is opened on the server only (for modification by the script).
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getActiveSheet();
var timeCell = sheet.getRange('F1');
var lastRow = sheet.getLastRow();
var cell = sheet.getRange('C2:C');

var cellFormula2;

var now = new Date();


timeCell.setValue(now + " " + now.getHours() + ":" + now.getMinutes());
  cell.clearContent();
  SpreadsheetApp.flush();
  Utilities.sleep(2000);
  for(i=2;i<=lastRow;i++){
    cellFormula2 = sheet.getRange('C'+[i]);
    cellFormula2.setValue('=importJSON(B'+[i]+',"/sections/products/cheapest/productUrl","noHeaders")');
  }


}