Connecting Google Sheets and BigQuery

Connecting Google Sheets and BigQuery

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:

  1. Create tables and views in BigQuery
  2. Push data from Sheets up to those tables
  3. 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:


Build cacheworthy data experiences

Stay updated with the latest tutorials + events, dedicated to helping you build wonderful in-app data experiences.

Subscribe to the newsletter