Google Sheets not visible in preview link

  • 1
  • Problem
  • Updated 2 years ago
  • Solved
  • (Edited)
Archived and Closed

This conversation is no longer open for comments or replies and is no longer visible to community members.

I am working on this presentation with Google Sheets. I can assure I have the sheets posted and shared properly. The presentation is working as supposed, I can preview the presentation on my PC, but nobody else can. They can see everything in presentation except Google sheets. Any ideas?

Preview (can u see the list?): http://preview.risevision.com/?type=presentation&id=d0a66da7-b43d-429e-ae08-3a30be2c712a
Photo of Darius - PRODO.us

Darius - PRODO.us, Champion

  • 26,850 Points 20k badge 2x thumb

Posted 2 years ago

  • 1
Photo of Darius - PRODO.us

Darius - PRODO.us, Champion

  • 26,850 Points 20k badge 2x thumb
It is account related because I get the same problem in incognito mode:
Photo of Darius - PRODO.us

Darius - PRODO.us, Champion

  • 26,850 Points 20k badge 2x thumb
So, I figured what is wrong. All my old Sheets without API Key can be previewed outside my account or in incognito mode no problem. I get this problem only with the new Sheets widget and API Keys. HELP...
Photo of Robb

Robb, Official Rep

  • 76,676 Points 50k badge 2x thumb
Darius,

I can see the list:


Have you updated the Presentation to not use the API Key?
Photo of Alan Clayton

Alan Clayton, Official Rep

  • 8,788 Points 5k badge 2x thumb
Data is showing up for me as well. http://www.screencast.com/t/fm264F29D6.

From dev console select the network tab. Use sheets.googleapis.com as the filter and let us know if you see a 200 response for the request. http://www.screencast.com/t/vPXcmgJim3b
Photo of Darius - PRODO.us

Darius - PRODO.us, Champion

  • 26,850 Points 20k badge 2x thumb
Robb, I tried, but it did not make any difference. I... we literally cannot preview any Sheet from the new widget, with or without API Key.
Photo of Darius - PRODO.us

Darius - PRODO.us, Champion

  • 26,850 Points 20k badge 2x thumb
Alan, yes I do under my account, but not in incognito mode... and the sheets aren't visible. What the hell is that? Network?...
Photo of Robb

Robb, Official Rep

  • 76,676 Points 50k badge 2x thumb
Darius,

When you have the preview open, open the Developer Tools Console in Chrome:


From there, you can go to the Network Tab:


Refresh your Presentation, and carry out Alan's instructions above.
Photo of Darius - PRODO.us

Darius - PRODO.us, Champion

  • 26,850 Points 20k badge 2x thumb
Robb, I did that already and I said I can see 200 as in the picture, but only under my account. I do not get any filtered results from sheets.googleapis.com in incognito mode and the sheets are not there. What does it tell us, what I was supposed to make out of this?
Photo of Darius - PRODO.us

Darius - PRODO.us, Champion

  • 26,850 Points 20k badge 2x thumb
I do not get it. I came back home and I cannot preview Sheets here too. We tried different network providers in different locations. It is simply not working over here. The only places I can see it working is my work PC and the actual media player. I even signed into RV on my PC at home, opened the presentation and I cannot see the sheets in preview.
Photo of Darius - PRODO.us

Darius - PRODO.us, Champion

  • 26,850 Points 20k badge 2x thumb
I just noticed that the buttons in editor aren't working again just like few weeks ago. I can get into the widgets and edit them, I am allowed to save and preview, but I cannot restore or publish.
Photo of Alan Clayton

Alan Clayton, Official Rep

  • 8,788 Points 5k badge 2x thumb
We might want to look at getting remote access so we can see what you are experiencing. I'm unable to replicate either of the problems you're having unfortunately.

Here is something else to try. When Previewing your Presentation open Dev Tools. Select the Application tab. On the side menu select Storage > Local Storage > http://s3.amazonaws.com. You should see several keys related to the Spreadsheet Widget as shown here, http://www.screencast.com/t/w6X8bN517q

Delete those keys then refresh the Preview and let us know if data appears.
Photo of Darius - PRODO.us

Darius - PRODO.us, Champion

  • 26,850 Points 20k badge 2x thumb
Alan, I do not get any keys, the list is empty.
Photo of Janne Aschan

Janne Aschan

  • 462 Points 250 badge 2x thumb
Hi, I had over 20 of those keys and erased them all, but there was no difference. Preview does not work
Photo of Darius - PRODO.us

Darius - PRODO.us, Champion

  • 26,850 Points 20k badge 2x thumb
Also, I tried adding another account to our company, I used totally different Google account... two different in fact. I copied the same presentation's code into new presentation under different account, I tried to attache different Sheet under different account. NADA! I cannot get Google Sheets widget to preview.
Photo of Darius - PRODO.us

Darius - PRODO.us, Champion

  • 26,850 Points 20k badge 2x thumb
It looks like anything coming from s3.amazonaws.com and then some gets blocked. It looks like my browser is thinking that some resources are not secure. Installed RV player and it worked fine, but no preview for the Sheets Widget, but got this once: 
(Edited)
Photo of Janne Aschan

Janne Aschan

  • 462 Points 250 badge 2x thumb
