谷歌工作表AddOn - AppScript和BigQuery通过服务帐户集成

function runQuery() {
  var projectId = 'your-project-id';
  var datasetId = 'your-dataset-id';
  var tableId = 'your-table-id';
  
  var query = 'SELECT * FROM `' + projectId + '.' + datasetId + '.' + tableId + '` LIMIT 10';
  
  var request = {
    query: query,
    useLegacySql: false
  };
  
  var queryResults = BigQuery.Jobs.query(request, projectId);
  
  var results = [];
  while (queryResults.jobComplete && queryResults.rows) {
    for (var i = 0; i < queryResults.rows.length; i++) {
      var row = queryResults.rows[i];
      var rowData = [];
      for (var col in row.f) {
        rowData.push(row.f[col].v);
      }
      results.push(rowData);
    }
    if (queryResults.pageToken) {
      request.pageToken = queryResults.pageToken;
      queryResults = BigQuery.Jobs.query(request, projectId);
    } else {
      break;
    }
  }
  
  // 将结果写入工作表
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Results');
  sheet.getRange(1, 1, results.length, results[0].length).setValues(results);
}