FIXED: I can't get the Google Sheets import utility to work - Official support forum

Jeff · 2021-08-19T01:10:24+01:00

Hi, I am trying to follow your example to connect with data from google sheets, however your link https://www.rgraph.net/demos/line-sheets.html don't show a graph as all others. Is this example working properly? Replacing your google ID with mine neither works. Thank you!

About

RGraph is a JavaScript charts library based on HTML5 SVG and canvas. RGraph is mature (over 18 years old) and has a wealth of features making it an ideal choice to use for showing charts on your website.

Version 7.20

Version 7.20 (released in June 2026) is the latest version of RGraph and the major change in this version is an update to the default values of properties making for better looking charts without having to set any properties. Read more about this and other changes in the changelog.

Download »

Download

Get the latest version of RGraph (version 7.20, 9th June 2026) from the download page. You can read the changelog here. There's also older versions available, minified files and links to cdnjs.com hosted libraries.

Download »

Latest forum posts

These are the latest support forum posts that have been posted or updated.

16th June, Rachel
I have a question about the 3D Bar chart

12th June, Marco
Should I use SVG or canvas for the charts on my website?

9th June, Richard
New version of RGraph: version 7.20

3rd June, Patrick
Question about installing RGraph

1st June, Ouja
How do I add a click event to a bar in my Bar chart?

Support forum »

License

RGraph can be used for free under the GPL or if that doesn't suit your situation there's an inexpensive (£129) commercial license available.

Boy is it your lucky day - sort of!

Two days ago I found out that Google has recently (days? Certainly since my last release of RGraph) changed their API for Google Sheets. So I've been updating the workings of the RGraph Google Sheets import tool.

So far the canvas and SVG libraries have been updated - the PHP one I'm hoping to do later on today.

Regardless though I've added the new version of the library here:

[LINK REMOVED]

And there's an example of it showing a regular and grouped Bar chart here:

[LINK REMOVED]

One thing that's new compared to the old method is that Google now requires you to get an OAuth key.

This is quite a simple process though - there's a link to where you can get one in the updated "Setting up" docs, which I've added here:

[LINK REMOVED]

Any problems just come back to me here.

FYI The links have been removed but the updated sheets library is now part of the regular RGraph download.