One would think that uploading multiple sheets from a Google spreadsheet to BigQuery would be natively supported since both products come from Google, right?
Too bad! BigQuery only supports uploading (or better “linking”) the first sheet which has sheet ID = 0 (gid=0 in the URL of the sheet). If you want to get any other sheet from Google Sheet to BigQuery then you probably already know that it’s not supported by Google.
So how do you get around this limitation? We’ve just released a free add-on called “BigQuery Uploader for Sheets” which allows you to upload multiple sheets from Google Sheets into BigQuery with ease.
Join hundreds of users using our free product and grab the add-on here and: https://gsuite.google.com/marketplace/app/bigquery_uploader_for_sheets/656385579297
In case you need more information about the add-on, read this article which covers all it’s features: https://mythicalreports.com/bigquery-uploader-for-google-sheets/
You can also join this Facebook support group where you can share your feature suggestions or issues you are facing: https://www.facebook.com/groups/bigquery.uploader/
Your MythicalReports.com team.