Google 脚本到 Firebase 脚本身份验证异常

Question

我在尝试运行代码时不断收到错误"异常：无效参数：键(第 39 行，文件"Auth"("，我确定客户端邮件、密钥、ID 和 sheetID 是正确的，但是，我每次都收到此异常，我找不到任何文档。 这是代码：

function myFunction() {

var email = "email";
var key = "key";
var projectId = "projectid";
var firestore = FirestoreApp.getFirestore(email, key, projectId);

var ss = SpreadsheetApp.openById("sheetID");
var sheet = ss.getSheetByName("Sheet1")

var sheetLR = sheet.getLastRow(); 
var sheetLC = sheet.getLastColumn(); 
var sourceDataSR = 1;

var sourceRange = sheet.getRange(1,1,sheetLR-sourceDataSR+1,sheetLC);

var sourceData = sourceRange.getValues();

var sourceLen = sourceData.length;

var data = {};
var scores = {};

for (var i=0;i<sourceLen;i++){

scores = {
ajan20:sourceData[i][3],
bFeb20:sourceData[i][4],
cMar20:sourceData[i][5],
dApr20:sourceData[i][6],
eMay20:sourceData[i][7],
fJun20:sourceData[i][8],
gJul20:sourceData[i][9],
hAug20:sourceData[i][10],
iSep20:sourceData[i][11],
jOct20:sourceData[i][12],
kNov20:sourceData[i][13],
lDec20:sourceData[i][14],
mJan21:sourceData[i][15],
nFeb21:sourceData[i][16],
oMar21:sourceData[i][17],
pApr21:sourceData[i][18],
qMay21:sourceData[i][19],
rJun21:sourceData[i][20],
sJul21:sourceData[i][21],
tAug21:sourceData[i][22],
uSep21:sourceData[i][23],
wOct21:sourceData[i][24],
xNov21:sourceData[i][25],
yDec21:sourceData[i][26],
zJan22:sourceData[i][27]
};

var Name = sourceData[i][2];

sourceData[Name] = {
aMale68KG:sourceData[i][0],
bCountry:sourceData[i][1],
cName:Name,
dScores:scores
};
firestore.createDocument("name",sourceData);  
}  
}

Answer 1

我遇到了同样的错误，您必须保留整个密钥，并带有BEGIN PRIVATE KEY和END PRIVATE KEY。

var key = "-----BEGIN PRIVATE KEY-----n your service account private key n-----END PRIVATE KEY-----n";

希望它能回答你的问题。