Sales Dashboard possibly using AppSheet

We need a mobile web app online Sales Dashboard that will pull online open csv files that update hourly from google drive (no login required) to the app. Would like to look at AppSheet if it’s possible to control logins but open for suggestions