Easiest Google Sheets Integration?

[Hejenemy]

Is there a built-in way to have CanvasJS create a chart using data from a public Google Sheet? For example, the sheet below?
https://docs.google.com/spreadsheets/d/18qW3T0LSrqCtg-2JlHSh5cHG06NeHUp4JZUyBg7k1Sw/edit?usp=sharing

If not native, what’s the easiest recommended export?

Many thanks!

[Thangaraj Raman]

@hejenemy,

You can publish Google-Sheet as CSV and use the URL generated to fetch data using jQuery AJAX as shown in this JSFiddle.

—
Thangaraj Raman
Team CanvasJS

[Hejenemy]

Thank you. Is there any guidance on how to manipulate the data? The example is a very simple series, just a few data points in a column. How would you specify specific columns in the Google Sheet to correspond with the axis or data series within the CanvasJS chart?

[Thangaraj Raman]

@hejenemy,

You can read a specific row from the CSV file by its index / header. Please take a look at this documentation page for a step-by-step tutorial on rendering charts with data from a CSV file and parsing it. Also, please refer to this article for more information on parsing CSV data.

—
Thangaraj Raman
Team CanvasJS