Read excel attachment and copy to custom table

[Nic Omaha]

Hello, 

I have a need to have a user attach a excel spreadsheet to a catalog item and then read the spreadsheet and copy all lines to a custom table. I have figured this out on an inbound action but cant seem to get this to work in workflow. 

Any suggestions would be great! Below is what I am doing with inbound actions

I created my data source and transform map and then I run the following code on inbound action

(function runAction(/*GlideRecord*/ current, /*GlideRecord*/ event, /*EmailWrapper*/ email, /*ScopedEmailLogger*/ logger, /*EmailClassifier*/ classifier) {
      var importSetTableName = "incentiveloadfinal";
      var transformMapIDs = "83106da21b8c91504e7b415dee4bcbd6 ";   //Use a comma to specify multiple transform maps
      var applicatonScope = "Global";

      // Create the datasource record
      current.name = "File import from: " + email.from;   //Feel free to rename this as appropriate
      current.import_set_table_name = importSetTableName;
      current.file_retrieval_method = "Attachment";
      current.type = "File";
     current.format = "Excel"; // For Excel Files
     // current.format = "CSV"; // For CSV Files
      current.header_row = 1;
      current.sheet_number = 1;
      current.sys_package.setDisplayValue(applicatonScope);
      current.sys_scope.setDisplayValue(applicatonScope);
      var dataSourceID = current.insert();
     
      /*
       * Schedule Load of Attachment
       *
       * This inbound email action will generate an import data source, however the attachment isn't copied to the data source until
       * after the insert of the record.   Scheduling the import to happen 30 seconds later so that attachment has time to be copied.
       */
      new global.EmailFileImportUtils().scheduleImport(dataSourceID, transformMapIDs);
})(current, event, email, logger, classifier);

[AnubhavRitolia]

Hi Nic,

May be below article helps you:

https://community.servicenow.com/community?id=community_blog&sys_id=d3dc8911db285490190dfb243996199a

Please mark this as correct answer and helpful if it resolved, or mark this helpful if this help you to reach towards solution.