- Dec 1, 2019
Connecting Google Sheets and BigQuery
- David Krevitt
A bridge connecting Google Sheets to a BigQuery analytics warehouse. Automates creation of BigQuery tables + views, and uploading of data to tables on a schedule.
This will be a pretty short post, to share one of our favorite utility tools for working with data.
The Sheets + BigQuery connector allows you to:
Create tables and views in BigQuery
Push data from Sheets up to those tables
Query data back down from BigQuery into Google Sheets
It's built as a Google Sheets template (with Google Apps Script) - make your copy here to get started.
If you're just getting started with BigQuery, you may also want to pick up our free BigQuery course to accelerate your progress.
The video below walks through how to use it:
Enjoy!