title: google Timeline Chart json data
body: <p>I am creating a Google Timeline Chart with JSON data from a Sheet. I have a hardcoded the timeline and parsed my json data, but I am having trouble combining the 2.</p>
  <pre><code>The hardcoded rows where I'd like to pull in the dynamic json data is this:
  dataTable.addRows([   
    [ 'Project Name', null, '&lt;div class=&quot;ggl-tooltip&quot;&gt;Dynamic Task&lt;/div&gt;', new Date(2001, 6, 14), new Date(2001, 6, 17) ]   
   ]);
  
  My json data looks like this:
  {cols: Array(4), rows: Array(3)}
  cols: Array(4)
  0: {id: &quot;B&quot;, label: &quot;Milestone&quot;, type: &quot;number&quot;, pattern: &quot;General&quot;}
  1: {id: &quot;D&quot;, label: &quot;Task&quot;, type: &quot;string&quot;}
  2: {id: &quot;F&quot;, label: &quot;Start Date&quot;, type: &quot;date&quot;, pattern: &quot;M/D/YYYY&quot;}
  3: {id: &quot;G&quot;, label: &quot;End Date&quot;, type: &quot;date&quot;, pattern: &quot;M/D/YYYY&quot;}
  length: 4
  __proto__: Array(0)
  rows: Array(3)
  0:
  c: Array(4)
  0: {v: 1, f: &quot;1&quot;}
  1: {v: &quot;Design Registration Portal, Invitation, Confirmati…ecruitment Dashboard with Placeholder information&quot;}
  2: {v: &quot;Date(2021, 1, 25)&quot;, f: &quot;2/25/2021&quot;}
  3: {v: &quot;Date(2021, 2, 4)&quot;, f: &quot;3/4/2021&quot;}
  length: 4
  __proto__: Array(0)
  __proto__: Object
  1: {c: Array(4)}
  2: {c: Array(4)}
  length: 3
  __proto__: Array(0)
  __proto__: Object
  </code></pre>