Business Central

While importing sales orders from a web shop, we would like the Excel Importer to create a new customer and apply a template when this customer doesn't exist yet based on the customer number.

For example, on receipt on an email, a Power Automate should be triggered which takes the Excel file attachment and pass it on to Business Central to import with a certain template passed on by Power Automate.

Some excel files contain grouping or total rows, which the app can't import into Business Central. We want the ability to specify criteria to identify these lines so that the app can skip them on import. This feature would save me from updating the file manually.