gistfile1.txt

function readAddresses2() {
  var contractAddress = SpreadsheetApp.getActiveSheet().getRange("E2").getValue()
  
  var walletAddress = ''
  var counter = 2
  
  while(counter <= 6) {
    walletAddress = SpreadsheetApp.getActiveSheet().getRange("C"+counter).getValue()
    var response = UrlFetchApp.fetch("https://test.tokenbalance.com/token/"+ contractAddress +"/"+ walletAddress);
    Logger.log(response.getContentText());
    var jsonResponse = JSON.parse(response.getContentText())
    SpreadsheetApp.getActiveSheet().getRange("B"+counter).setValue(jsonResponse.balance);
    counter += 1
  }
}