Google Sheets add-on which allows you to upload multiple sheets in bulk from your Google Sheet into Google BigQuery with one click!
Ever wondered how to upload MULTIPLE sheets in bulk from one Google Sheet into Google BigQuery? Look no further. You just found solution!
As you may already know, BigQuery web UI allows you to use a Google Sheet as data source for your BigQuery tables. The problem is that it can only be ONE sheet from your Google Sheet. On the top of that, it’s always the FIRST sheet created in your Google Sheet.
Our FREE BigQuery Uploader for Sheets solves both problems - you can upload multiple sheets from your Google Sheet or just one sheet regardless whether it was created as the first sheet in the doc or not.
The setup is quite easy process. After adding our add-on into your Google Sheets, start with pressing “Create Config Sheet” button via add-on’s menu. This will create new sheet called “BqUploadConfigSheet”, where you just enter your project ID, dataset ID and table name. You can also choose if you want to truncate existing table in Big Query or if you want to just append the rows from the current sheet to your BigQuery table. When you are done, just press “Upload Sheets” button and let the magic work for you. Few seconds later, you will see status of your upload on the newly created “BqLogSheet” and you should see your tables in BigQuery.