It turns out that one can connect google sheets to bigquery, see [Using Connected Sheets | BigQuery | Google Cloud](https://cloud.google.com/bigquery/docs/connected-sheets)
Some notes:
- it seems possible to *periodically refresh* a view in sheets, see [the docs](https://support.google.com/docs/answer/9703214?hl=en#zippy=%2Cschedule-a-refresh)
- it seems it not possible to use SQL in Sheets to connect to BigQuery, one needs to create a view in Sheets
Some alternatives:
- [Equals.app](https://equals.app/)