Back

Technologies:

javascriptjavascript
avatar
Tolerim
a month ago

The data on the sheet doesn't actually update when published to the web, even though it claims to update every 5 minutes.

I am facing an issue where my Google Sheet updates values in the cells every 5 minutes, but the updates do not reflect when the sheet is published to the web. The message "Updated automatically every 5 minutes" appears at the bottom of the page, but I still need to refresh the page manually to see the updates. Despite checking the calculation settings, I am yet to find a solution. Is there a workaround to this problem?

Additionally, I attempted to update the calculation settings in the spreadsheet settings but unfortunately, it did not resolve the issue.

Answers(2)
avatar
Vogi
a month ago
Verified Answer
I'm sorry to hear that you are facing this issue. It seems that the updates are not reflecting when the sheet is published to the web. One possible reason for this could be that if anyone has the Google Sheet Doc open, it will not update on the Published version until a change is made by anyone until all are closed. You can try closing all the sheets and see if that resolves the issue. If that doesn't work, you can try clearing your browser cache and cookies or using a different browser. If none of these solutions work, you can try reaching out to Google support for further assistance. I hope this helps!

Sources

https://stackoverflow.com/questions/49515131
avatar
Tolerim
a month ago
Unfortunately, this seems to be a common issue with Google Sheets when published to the web. One workaround for this is to use the Google Sheets API in conjunction with JavaScript to retrieve data from the spreadsheet and display it on your webpage. Here are the basic steps to using the Google Sheets API: 1. Create credentials for the Google Sheets API by following the instructions provided by Google. This will give you a client ID and client secret that you will need later. 2. Use the Google Sheets API to retrieve data from your spreadsheet. You can do this by sending a GET request to the appropriate endpoint, passing your client ID and client secret in the header. 3. Parse the data returned from the API into an appropriate format (e.g. JSON) and use JavaScript to display it on your webpage. There are also a number of JavaScript libraries available that can help you interface with the Google Sheets API, such as SheetJS and Google Sheets API v4.
;