In my Google Sheet, I'm running a query to pull in Twitter User Data. In the query, I initially checked the box for "Append new results to old", but when the query refreshes in the morning time (it's scheduled), it overwrites the previous cells rather than appending the results to the next row. On top of that, my Query no longer has the checkbox enabled.
Basically, it's just removing that appending of results on its own each morning. How can I prevent that from happening?
Also, when I fix the query and run it with the checkbox, it works, and add the first line with the data it captured the query. However, when it's run automatically each morning it reverts again.