问题[google-apps-script](coding)

我正在使用 Google App Scripts 内置函数 UrlFetchApp.fetch 来从 URL 请求数据。当您在浏览器中导航到此 URL 时，它只会启动 XLSX 文件的文件下载。如果我 console.log 响应，它只是一串乱码数据。如何将表示此 XLSX 文件内容的字符串解析为 JSON 数组？

我无法将此文件保存到驱动器并重新读取它，我正在寻找一种在 App Script 中直接解析响应字符串的方法。以下代码使用 xlsx.full.min.js 库。我收到错误“解析过程中出错：不支持的 ZIP 压缩方法 NaN”

    function parseExcelToJson() {
  try {
    // Step 1: Fetch the Excel file from the URL
    const response = UrlFetchApp.fetch('https://www.nasdaqtrader.com/Content/ProductsServices/TRADING/TRF-Chicago-Test-Securities.xlsx');
    
    // Step 2: Convert the response to a Blob (in memory)
    const blob = response.getBlob();
    
    // Step 3: Convert the Blob to a byte array (needed for xlsx.js)
    const byteArray = blob.getBytes();
    
    // Step 4: Use xlsx.js to parse the byte array
    const data = XLSX.read(byteArray, { type: 'array' });
    
    // Step 5: Access the first sheet
    const sheet = data.Sheets[data.SheetNames[0]];
    
    // Step 6: Convert the sheet to JSON format
    const json = XLSX.utils.sheet_to_json(sheet);
    
    // Step 7: Return the JSON result
    return json;
    
  } catch (e) {
    // Log any errors during parsing
    Logger.log("Error during parsing: " + e.message);
  }
}

基于包含 3 列的 Google 表格：

col 1 包含部门代码，col 2 包含城市名称，col 3 包含机构名称，

这是我用作表单来源的 Google 表格的链接

我正在尝试编写一个代码，该代码可以生成一个谷歌表单，该表单分为几个部分，其中包含一些问题，这些问题的答案项会根据上一个问题的答案进行过滤，也就是说，我希望根据所选的部门代码，在下一部分要求选择城市时，只有该部门的城市可用，并且根据所选城市，在最后一部分要求选择机构时，只有该城市的机构可用。

我有适用于部门和城市的代码

请参阅使用以下代码生成的Google表单

const FORM_ID="1OkH_GNjrvOCkiBAXKqmRQq3e1uYxEpE8baqEDVokFso"
let form=FormApp.openById(FORM_ID)
function resetForm(){
let items=form.getItems()
items.forEach(item=>form.deleteItem(item))
}
function createConditionalForm(){
resetForm()
let ws=SpreadsheetApp.getActiveSpreadsheet()
let ss=ws.getSheetByName("Feuille 4")
let table=ss.getDataRange().getValues()
table.shift()
let dptOptions=table.map(row=>row[0])
let singleDptOptions=[]
dptOptions.forEach(option=>{
if(singleDptOptions.indexOf(option)==-1)
singleDptOptions.push(option)
})
let departementQuestion = form.addMultipleChoiceItem().setTitle("Select Region")
let finalDptOptions = []
singleDptOptions.forEach(dptOption=>{
let section=form.addPageBreakItem().setTitle(dptOption)
section.setGoToPage(FormApp.PageNavigationType.SUBMIT)

let cityOptions=table.filter(option=>option[0]==dptOption).map(row=>row[1])
let singleCityOptions=[]
cityOptions.forEach(option=>{
if(singleCityOptions.indexOf(option)==-1)
singleCityOptions.push(option)
})
let cityQuestion = form.addMultipleChoiceItem().setTitle("Select City")
cityQuestion.setChoiceValues(singleCityOptions)
let dptChoice = departementQuestion.createChoice(dptOption, section)
finalDptOptions.push(dptChoice)
})
departementQuestion.setChoices(finalDptOptions)
}

但在选择城市后，我无法添加另一个包含机构的部分。

这是我目前的情况，但我不断收到错误消息，提示数组为空。

