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.
Can you describe a little bit more your process?
Hi @Romain_Marechal ,
First you need to open a Google Cloud Platform (GCP) account, which gives you 1 TB of free querying per month. See Google Cloud Free Program
Next see Querying Drive data | BigQuery | Google Cloud and follow the instructions for creating and querying permanent external tables.
Then you can execute queries directly in the BigQuery Console UI or using Google Apps Script. See BigQuery Service | Apps Script | Google Developers
I hope this helps.