Interesting! Which automation are you using? Yours seems to be behaving differently than mine not only in the fact that the data seems to be getting transcribed correctly. It seems you have a bunch of blank rows already populated (ie rows 2-15+) and your action is correctly inserting in the first available slot, however, with the one I am using, if there are a bunch of blank rows, it will still create a brand new row at the bottom.
I am using the built in "append a new row to a spreadsheet" action.