You don't need to use the "gadget" method to get the spreadsheet URL. Look in the URL of your spreadsheet: there is a "key" parameter "key=<string of characters/numbers>", for example, in this url: " https://docs.google.com/spreadsheet/ccc?key=0AiFfbdok-kQKcENRYmV0ZC1DcHRHWHh4UUlHN1ZGSVE#gid=0";, the key is "0AiFfbdok-kQKcENRYmV0ZC1DcHRHWHh4UUlHN1ZGSVE". The URL of the data source is then "https://docs.google.com/spreadsheet/tq?key=<your key>" ("https://docs.google.com/spreadsheet/tq?key=0AiFfbdok-kQKcENRYmV0ZC1DcHRHWHh4UUlHN1ZGSVE"; in the example). Basically, the only significant difference between the two URL's is that one has "ccc" and the other has "tq" as the last parameter in the path.
On Monday, October 28, 2013 5:43:56 PM UTC-4, [email protected] wrote: > > Greetings Everyone, > > I am not a programmer by training, but I like to think that I am quasi > savvy in augmenting code that has already been written. Google has made > this exponentially easier with their Google Charts tool. I have > successfully created a chart that works in the Google Code Playground by > adding the data directly into the chart code. However, I would like to pull > this information from a spread sheet I have in my Google Drive. > > I visited the tutorial below: > > > https://developers.google.com/chart/interactive/docs/spreadsheets#Google_Spreadsheets_as_a_Data_Source > > This specific step was not able to be followed: *From the spreadsheet > toolbar, click 'Insert' and choose 'Gadget'. Choose an existing gadget or > select 'Custom' as the gadget type, enter the URL of your gadget XML > specification and click 'Add'. You can choose a visualization gadget, if > you want your visualization to live in the spreadsheet; otherwise, you can > choose any gadget if you just need to get a URL to pass to an external > visualization .* > * > * > There is no Gadget from insert any longer. > > I published the spreadsheet as a website and used that URL in the code. > Any assistance with what precisely I am doing wrong would be greatly > appreciated. > > It was not helpful. > > I am trying to get data from my Google Spreadsheet to fill in my Motion > Chart from the Google Charts tool. > -- 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 http://groups.google.com/group/google-visualization-api. For more options, visit https://groups.google.com/groups/opt_out.
