Can this Automation import files from OneDrive or SharePoint?

It depends, but as long as you can have files with publicly accessible URLs on the web, then they can be imported into Airtable using this automation.