CODE EXAMPLE FOR JAVASCRIPT

Clear Cell Value In Google Sheet By App Scripts

var sheet = ss.getSheetByName("Questionário DQSA");  
  var range = sheet.getRange("F1");
  range.deleteCells(SpreadsheetApp.Dimension.COLUMNS);//F2 becomes the new F1