Automated, regular movement of old data from Google sheet to a more permanent cloud database?

Is there a good or/and common practice on how to store data more permanently beyond Google sheets? I know that Google sheets can take in lots of rows and columns, and we can lock it to prevent accidental changes. It still needs to be maintain so that the AppSheet app can sync faster if the Google sheet contains just the relevant data, and a separate database that contains historical data could be very helpful in further analysis.

1 Like
1 Like

Thank you very much Steve. This is very helpful and specific. I noted an earlier reply to go through AppSheet documentation too. I will do so. Sorry to trouble everyone.

Edmund Chan

1 Like