I am looking for a way to automatically create a new row on top of older rows each day.
Inside of this row should be the current date.
With this little snippet it is possible. Add the code by selecting tools>Script editor in the spreadsheet. Make sure to press the
In the script editor, choose the following menu option:
and set the trigger as follows (or however you choose):
I've created an example file for you: on top
You have to return tomorrow to check it though =)