A collection of references:

Real Time Google Sheets Data Exported to BigQuery, Displayed in Google Data Studio [YouTube] De’Lon Dixon [LinkedIn]

Connect and transfer data from Google Sheets to BigQuery [OptimizeSmart.com] Himanshu Sharma [LinkedIn]

How are you Loading data to BigQuery? [Reddit/r/bigquery]