Today is a big day because we are releasing a brand new version of our BigQuery Uploader for Google Sheets.
The main improvements are:
-
- The long awaiting scheduler is finally here – you can setup hourly, daily, and weekly loads from Google Sheets to BigQuery.
- We are introducing a new UI minimizing user input errors – the old config sheet has no purpose. It’s been replaced by a proper menu UI. If you are using the previous version, you need to migrate your upload configurations into “Upload Definitions” in the menu. Sorry about that!
- We’ve significantly improved the upload procedure in order to minimize upload errors.
- A new fully manual mode is available – you can define data types for every single column of your table
- We’ve prepared a Help Center which explains how the product works and what are the most common causes of upload errors. Check it out here.
There is one bad news though – the add-on is becoming a paid product. The new users are automatically granted 14 day trial period. The existing users need to migrate to the paid version by 2020-07-31. Check out our pricing here.
Before you start using the new version, there are 2 articles you should read:
-
- Setup your spreadsheet to US locale.
- The importance of correct date formatting and datetime formatting.
You can get the addon from GSuite Marketplace:
Sample screenshots:
Here is a sample upload recorded as GIF:
And that’s all!
Pingback: Download Our FREE Google BigQuery Uploader for Google Sheets Add-On! – Mythical Reports
Pingback: How to Upload Multiple Sheets from Google Sheets to Big Query? – Mythical Reports
I’m trying to reconfigure all of our sheets to use the new version. However, the Setup Upload screen does not list all of my BigQuery datasets. Many are missing. Is there a limit? Please let me know how to access all of my datasets.
Hi Pamela,
we’ll certainly look at it and get back to you.
Daniel
Hello,
I love this uploader it’s great! I’ve recently been having an issue when trying to use though.
I get the following error message
mytable – myprojectid/dataset/table -> Error: GoogleJsonResponseException: API call to bigquery.jobs.get failed with error: Not found: Job myprojectid:job_Xy09BLtLGpvGRTx828Hv-OC4eLRy
We’ll certainly have a look and get back.
Happy to report the uploader is now approved and all the issues are gone.
Hi, unfortunately I’m still having this issue
Let’s sync privately. I sent you an email 15 minutes ago. Subject: “The Issue”. Check your spam too.
Daniel
Hello,
Trying to setup this tool and the setup upload definitions just sits on a loading screen without doing anything. Tried numerous times and still nothing.
Hi Adam,
I’ve replied directly to your email. Please, also check your spam folder.
Daniel
Hi, great job with this uploader!
I’m trying to call the “Run manual upload now” option in a macro, but it returns the error “ReferenceError: getDefinitionsAndRunUpload is not defined”.
What I’m doing wrong?
Regards,
Hi Marcelo,
are you logged into multiple Google accounts? If so, pls log into just 1 account or try in incognito.
Daniel
Hi Daniel,
Yes, I’m logged into multiple Google accounts, but I got the same issue running it in incognito.
Marcelo.
Hi Daniel,
Yes, I’m logged into multiple Google accounts, but I got the same issue running it in incognito.
Marcelo.
Let’s take it offline – I sent you an email.
DZ
Pingback: BigQuery Downloader for Google Sheets Released! – Mythical Reports