AddRows randomly adding (or trying to) at row 0.

[PRossESA]

Sometimes sheet.addRow / addRows works most the time it tries to write on my header row which I had to protect from the user the api uses to try and write to the sheet.

Sometimes, rarely it works and then just reverts back to attempting to write on the first row again, where my headers are (which are protected). The sheet has about 60 rows in it other than that. Updating the rows works fine.

If I console sheet.headerValues or write a recordcount before the line before the addRow, they both show what they should, the sheet is aware of data and headers..

I tried using the insert;true arg and that works but inserts ABOVE the headers. I want to append to the bottom of the sheet though.

help? Seems odd that it's very inconsistent.

[theoephraim]

That all sounds quite odd and not something I've seen before...
Question for you - are you writing many rows concurrently or is it always just one at a time?
I suspect it is something specific to the doc itself and how things are set up. If you can share it with me (or a clone of it with any sensitive data scrubbed) I can take a look and see if I can recreate the issue.

[nktnet1]

My header row also gets replaced when I have hidden columns - have documented it in #706.
I can also reproduce the "insert above header row" issue.