const FORM_ID="Form_ID"
let form=FormApp.openById(FORM_ID)
function resetForm(){
let items=form.getItems()
items.forEach(item=>form.deleteItem(item))
}
function createConditionalForm(){
resetForm()
let ws=SpreadsheetApp.getActiveSpreadsheet()
let ss=ws.getSheetByName("Feuille 4")
let table=ss.getDataRange().getValues()
table.shift()
let dptOptions=table.map(row=>row[0])
let singleDptOptions=[]
dptOptions.forEach(option=>{
if(singleDptOptions.indexOf(option)==-1)
singleDptOptions.push(option)
})
let departementQuestion = form.addMultipleChoiceItem().setTitle("Select Dpt code")
let finalDptOptions = []
singleDptOptions.forEach(dptOption=>{
let section=form.addPageBreakItem().setTitle(dptOption)
let cityOptions=table.filter(option=>option[0]==dptOption).map(row=>row[1])
let singleCityOptions=[]
cityOptions.forEach(option=>{
if(singleCityOptions.indexOf(option)==-1)
singleCityOptions.push(option)
})
let cityQuestion = form.addMultipleChoiceItem().setTitle("Select City")
let finalCityOptions=[]
singleCityOptions.forEach(cityOption=>{
let section2=form.addPageBreakItem().setTitle(cityOption)
section2.setGoToPage(FormApp.PageNavigationType.SUBMIT)
let etabOptions=table.filter(option=>option[0]==cityOption).map(row=>row[2])
let singleEtabOptions=[]
etabOptions.forEach(option=>{
if(singleEtabOptions.indexOf(option)==-1)
singleEtabOptions.push(option)
})
let etabQuestion=form.addMultipleChoiceItem().setTitle("Select Place")
etabQuestion.setChoiceValues(singleEtabOptions)
let cityChoice = cityQuestion.createChoice(cityOption, section2)
finalCityOptions.push(cityChoice)
})
cityQuestion.setChoices(finalCityOptions)
cityQuestion.setChoiceValues(singleCityOptions)
let dptChoice = departementQuestion.createChoice(dptOption, section)
finalDptOptions.push(dptChoice)
})
departementQuestion.setChoices(finalDptOptions)
}

有任何线索可以告诉我如何调整初始代码吗？

感谢您的帮助 ！

因此，我有来自 CoinMarketCap 的这个脚本来查询加密货币价格。我想修改这个脚本，以便可以将其应用于单元格，然后将其拖放到列中以读取另一个单元格列中的股票代码。我对 App Scripts 完全是菜鸟。

function getLatestBTCPrice() {

var url = "https://pro-api.coinmarketcap.com/v1/cryptocurrency/quotes/latest";
var apiKey = 'YOUR_API_KEY'; // Replace with your API key
var headers = {
"X-CMC_PRO_API_KEY": apiKey,
"Accept": "application/json"
};

var parameters = {
"symbol": "BTC"
};

var response = UrlFetchApp.fetch(url + "?" + Object.keys(parameters).map(key => key + '=' +
parameters[key]).join('&'), {'headers': headers});
var json = JSON.parse(response.getContentText());
var btcPrice = json.data.BTC.quote.USD.price;

return btcPrice;
}

这是我迄今为止尝试过的方法，但没有成功。我遇到的问题是，var tickerPrice = json.data.ETC.quote.USD.price; 我想让 ETC 更新，因为它读取了新的股票代码，但我似乎无法弄清楚。

