Export firebase realtime data to google sheets

[vanhau]

Hello everyone!
Let me ask how to export firebase realtime data to google sheets.
Any brothers / sisters who can help me, thank you!

[TIMAI2]

Has the data on firebase been created by an App Inventor app ?

See here for data going the other way (google sheet > firebase > AI2)

Colintree Custom listview extension update one element

We have seen this issue before when developers have imported data from a google sheet. For some reason it doesn’t escape ( \ " ) the ", causing problems when you import the data to AI2 This is what things should look like on firebase: [image] Other than calling down the data from the google sheet into AI2 and then uploading to Firebase, I can’t offer another solution, but will have a look around later to see what I can find

[TIMAI2]

If you use the "web component method" with Firebase on AI2, then the data is compatible with Google Sheets for import

Firebase Database and Storage: with the Web Component - Secure Rules

[fb] This is one of those, could it be done.... did I need to use the built-in firebase component, or the extensions available, in order to use Firebase database and storage, and operate secure rules. Well after some research and testing, it turns out that it could be done. Find out how: Firebase with a Web Component . . . My thanks @ChrisWard for proof reading and suggestions [EDIT - Now updated to include the new PATCH feature of the web component]

[Solomon_Vineeth]

@vanhau Check out this article : How to get Firebase Data into Google Sheets – Two Minute Reports