The data collected by my AppSheet app now goes directly to my Google Spreadsheet. As I will delete old data in my Google Spreadsheet, I hope to use a more persistent cloud storage to store all my historical data, so that I only need to keep on appending data to the cloud storage, as well as adding to my google spreadsheet. In this way. I can use google spreadsheet for a one month view, and pull a much longer historical data for analysis from a cloud storage if needed. Have been trying to search for answers, but am not successful. So any help is certainly appreciated
Maybe Cloud SQL?
Or if you really want to try, there is a Biqquery connected-sheet called Data-Connectors, however it is still at beta stage.