Send list to google sheets using script issue

This should not work.
image
Your script is clearing the sheet every time you call it.

[Edit]
To send large data to Google sheet or Google script see this demo