Now that you are a part of google and they announced Google Sheets integration with big query, could this be packaged together? Can there be some function that allows base data to be kept in the google sheet, but the appsheet is really just recording all data to BigQuery?
I guess a first step would be to allow BigQuery as a data source.
A solution that currently works is :
- Use a Google Sheets spreadsheet as the data source for an AppSheet App
- In BigQuery, define a table configured as external data for each sheet used by the AppSheet App
- A Query executed in BigQuery can then access all the data from the AppSheet App as soon as sync is completed.
I hope you all have seen the announcement for the new BigQuery data source that is currently in Preview mode and available to all users. You can find the announcement here.