As noted in the thread that @Clint.C shared, this solution: Simple CSV Import Workflow (for Unsupported Data Sources) is pretty flexible. It’s a little more of an advance setup because it requires adding AppsScript to your Google Sheet, but it’s the workflow I personally use if I have an unsupported account.