Putting data collected by AppSheet to a cloud storage like BigQuery (or others)

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 :slight_smile:

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.

1 Like