title: Google Sheet Coinmarketcap requesting 1 single importxml instead of 1 request for each coin
body: <p>I am developing a sheet in google sheet that pulls data from coinmarketcap with a script i've been trying to write.</p>
  <p>I am a f. noob @ coding.</p>
  <p>I use the function importxml (i need to refresh the latest price for each coin, like 100 coins) in this script:</p>
  <pre><code>function CryptoRefresher() {
  
          var spreadsheet = SpreadsheetApp.getActive();
          var queryString = Math.random();
          var link1 = &quot;C&quot;;
          var xpath = &quot;D&quot;;
          var destination = &quot;E&quot;;
          var Direction=SpreadsheetApp.Direction;
          var NumeroRighe =spreadsheet.getRange(&quot;B&quot;+(spreadsheet.getLastRow()+1)).getNextDataCell(Direction.UP).getRow();
  
          for (var i = 2; i &lt;= NumeroRighe; i++) {
      var cellFunction1 = '=IMPORTXML(&quot;' + SpreadsheetApp.getActiveSheet().getRange(link1+i).getValue() + '?' + queryString + '&quot;, &quot;'+ SpreadsheetApp.getActiveSheet().getRange(xpath+i).getValue() + '&quot;)';
    SpreadsheetApp.getActiveSheet().getRange(destination+i).setValue(cellFunction1);
      }
            };
  
  
          Example Data:
  
          Cell B2 = &quot;bitcoin&quot;
          cell C2 = &quot;https://coinmarketcap.com/currencies/Bitcoin&quot;
          Cell D2 = &quot;//div[@class='priceValue___11gHJ']&quot;
          Cell E2 = is the destination and will receive the bitcoin price
  </code></pre>
  <p>The problem is that it's really slow because it calls 1 coin per time.</p>
  <p>Question: Is there a way to send ALL THE COINS REQUESTS in 1 single importxml call?</p>
  <p>Like I'd like to collect all the coin names in column C (1 cell of column C has 1 different and unique Coin Name) to collect all the coin names that i am watching and ask for 1 single call to speed up the process?</p>
  <p>(Is there a way to create an array, a list of the coin names and do 1 single call to coinmarketcap?)</p>
  <p>I really can't figure that out and i hope what i'm asking is clear!</p>
  <p>Thank you!
  Alessandro</p>