I have written a script to pull daily an attachment that is sent with the same description daily on a xlsm attachment into a google sheet so that it is in a more useable format for the desired audience, but the script is currently failing.

The email also has a picture embedded into the footer, which could also be cuasing part of the problem.

Script i am using is below and it is now failing at line 18

Unsure of where to go with this, thanks in advance

function importxlsmFromGmail() {

  var ws = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("INPUT");
  ws.getRange("A1:M").clearContent();

  var threads = GmailApp.search('from:Services@customer.com subject:"Routes Delay"');
  var message = threads[0].getMessages()[0];
  var attachment = message.getAttachments()[0];
  // Is the attachment a xlsm file
  attachment.setContentTypeFromExtension();
  
  Logger.log(attachment.getContentType())
  if (attachment.getContentType() === "application/vnd.ms-excel.sheet.macroenabled.12") {
  attachment.setContentType(MimeType.MICROSOFT_EXCEL);
}{

    var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("INPUT");
    var xlsmData = Utilities.parsexlsm(attachment.getDataAsString(), ",");  // Error occurs here

    // Remember to clear the content of the sheet before importing new data
    //sheet.clearContents().clearFormats();
    sheet.getRange(1, 1, xlsmData.length, csvData[0].length).setValues(xlsmData);
    var total_lenght = sheet.getRange("A1:A").getValues();
    var last_row = total_lenght.filter(String).length;
    //console.log(Alast)
    // var cell = sheet.getRange("F2:F" & last_row);
    // cell.setNumberFormat("0.0");

  }
}