It is easier to load data from a fully public spreadsheet, where you can grab the data in CSV format. See SO accepted answer <http://stackoverflow.com/questions/16485255/how-do-you-import-data-from-a-google-spreadsheet-to-javascript> .
If you need to load data from a spreadsheet with more normal access restrictions, then start with https://developers.google.com/sheets/quickstart/js The oAuth code can be intimidating at first, but most of it is copy-paste, and you end up with a nicely structured javascript object containing the spreadsheet's data, while still respecting read/write permissions. Most of the code is to handle the permissions pop-up and isn't specific to which oAuth permission you are asking the user for. If you are looking at timelines, I also highly recommend https://developers.google.com/chart/interactive/docs/gallery/ganttchart 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/570f5a08-34c4-424e-8927-aa162208d33c%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
