title: Google JavaScript Spreadsheet property JSON from variable
body: <p>In google sheets using the Coinmarketcap.com API I am trying to download data.
  For this purpose, I have a loop in which I want to iterate subsequent names from the previously created table.</p>
  
  <pre class="lang-js prettyprint-override"><code>  var listaCrypto = "BTC,ETH,ADA";
    var tabCrypto = listaCrypto.split(",");
  
  
  for (var i = 1; tabCrypto[i]; i++) {
  
      var url='https://pro-api.coinmarketcap.com/v1/cryptocurrency/quotes/latest?symbol='+tabCrypto[i];
      var result= UrlFetchApp.fetch(url, requestOptions);
  
      var txt= result.getContentText();
      var d=JSON.parse(txt); 
  
      lista1.getRange(start_row + rankBTC, 1).setValue(d.data.tabCrypto[i].name);  //&lt;-- this doesn't
      lista1.getRange(start_row + rankBTC, 2).setValue(d.data.BTC.name);  //&lt;-- this line works
    }
  </code></pre>