The Problem We've Identified

4 years ago, we struggled to upload data from Google Sheets to Google BigQuery. We were sure there must have been hundreds of people having the same problem so we’ve built an add-on for Google Sheets which solves the problem – it allows you to easily upload data from Google Sheets to Google BigQuery without leaving the Google Sheets interface.

To date, the add-on has scored over 100,000 installations around the world.

We had also wanted to be able to easily query BigQuery data from Google Sheets and so we launched our Downloader product in February 2022.

Features

BigQuery Uploader for Sheets:

  • On demand or scheduled uploads available – hourly, daily, weekly
  • A new user-friendly UI guiding you through the setup process
  • Handle data types with Autodetect, Manual, or All Columns as STRING mode
  • Pause and activate your uploads
  • Stop worrying about renaming your columns so you meet BigQuery’s requirements – the add-on can do it for you
  • Help center and personal support available – you’ll hear from us within 24 hours in case you run into technical difficulties

You can install the uploader from here.

BigQuery Downloader for Sheets:

  • Run ad hoc SQL queries in Google BigQuery™ directly from Google Sheets™
  • Schedule your queries (hourly, daily, weekly)
  • Save multiple query definitions in the spreadsheet
  • Store query results as standard rows which can be referenced throughout your spreadsheet
  • Get email notification on failures

You can install the downloader from here.

Blog