Publish to make Google Spreadsheet changes work

  • 1
  • Problem
  • Updated 4 years ago
  • Solved
When we make changes to the Google Spreadsheet we need to republish the google spreadsheet everytime in order to make the changes to the spreadsheet show up.   I checked to make sure the Spread sheet is set to Public.   

Any suggestions?

http://rva.risevision.com/#PRESENTATION_MANAGE/id=7a1b2fd9-cc06-47fd-adce-c97f73007174/company=159b1...
Photo of Rob Ehlert

Rob Ehlert

  • 352 Points 250 badge 2x thumb

Posted 4 years ago

  • 1
Photo of Justin

Justin, Employee

  • 2,526 Points 2k badge 2x thumb
Rob,

Can you make sure that the checkbox beside 'automatically republish when changes are made' is checked on your spreadsheet?

See the second bullet point here in this documentation from Google.

Justin
Photo of Rob Ehlert

Rob Ehlert

  • 352 Points 250 badge 2x thumb
Justin,

I verified the settings and the 'Automatically republish when changes are made' was checked.  After a little more troubleshooting, I found that the Google Spreadsheet was updating in the presentation but it was taking approximately 4 1/2 min to update so I think my customer may have just been getting impatient and not waiting for the update.

We have other presentations that are running the old Google Spreadsheet gadget and they update typically in less than 15 sec.   Is it possible to adjust the new Google Spreadsheet settings to less than 5 min?

Thanks,

Rob Ehlert
Photo of Blake Freeman

Blake Freeman, Official Rep

  • 36,116 Points 20k badge 2x thumb
Rob,

We currently aren't able to refresh at an interval of less than 5 minutes. We'll make a product announcement should that change.
Photo of Rob Ehlert

Rob Ehlert

  • 352 Points 250 badge 2x thumb
I have been working with our customer and have finally been able to recreate the issue they are having with Google Spreadsheet.   Everyday the people on call changes at noon.   When the on call staff changes they edit the spreadsheet by deleting all of the people on call in the spreadsheet and type in the new people.   When they completely delete the content in all of the cells and type in new content, then Rise Vision won't update the spreadsheet in the presentation until the presentation is Republished.   Any thoughts?