Jump to content
Search In
  • More options...
Find results that contain...
Find results in...
Advanced Search
  • 0
gbrunks

Google Sheets Slow to Update

Question

I have a page which I let the user complete a form which then stores the data in a Google Sheet.  That works great.  On the same page I display the same Google Sheet by embedding the google sheet in a code block.  The problem is that after the user submits the form it doesn't immediately show in the embedded Google sheet.  It takes maybe 1 or 2 minutes later then it shows.

Is there anyway to force SP to update the page immediately or more frequently?

Share this post


Link to post

3 answers to this question

Recommended Posts

  • 0
3 minutes ago, gbrunks said:

The page is -->https://www.phgagolf.com/spring-scramble

You can go ahead and click and complete a Join Event and observe the delay between the completion of the form and the update to the embedded google sheet a minute or two later by refreshing the page

That's what I thought. Google says shared html and csv sheets are updated in 5 min, I do not think there is a way to force this unless use their API, but that's sure far more complex than pasting an embed code to Code block.

Share this post


Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment


×
×
  • Create New...