Sankey w/ Upload from Google Sheet

by Tradd Salvo

HTML

<script type="text/javascript" src="https://www.google.com/jsapi"></script>
<div id="sankey_basic" style="width: 900px; height: 300px;"></div>

JavaScript

google.load('visualization', '1.1', {packages: ['sankey']});      
google.setOnLoadCallback(queryData);

function queryData() {
    var queryString = encodeURIComponent('');   
    var query = new google.visualization.Query(      'https://docs.google.com/spreadsheets/d/1l7i1A8BrXqBVcr3y34ySBfgrwZ_PM7FDkoL86rhbTAg/edit?usp=sharing'+ queryString);
    
    query.send(drawChart); 
}

function drawChart(response) {

    if (response.isError()) {
       alert('Error in query: ' + response.getMessage() + ' ' + response.getDetailedMessage());
       return;
    }
        
    var data = response.getDataTable();    
      
    // Sets chart options.
    var options = {
        width: 600,
        sankey: {
            node: {
                interactivity: true
            }
        }
    };

    // Instantiates and draws our chart, passing in some options.
    var chart = new        
    google.visualization.Sankey(document.getElementById('sankey_basic'));
    
    chart.draw(data, options);
}