Data from Google Sheets to Firebase

I am extremely new to FF, and now trying to use my Google Sheet database I've been using on AppSheet, to recreate the app better on FF.

Issue now is I have no idea how to import the data from Sheets to Firebase.
Data I have is over 70 thousand rows, and when I tried solutions like Rowy to import the CSV, they crash about 35% through the import.

1. Is there potentially a way to not use Firebase and just have the whole data on the app itself?
I don't need users to edit the data, and updates to the db will probably only be once every few months. It is a database of locations users can navigate to with the co-ords.

2. If there is a dummy-proof way for newbies like me to use the Sheets data and get it exported to Firebase for use, that would be awesome. Please guide me to it if you don't mind...

3. Or if you guys have any better solution to my use, please suggest it to me.

Thank you in advance!

2
5 replies