This is likely the problem. I have experienced the exact same thing. All string columns in bigquery tend to default to long text. When you put a key on the longtext field, it riles back to the rownumber. When you change to a text field then make that...

Bigquery can watch GCP Buckets and automatically append to specific tables that can be shared with Appsheet. There is an Appsheet API that could be used to ingest content using JSon format. A scheduled process will need to be used to run. Using Appsc...