Populate Google Sheet, pull the data and display as a reporting dashboard

Is there anyway to populate a google sheets doc with real-time data then pull that data from the sheet and display it?

I’m looking to create a real-time reporting dashboard for management to see how the prototype is performing.

Any help?

Hi you could try to put iframe/frame and it content but not sure what and how it should work. Could you be more specific ?
BR Karel

I would like to embed my prototype with tracking tags though Google Analytics/Tag manager. I was wondering if i could somehow capture that data from the tags (Ie number of users who have pressed button X) in google sheets, then display that data in my prototype.

I’m trying to build a user facing page to show the stats for internal users to understand the site performance.

I am afraid you have to “fake it” somehow rather than use real data.