How to Run Your First Upload
Making the first step is always the hardest part of the job. That’s why we have prepared this tutorial to help you out. Follow these 5 easy steps. Step 1: …
Supported Table Structures
We believe there needs to be a clarity on what structures of tables you can actually push to BigQuery. This article shows several examples of tables which would successfully be …
Exception: Service Spreadsheets Failed While Accessing Document
If you are getting a message like this: Exception: Service Spreadsheets failed while accessing document with id {some id}, the problem is likely the sheer size of your spreadsheet. During the …
Data Types: All Columns as STRING
If your data is messy (=multiple data types appearing within 1 column) and you want to make sure that everything will be successfully uploaded to BigQuery, you should use “All …
Data Types: Manual
If you want to retain control over data types for each column in your table, you can use Manual option in the Data Types dropdown. The down side is that …
Data Types: Autodetect
If you are lazy person like us, you will likely want to use Autodetect option for detecting the data types: This is a very helpful option when your table has …
How to Set Datetime Column to YYYY-MM-DD HH:MM:SS Format?
If your table has a datetime column and you are using either Manual or Autodetect option for upload, it’s important to make sure your column is formatted properly because BigQuery …
I Only See Help Button
On rare occasions, it may happen, that you only see “Help” button in the add-on menu and no other items: How to get around it? Unfortunately, you have to uninstall …
How to Enable BigQuery API in Google Cloud Platform Project?
Before you can upload anything from Google Sheets to BigQuery with our BigQuery uploader for Google Sheets, you need to enable BigQuery API in your Google Cloud Platform (aka “GCP”) …
How to Set Date to YYYY-MM-DD Format in Google Sheets?
You may run into issues with your date column during uploads: Uploads failing because of incorrect formatting of your date column – this applies mainly to Manual option under Data …