Connecting Google Sheets and BigQuery
Welcome to Cacheworthy
This post is a vestige of this blog's previous life as CIFL (2015 - 2023), which covered building analytics pipelines for internal reporting. When migrating to Cacheworthy and a focus on data applications, we found this post too helpful to remove - hope you enjoy it!
Curious about data applications? Meet Cacheworthy.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!