googlessheets .spreadsheets.values.append函数一遍又一遍地替换同一行，而不是创建

Question

我使用puppeteer创建了一个webscraper，输出到google sheets。我经常遇到的问题是当我追加时，通常它会创建一个新行并插入数据。但是在某些情况下,结果会出现楼梯,目前

await googleSheets.spreadsheets.values.append({
auth,
spreadsheetId,
range: "ECTRIMS v2",
valueInputOption: "USER_ENTERED",
resource: {
values: [[sEventID,slastWideoutEdit,scongressName,scongressfullEventName,
scongressAbbrev,scongressLocation,scongressCity,scongressCountry,scongressYear,
scongressStartDate,scongressEndDate,scongressTime,scongressUrl,scongressUrlQuality,
scongressTwitterHashtag,scongressPresenters,scongressHCPAttendees,scongressVirtual,
scongressType,spresenterFirstName,spresenterMiddleName,spresenterLastName,spresenterDegrees,
spresenterCity,spresenterState,spresenterCountry,spresenterInstitution,spresenterBio,spresenterRole,
spresenterPresentationType,spresenterPresentationID,spresenterPresentationAbstract,spresenterPresentationAbstractQuality,
spresenterPresentationUrl,spresenterPresentationUrlQuality,spresenterOralPoster,spresenterSessionTitle,
spresentationDate,spresentationStartTime,spresentationEndTime,spresentationTitle,spresentationAbstract]],
},
});

替换同一行，而不是追加。但是当我使用字符串时，它会正常工作。

await googleSheets.spreadsheets.values.append({
auth,
spreadsheetId,
range: "ECTRIMS v2",
valueInputOption: "USER_ENTERED",
resource: {
values: [["sEventID","slastWideoutEdit","scongressName","scongressfullEventName",
"scongressAbbrev","scongressLocation","scongressCity","scongressCountry","scongressYear",
"scongressStartDate","scongressEndDate","scongressTime","scongressUrl","scongressUrlQuality",
"scongressTwitterHashtag","scongressPresenters","scongressHCPAttendees","scongressVirtual",
"scongressType","spresenterFirstName","spresenterMiddleName","spresenterLastName","spresenterDegrees",
"spresenterCity","spresenterState","spresenterCountry","spresenterInstitution","spresenterBio","spresenterRole",
"spresenterPresentationType","spresenterPresentationID","spresenterPresentationAbstract","spresenterPresentationAbstractQuality",
"spresenterPresentationUrl",'spresenterPresentationUrlQuality',"spresenterOralPoster","spresenterSessionTitle",
"spresentationDate","spresentationStartTime","spresentationEndTime","spresentationTitle","spresentationAbstract"]],
},
});

Answer 1

我认为问题在于你给出的范围。试试这个:

await googleSheets.spreadsheets.values.append({
auth,
spreadsheetId,
range: "test1!A:B",
valueInputOption: "USER_ENTERED",
resource: {
values: [
[name, email]
],
}
})