CODE EXAMPLE FOR JAVASCRIPT

Get current active sheet name google appscript

function logging(){
  let activeSheet = SpreadsheetApp.getActiveSheet();
  Logger.log(activeSheet.getName());
}