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!
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?
