Linking Smartsheet to Sharepoint


I currently have Smartsheets in place where in the "Data Shuttle", I use "attachment" as a Source. However, this requires to manually go on ERP (OBI), extract the .csv file and drag&drop it in Attachments to refresh with new data. The better way in my mind would be : 1/ Program OBI to send .csv to mailbox at regular schedule. 2/ Use PowerAutomate to move .csv from Inbox to a Sharepoint 3/ Have Smartsheet use that Sharepoint as Source data. Can someone help me to understand how 3/ works, if it's possible? Thanks