BigQuery Tutorial Code Snip 2

var resultValues = new Array(resultCount);
  var tableRows = queryResults.getRows();

  // Iterate through query results
  for (var i = 0; i < tableRows.length; i++) {
    var cols = tableRows[i].getF();
    resultValues[i] = new Array(cols.length);
    // For each column, add values to the result array
    for (var j = 0; j < cols.length; j++) {
      resultValues[i][j] = cols[j].getV();
    }
  }

  // Update the Spreadsheet with data from the resultValues array
  sheet.getRange(1, 1, resultCount, tableRows[0].getF().length).setValues(resultValues);