A Google App Script to clear content of a Google spreadsheet

clearContent.js

// funtion to clear the mpesa upload for new entries 
function clearRange() {
  
  // get spreasheet details
  var sheet = SpreadsheetApp.getActive().getSheetByName('Mpesa upload summary');
  
  // get the cell range and call clear method
  sheet.getRange('B2:E').clearContent();
}