Query Cloud Firestore from Google Sheet using Database Browser
You can now connect Google Sheet with Firestore using Database Browser add-on and build query from wizard, execute query and present results directly into Google Sheet. Getting Firestore data into Google Sheet is NO more complicated. Users can now just follow the steps below Step 1 : Create a Firestore connection authorized with Google sign-in button. Step 2 : Provide project-id of the Firestore project (refer Google Cloud Console), test and save the connection. Step 3 : Build, Query and Present the results into Google Sheet as normally as you do with any other data sources. Check more documentation at how it works . Check out the current list of supported databases by Database Browser. ...