As Jeff said, it’s likely the empty rows are the issue here. When Glide tells Sheets there’s a new row, Sheets see all empty rows as valid rows and won’t write to them. Therefore it will be written to row 501 or 1001 something.
Another case is that you may have written “ “ instead of “” in your formula.