Small Payment Automation (PowerAutomate - Microsoft Exchange Email>Attachment to SharePoint>SharePoint attachment formatted by Macro> Macro uploaded into SAP)

I work in Accounts Receivable and Cash application. We have a lot of small customers that send us in Excel files to a group mailbox with remittance information that lines up to an ACH/electronic payment we receive. Right now we manually need monitor a group mailbox then manually save a file to a SharePoint site, then if on a certain list we need to format that info with a macro to a certain format, then we need to go into SAP and use a t-code to "marry the payment we got from the bank with the properly formatted data that matches to it so that our system can offset the cash and items in the ar. I think powerAutomate can do all of that. If it can then we would want this to be easily expandable. Right now the scope is only for using spreadsheets submitted by the customer but would like to know about the OCR features so that if customers submit a paper print out in mail we could possibly scan that tot he mailbox for this process to read. As part of the Project Maintenance training must be documented and provided to two individuals at the hiring company.