Post by Buzzrick in Google Sheets for Unity comments

Viewing post in Google Sheets for Unity comments

Hi Novack. The library looks really promising, but I haven't been able to get it to pull any data yet. I believe that I've wired everything up correctly (as per the docmentation) but whenever I try to start pulling the data (I'm starting with a GetAllTables() call), I just get an Undefined Server Response. Digging into the resulting HTML response I see the error text: "Sorry, unable to open the file at present. Please check the address and try again". I've double checked all of my connection details and they all look correct.

Any suggestions on what I might be doing wrong?

The only possible anomaly that I can think of is that this spreadsheet is stored inside a company Google Suite account, so when I expose the sheet, the least restrictive access I can give is to "anyone within the company" (rather than "Anyone, even anonymous". Is this supported?

Novack4 years ago

Hi @buzzrick, thanks for contacting.

Indeed, the endpoint wont be reachable unless you use the access level described in the documentation.

You have two paths from there:

You escalate the permisions, indeed allowing for anonymous access (this can be enabled in the Google admin console from Google Apps).
You deploy the webapp on a different google account where you can apply the less restrictive permissions, and share the spreadsheet with that account.

Hope it helps :)

Buzzrick4 years ago

Thanks @Novack. After digging into our corporate G Suite admin portal and finally figuring out where to change the obtuse settings (it was in the Google Drive settings within Apps), and then figuring out a way to limit who had access to change those settings (using Groups) we were finally able to expose and publish the endpoint.

Now it's working like a charm!

Novack4 years ago

Thats great! thanks for letting me know :)

itch.io

Viewing post in Google Sheets for Unity comments