Here's a demo of the Google Sheets connector that's bundled with RGraph. The connector is fetching data from the first sheet (there are multiple sheets) but the connector supports fetching data from any sheet.
You can see the Google Sheet that RGraph is fetching data from here.
<script src="RGraph.svg.common.core.js"></script> <script src="RGraph.svg.common.sheets.js"></script> <script src="RGraph.svg.bar.js"></script>Put this where you want the chart to show up:
<div style="width: 1000px; height: 300px" id="chart-container"></div>This is the code that generates the chart: