Data Back Up

[Saketh_Dutch]

I have a table in appsheet which should be backed up into an existing xlsx file in google drive. It should be backed up after every 90 days. And the data back up should be appended to the last row of existing data. That file should be connected to big query and the data should load into a specific table into big query. How to achieve this in appsheet. Can we directly move table data from appsheet to bigquery without involving google drive? 

[WillowMobileSys]

---

@Saketh_Dutch wrote:

Can we directly move table data from appsheet to bigquery without involving google drive? 

---

No, if your app is using a sheet but you want to move that data into BigQuery in some automated way, you will need to create a script of some sort to do that.

But...I don't understand,  if you are using BigQuery, then why not create your tables in a BigQuery database.  Then you don't have to do the move at all - you can setup BigQuery to automatically back up that table data.