title: Import JSON object in Google SpreadSheet using Google APP Script
body: <p>I writing a script which calls REST API to get JSON to object as response and then import that JSON object in Google SpreadSheet. I have written the code to call the REST API and get the JSON object. Now I have to write such a code that will write the JSON object in a Google SpreadSheet.
  Please see below code:</p>
  
  <pre><code>function myFunction() {
  
  
      var options = {};
      options.headers = {"Authorization": "Basic " + Utilities.base64Encode("username" + ":" + "password")}
      options.muteHttpExceptions=true;
  
  
      // var response = UrlFetchApp.fetch(url, {'muteHttpExceptions': true});
  
      var response=UrlFetchApp.fetch("url", options);
  
      var dataAll=JSON.parse(response.getContentText())
  
      Logger.log(dataAll)
  
      /*
      var sheet = Sheets.newSpreadsheet();
      sheet.properties = Sheets.newSpreadsheetProperties();
      sheet.properties.title = "Demo";
      var spreadsheet = Sheets.Spreadsheets.create(sheet);
      */
  }
  </code></pre>
  
  <p>This is code to call get the JSON object. The lines of code which have been commented out is for calling Google Sheets API.
  I want such a script which will import the data in dataAll object, which is JSON object in Google SpreadSheet.</p>
  
  <p>The JSON object is as below:</p>
  
  <pre><code>[
  {
      "id": 3428,
      "type": "SUPER",
      "firstName": "Nikhil",
      "lastName": "Dingane",
      "loginName": "nikhildingane",
      "domain": "openspecimen",
      "emailAddress": "nikhil@krishagni.com",
      "instituteName": "Krishagni Institute",
      "primarySite": "KSPL site",
      "admin": true,
      "instituteAdmin": false,
      "manageForms": true,
      "cpCount": 0,
      "creationDate": 1586333347000,
      "activityStatus": "Active"
  },
  {
      "id": 3439,
      "type": "NONE",
      "firstName": "NikhilUpdated",
      "lastName": "Dingane",
      "loginName": "nikhildingane1",
      "domain": "openspecimen",
      "emailAddress": "nikhil.nikhil.dingane@gmail.com",
      "instituteName": "Krishagni Institute",
      "primarySite": "KSPL site",
      "admin": false,
      "instituteAdmin": false,
      "manageForms": true,
      "cpCount": 0,
      "creationDate": 1586427573000,
      "activityStatus": "Active"
  }
  ]
  </code></pre>
  
  <p>I want to write this JSON in Google SpreadSheet</p>