'Google sheets API Writing data issue, Adding extra fields

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"], 
    ] 
  } 
})

javascript google-sheets-api

Solution 1:^[1]

It's a bug

Issues with spreadsheets.values.append appending values at the wrong location in the sheet are already know and reported on Google's Issue Tracker - see API values.append sometimes adds row not where it supposed to and Sheets V4 does not provide any suitable append operation
What you can do is "star" the issues to increase visibility, so that hopefully the issue will be fixed soon

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source
Solution 1	ziganotschka

'Google sheets API Writing data issue, Adding extra fields

Solution 1:[1]

It's a bug

Sources

Related Questions

Solution 1:^[1]