CONNECT GOOGLE SHEET TO PORTAL AND GOOGLE DATA STUDIO VIA FIRESTORE ON FIREBASE PROJECT

I need a smart Google Data Studio Expert to connect my Google Sheet with my Firebase project. This is to enable realtime update of my Google Data Studio from Firebase FireStore project.

Connect Google Sheet to Google Data and Firebase project so that I can see real time update on Google Data Studio.

Immediate task please.

Thank you.