title: Parsing nested JSON via Google Scripts
body: <p>I've been struggling to try to find a way online to parse JSON output from an API request successfully.</p>
  
  <p>I'm looking to parse the "ResultData" section of the following API JSON Example Output:</p>
  
  <p>{"url":"<a href="http://elasticbeanstalk.com/api/results/69/" rel="nofollow noreferrer">http://elasticbeanstalk.com/api/results/69/</a>","id":69,"user":3,"inputdata":{"Q1":"Response1","Q2":"Response2","Q3":"Response3","Q4":"Response4","Q5":"Response5"},"ResultData":"{\"index\":1551,\"ID\":5246,\"Attribute1\":\"Output1\",\"Attribute2\":\"Output2",\"Attribute3\":16,\"Attribute4\":62.9433099,\"Attribute5\":\"www.google.com.au\"}\n {\"index\":1551,\"ID\":5246,\"Attribute1\":\"Output1\",\"Attribute2\":\"Output2",\"Attribute3\":16,\"Attribute4\":62.9433099,\"Attribute5\":\"www.google.com.au\"}\n {\"index\":1551,\"ID\":5246,\"Attribute1\":\"Output1\",\"Attribute2\":\"Output2",\"Attribute3\":16,\"Attribute4\":62.9433099,\"Attribute5\":\"www.google.com.au\"}\n {\"index\":1551,\"ID\":5246,\"Attribute1\":\"Output1\",\"Attribute2\":\"Output2",\"Attribute3\":16,\"Attribute4\":62.9433099,\"Attribute5\":\"www.google.com.au\"}\n {\"index\":1551,\"ID\":5246,\"Attribute1\":\"Output1\",\"Attribute2\":\"Output2",\"Attribute3\":16,\"Attribute4\":62.9433099,\"Attribute5\":\"www.google.com.au\"}\n {\"index\":1551,\"ID\":5246,\"Attribute1\":\"Output1\",\"Attribute2\":\"Output2",\"Attribute3\":16,\"Attribute4\":62.9433099,\"Attribute5\":\"www.google.com.au\"}\n {\"index\":1551,\"ID\":5246,\"Attribute1\":\"Output1\",\"Attribute2\":\"Output2",\"Attribute3\":16,\"Attribute4\":62.9433099,\"Attribute5\":\"www.google.com.au\"}\n {\"index\":1551,\"ID\":5246,\"Attribute1\":\"Output1\",\"Attribute2\":\"Output2",\"Attribute3\":16,\"Attribute4\":62.9433099,\"Attribute5\":\"www.google.com.au\"}\n {\"index\":1551,\"ID\":5246,\"Attribute1\":\"Output1\",\"Attribute2\":\"Output2",\"Attribute3\":16,\"Attribute4\":62.9433099,\"Attribute5\":\"www.google.com.au\"}"}</p>
  
  <p>Want the following values for each row exported into google sheets:</p>
  
  <p>index   ID  Attribute1  Attribute2  Attribute3  Attribute4  Attribute5</p>
  
  <p>Any ideas? Any help or pointers in the right direction would be greatly appreciated!</p>