title: How to pull data from Google sheets using Tabletop.js for a plotly heatmap chart?
body: <p>I'm trying to plot a heatmap chart using plotly with data being pulled from Google sheets (as json) using Tabletop.js.
  I have so far accomplished to pull data from Googleseet as json and display it in the console. But, getting it to display as a heatmap is proving cumbersome. Any help would be greatly appreciated.</p>
  
  <p><div class="snippet" data-lang="js" data-hide="false" data-console="true" data-babel="false">
  <div class="snippet-code">
  <pre class="snippet-code-js lang-js prettyprint-override"><code>var publicSpreadsheetUrl = 'https://docs.google.com/spreadsheets/d/1BFPjROVypCGNeLxhk5_PW6PoOb4FDzJsL3DEOEdW_Rc/edit?usp=sharing';
  
  function init() {
    Tabletop.init({
      key: publicSpreadsheetUrl,
      callback: showInfo,
      simpleSheet: true
    })
  }
  
  function showInfo(data, tabletop) {
    console.log(data);
  }
  
  window.addEventListener('DOMContentLoaded', init)
  
  var data = [{
    graphdata,
    type: 'heatmap'
  }];
  
  Plotly.newPlot('myDiv', data1);</code></pre>
  </div>
  </div>
  </p>