function getTickerPrice() {


var url = "https://pro-api.coinmarketcap.com/v1/cryptocurrency/quotes/latest";
var apiKey = 'YOUR_API_KEY'; // Replace with your API key
var headers = {
"X-CMC_PRO_API_KEY": apiKey,
"Accept": "application/json"
};

var sheet = SpreadsheetApp.getActiveSpreadsheet();
var ticker = sheet.getRange('A3').getValue();
var parameters = {
"symbol": ticker
};

var response = UrlFetchApp.fetch(url + "?" + Object.keys(parameters).map(key => key + '=' +
parameters[key]).join('&'), {'headers': headers});
var json = JSON.parse(response.getContentText());
var tickerPrice = json.data.ETC.quote.USD.price;

return tickerPrice;

我正在尝试循环遍历 Sheets 和 getLastColumn()。我激活第一个 Sheet 并获取最后一列，然后激活下一个 Sheet，但这次我在 getLastColumn() 上收到错误。我在 for 循环中执行此操作，这可能是问题所在吗？

    //sort fab, milling, turning, engraving
    sheet = SpreadsheetApp.getActive().getSheetByName("Fab Schedule");
    sheet.activate;
  
    var lastColumnFab = sheet.getLastColumn();
    var lastColumn = lastColumnFab;
    var lastColumnMilling;
    var lastColumnTurning;
    var lastColumnEngraving;
    var currentSheet = SpreadsheetApp.getActiveSheet().getSheetName(); 
    Logger.log(currentSheet);

    for(a=0;a<3;a++){ // 'a' is for looping through the different sheets
    Logger.log(a);

    // counting non-empty rows 
    var BValues = sheet.getRange("B3:B").getValues();
    var i=0;
    var singleBValue = "";
    //Logger.log(BValues[i]);
    for(i = 0; BValues[i] != ""; i++){
      singleBValue = BValues[i];
      //console.log({i,singleBValue});
    }
    var lastRow = i;
    i=i+3;

    // arrays begin with 0 // all rows and columns begin with 1
    sheet.getRange(3,2,lastRow,lastColumn).activate();
    //sheet.getRange('B3:V').activate(); //number of columns is different on every
    sheet
    var statusColumn = getHeaderNumber("Status")+1; //get header uses array, so it
    starts at 0
    var dueDateColumn = getHeaderNumber("Due Date")+1;
    var engineerColumn = getHeaderNumber("Engineer")+1;
  
    //sort by incomplete->complete, then
    sheet.getActiveRange().sort([{column: statusColumn, ascending: false}, {column: dueDateColumn, ascending: true},{column:engineerColumn, ascending: true}]);
  //sheet.getActiveRange().sort([{column: 14, ascending: false}]);//, {column: 18, ascending: true},{column:2, ascending: true}]);

  sheet.getRange(3,14,lastRow,lastColumn-14).setHorizontalAlignment("center"); //number of columns is different on every sheet
  sheet.getRange(3,1,lastRow,lastColumn).setVerticalAlignment("middle");
  sheet.getRange(3,1,lastRow,lastColumn).setFontFamily("Arial");
  sheet.getRange(3,1,lastRow,lastColumn).setFontSize(10);
  if (a==0){
      sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Milling Schedule");
      sheet.activate();
      var currentSheet = SpreadsheetApp.getActiveSheet().getSheetName(); 
      Logger.log(currentSheet);
      lastColumnMilling = sheet.getLastColumn(); //error?
      lastColumn = lastColumnMilling;
    }

Exception: The coordinates of the range are outside the dimensions of the sheet. Sortbyincompleteanddate @ sort.gs:62

我有一张工作表，我想根据两个不同单元格中的条目添加日期。因此，当一个人添加他们的姓名时，它会添加开始日期，当他们将状态更改为完成时，它会添加结束日期。

最初，我将它们放在单独的脚本中，然后发现列表中排在第二位的那个脚本可以工作，而另一个脚本则不行。因此，我尝试将它们合并为一个脚本，现在第一部分（名称添加开始日期）可以工作，但第二部分不行。

到目前为止，我还不知道我做错了什么，但这是一个全新的体验！感谢您的帮助！

function onEdit (e) {
  var range = e.range;
  var sheet = range.getSheet();

//set start date when owner is entered  
  if (range.getColumn() == 3 && sheet.getName() === "Projects"){
    var ownerCell = range.getValue();

    if (ownerCell !=="") {
      var startdateCell = range.offset(0,5);
      var currentDate = new Date();
      startdateCell.setValue(currentDate);
    } else {
      range.offset(0,5).clearContent();
    }
    
//set end date when completed is selected
  if (range.getColumn() == 6 && sheet.getName() === "Projects"){
    var statusCell = range.getValue();

    if (statusCell ==="Complete") {
      var enddateCell = range.offset(0,3);
      var finishDate = new Date();
      enddateCell.setValue(finishDate);
    } else {
      range.offset(0,3).clearContent();
    }

  }
}
}

我正在尝试编写一个脚本，将数据从一个 Google 工作表拉到另一个工作表，并将其附加到第二个工作表底部的正确列中。我遇到了问题，因为源工作表上的数据不在单个列或行范围内。

我当前的脚本是：

    function appendLPSales() {
    const ss = SpreadsheetApp.getActiveSpreadsheet();
    
    // Collect the data
    const sourceSheet = ss.getSheetByName("Source Data");
    const sourceRange = sourceSheet.getRange(C4,C5,E4,E5,C6,E6,C7,E7,C8,C9,E9,D11,D13);
    const sourceVals = sourceRange.getValues()
    
    // Append the data.
    // Input order: Date,Customer/Site,# of Tanks,Tank Size/LBS,Amount Paid,Start Reading,End Reading,Gallons,Values Match,Discrepancy note,Filled by,Cashier,Delivery
    const destinationsheet = ss.getSheetByName("Destination");
    destinationsheet.appendRow(sourceVals)
    
    sourceRange.clearContent();
    
    };

我有以下脚本：

function send_purchase_invoices() {
  var ss = SpreadsheetApp.getActive();
  var srcSheet = ss.getSheetByName("MAIN");
  var dstSheet = ss.getSheetByName("purchase_invoices");

  var data_range = srcSheet.getRange('DK4:DR18'); 
  var data_data = data_range.getValues();
  var data_clean  = data_data.filter(function (r) {return !r[0]});

  var lr = dstSheet.getLastRow(); 

  dstSheet.getRange(lr+1, 1,data_clean.length,8).setValues(data_clean);  
  srcSheet.getRange(data_clean).setValues('SUBMITTED');
}

此处有这一行：

srcSheet.getRange(data_clean).setValues('SUBMITTED');

我正在尝试调用此部分中设置的数据范围：

  var data_range = srcSheet.getRange('DK4:DR18'); 
  var data_data = data_range.getValues();
  var data_clean  = data_data.filter(function (r) {return !r[0]});

或者更具体地说，列 [0] 定义如下：

 var data_clean  = data_data.filter(function (r) {return !r[0]});

这样它就会将“已提交”一词填充到这些单元格中。

如有任何建设性建议，我将不胜感激。

我有这个简单的代码，它采用我的范围并提供 colDK [0] 中的值，它会将内容复制到我的目标表上。

function send_purchase_invoices() {
  var ss = SpreadsheetApp.getActive();
  var srcSheet = ss.getSheetByName("MAIN");
  var dstSheet = ss.getSheetByName("purchase_invoices");

  var data_range = srcSheet.getRange('DK4:DR18'); 
  var data_data = data_range.getValues();
  var data_clean  = data_data.filter(function (r) {return r[0]});

  var lr = dstSheet.getLastRow(); 

  dstSheet.getRange(lr+1, 1,data_clean.length,8).setValues(data_clean); 
}

我只是想改变它，所以如果 colDK 中没有值，它才会复制数据。

我估计是这一行需要改变，但我不知道该如何改变。

  var data_clean  = data_data.filter(function (r) {return r[0]});

任何建设性的建议都将受到赞赏。

我一直在尝试使用 Cloud Identity API 将 API JSON 响应中的特定值提取到 Google Sheet 中，特别是策略部分。API 响应正在运行，我得到了我想要的值，但我似乎无法让它将所有响应添加到 Google Sheet 上的 228 行，因为我无法获取要填写的行。我似乎只能让它填写 A2 行，而不能填写其他行。我认为这是 for 循环的问题，但我搞不清楚。我将在下面展示代码、示例 JSON 响应和工作表。任何帮助都感激不尽。

function get_settings(){

const ss = SpreadsheetApp.getActiveSpreadsheet();
const settingsSheet = ss.getSheetByName("07. settings api");

const api_key = PropertiesService.getScriptProperties().getProperty('apikey');
var url = "https://cloudidentity.googleapis.com/v1beta1/policies?key=" + api_key;

const params = {
  headers: {
    "Authorization": 'Bearer ' + ScriptApp.getOAuthToken()
  }
};

var response = UrlFetchApp.fetch(url, params);
var data = response.getContentText();
var json = JSON.parse(data);

for (let i = 0; i < 229; i++){
let settingsData = [];
settingsData.push(json.policies[0].name);
settingsData.push(json.policies[0].setting.type);
settingsData.push(json.policies[0].setting.value.serviceState);
settingsData.push(json.policies[0].setting.value.enableAccountRecovery);



//console.log(settingsData);

let ssdata = [];
ssdata.push(settingsData);

let targetRange = settingsSheet.getRange('A2:A229');
targetRange.setValues(ssdata);
}

}

JSON 响应

{
  "policies": [
    {
      "name": "policies/axynr375bw46nm5dcsjnvrfpuefam",
      "customer": "customers/C03r7ld3j",
      "policyQuery": {
        "query": "entity.org_units.exists(org_unit, org_unit.org_unit_id == orgUnitId('03ph8a2z32dhpy9'))",
        "orgUnit": "orgUnits/03ph8a2z32dhpy9",
        "sortOrder": 101
      },
      "setting": {
        "type": "settings/security.super_admin_account_recovery",
        "value": {
          "enableAccountRecovery": true
        }
      },
      "type": "SYSTEM"
    },
    {
      "name": "policies/axynr375bw46nm5dctezjp4byyksa",
      "customer": "customers/C03r7ld3j",
      "policyQuery": {
        "query": "entity.org_units.exists(org_unit, org_unit.org_unit_id == orgUnitId('03ph8a2z32dhpy9')) && entity.licenses.exists(license, license in ['/product/101034/sku/1010340001','/product/Google-Apps/sku/1010020020','/product/Google-Apps/sku/1010020025','/product/Google-Apps/sku/1010020026','/product/Google-Apps/sku/1010020027','/product/Google-Apps/sku/1010020028','/product/Google-Apps/sku/1010020030','/product/Google-Apps/sku/1010020031'])",
        "orgUnit": "orgUnits/03ph8a2z32dhpy9",
        "sortOrder": 101
      },
      "setting": {
        "type": "settings/gmail.email_spam_filter_ip_allowlist",
        "value": {
          "allowedIpAddresses": [
            "172.217.25.142"
          ]
        }
      },
      "type": "SYSTEM"
    },
    {
      "name": "policies/axynr375bxlm5l5gc6cib7vrw4lsg",
      "customer": "customers/C03r7ld3j",
      "policyQuery": {
        "query": "entity.org_units.exists(org_unit, org_unit.org_unit_id == orgUnitId('03ph8a2z32dhpy9'))",
        "orgUnit": "orgUnits/03ph8a2z32dhpy9",
        "sortOrder": 101.00002
      },
      "setting": {
        "type": "settings/play_console.user_takeout",
        "value": {
          "takeoutStatus": "ENABLED"
        }
      },
      "type": "SYSTEM"
    },
    {
      "name": "policies/axynr375bwa3nh5uckijlmho3afcg",
      "customer": "customers/C03r7ld3j",
      "policyQuery": {
        "query": "entity.org_units.exists(org_unit, org_unit.org_unit_id == orgUnitId('03ph8a2z32dhpy9'))",
        "orgUnit": "orgUnits/03ph8a2z32dhpy9",
        "sortOrder": 101.00005
      },
      "setting": {
        "type": "settings/blogger.user_takeout",
        "value": {
          "takeoutStatus": "ENABLED"
        }
      },
      "type": "SYSTEM"
    },
    {
      "name": "policies/axynr375bx2oz6wsbpunrgxt7qbcg",
      "customer": "customers/C03r7ld3j",
      "policyQuery": {
        "query": "entity.org_units.exists(org_unit, org_unit.org_unit_id == orgUnitId('03ph8a2z32dhpy9'))",
        "orgUnit": "orgUnits/03ph8a2z32dhpy9",
        "sortOrder": 101.00016
      },
      "setting": {
        "type": "settings/books.user_takeout",
        "value": {
          "takeoutStatus": "ENABLED"
        }
      },
      "type": "SYSTEM"
    },
    {
      "name": "policies/axynr375bwi5l5wvb2t335wn7mlsg",
      "customer": "customers/C03r7ld3j",
      "policyQuery": {
        "query": "entity.org_units.exists(org_unit, org_unit.org_unit_id == orgUnitId('03ph8a2z32dhpy9'))",
        "orgUnit": "orgUnits/03ph8a2z32dhpy9",
        "sortOrder": 101.00021
      },
      "setting": {
        "type": "settings/location_history.user_takeout",
        "value": {
          "takeoutStatus": "ENABLED"
        }
      },
      "type": "SYSTEM"
    },
    {
      "name": "policies/axynr375bx25ndwad3wz7ehl3mkcg",
      "customer": "customers/C03r7ld3j",
      "policyQuery": {
        "query": "entity.org_units.exists(org_unit, org_unit.org_unit_id == orgUnitId('03ph8a2z32dhpy9'))",
        "orgUnit": "orgUnits/03ph8a2z32dhpy9",
        "sortOrder": 101.00025
      },
      "setting": {
        "type": "settings/play.user_takeout",
        "value": {
          "takeoutStatus": "ENABLED"
        }
      },
      "type": "SYSTEM"
    }

我尝试调用云身份 API 从管理控制台中提取所有 Google Workspace 设置。最终，我想将特定设置提取到 Google Sheet 中，这就是我拥有电子表格应用程序的原因。当我运行代码时，它不断返回以下错误：

{ 错误：{ 代码：401，消息：'请求缺少所需的身份验证凭据。预期的 OAuth 2 访问令牌、登录 cookie 或其他有效的身份验证凭据。请参阅https://developers.google.com/identity/sign-in/web/devconsole-project。'，状态：'未经认证'，详细信息：[ [Object] ] } }

我已启用 Cloud Identity API 和 Sheets API，已将 GCP 项目链接到我的 Apps 脚本项目，已创建服务帐户并下载了 JSON 密钥。我还创建了 OAuth 客户端 ID，但仍然遇到同样的问题。我使用复制并粘贴到不同代码文件中的 JSON 密钥，并尝试使用它来验证 API，但不起作用。

我已经在网上进行了研究，但找不到任何可以实现这一点的东西。

知道如何让它工作吗？

function get_settings(){

const ss = SpreadsheetApp.getActiveSpreadsheet();
const settingsSheet = ss.getSheetByName("02. Google Workspace Security Settings");

var url = "https://cloudidentity.googleapis.com/v1beta1/policies"

var response = UrlFetchApp.fetch(url);
var json = response.getContentText();
var data = JSON.parse(json)

console.log(data);

}

**Configuration.gs**

const cloudidentity_credentials = {
"type": "service_account",
  "project_id": "security-review-automation",
  "private_key_id": "***********************************",
  "private_key": "-----BEGIN PRIVATE KEY-----\nMIIEvAIBADANBgkqhkiG9w0BAQEFAASCBKYwggSiAgEAAoIBAQC7AKYgLBa/U38y\njXaBfBGMiS0rU4tRh8rzVF+tttW/2saBl5ud+1X6ySNwhCnCVnm4IbfMsKzLX0WT\nSp2Mqs8v2Tc6JZPDBqqXKTwcuUeEwYNerBrhcS0GMpx3tzOtyGNTCpLUoAXa9UPE\n2FW9F8Kc501hjONhY2J/HW4n8hOe+V/JwIowmv912/WR8WkLUyQstFeI0A50QR4D\np1BFlmUYFrgu37f+vTQAyY/1ek91B7NtDvRa+N7Gjt+ccwFqafUHdByMSisGp6zw\nBaNbB43tIYV8pm9rfIkq0ex6l2Bi6SxbUKpcLvC7drnzamO3sy4rgFEjqJIdQAr2\noMplcDHFAgMBAAECggEAKkWxiATHaJ0onAYf85HXCriIsipazEWg0mQwk72IsKu1\nI17g8fO6oiwdO4ZYxUJUlhPjL12B1iBVg0ADAOUs3EFjS1zqu9OyNOUAnnKgsOko\nt/o6QluZ5LSEq8hJYZ+ymjdB7Vg2MqKuXN1Vdl8cYmkkFCjrzpxPi/IccGG33z/W\n7Em2VXLq7mlb1WeUorDdkw43W9hmCcOknR4VgTS1Aeu34Z+kr/b7m+Dz/G9DhSSl\nhUpeB8HN9BEs+4OxPooWwUPYYDggtxBeSXYqqDLt1LHTYU5+9udaRC33MSpCBga1\nDF0c7hHk3MlZexuugkLWBQPOpv9tp4GHeljCZny7CQKBgQD20pGC7h6x00+GA7NR\nVWvx6XNtmVdJzya8iEIkYV5mYPjHUwN4LPsTV2vL7h5uXkgSgDo8lluvU4hGZt6M\nOoJ8hO67N9U8zmC472HgTI0XfZpSZn14DtswgX1Rf6GuniksiSDtHgyAbMFlTguY\nkeIpwmlKHg1nii7RAtY4OLB1aQKBgQDB9KvjRFAaV41nTd366tGqQ/uimRAG6Cn0\n4YEKxyDdwXNrkCSYeRHX93m39ebWd7DzX69UyAIRLmDhtpTP1ZsP0i9MDGLFM8dR\nAb36Y8Ik6i3s0bUHkErOBdkr9TgkRSMQj1TWu2NL2zjPZDMyviW4JKWFNoiDn8lc\n9sFKqUjB/QKBgFr02Aiu5YLUgy64uGEVoJTiWdYetwsNGpJJiE5Nz3Lc83DIx7OG\np/PFuITLOE2l0tt2g3+GTT08BDElgYednC508mDtv1gMGZqtJJ16uFfawn7xI/WV\nS/MBFQRui0+FG1k9I3QeKa895LsHWsCbqgOHkDNvBbONOZlueTD4uxZZAoGATYDD\nntERYTVTH9CRv05N8cewqcyYBuqGuX/S3Metbm96+6RhuzvF0ZLmZIgyccjqQJYf\nrbUufkcWF5up41Lr32qR08WvQjXqk4gqrf9m+PFK4LL7r8YM3j6gBVy7zmKCHH/p\n2tSOXSWAkf7sJn6s++RI7+5WpqIXCLrhikAS/tECgYB6xQ7yrCrCfTxwTX42BmJX\nMBFukX/51kVn98CPMccgami23naUVGJfz9DrZZ/vtrVFoUDehqqruDiXjiFzBZRl\nyqjILD7tGMHk+K58wDFc8GQ1nCB4mTbwbDjlXla//j3C1ISnQLwjtsj5Ggss/vNu\nF8RqCO4EeKTK1s1f8FqMew==\n-----END PRIVATE KEY-----\n",
  "client_email": "cloud-identity-policy-app@security-review-automation.iam.gserviceaccount.com",
  "client_id": "102944771842644545560",
  "auth_uri": "https://accounts.google.com/o/oauth2/auth",
  "token_uri": "https://oauth2.googleapis.com/token",
  "auth_provider_x509_cert_url": "https://www.googleapis.com/oauth2/v1/certs",
  "client_x509_cert_url": "https://www.googleapis.com/robot/v1/metadata/x509/cloud-identity-policy-app%40security-review-automation.iam.gserviceaccount.com",
  "universe_domain": "googleapis.com"
};
const PROJECT_ID = 'security-review-automation';