You can use the BigQuery connector to load your Google Sheets data into BigQuery. Here are the steps that you can follow.
Company Website: https://www.datadice.io/
Follow us:
Medium (blog posts about Google Data Analytics Release Notes, Data Studio Tips & Tricks, Introductions to Google Cloud Tools and many more): https://bit.ly/3trJPRr
LinkedIn (stay informed about most important company news): https://bit.ly/3qqJKeX