How do I create Trello cards when a new sheet is added to a shared Excel file?

I have multiple Excel spreadsheets in our Microsoft shared files which cannot be accessed through the One Drive or Sharepoint selection under the ‘Storage Source’ selection even though they are also stored locally on my PC. Is there a hack around this?  Do I need a paid subscription or some type of data link to personal OneDrive that is accessible through Zapier.  My goal is to automatically generate Trello cards when a sheet is produced in one of our company shared Excel files.