Google Sheets API Authentication with Rise Vision

  • 1
  • Question
  • Updated 2 years ago
  • Answered
  • (Edited)
Archived and Closed

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

I'm having an issue getting my website to show correctly in Rise Vision with a data pull from Google Sheets.  I'm able to get through the Google API authentication when in preview mode, but in the actual digital signage the authorization button does nothing.  Has anyone been able to bypass the Google Sheet API authentication to display data from Google Sheets?  The Google Sheets widget offered by Rise Vision simply displays the spreadsheet which is not the effect we're going for.  Does anyone have the code for the Rise Vision Google Sheet widget that shows how its pulling from Google Sheets without authentication needed?

The website has 3 components:
1) Html code with JavaScript that pulls from Google Sheets
2) CSS style sheet
3) The Google Sheets being pulled from has been published to the public (anyone can find and view)
Note: The JavaScript being used came directly from the Google Sheets documentation:
https://developers.google.com/sheets/quickstart/js

Here's the live link to the website we're trying to display on Rise Vision:
http://vout.neocities.org/NewJavaJob.html

Link to Rise Vision preview:
http://preview.risevision.com/?type=presentation&id=902f6a21-0866-4f41-9060-6751ce3fcda2

Any help would be greatly appreciated!

Best,
Thompson

Screen shots attached


 
Photo of Thompson Vou

Thompson Vou

  • 140 Points 100 badge 2x thumb

Posted 2 years ago

  • 1
Photo of Blake Freeman

Blake Freeman, Official Rep

  • 36,116 Points 20k badge 2x thumb
Hey Thompson,

Quick question on your setup. When I pull up that preview and click Authorize I get no response. Within dev tools, I get this error message:

cb=gapi.loaded_0:517 Blocked opening 'https://accounts.google.com/o/oauth2/auth?client_id=1027850356845-832jv7qu1...res__%2Fam%3DAQ%2Frt%3Dj...' in a new window because the request was made in a sandboxed frame whose 'allow-popups' permission is not set.

I'm curious what happens on your end when you are not logged into a Google account on your browser? Could you try previewing this presentation in an incognito windows that is not logged into a Google account and let me know what happens?
Photo of Thompson Vou

Thompson Vou

  • 140 Points 100 badge 2x thumb
Hi Blake,

I just tried opening the preview in an incognito window and the Authorize button didn't work either.  Do you know of a way to push through the authorization without having a pop-up window? How does Rise Vision handle authorization on the Google Sheet widget?
Photo of Blake Freeman

Blake Freeman, Official Rep

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

Rise Player doesn't handle any Authentication, and unless I'm misreading your question, the Google Sheets Widget doesn't do any sort of authentication/authorization either. That's why sheets must be shared publicly and published to the web.
(Edited)
Photo of Blake Freeman

Blake Freeman, Official Rep

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

To clarify, the Spreadsheet itself needs to be set to On - Anyone with the link.

Photo of Thompson Vou

Thompson Vou

  • 140 Points 100 badge 2x thumb
Blake, I just changed the Spreadsheet from "On-Public on the web" to "On-Anyone with the link" as you indicated.  The Spreadsheet also says "No sign-in required".  

I'm still getting the message that says, "Authorize access to Google Sheets API".  Is the Rise Vision Google Sheets widget not using the Google Sheets API?  I followed these steps to setup the website that pulls from Google Sheets:
https://developers.google.com/sheets/quickstart/js
Photo of Blake Freeman

Blake Freeman, Official Rep

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

In order for this to display properly within Rise Player, the website here will need to be publicly accessible without authorization. I can't offer any input on how to do that. 

Rise Player at this time has no means of handling authentication.
Photo of Donna Peplinskie

Donna Peplinskie

  • 7,142 Points 5k badge 2x thumb
Hi Thompson,

You don't need to write any authentication code in order to access a shared spreadsheet. All we're doing in the Spreadsheet Widget is sending a request directly to https://sheets.googleapis.com/v4/spreadsheets/.

You can find more documentation on the structure of the API call you need to make here.

Thx.
Photo of Thompson Vou

Thompson Vou

  • 140 Points 100 badge 2x thumb
Hi All,

I wanted to close the loop on this.  We weren't able to get the Google Sheets solution to work.  We did have someone internally that built a solution using C# and .NET (way above my knowledge and capabilities).  

Thanks again for the help.