My case is that I have a Google Form that populates a sheet. But I also have a other sources such as a Bot, that is able to add a new row. The bot always adds the new row at the very end of the sheet (getLastRow()+1
);. I expected Google Forms to do the same.
After some testing and reading up I realized, that Google Forms somehow
remembers where it inserted the last row into the answers Sheet and will insert the new submission before the data from other sources.
My question seems simple but I cannot find a solution: How can I ensure that Google Forms inserts the new submission at the very end, even if data has been entered through other means?