This video demonstrates how to make table out of Firestore documents.
Import script : npx @firebaseextensions/fs-bq-import-collection
Official documentation : https://github.com/firebase/extension...
The table created with the above script contains your data in one field (in JSON format). Please watch • How to Create Table from Firestore Data an... video to see how to convert this one field data into something usable (i.e. the way you expect).