Posted by Jan at 21:11 on Saturday 3rd July 2021[link]
I have a problem with displaying a line chart using Google sheets connector. I have set visibility for everyone in the settings for the table and in the Data Studio too. I was able to locate the sheet identificator and I was able to post a chart on my web when linking a demo chart from this site. As soon as I try to link any other chart using any table in my own accounts I have made in Google, it does not work. The files sit in my Google drives and I am sharing them with everybody with the link. I also found the table used in the demo just by altering my own links the way I replaced the identificator. So I could see the tables looked very similar to mine. My question is: what everything needs to be set in the Google account for my charts to be visible on my websites? I have never used Data Studio or data sources saved in Google drive. Thank you in advance for any replies. :)
Posted by Richard at 11:28 on Sunday 4th July 2021[link]
The Google Sheets connector is only designed to work with spreadsheets that are created and accessed using the Google Sheets online application.
It won't work with things that are saved in your Google Drive or in Data Studio.
What is the ID/key of your spreadsheet? It should look a bit like the one for the example spreadsheet that the RGraph website uses:
So the code for that would look like this:
new RGraph.Sheets('1ncvARBgXaDjzuca9i7Jyep6JTv9kms-bbIzyAxbaT0E', function (sheet)
// Make the chart here