从BigQuery的查询数据并返回一个数据导入谷歌AppMaker(Querying data fr

从我刚才的问题在这里，我认为这是问题，从BigQuery的数据的查询我的服务器脚本功能。以下是我的代码来查询有关委托单位的电子邮件地址HOD电子邮件基地。

//To fetch requester's HOD email address
function BigQueryGetEmail(emailRequester){

  // Replace this value with the project ID listed in the Google
  // Cloud Platform project.
  var projectId = 'xxxxxx-xxx-stg';

  query = '#standardSQL \n SELECT SUPV_EMAIL_A FROM `xxxxx-xxx-stg.xxxxx.vw_HOD_email` WHERE EMP_EMAIL_A = "' + emailRequester + '";';

  var request = {
    query: query,
  };
  var queryResults = BigQuery.Jobs.query(request, projectId);
  var jobId = queryResults.jobReference.jobId;

  // Check on status of the Query Job.
  var sleepTimeMs = 500;
  while (!queryResults.jobComplete) {
    Utilities.sleep(sleepTimeMs);
    sleepTimeMs *= 2;
    queryResults = BigQuery.Jobs.getQueryResults(projectId, jobId);
  }

  // Get all the rows of results.
  var rows = queryResults.rows;
  while (queryResults.pageToken) {
    queryResults = BigQuery.Jobs.getQueryResults(projectId, jobId, {
      pageToken: queryResults.pageToken
    });
    rows = rows.concat(queryResults.rows);
  }

  // Append the results.
  var data = new Array(rows.length);
  for (var i = 0; i < rows.length; i++) {
   var cols = rows[i].f;
    data[i] = new Array(cols.length);
    for (var j = 0; j < cols.length; j++) {
      data[i][j] = cols[j].v;
    }
  }
  console.log('HOD email: ' + data);
  return data.toString();
}

奇怪的是，当我console.log数据它返回HOD电子邮件地址。但是，当过我所说的功能将不会返回数据结果BigQueryGetEmail功能。以下是调用函数：

function getHOD(){
  var ownerEmail = app.pages.Main.descendants.TextBox1.value;
  var HODemailfield = app.pages.Main.descendants.TextBox2.value;

  function successHandler(email){
  //assign email value to widget;
    HODemailfield = email;
  }

google.script.run.withSuccessHandler(successHandler).BigQueryGetEmail(ownerEmail);  
}

窗口小部件TextBox2没有反映这是我相信这是因为任何数据，也没有错误BigQueryGetEmail函数不返回任何数据。

任何人都可以指导我在正确的方式如何，当我打电话返回查询结果BigQueryGetEmail功能？尝试了多种方法，但仍停留。