Jump to content

Google Sheets Slow to Update

Recommended Posts

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?

Link to comment
  • Replies 3
  • Views 1k
  • Created
  • Last Reply
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.

Link to comment

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Squarespace Webinars

Free online sessions where you’ll learn the basics and refine your Squarespace skills.

Hire a Designer

Stand out online with the help of an experienced designer or developer.