Hi, I can confirm that I have exaktly the same problem as Darius. Can not see any preview but the players work fine for my customers. I have not made any own investigations but it can be good for you to know that I also have the same problem.

Ps! Darius, Many thanks for your help with my previous problems with API keys and updating certain columns. The problem is, unfortunately, not resolved. I have tried many different ways to solve it but failed. When I have time I will explain more in the right thread

Best regards
Janne
Photo of Darius - PRODO.us

Darius - PRODO.us, Champion

  • 26,850 Points 20k badge 2x thumb
Janne, I was gonna ask you about were you able to resolve this. Now I can feel your pain. I can no longer preview the test presentation that I've made for you then.
Photo of Darius - PRODO.us

Darius - PRODO.us, Champion

  • 26,850 Points 20k badge 2x thumb
I am able to preview the sheets on my Android phone, though; on both mobile and wifi connections, so I cannot blame the router.
Photo of PrakashM

PrakashM

  • 72 Points
Hi Darius,

I was able to see the list. Something might be blocking it. Some chrome setting.

Regards
Prakash.
Photo of Darius - PRODO.us

Darius - PRODO.us, Champion

  • 26,850 Points 20k badge 2x thumb
I did not change any setting and I am running default Chrome just as any other browser and I cannot preview on any of them.
Photo of Darius - PRODO.us

Darius - PRODO.us, Champion

  • 26,850 Points 20k badge 2x thumb
This morning even my work PC gave up... cannot preview on it any more, too. And it looks like only windows devices are affected.
(Edited)
Photo of Robb

Robb, Official Rep

  • 76,676 Points 50k badge 2x thumb
Darius, Janne,

To confirm this is not previewing on Windows at all right? I am on my Mac right now, so I am going to jump over to my PC and see if I can recreate. Hang tight!
Photo of Darius - PRODO.us

Darius - PRODO.us, Champion

  • 26,850 Points 20k badge 2x thumb
Yes it appears so. I can preview on Android and Chrome devices, even phones. I had no chance to find Mac yet, but it did not work on iPad, but iPad this is different can of worms.
(Edited)
Photo of Janne Aschan

Janne Aschan

  • 462 Points 250 badge 2x thumb
Same for me. I created a new Google spreadsheet and a test presentation with spreadsheet widget without API-key on my Windows 10 PC = preview does not work. When I open the same presentation on my MacBook Air, preview works immediately
Photo of Darius - PRODO.us

Darius - PRODO.us, Champion

  • 26,850 Points 20k badge 2x thumb
Janne, it does not work on Win with or without API Key.
Photo of Robb

Robb, Official Rep

  • 76,676 Points 50k badge 2x thumb
Darius,

On your PC, can you preview the Presentation, open the Developer Console and then go to the Network tab? On there , search for sheets.googleapi.com, and let me know if you see any requests?

Looking at your preview on the Mac, I see the requests, on the PC, I do not. I just want to confirm if you are seeing the same behaviour.

Thanks!
Photo of Darius - PRODO.us

Darius - PRODO.us, Champion

  • 26,850 Points 20k badge 2x thumb
Robb, the list is empty
Photo of Robb

Robb, Official Rep

  • 76,676 Points 50k badge 2x thumb
Thanks for that confirmation Darius!

I was able to recreate this on my Windows machine in preview. The Windows Players are still showing the spreadsheet no problem, this only appears to be affecting preview.

I will let you know when we have determined the cause.

Thanks!
Photo of Darius - PRODO.us

Darius - PRODO.us, Champion

  • 26,850 Points 20k badge 2x thumb
Thanks god u were, and I do not feel anymore like I am the only one completely crazy here )))

On the side note:
#1 U snobbish Apple users...  y u cannot be humble like the rest of us, Windows users... y u always screw things up for us )))
#2 do u even test on windows? I am available as part-time windows tester if anything ;))))
(Edited)
Photo of Robb

Robb, Official Rep

  • 76,676 Points 50k badge 2x thumb
hehehe....Ah Darius, Our days are so much better with you around :)

We're still trying to isolate what the issue is here, but have no fear, this has our full attention, and we will update everyone once this is corrected.

Thanks!
Photo of Darius - PRODO.us

Darius - PRODO.us, Champion

  • 26,850 Points 20k badge 2x thumb
Hey, I just noticed at home that the previews work correctly again! Awesome! What was the problem?
Photo of Robb

Robb, Official Rep

  • 76,676 Points 50k badge 2x thumb
Hi there Darius!

I wanted to update this post to say the same, that everything is working now.

It appears that this may have been due to an update to the Spreadsheet Widget that we rolled out, so we rolled back and are investigating why that occurred.

Thanks!
Photo of Alan Clayton

Alan Clayton, Official Rep

  • 8,788 Points 5k badge 2x thumb
Hi Darius, we believe the issue related to the Spreadsheet data not showing in Preview has been corrected. We are planning to release the update on Monday. In the mean time, would you mind Previewing this Presentation in Incognito Mode and confirming if the data appears for you? 

Thanks!
Photo of Darius - PRODO.us

Darius - PRODO.us, Champion

  • 26,850 Points 20k badge 2x thumb
Alan, everything works perfectly in incognito mode.
Photo of Alan Clayton

Alan Clayton, Official Rep

  • 8,788 Points 5k badge 2x thumb
Great! Thanks for the quick feedback.