title: obtaining json data from a specific range of cells in a google spreadsheet
body: <p>I'm trying to find a way to fetch json data from specific range of cells within a google docs sheet.</p>
  
  <p>My spready looks like this
  <a href="https://i.stack.imgur.com/6UmJb.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/6UmJb.png" alt="enter image description here"></a></p>
  
  <p>And I would like to obtain a JSON object as follows</p>
  
  <pre><code>{ 
   "Parts":{"target1": 230000, "target2":200000},
   "Accessories":{"target1": 150000, "target2":100000},
   "Stars":{"target1": 95, "target2":70},
   "Labour":{"target1": 900, "target2":750},
  }
  </code></pre>
  
  <p>I've read <a href="http://www.ravelrumba.com/blog/json-google-spreadsheets/" rel="nofollow noreferrer">this article</a> and tried to adapt it to my needs, but my experiments in doing so have all been horribly broken. I either end up with a ton of unwanted meta-data in with my json, or nothing at all. I suspect the article in question is outdated, being more than 5 years old.</p>
  
  <p>Can anyone suggest a different approach?</p>