title: How to insert json array data to google app spreadsheet using app script?
body: <p>I have two methods one method returns the data in form of JSON array. Now I want to write this data to google app script.How to do that?</p>
  
  <p>Using the code below I get</p>
  
  <blockquote>
    <p>Cannot convert Array to Object" Error </p>
  </blockquote>
  
  <pre><code>var noEpicListArray = new Array();
  
  if(epicCount==0){
    var noEpicMetric = {
      "issueKey": "No Epic",
      "issueSummary": "NA",
      "epicEfficiency": "NA",
      "teamName": "NA",
      "firstPassInd": "NA",
      "secondPassInd": "NA",
      "thirdPassInd": "NA",
      "tooManyPassInd": "NA",
      "storyCountInsideEpic": "NA" 
  }
  
  noEpicListArray.push(noEpicMetric);
  epicWiseEpicEfficiencySheet.getRange(2, 1, 1, 9).setValues(noEpicListArray); }
  </code></pre>