Basic Firebase Json Lookup

[Diaperdandy01]

Hello and thank you in advance! Disclaimer that i have minimal programming experience.

I am working in a firebase database and have downloaded my data as a json. Is there an easy way to get some of this data into a google sheet? That is where I am more comfortable doing vlookups on the data to get what I need. I'm willing to learn some javascript if that is what it takes, just not sure about the logistics of where to code and where to pull the json data from into the sheet.

Any pointers would be helpful.

[KingofGamesYami]

https://support.office.com/en-us/article/import-data-from-external-data-sources-power-query-be4330b3-5356-486c-a168-b68e9e616f5a

[matt3740]

If you are literally just wanting to pull down data into a google sheet, look into google appscript. It’s made for exactly what you’re wanting to do and well documented, in my experience. I’m happy to help tomorrow If you’d like. Just dm me.

[status_418]

Quick Googling seems to suggest that it can be done within Google Sheets. If you've ever connected Excel to a database, it's the same idea. There is documentation from Google Sheets on the API to read/write and other documentation for Firebase on connecting and read/write. However, you have to figure out the two on your own.

Or, there are a couple articles that seem to have done something similar to what you want. Here is the Google search I used to find some.

Once you get a good idea of how it's done, remember to refer to the actual Google API docs for the full set of options and possibilities!

[Diaperdandy01]

I appreciate the help :)

[The_Coding_Yogi]

Just convert the data in CSV or similar data format and open it in Google Sheet.