Although a direct API would be preferred, you also have the following power
Microsoft Outlook
- An e-mail is received
- The e-mail has an attachment of an Excel Spreadsheet
- The spreadsheet is received every week and contains key data that validates information
- An Outlook rule moves this e-mail to a folder
Welcome Microsoft Power Automate (flow)
- Pick-up the e-mail
- Save the Attachment
- Process the Attachment data and injected the data into Dataverse (Model Driven Power App)
Microsoft Power App
- Dashboards
- Comparisons
- Calculations
- Reporting errors
There are many choices when it comes to business processes and eliminating manual steps.