How to Setup Scheduled Uploads
Once you define your upload definitions, you may want to schedule your uploads so you don’t have to upload your tables manually. First of all, you need to enter the …
How to Set United States Locale in Google Sheets
If you are not based in the United States, you should set your spreadsheet to “United States” locale before you run your first upload with BigQuery Uploader for Google Sheets. …
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 …