Firebase productivity tips #AskFirebase

Welcome to another episode of #AskFirebase! Today, both of our co-hosts David East and Sumit Chandel team up to answer all your burning Firebase questions! Watch to find out the answers like…

0:59 - What’s your favorite Firebase console tips and tricks?
4:48 - How do I monitor in manage costs with the Blaze plan?
7:10 - Is there a way to export data from Google Sheets to Firestore?

Remember to use #AskFirebase to get your question answered!

[nicolapigozzo]

Pls show us inverse process firestore->spreadsheet export

[the_data_panda]

Move document (and their subcollections) to another collection. I think you can do this with export-import feature, but would love a video on this, since it's needed so often!

[jsebastian]

I have no idea about export data from Google spreadsheets to Firestore it was great, thanks more videos like this

[PatrickTorossian]

More keyboard shortcuts in the Firebase console would be great! (And a reference somewhere of course.)

[Kurenquilan]

This is great if your document properties are formatted as strings, numbers or dates... how do you format more complex data primitives in google spreadsheets? (eg: arrays and maps)

[DebugWithAdam]

This solves my problem, I have being looking for this solutions, but I still have a question please, #AskFirebase how many maximum number of records (rows) can I add at a time using free plan?

[donaldbough]

Any productivity tips for RTDB! Specifically with querying and exporting data.

[carlosmarques]

Best way to reference image present in firebase storage in database

[jassiemrobinson]

If exported often with varying amounts of information is there a way I can have the code not have a hard number of values to get and have it go until there aren't any values to get? I'm trying to automate answers from a questionnaire go to Firestore. Also, if my questionnaire created new sheets would I just have to copy and paste the script to every google sheet?

[befit_kw]

I'm looking for a solution of firebase Google authentication to be connected to Google fit Api. It's a critical method in order to keep the database operational within android App.

Thanks

[chrisodonnell]

Is there a way to import from an excel sheet (not google sheet) into FIRESTORE?

[CanalianInc]

I did this spreadsheet method to update a few month ago but if it's more than a few thousand rows it times out. I ended up having to write cloud function to get 10, 000 items into firestore.

[botcontador]

How do I get the whatever number of rows in the spreadsheet? I mean, instead hard coding 100 rows like you did in your demo.

[jplau]

Thanks for the video. I have a question, why is there no cron job trigger for firebase functions? I often have the issue, that I need to sync data from an external source.

[VincenzoN]

Hi! I got a very huge doubt about Firestore increment cost. Cost simple twice a write o it multiplicate if a document update contains more increment ops??

[fzmdev]

Can you teach us how to develop an angular web app with guest and user login.

[christoslytras]

There should be an option to filter/find a document using the document ID. We can filter document's using their properties but there is no way to find a document using IDs.

[ngabarra]

Does the script work with the Realtime Database as well by any chance?

[vankatad]

Guys just add "!=" and "contains" (for substring) queries...please

[RudyLehman]

How can I query Firestore using Google Apps Script?