How do I reduce time saving data in firebase and after in google sheets

MIT App Inventor Help
1

Hello everyone

I created an application that allows you to track the execution of different tasks
in a site by different users on their devices everyone can see the changes in real time it works then I send the data in a google sheets spreadsheet and the return in the application is slower than if I were just using firebase

what are the avenues that I should consider so that the use of google sheets is as transparent as possible

regards

2

Firebase is super quick compared to google sheets in terms of responses time (although google sheets isn't all that bad)

I guess we would really need you to expose your workflow to fully understand what you are doing before we could make any suggestions. Perhaps an example or two....

3

hi

thank you for your response so quick in the way of firebase
in fact I explored different solutions the best would be to synchronize firebase and google sheets but I have to resort to the use of node.js and I do not know
another solution would be to send the data to google sheets independently like printing a report
What do you think ?

4

You shouldn't have to use node.js......

Some useful links:

5

thanks for all these links but they all seem out of my reach even using google translator

nevertheless I will try with this link: [https://medium.com/@marijn_koin/import-realtime-firebase-into-google-sheet-33f80228a150]

unfortunately it is not detailed enough for me

6

Consider why you need to use Firebase and Google Sheets to store data for your app ?

Also it may be easier to call in the data from Firebase to your app, then upload the data to Google Sheets ?

Depends on your workflow.....