When I first tried, I was thinking "put &format=json at the end of the URL and the system should handle the authentication... right?" go/broccoliman was not ok with that assumption.
Hacky ways for a fully-public spreadsheet are in Stack Overflow <http://stackoverflow.com/questions/16485255/how-do-you-import-data-from-a-google-spreadsheet-to-javascript> But security isn't cool with that. So I built go/ezgantt that uses javascript to load spreadsheet data the "right" way using oauth. Which IMHO was a great example showing that we need too much ugly stuff to get it to work. So I filed b/31111282 But in the meantime, I was getting frustrated with the three different ways to load google JS APIs, the copy-paste of oAuth popups that might either be , so I wrapped up all the logic in pledge.js - https://pledge.googleplex.com/ which I think is a nicer way to deal with loading data from drive docs via javascript. But I am not eng, and ymmv. On Thursday, October 6, 2016 at 1:11:55 PM UTC-7, C wrote: > > Hi all, > > I'm just starting out on my journey to building web apps. I have a Google > Sheet populated with development timelines for different teams working on a > big project. I'm trying to build a web app to visualize progress on the > various work streams. > > I followed the web app tutorial, in which the data source / table was > input directly in the .gs script. > > However, I can't find a solution for importing a sheet via its URL into a > .gs file. > > What's wrong with this? > > function doGet() { > var data = ('http://urlhere.com/234ouious89r') > > } > > > Thanks in advance. And apologies for the simplicity of the question. I > am not a programmer! > > Cheers, > C > -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/google-visualization-api. To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/3d15996b-ef17-46dc-88fa-02608af27529%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
