I am using google-sheet-api for my project and it totally works fine most of the time. But at times it behaves differently. Last time I encountered with a problem that some of cells filled by my data which I am not intend to. It randomly picked one of the values from my data and filled up other cells in my row. So my question is , Is this something with my side or google-sheets-api issues ??
Used code:
const writeReq = await sheets.spreadsheets.values.append({
spreadsheetId:id, range:'range', valueInputOption:"USER_ENTERED",
resource:{
values:[
["data1", "data2", "data3", "data4", "data5", "data6", "data7", "data8"],
]
}
})