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: Locate BigQuery Uploader for Sheets Add-on

Locate Addon

Step 2: Setup New Upload

Setup New Upload v2

Step 3: Configure Your Upload

This is apparently the crucial part:

  • Sheet Name – select the sheet which you want to upload to BigQuery
  • Project ID – your Google Cloud project ID
  • Dataset ID – your dataset in BigQuery needs to already exist before the upload. Also, your BigQuery API needs to be enabled in your project.
  • Table ID – how do you want to call your table in BigQuery?
  • Upload Type – you can select either Append or Overwrite
  • Data Types – how should BigQuery treat your columns? You can select Autodetect, Manual, or All Columns as STRING

Once you are done, press “Save Changes”.

Upload Config

Step 4: Run Manual Upload

Run Manual Upload

Step 5: See Upload Results

See Results

Here is the whole setup process recorded as GIF:

First Upload

Back to Help Center  Buy License Now

2 thoughts on “How to Run Your First Upload

  1. Pingback: How to Setup Scheduled Uploads – Mythical Reports

  2. Pingback: BigQuery Uploader for Google Sheets 2.0: What’s Changing? – Mythical Reports

Leave a Reply

Your email address will not be published. Required fields are marked *