0

I need to embed Google Sheet data into a Google site. This is easy to do for static data, but not for live, changing, dynamic data in the Sheet. I need the Google site to automatically refresh in realtime for any change made on the Google Sheet.

I have tried using the automatic refresh/publish checkbox on Google Sheets. This will make the data available to the Google site, but the Google site does not automatically update unless the page is refreshed.

I expect one user to add information to a cell in Google Sheets, and in realtime the embedded sheet data on the Google site would reflect that change. However, what actually happens is the cell is changed in Google Sheets, then the Google site has to be refreshed manually in order to display the changed cell.

BAM
  • 137
  • 1
  • 9
  • Possible duplicate of [build real time dashboard using google apps script](https://stackoverflow.com/questions/58270885/build-real-time-dashboard-using-google-apps-script) – carlesgg97 Nov 08 '19 at 09:08

2 Answers2

1

There is a way, but automatically updating content every 5 minutes (I ignore if the frequency can be changed).

You have to go to Gsheet > File > Publish to Web.

From there you grab the link and publish.

Then, you go to Google sites > Insert > Embed. Choose URL, paste link grabbed before.

Hope that helps!

Mario Bonilla
  • 26
  • 2
1

That's actually not an issue from Google Sheet. It depends on how often does your site clears its cache for the updates. You should set that up within your admin panel if you have. Example, for wordpress users we tend to have a caching plugin to do the job.

jaYCee
  • 11
  • 2